// provided for DB upgrade operations at the basic level..
public void PerformUpgrade(int newVersion, bool catchErrors, bool backupDbFile, string[] queries, Action doAfterQueries = null)
{
if (backupDbFile)
{
string dbfile = DBFile;
try
{
File.Copy(dbfile, dbfile.Replace(".sqlite", $"{newVersion - 1}.sqlite"));
}
catch (Exception ex)
{
System.Diagnostics.Trace.WriteLine("Exception: " + ex.Message);
System.Diagnostics.Trace.WriteLine("Trace: " + ex.StackTrace);
}
}
try
{
ExecuteNonQueries(queries);
}
catch (Exception ex)
{
if (!catchErrors)
{
throw;
}
System.Diagnostics.Trace.WriteLine("Exception: " + ex.Message);
System.Diagnostics.Trace.WriteLine("Trace: " + ex.StackTrace);
System.Windows.Forms.MessageBox.Show($"UpgradeDB{newVersion} error: " + ex.Message);
}
doAfterQueries?.Invoke();
SQLExtRegister reg = new SQLExtRegister(this);
reg.PutSettingInt("DBVer", newVersion);
}
public bool PutSettingInt(string key, int intvalue)
{
return(registerclass.PutSettingInt(key, intvalue));
}
static public bool PutSettingInt(string key, int intvalue, TConn conn = null)
{
return(RegisterPut(cn => { var reg = new SQLExtRegister(cn); return reg.PutSettingInt(key, intvalue); }, conn));
}
