public static void TranferVisitedSystemstoJournalTableIfRequired() { if (System.IO.File.Exists(SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDiscovery))) { if (SQLiteDBClass.GetSettingBool("ImportVisitedSystems", false) == false) { TranferVisitedSystemstoJournalTable(); SQLiteDBClass.PutSettingBool("ImportVisitedSystems", true); } } }
public static void Initialize() { InitializeIfNeeded(() => { string dbv4file = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDiscovery); string dbuserfile = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDUser); if (File.Exists(dbv4file) && !File.Exists(dbuserfile)) { File.Copy(dbv4file, dbuserfile); } using (SQLiteConnectionUser conn = new SQLiteConnectionUser(true, true, EDDbAccessMode.Writer)) { UpgradeUserDB(conn); } }); }
private static bool SplitDataBase() { string dbfile = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDiscovery); string dbuserfile = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDUser); string dbsystemsfile = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDSystem); try { if (!File.Exists(dbuserfile)) { File.Copy(dbfile, dbuserfile); } } catch (Exception ex) { MessageBox.Show("SplitDatabase error: " + ex.Message); MessageBox.Show(ex.StackTrace); return(false); } return(true); }
private static void InitializeDatabase() { string dbv4file = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDiscovery); string dbuserfile = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDUser); string dbsystemsfile = SQLiteConnectionED.GetSQLiteDBFile(EDDSqlDbSelection.EDDSystem); DbFactory = GetSqliteProviderFactory(); try { if (File.Exists(dbv4file)) { SplitDataBase(); } SQLiteConnectionUser.Initialize(); SQLiteConnectionSystem.Initialize(); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show(ex.Message, "Error creating data base file, Exception", System.Windows.Forms.MessageBoxButtons.OK); } }