/// <summary>
/// Creates new instance of SQLiteVdbe class by compiling a statement
/// </summary>
/// <param name="query"></param>
/// <returns>Vdbe</returns>
public SQLiteVdbe( SQLiteDatabase db, String query )
{
vm = null;
// prepare and compile
csSQLite.sqlite3_prepare_v2( db.Connection(), query, query.Length, ref vm, 0 );
}
private void InitializeTables(SQLiteDatabase db)
{
db.ExecuteNonQuery("BEGIN EXCLUSIVE");
for (int i = 0; i < CREATE_Commands.Length; i++)
{
db.ExecuteNonQuery(CREATE_Commands[i]);
}
}
private SQLiteDatabase OpenDB(string fileName)
{
if (File.Exists(fileName))
File.Delete(fileName);
var db = new SQLiteDatabase(fileName);
for (int i = 0; i < PRAGMA_Commands.Length; i++)
{
db.ExecuteNonQuery(PRAGMA_Commands[i]);
}
return db;
}
