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