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