private void setDataGridFunctions() { if (!Utils.IsDbEmbedded(GetServer().db_type)) { dataGridViewFunctions.DataSource = DbDataHelper.getDataTableData(GetSqlConnection(), new SqlBuilderFactory(GetServer()).Create(GetSqlConnection().Database).GetFunctions()); } }
private void fillTreeView() { if (cmbServers.Items.Count == 0) { return; } //ama den iparxei kanenas server den to kanei sqlservers server = null; this.Invoke((MethodInvoker) delegate() { server = sqlservers.CreateSqlServerFromDataTable(serverData, cmbServers); }); ConnectionResultSet result = DB.TestConnection(server); if (result.wasSuccessful) { DbConnection con = DB.connect(server); List <string> databases = null; if (Utils._convert(server.db_type) == sqlbox.commons.DbType.SQLITE) { databases = new List <string>() { "main" }; } else { databases = new SqlBuilderFactory(server) .Create(null).removeSystemDatabases(DbDataHelper.getDatabases(server, con), !hideSystemDatabases); } foreach (string database in databases) { this.Invoke((MethodInvoker) delegate() { TreeNode node = new TreeNode(database); node.ImageIndex = 0; List <string> tables = DbDataHelper.getTables(server, database, con); foreach (string table in tables) { TreeNode tablenode = new TreeNode(table); tablenode.ImageIndex = 1; node.Nodes.Add(tablenode); } tvDatabases.Nodes.Add(node); }); } DB.close(con); } else { this.Invoke((MethodInvoker) delegate() { MessageBox.Show("Connection failed: \n" + result.errorMessage, "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error); }); } }
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"); } } }
private void ComboBoxServers_SelectedIndexChanged(object sender, EventArgs e) { if (!Utils.IsDbEmbedded(GetServer().db_type)) { base.changeDatabase(comboBoxServers.SelectedItem.ToString()); } var tables = DbDataHelper.getTables(base.GetSqlConnection()); this.initTabControl(comboBoxServers.SelectedItem.ToString(), tables); GetMainHome().GetUserControl <Editor>().UpdateEditor( new SqlBuilderFactory(base.GetSqlConnection()).Create(null).removeSystemDatabases(tables, false)); }
private void TreeViewTables_BeforeExpand(object sender, TreeViewCancelEventArgs e) { if (!GetMainHome().GetUserControl <Editor>().GetQueryExecutor().IsAlive()) { switch ((e.Node as MyTreeNode).Type) { case NodeType.Table: { List <string> fields = DbDataHelper.getTableFields(GetSqlConnection(), e.Node.Text); List <string> fieldsInfo = DbDataHelper.getTableInfo(GetSqlConnection(), e.Node.Text); List <MyTreeNode> nodes = new List <MyTreeNode>(); foreach (string f in fields) { nodes.Add(new MyTreeNode() { Text = f, ImageIndex = 1, SelectedImageIndex = 1 }); } foreach (string f in fieldsInfo) { nodes.Add(new MyTreeNode() { Text = f, ImageIndex = 2, SelectedImageIndex = 2 }); } var triggerParentNode = new MyTreeNode() { Text = "Triggers", ImageIndex = 3, SelectedImageIndex = 3, Type = NodeType.ParentTrigger }; triggerParentNode.Nodes.Add(getDummy()); nodes.Add(triggerParentNode); this.setTableFields(nodes, e.Node as MyTreeNode); } break; case NodeType.ParentTrigger: { List <string> triggers = DbDataHelper.getTableTriggers(GetSqlConnection(), e.Node.Parent.Text); List <MyTreeNode> nodes = new List <MyTreeNode>(); foreach (string t in triggers) { nodes.Add(new MyTreeNode() { Text = t, Type = NodeType.Trigger, ImageIndex = 3, SelectedImageIndex = 3 }); } this.setTableFields(nodes, e.Node as MyTreeNode); } break; } } }
private void sendCreateTableWithTriggersToEditor(string table) { StringBuilder sb = new StringBuilder(); sb.Append(DbDataHelper.getCreateTable(GetSqlConnection(), table) + ";\r\n"); List <string> triggers = DbDataHelper.getTableTriggers(GetSqlConnection(), table); foreach (string t in triggers) { sb.Append("\r\n" + DbDataHelper.GetCreateTrigger(GetSqlConnection(), table, t) + "\r\n"); } GetMainHome().GetUserControl <Editor>().AddQueryTab(sb.ToString(), table); }
private void setDataGridViewPKs() { if (Utils.IsDbEmbedded(GetServer().db_type)) { sqlbox.commons.DbType type = Utils._convert(GetServer().db_type); if (type == sqlbox.commons.DbType.SQLITE) { dataGridViewPKs.DataSource = SqliteHelpers.GetDatabasePrimaryKeysDataSource(GetServer(), GetSqlConnection()); } } else { dataGridViewPKs.DataSource = DbDataHelper.getDataTableData(GetSqlConnection(), new SqlBuilderFactory(GetServer()).Create(GetSqlConnection().Database).getDatabasePrimaryKeys()); } }
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"); } } } }
private void treeViewTables_MouseUp(object sender, MouseEventArgs e) { if (e.Button == MouseButtons.Right) { Point p = new Point(e.X, e.Y); MyTreeNode node = treeViewTables.GetNodeAt(p) as MyTreeNode; if (node != null) { switch (node.Type) { case NodeType.Table: { treeViewTables.SelectedNode = node; TableTableMenu.Show(this, this.PointToClient(treeViewTables.PointToScreen(p))); } break; case NodeType.Trigger: { treeViewTables.SelectedNode = node; TableTriggersMenu.Show(this, this.PointToClient(treeViewTables.PointToScreen(p))); } break; } } } else if (e.Button == MouseButtons.Left && !GetMainHome().GetUserControl <Editor>().GetQueryExecutor().IsAlive()) { MyTreeNode node = treeViewTables.GetNodeAt(new Point(e.X, e.Y)) as MyTreeNode; if (node != null && node.Type == NodeType.Table && e.X > node.Bounds.Left - 15) { GetMainHome().GetUserControl <TableView>().setTableInfo(node.Text, DbDataHelper.getTableFields(GetSqlConnection(), node.Text) , DbDataHelper.getTableInfo(GetSqlConnection(), node.Text)); } } }
private void setDatagridviewTables(List <string> tables) { setRootTablesIntoTreeView(new SqlBuilderFactory(base.GetSqlConnection()) .Create(null).removeSystemDatabases(tables == null ? DbDataHelper.getTables(base.GetSqlConnection()) : tables, false)); }
internal void TreeViewTable_MenuItem_TruncateTable(object sender, EventArgs e) { DbDataHelper.executeNonQuery(GetSqlConnection(), "truncate table " + treeViewTables.SelectedNode.Text); refreshTables(); }
private void sendCreateTriggerToEditor(string table, string triggerName) { GetMainHome().GetUserControl <Editor>().AddQueryTab(DbDataHelper.GetCreateTrigger(GetSqlConnection(), table, triggerName), triggerName); }
private void sendCreateTableToEditor(string table) { GetMainHome().GetUserControl <Editor>().AddQueryTab(DbDataHelper.getCreateTable(GetSqlConnection(), table), table); }
private void setDatagridViews() { dataGridViewView.DataSource = DbDataHelper.getDataTableData(GetSqlConnection(), new SqlBuilderFactory(GetServer()).Create(GetSqlConnection().Database).GetAllViews()); }
private void setConnectionAndServerToUserControls() { this.pushConnection(); if (core.sql.Utils._convert(GetServer().db_type) == sqlbox.commons.DbType.SQLITE) { this.tabView1.setServerDataToComboBox(new List <string>() { "main" }); } else { this.tabView1.setServerDataToComboBox(new SqlBuilderFactory(GetServer()) .Create(null).removeSystemDatabases(DbDataHelper.getDatabases(this.server, this.con), this.showSystemDatabases)); } }
internal void UpdateEditor(List <string> tables) { this.UpdateEditor(tables, DbDataHelper.getTablesInfo(this.GetServer(), this.GetSqlConnection())); }
private void loadSqliteSettings() { checkBoxBeginTransAfterCommit.Checked = Properties.Settings.Default.option_sqlite_begintranscommit; checkBoxBeginTransAfterDbOpens.Checked = Properties.Settings.Default.option_sqlite_begintransdbopen; fastColoredTextBoxSqlAfterDbOpens.Text = Properties.Settings.Default.option_sqlite_sqlafteropen; checkBoxForeignKeys.Checked = Properties.Settings.Default.option_sqlite_foreign_keys; //load pragma if (DB.IsConnected(con) && Utils.GetDbTypeEnum(con) == sqlbox.commons.DbType.SQLITE) { var intList = DbDataHelper.getIntData(con, "PRAGMA auto_vacuum"); if (intList.Count > 0) { int val = intList[0]; //0 none,1 full, 2 INCREMENTAL switch (val) { case 0: comboBoxAutoVacuum.SelectedItem = "NONE"; break; case 1: comboBoxAutoVacuum.SelectedItem = "FULL"; break; case 2: comboBoxAutoVacuum.SelectedItem = "INCREMENTAL"; break; } } intList = DbDataHelper.getIntData(con, "PRAGMA automatic_index"); if (intList.Count > 0) { checkBoxAutoIndex.Checked = intList[0] == 0 ? false : true; } intList = DbDataHelper.getIntData(con, "PRAGMA cell_size_check"); if (intList.Count > 0) { checkBoxCellSizeCheck.Checked = intList[0] == 0 ? false : true; } intList = DbDataHelper.getIntData(con, "PRAGMA checkpoint_fullfsync"); if (intList.Count > 0) { checkBoxCheckFullSync.Checked = intList[0] == 0 ? false : true; } intList = DbDataHelper.getIntData(con, "PRAGMA defer_foreign_keys"); if (intList.Count > 0) { checkBoxDeferForeignKeys.Checked = intList[0] == 0 ? false : true; } intList = DbDataHelper.getIntData(con, "PRAGMA ignore_check_constraints"); if (intList.Count > 0) { checkBoxIgnoreCheckConstraints.Checked = intList[0] == 0 ? false : true; } var stringList = DbDataHelper.getStringData(con, "PRAGMA journal_mode"); if (stringList.Count > 0) { comboBoxJournalMode.SelectedItem = stringList[0].ToUpper(); } intList = DbDataHelper.getIntData(con, "PRAGMA journal_size_limit"); if (intList.Count > 0) { numericUpDownJournalSizeLimit.Value = intList[0]; } stringList = DbDataHelper.getStringData(con, "PRAGMA locking_mode"); if (stringList.Count > 0) { comboBoxLockMode.SelectedItem = stringList[0].ToUpper(); } intList = DbDataHelper.getIntData(con, "PRAGMA max_page_count"); if (intList.Count > 0) { numericMaxPageCount.Value = intList[0]; } intList = DbDataHelper.getIntData(con, "PRAGMA page_size"); if (intList.Count > 0) { numericPageSize.Value = intList[0]; } intList = DbDataHelper.getIntData(con, "PRAGMA recursive_triggers"); if (intList.Count > 0) { checkBoxRecursiveTriggers.Checked = intList[0] == 0 ? false : true; } intList = DbDataHelper.getIntData(con, "PRAGMA secure_delete"); if (intList.Count > 0) { checkBoxSecureDelete.Checked = intList[0] == 0 ? false : true; } intList = DbDataHelper.getIntData(con, "PRAGMA synchronous"); if (intList.Count > 0) { int val = intList[0]; //0 OFF,1 NORMAL, 2 FULL, 3 EXTRA switch (val) { case 0: comboBoxSynchronous.SelectedItem = "OFF"; break; case 1: comboBoxSynchronous.SelectedItem = "NORMAL"; break; case 2: comboBoxSynchronous.SelectedItem = "FULL"; break; case 3: comboBoxSynchronous.SelectedItem = "EXTRA"; break; } } intList = DbDataHelper.getIntData(con, "PRAGMA user_version"); if (intList.Count > 0) { numericUpDownUserVersion.Value = intList[0]; } } }
private void ShowHideSystemDbEventClick(object sender, EventArgs e) { if (DB.IsConnected(this.con) && !core.sql.Utils.IsDbEmbedded(GetServer().db_type)) { this.tabView1.setServerDataToComboBox(new SqlBuilderFactory(GetServer()) .Create(null).removeSystemDatabases(DbDataHelper.getDatabases(this.server, this.con), this.showSystemDatabases = !this.showSystemDatabases)); } }