public void RegisterHotKeys(bool reload)
{
if (reload)
{
HotKeyUtil.UnRegisterHotKeys();
}
HotKeyUtil.RegisterHotKey(SettingItemUtils.GetMainWindowOpenHotkey(), OnOpenWindowHotKey);
}
public static void DoUpgradeDb()
{
var dbVerItem = SettingItemUtils.GetDbVersion();
int v = Convert.ToInt32(dbVerItem.Value);
Trace.TraceInformation("current database version {0}", v);
UpgradeSQL upgradeSQL = GlobalSetting.Instance.GetUpgradeSQL();
int newerVersion = upgradeSQL.SQLS.Count;
Trace.TraceInformation("newer database version {0}", newerVersion);
if (newerVersion > v)
{
Trace.TraceInformation("upgrade database version from {0} to {1}", v, newerVersion);
using (var dbConn = getConnection())
{
dbConn.Open();
using (var transaction = dbConn.BeginTransaction())
{
for (int i = v; i < newerVersion; i++)
{
List <string> sqls = upgradeSQL.SQLS[i];
foreach (string sql in sqls)
{
Trace.TraceInformation("run sql {0}", sql);
var cmd = new SqliteCommand(sql, dbConn, transaction);
cmd.ExecuteNonQuery();
}
}
Trace.TraceInformation("write current database version to db");
var verSQL = string.Format("INSERT OR REPLACE INTO SETTING(KEY, VALUE) VALUES ('db.version', '{0}');", newerVersion);
var verCmd = new SqliteCommand(verSQL, dbConn, transaction);
verCmd.ExecuteNonQuery();
transaction.Commit();
}
}
}
else
{
Trace.TraceInformation("database version is already the latest");
}
}
private void loadSettings()
{
viewSetting = SettingItemUtils.GetViewMode();
}