summaryrefslogtreecommitdiffstats
path: root/core
diff options
context:
space:
mode:
authorJérémy Zurcher <jeremy@asynk.ch>2016-02-16 16:38:24 +0100
committerJérémy Zurcher <jeremy@asynk.ch>2016-02-16 16:38:24 +0100
commitc7228cde6e2efb0e53c92f5da2b2e2f1f4283548 (patch)
tree88a4f434d0b4706b789b854d898f16e46894163f /core
parent16d201d391f0e38c9709026959a4e303f5737518 (diff)
downloadRustAndDust-c7228cde6e2efb0e53c92f5da2b2e2f1f4283548.zip
RustAndDust-c7228cde6e2efb0e53c92f5da2b2e2f1f4283548.tar.gz
DB: debug SQL
Diffstat (limited to 'core')
-rw-r--r--core/src/ch/asynk/rustanddust/RustAndDust.java2
-rw-r--r--core/src/ch/asynk/rustanddust/util/DB.java44
2 files changed, 31 insertions, 15 deletions
diff --git a/core/src/ch/asynk/rustanddust/RustAndDust.java b/core/src/ch/asynk/rustanddust/RustAndDust.java
index 572b326..ac6e4eb 100644
--- a/core/src/ch/asynk/rustanddust/RustAndDust.java
+++ b/core/src/ch/asynk/rustanddust/RustAndDust.java
@@ -115,7 +115,7 @@ public class RustAndDust extends Game
this.hudCorrection = ((int) (125 * Gdx.graphics.getDensity()) - 75);
debug("create() [" + Gdx.graphics.getWidth() + ";" + Gdx.graphics.getHeight() + "] " + Gdx.graphics.getDensity() + " -> " + hudCorrection);
- db = new DB(Gdx.files.internal(DB_FILE).path());
+ db = new DB(Gdx.files.internal(DB_FILE).path(), true);
db.setup();
manager = new AssetManager();
diff --git a/core/src/ch/asynk/rustanddust/util/DB.java b/core/src/ch/asynk/rustanddust/util/DB.java
index 096776e..c90fe40 100644
--- a/core/src/ch/asynk/rustanddust/util/DB.java
+++ b/core/src/ch/asynk/rustanddust/util/DB.java
@@ -17,6 +17,7 @@ public class DB
public static final int NO_RECORDS = -1;
private static final String DIGEST = "SHA-256";
+ private boolean debug;
private Database db;
private MessageDigest md;
@@ -71,10 +72,11 @@ public class DB
private static final String DB_CRT = TBL_CFG_CRT + TBL_PLAYERS_CRT + TBL_BATTLES_CRT + TBL_GAMES_CRT + TBL_TURNS_CRT + TBL_STATES_CRT;
- public DB(String dbPath)
+ public DB(String dbPath, boolean debug)
{
- db = DatabaseFactory.getNewDatabase(dbPath, DB_SCHEMA_VERSION, DB_CRT, null);
- db.setupDatabase();
+ this.db = DatabaseFactory.getNewDatabase(dbPath, DB_SCHEMA_VERSION, DB_CRT, null);
+ this.db.setupDatabase();
+ this.debug = debug;
}
public void setup()
@@ -100,7 +102,7 @@ public class DB
public boolean storeConfig(String config)
{
try {
- db.execSQL(String.format(INSERT_CONFIG, config));
+ exec(String.format(INSERT_CONFIG, config));
} catch (SQLiteGdxException e) {
RustAndDust.error("storeConfig");
return false;
@@ -112,7 +114,7 @@ public class DB
{
String ret = null;
try {
- DatabaseCursor cursor = db.rawQuery(GET_CONFIG);
+ DatabaseCursor cursor = query(GET_CONFIG);
if (cursor.getCount() > 0) {
cursor.next();
ret = cursor.getString(0);
@@ -131,7 +133,7 @@ public class DB
public void storePlayer(String gmail, String name, String hash)
{
try {
- db.execSQL(String.format(INSERT_PLAYER, hash, gmail, name));
+ exec(String.format(INSERT_PLAYER, hash, gmail, name));
} catch (SQLiteGdxException e) {
RustAndDust.error("storePlayer");
}
@@ -142,7 +144,7 @@ public class DB
int ret = NO_RECORDS;
String sql = (hash ? GET_PLAYER_ID_FROM_HASH : GET_PLAYER_ID_FROM_GMAIL);
try {
- DatabaseCursor cursor = db.rawQuery(String.format(sql, s));
+ DatabaseCursor cursor = query(String.format(sql, s));
if (cursor.getCount() > 0) {
cursor.next();
ret = cursor.getInt(0);
@@ -160,14 +162,14 @@ public class DB
public void storeBattle(int id, String name)
{
try {
- db.execSQL(String.format(UPDATE_BATTLE, id, name));
+ exec(String.format(UPDATE_BATTLE, id, name));
} catch (SQLiteGdxException e) { RustAndDust.error("storeBattle"); }
}
public void storeGame(int you, int opponent, int battle, int mode)
{
try {
- db.execSQL(String.format(INSERT_GAME, you, opponent, battle, mode));
+ exec(String.format(INSERT_GAME, you, opponent, battle, mode));
} catch (SQLiteGdxException e) { RustAndDust.error("storeGame"); }
}
@@ -175,7 +177,7 @@ public class DB
{
int ret = NO_RECORDS;
try {
- DatabaseCursor cursor = db.rawQuery(String.format(GET_GAME_ID, you, opponent, battle, mode));
+ DatabaseCursor cursor = query(String.format(GET_GAME_ID, you, opponent, battle, mode));
if (cursor.getCount() > 0) {
cursor.next();
ret = cursor.getInt(0);
@@ -195,7 +197,7 @@ public class DB
try {
String hash = getDigest(payload);
if (hash == null) return false;
- db.execSQL(String.format(INSERT_TURN, game, player, hash, payload, game));
+ exec(String.format(INSERT_TURN, game, player, hash, payload, game));
} catch (SQLiteGdxException e) {
RustAndDust.error("storeTurn");
return false;
@@ -209,8 +211,8 @@ public class DB
try {
String hash = getDigest(payload);
if (hash == null) return false;
- db.execSQL(String.format(INSERT_STATE, game, hash, payload, game));
- db.execSQL(String.format(UPDATE_GAME, p1, p2, game));
+ exec(String.format(INSERT_STATE, game, hash, payload, game));
+ exec(String.format(UPDATE_GAME, p1, p2, game));
} catch (SQLiteGdxException e) {
RustAndDust.error("storeState");
return false;
@@ -223,7 +225,7 @@ public class DB
RustAndDust.debug("loadState");
String ret = null;
try {
- DatabaseCursor cursor = db.rawQuery(String.format(GET_STATE, game));
+ DatabaseCursor cursor = query(String.format(GET_STATE, game));
if (cursor.getCount() > 0) {
cursor.next();
ret = cursor.getString(0);
@@ -231,4 +233,18 @@ public class DB
} catch (SQLiteGdxException e) { RustAndDust.error("loadState"); }
return ret;
}
+
+ private void exec(String sql) throws SQLiteGdxException
+ {
+ if (debug) RustAndDust.debug(" SQL " + sql);
+ db.execSQL(sql);
+ }
+
+ private DatabaseCursor query(String sql) throws SQLiteGdxException
+ {
+ if (debug) RustAndDust.debug(" SQL " + sql);
+ DatabaseCursor c = db.rawQuery(sql);
+ if (debug) RustAndDust.debug(String.format(" SQL -> %d", c.getCount()));
+ return c;
+ }
}