internal void TreeViewTableTriggers_MenuItem_DropTrigger(object sender, EventArgs e) { if (IsNodeSelected()) { DbDataHelper.executeNonQuery(GetSqlConnection(), "drop trigger " + treeViewTables.SelectedNode.Text); treeViewTables.SelectedNode.Parent.Collapse(); } }
internal void TreeViewTable_MenuItem_DropTable(object sender, EventArgs e) { if (IsNodeSelected()) { DbDataHelper.executeNonQuery(GetSqlConnection(), "drop table " + treeViewTables.SelectedNode.Text); refreshTables(); } }
private void CommitBtnEventClick(object sender, EventArgs e) { if (DB.IsConnected(this.con)) { DB.Commit(this.con); if (Utils._convert(server.db_type) == sqlbox.commons.DbType.SQLITE && Properties.Settings.Default.option_sqlite_begintranscommit) { DbDataHelper.executeNonQuery(con, "begin transaction"); } } }
internal void applySettingsAfterOpen() { if (core.sql.Utils._convert(server.db_type) == sqlbox.commons.DbType.SQLITE) { if (Properties.Settings.Default.option_sqlite_begintransdbopen) { //sqlite transaction is needed to make db updates/changes DbDataHelper.executeNonQuery(con, "begin transaction"); } if (!string.IsNullOrWhiteSpace(Properties.Settings.Default.option_sqlite_sqlafteropen)) { DbDataHelper.executeNonQuery(con, Properties.Settings.Default.option_sqlite_sqlafteropen); } } else { DbDataHelper.executeNonQuery(con, "set autocommit=" + (Properties.Settings.Default.option_general_autocommit == true ? "1" : "0")); } }
private void buttonSavePragma_Click(object sender, EventArgs e) { if (DB.IsConnected(con) && Utils.GetDbTypeEnum(con) == sqlbox.commons.DbType.SQLITE) { var dialog = new CommitRollbackForm(); dialog.ShowDialog(); if (dialog.action != null) { if (dialog.action == DbData.COMMIT) { DB.Commit(con); } else if (dialog.action == DbData.ROLLBACK) { DB.Rollback(con); } Properties.Settings.Default.option_sqlite_foreign_keys = checkBoxForeignKeys.Checked; //0 none,1 full, 2 INCREMENTAL if (comboBoxAutoVacuum.SelectedItem == "NONE") { DbDataHelper.executeNonQuery(con, "pragma auto_vacuum = 0"); } else if (comboBoxAutoVacuum.SelectedItem == "FULL") { DbDataHelper.executeNonQuery(con, "pragma auto_vacuum = 1"); } else if (comboBoxAutoVacuum.SelectedItem == "INCREMENTAL") { DbDataHelper.executeNonQuery(con, "pragma auto_vacuum = 2"); } if (checkBoxRunVacuum.Checked) { DbDataHelper.executeNonQuery(con, "vacuum"); } } } }
internal void TreeViewTable_MenuItem_TruncateTable(object sender, EventArgs e) { DbDataHelper.executeNonQuery(GetSqlConnection(), "truncate table " + treeViewTables.SelectedNode.Text); refreshTables(); }