diff options
| -rw-r--r-- | core/src/ch/asynk/rustanddust/util/DB.java | 32 |
1 files changed, 32 insertions, 0 deletions
diff --git a/core/src/ch/asynk/rustanddust/util/DB.java b/core/src/ch/asynk/rustanddust/util/DB.java index c90fe40..e1cf1a5 100644 --- a/core/src/ch/asynk/rustanddust/util/DB.java +++ b/core/src/ch/asynk/rustanddust/util/DB.java @@ -1,5 +1,7 @@ package ch.asynk.rustanddust.util; +import java.util.Date; +import java.text.SimpleDateFormat; import java.security.MessageDigest; import java.math.BigInteger; @@ -9,6 +11,7 @@ import com.badlogic.gdx.sql.DatabaseFactory; import com.badlogic.gdx.sql.SQLiteGdxException; import ch.asynk.rustanddust.RustAndDust; +import ch.asynk.rustanddust.game.Config.GameMode; public class DB { @@ -16,6 +19,7 @@ public class DB public static final int NO_RECORDS = -1; private static final String DIGEST = "SHA-256"; + private static final SimpleDateFormat df = new SimpleDateFormat("yyyy-mm-dd HH:mm:ss"); private boolean debug; private Database db; @@ -69,6 +73,7 @@ public class DB private static final String INSERT_STATE = "insert or replace into states(_g,hash,payload) values (%d,'%s','%s'); update games set ts=current_timestamp where _id=%d;"; private static final String UPDATE_GAME = "update games set _p1=%d, _p2=%d, ts=current_timestamp where _id=%d;"; private static final String GET_STATE = "select payload from states where _g=%d;"; + private static final String GET_GAMES = "select g.*, p1.name, p2.name, b.name from games g inner join players p1 on (g._p1=p1._id) inner join players p2 on (g._p2=p2._id) inner join battles b on (g._b=b._id);"; private static final String DB_CRT = TBL_CFG_CRT + TBL_PLAYERS_CRT + TBL_BATTLES_CRT + TBL_GAMES_CRT + TBL_TURNS_CRT + TBL_STATES_CRT; @@ -234,6 +239,33 @@ public class DB return ret; } + public void loadGames() + { + RustAndDust.debug("loadGames"); + GameRecord.clearList(); + GameRecord r = null; + try { + DatabaseCursor cursor = query(GET_GAMES); + if (cursor.getCount() > 0) { + while(cursor.next()) { + // cursor.next(); + r = GameRecord.get(); + r.g = cursor.getInt(0); + r.p1 = cursor.getInt(1); + r.p2 = cursor.getInt(2); + r.b = cursor.getInt(3); + r.m = GameMode.from(cursor.getInt(4)); + try { r.ts = df.parse(cursor.getString(5)); } + catch (java.text.ParseException e) { r.ts = null; RustAndDust.error(String.format("can't parse", cursor.getString(5))); } + r.p1Name = cursor.getString(6); + r.p2Name = cursor.getString(7); + r.bName = cursor.getString(8); + GameRecord.list.add(r); + } + } + } catch (SQLiteGdxException e) { r.dispose(); RustAndDust.error("loadGames"); } + } + private void exec(String sql) throws SQLiteGdxException { if (debug) RustAndDust.debug(" SQL " + sql); |