public NewSqlServer(firedumpdbDataSet.sql_serversRow server) : this() { bSave.Text = "Update"; this.isUpdate = true; this.mysqlserver = server; tbName.Text = server.name; tbHost.Text = server.host; if (server.port != 0) { tbPort.Text = server.port.ToString(); } tbUsername.Text = server.username; tbPassword.Text = !string.IsNullOrEmpty(server.password) ? EncryptionUtils.sDecrypt(server.password) : null; tbDatabase.Text = server.database; checkkDbType(server.db_type); setSelectedItem(server.db_type); DbType type = Firedump.core.sql.Utils._convert(server.db_type); if (Firedump.core.sql.Utils.IsDbEmbedded(type) && string.IsNullOrEmpty(textBoxPath.Text)) { this.textBoxPath.Text = server.path; } this.groupBoxDetails.Enabled = true; this.comboBoxDbTypes.Enabled = false; }
private void btEditServer_Click(object sender, EventArgs e) { if (cmbServers.Items.Count > 0 && cmbServers.SelectedIndex >= 0) { firedumpdbDataSet.sql_serversRow server = ((firedumpdbDataSet.sql_serversDataTable)cmbServers.DataSource).ElementAt(cmbServers.SelectedIndex); NewSqlServer newServer = new NewSqlServer(server); newServer.ReloadServerData += reloadserverData; newServer.Show(); } }
public NewSqlServer(bool update, firedumpdbDataSet.sql_serversRow server) { InitializeComponent(); bSave.Text = "Update"; this.isUpdate = update; this.mysqlserver = server; tbName.Text = server.name; tbHost.Text = server.host; if (server.port != 0) { tbPort.Text = server.port.ToString(); } tbUsername.Text = server.username; tbPassword.Text = EncryptionUtils.sDecrypt(server.password); tbDatabase.Text = server.database; }
internal void Start() { List <string> tables = utils.StringUtils.extractTableListFromString(schedulesRow.tables); string database = schedulesRow.database; firedumpdbDataSetTableAdapters.sql_serversTableAdapter serveradapter = new firedumpdbDataSetTableAdapters.sql_serversTableAdapter(); firedumpdbDataSet.sql_serversDataTable servertable = new firedumpdbDataSet.sql_serversDataTable(); serveradapter.FillById(servertable, schedulesRow.server_id); if (servertable?.Count > 0) { //File.AppendAllText(@"servicelog.txt", "COUNT:"+servertable.Count+","); server = servertable[0]; } else { //File.AppendAllText(@"servicelog.txt", "COUNT:" + "EMPTY" + ","); return; } DumpCredentialsConfig dumpConfig = new DumpCredentialsConfig(server.host, (int)server.port, server.username, server.password, database); if (tables.Count > 0) { dumpConfig.excludeTables = tables.ToArray(); } mysqldumpAdapter = new SqlDumpAdapter(); mysqldumpAdapter.Cancelled += OnCancelled; mysqldumpAdapter.Completed += OnCompleted; mysqldumpAdapter.CompressProgress += oncompressprogress; mysqldumpAdapter.CompressStart += oncompstart; mysqldumpAdapter.Error += onerror; mysqldumpAdapter.InitDumpTables += oninitdumptables; mysqldumpAdapter.Progress += onprogress; mysqldumpAdapter.TableRowCount += ontablerowcount; mysqldumpAdapter.TableStartDump += ontablestartdump; //File.AppendAllText(@"servicelog.txt", "STARTDUMP"); mysqldumpAdapter.startDump(dumpConfig); }