/// <summary>
/// Create long_operations_status table
/// </summary>
/// <param name="connection"></param>
private static void CreateLongOperationsStatusTable(DBHelper db)
{
var sb = new StringBuilder();
sb.Append("CREATE TABLE IF NOT EXISTS ").Append(LongOperationsStatusTable).Append(" (")
.Append(IdCol).Append(" INTEGER PRIMARY KEY AUTOINCREMENT")
.Append(",").Append(TypeCol).Append(" TEXT")
.Append(",").Append(DetailsCol).Append(" TEXT")
.Append(",").Append(StatusCol).Append(" TEXT")
.Append(", ").Append(CreatedCol).Append(" INTEGER")
.Append(", ").Append(LastModifiedCol).Append(" INTEGER")
.Append(")");
db.Execute(sb.ToString());
}
public static DBHelper GetInstance(string sqliteDbFile)
{
if (_instances == null)
{
_instances = new Dictionary<string, DBHelper>();
}
DBHelper instance;
if (!_instances.TryGetValue(sqliteDbFile, out instance))
{
instance = new DBHelper(sqliteDbFile);
_instances.Add(sqliteDbFile, instance);
}
return instance;
}
