public static int SaveQuery(int tabId, int currentQueryId, string expr, bool executing) { // string now = "'" + DateTime.Now.ToString("u") + "'"; double now = DateTime.Now.ToEpoch(); expr = QSqlLite.n(expr); bool justUpdate = (currentQueryId != 0 && 0 != QSqlLite.SqlInt("select count(*) from queries where id=" + currentQueryId + " and expr='" + expr + "'")); string sql; if (justUpdate) { sql = "update queries set expr='" + expr + "',when_changed=" + now; sql += " where id = " + currentQueryId; QSqlLite.Exec(sql); } else { sql = "insert into queries (tab_id, expr,when_changed) values (" + tabId + ",'" + expr + "'," + now + ")"; currentQueryId = QSqlLite.Exec(sql); } return(currentQueryId); }
public static void SetQueryName(int id, string name) { QSqlLite.Exec("update tabs set name='" + QSqlLite.n(name) + "' where id=" + id); }
public static void SaveSettings(bool shuttingDown) { lock (settings) { A.AddToLog("saving settings"); string sql = "delete from settings;"; foreach (string key in settings.Keys) { sql += "insert into settings (name,value) values ('" + key + "', '" + QSqlLite.n(settings[key]) + "');"; } QSqlLite.Exec(sql); dirty = false; BindingFlags flags = BindingFlags.DeclaredOnly | BindingFlags.Public | BindingFlags.Instance | BindingFlags.GetField | BindingFlags.GetProperty; if (A.dbId > 0) { sql = "delete from tables;delete from table_columns;delete from table_aliases;"; foreach (DbTable table in A.db.tables.Values) { if (table.hasSettings) { sql += QObject.RenderInsert(table, "tables", false, flags); foreach (DbColumn column in table.columns.Values) { if (column.hasSettings) { sql += QObject.RenderInsert(column, "table_columns", false, flags); } } foreach (DbAlias a in table.aliases.Values) { if (a.hasSettings) { sql += QObject.RenderInsert(a, "table_aliases", false, flags); } } } } QSqlLite.Exec(sql); if (shuttingDown) { initSettings.shutDownClean = true; sql = "delete from init_settings;" + QObject.RenderInsert(initSettings, "init_settings", false); QSqlLite.Exec(sql); } } } }