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);
}
}