/// <summary>
/// Sets up database.
/// </summary>
/// <param name="dbPath">Db path.</param>
private static void SetUpDatabase(String dbPath)
{
lock (_lock)
{
SQLiteStatement stmt = null;
try
{
db = new SQLiteDatabase(System.IO.Path.Combine(AmazonHookedPlatformInfo.Instance.PersistentDataPath, dbPath));
//turn on auto vacuuming so that when events are deleted, then we can recover the table space.
string query = "PRAGMA auto_vacuum = 1";
db.Exec(query);
query = "SELECT count(*) as count FROM sqlite_master WHERE type='table' AND name='" + TABLE_NAME + "'";
stmt = db.Prepare(query);
if (stmt.Read() && stmt.Fields["count"].INTEGER == 0)
{
query = "CREATE TABLE " + TABLE_NAME + " ("
+ EVENT_COLUMN_NAME + " TEXT NOT NULL," + EVENT_ID_COLUMN_NAME + " TEXT NOT NULL UNIQUE,"
+ MA_APP_ID_COLUMN_NAME + " TEXT NOT NULL,"
+ EVENT_DELIVERY_ATTEMPT_COUNT_COLUMN_NAME + " INTEGER NOT NULL DEFAULT 0)";
db.Exec(query);
}
}
catch (Exception e)
{
_logger.Error(e, "");
}
finally
{
if (stmt != null)
{
stmt.FinalizeStm();
}
}
}
}
private void SetupDatabase()
{
lock (sqlite_lock)
{
SQLiteStatement stmt = null;
try
{
db = new SQLiteDatabase(this.dataPath);
string query = "SELECT count(*) as count FROM sqlite_master WHERE type='table' AND name='" + TABLE_DATASETS + "'";
stmt = db.Prepare(query);
if (stmt.Read() && stmt.Fields["count"].INTEGER == 0)
{
_logger.InfoFormat("{0}", @"Cognito Sync - SQLiteStorage - running create dataset");
db.Exec(
"CREATE TABLE " + TABLE_DATASETS + "("
+ DatasetColumns.IDENTITY_ID + " TEXT NOT NULL,"
+ DatasetColumns.DATASET_NAME + " TEXT NOT NULL,"
+ DatasetColumns.CREATION_TIMESTAMP + " TEXT DEFAULT '0',"
+ DatasetColumns.LAST_MODIFIED_TIMESTAMP + " TEXT DEFAULT '0',"
+ DatasetColumns.LAST_MODIFIED_BY + " TEXT,"
+ DatasetColumns.STORAGE_SIZE_BYTES + " INTEGER DEFAULT 0,"
+ DatasetColumns.RECORD_COUNT + " INTEGER DEFAULT 0,"
+ DatasetColumns.LAST_SYNC_COUNT + " INTEGER NOT NULL DEFAULT 0,"
+ DatasetColumns.LAST_SYNC_TIMESTAMP + " INTEGER DEFAULT '0',"
+ DatasetColumns.LAST_SYNC_RESULT + " TEXT,"
+ "UNIQUE (" + DatasetColumns.IDENTITY_ID + ", "
+ DatasetColumns.DATASET_NAME + ")"
+ ")");
}
stmt.FinalizeStm();
query = "SELECT count(*) as count FROM sqlite_master WHERE type='table' AND name='" + TABLE_RECORDS + "'";
stmt = db.Prepare(query);
if (stmt.Read() && stmt.Fields["count"].INTEGER == 0)
{
_logger.InfoFormat("{0}", @"Cognito Sync - SQLiteStorage - running create dataset");
db.Exec(
"CREATE TABLE " + TABLE_RECORDS + "("
+ RecordColumns.IDENTITY_ID + " TEXT NOT NULL,"
+ RecordColumns.DATASET_NAME + " TEXT NOT NULL,"
+ RecordColumns.KEY + " TEXT NOT NULL,"
+ RecordColumns.VALUE + " TEXT,"
+ RecordColumns.SYNC_COUNT + " INTEGER NOT NULL DEFAULT 0,"
+ RecordColumns.LAST_MODIFIED_TIMESTAMP + " TEXT DEFAULT '0',"
+ RecordColumns.LAST_MODIFIED_BY + " TEXT,"
+ RecordColumns.DEVICE_LAST_MODIFIED_TIMESTAMP + " TEXT DEFAULT '0',"
+ RecordColumns.MODIFIED + " INTEGER NOT NULL DEFAULT 1,"
+ "UNIQUE (" + RecordColumns.IDENTITY_ID + ", " + RecordColumns.DATASET_NAME
+ ", " + RecordColumns.KEY + ")"
+ ")");
}
}
finally
{
if (stmt != null)
{
stmt.FinalizeStm();
}
}
_logger.InfoFormat("{0}", @"Cognito Sync - SQLiteStorage - completed setupdatabase");
}
}