public static void ReplaceSystemsTable()
{
using (var slock = new SQLiteConnectionSystem.SchemaLock())
{
using (var conn = new SQLiteConnectionSystem())
{
DropSystemsTableIndexes();
using (var txn = conn.BeginTransaction())
{
SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS Systems");
SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS EdsmSystems");
SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS SystemNames");
SQLiteDBClass.ExecuteQuery(conn, "ALTER TABLE EdsmSystems_temp RENAME TO EdsmSystems");
SQLiteDBClass.ExecuteQuery(conn, "ALTER TABLE SystemNames_temp RENAME TO SystemNames");
txn.Commit();
}
SQLiteDBClass.ExecuteQuery(conn, "VACUUM");
CreateSystemsTableIndexes();
}
}
}
public static void ReplaceSystemsTable()
{
using (var slock = new SQLiteConnectionSystem.SchemaLock())
{
using (var conn = new SQLiteConnectionSystem())
{
DropSystemsTableIndexes();
using (var txn = conn.BeginTransaction())
{
SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS Systems");
SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS EdsmSystems");
SQLiteDBClass.ExecuteQuery(conn, "DROP TABLE IF EXISTS SystemNames");
SQLiteDBClass.ExecuteQuery(conn, "ALTER TABLE EdsmSystems_temp RENAME TO EdsmSystems");
SQLiteDBClass.ExecuteQuery(conn, "ALTER TABLE SystemNames_temp RENAME TO SystemNames");
txn.Commit();
}
SQLiteDBClass.ExecuteQuery(conn, "VACUUM");
CreateSystemsTableIndexes();
}
}
}
