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