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