private void InitDataFormData(object sender, EventArgs e)
{
mysql_serversAdapter = new firedumpdbDataSetTableAdapters.sql_serversTableAdapter();
serverData = new firedumpdbDataSet.sql_serversDataTable();
mysql_serversAdapter.Fill(serverData);
comboBox1.DataSource = serverData;
comboBox1.DisplayMember = "name";
comboBox1.ValueMember = "id";
}
private void loadComboBoxServers()
{
serverData = new firedumpdbDataSet.sql_serversDataTable();
mysql_serversAdapter = new firedumpdbDataSetTableAdapters.sql_serversTableAdapter();
mysql_serversAdapter.Fill(serverData);
cmbServers.DataSource = serverData;
cmbServers.DisplayMember = "name";
cmbServers.ValueMember = "id";
if (cmbServers.Items.Count > 0)
{
cmbServers.SelectedIndex = 0;
//backgroundWorker1.RunWorkerAsync();
fillDatabaseCmb(null, null);
}
}
private void bSave_Click(object sender, EventArgs e)
{
firedumpdbDataSetTableAdapters.sql_serversTableAdapter adapter = new firedumpdbDataSetTableAdapters.sql_serversTableAdapter();
if (string.IsNullOrEmpty(tbName.Text))
{
MessageBox.Show("Type a name for the new server", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if ((Int64)adapter.numberOfOccurances(tbName.Text) == 0 || isUpdate)
{
if (!performChecks())
{
return;
}
sqlservers server = createMySqlServerInfoCreds();
String passwd = EncryptionUtils.sEncrypt(server.password);
string path = null;
DbType type = Firedump.core.sql.Utils._convert(((ToolStripItemDbType)this.comboBoxDbTypes.SelectedItem).db_type);
if (Firedump.core.sql.Utils.IsDbEmbedded(type))
{
path = textBoxPath.Text;
}
if (isUpdate)
{
adapter.UpdateMySqlServerById(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, mysqlserver.id);
}
else
{
adapter.InsertQuery(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, (int)type, path);
}
int id = Convert.ToInt32((Int64)adapter.GetIdByName(tbName.Text));
onReloadServerData(id);
this.Close();
return;
}
MessageBox.Show("Name " + tbName.Text + " already exists", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbPassword.Text = "";
tbName.Text = "";
isUpdate = false;
}
private void bSave_Click(object sender, EventArgs e)
{
firedumpdbDataSetTableAdapters.sql_serversTableAdapter adapter = new firedumpdbDataSetTableAdapters.sql_serversTableAdapter();
if (string.IsNullOrEmpty(tbName.Text))
{
MessageBox.Show("Type a name for the new server", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if ((Int64)adapter.numberOfOccurances(tbName.Text) == 0 || isUpdate)
{
if (!performChecks())
{
return;
}
sqlservers server = createMySqlServerInfoCreds();
String passwd = EncryptionUtils.sEncrypt(server.password);
if (isUpdate)
{
adapter.UpdateMySqlServerById(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, mysqlserver.id);
}
else
{
adapter.InsertQuery(tbName.Text, server.port, server.host, server.username, passwd, tbDatabase.Text, 0); //prepei na bei kai
}
//adapter.Insert(tbName.Text, server.port, server.host, server.username, server.password, tbDatabase.Text); //prepei na bei kai database
int id = Convert.ToInt32((Int64)adapter.GetIdByName(tbName.Text));
onReloadServerData(id);
this.Close();
return;
}
MessageBox.Show("Name " + tbName.Text + " already exists", "Test Connection", MessageBoxButtons.OK, MessageBoxIcon.Warning);
tbUsername.Text = "";
tbPassword.Text = "";
tbHost.Text = "";
tbName.Text = "";
tbDatabase.Text = "";
isUpdate = false;
}
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);
}
