public static int GetRevision(SQLiteDatabase db)
{
if (db.Execute("SELECT DATEINFO FROM NAMES WHERE 0") == null)
return (int)PcdbRevision.Rev0;
if (db.Execute("SELECT 1 FROM DBVERSION WHERE 0") == null)
return (int)PcdbRevision.Rev1;
return Convert.ToInt32(db.Execute("SELECT VERSION FROM DBVERSION").Rows[0][0]);
}
public void PropagationHorizonCreateTable(ELEVATIONMODEL model, string tablename = "")
{
System.Data.SQLite.SQLiteDatabase db = GetPropagationDatabase(model);
lock (db.DBCommand)
{
// check for table name is null or empty --> use default tablename from type instead
string tn = tablename;
if (String.IsNullOrEmpty(tn))
{
tn = PropagationHorizonDesignator.TableName;
}
db.DBCommand.CommandText = "CREATE TABLE " + tn + " (Lat DOUBLE NOT NULL DEFAULT 0, Lon DOUBLE NOT NULL DEFAULT 0, h DOUBLE NOT NULL DEFAULT 0, Dist DOUBLE NOT NULL DEFAULT 0, QRG DOUBLE NOT NULL DEFAULT 0, Radius DOUBLE NOT NULL DEFAULT 0, F1_Clearance DOUBLE NOT NULL DEFAULT 0, StepWidth DOUBLE NOT NULL DEFAULT 0, Horizon BLOB, LastUpdated INT32, PRIMARY KEY (Lat, Lon, h, Dist, QRG, Radius, F1_Clearance, StepWidth))";
db.DBCommand.Parameters.Clear();
db.Execute(db.DBCommand);
}
}
public static PcdbGameVersion GetGameVersion(SQLiteDatabase db)
{
return (PcdbGameVersion)Convert.ToInt32(db.Execute("SELECT TYPEID FROM DBTYPE").Rows[0][0]);
}