private void deployTypeSet(ConfigurationForm form, Configuration config) { if (form.DeployTypeRadioDropCreate.Checked) { config.type = 1; } else { if (form.DeployTypeRadioAlter.Checked) { config.type = 2; } else if (form.DeployTypeRadioTransfer.Checked) { config.type = 3; } else { config.type = 4; } } }
private void configAddButton_Click(object sender, EventArgs e) { Source source = (Source)(sourceList.SelectedItem); if (source == null) { MessageBox.Show("Please select a source to which you want to add a configuration."); } else { bool AlreadyClosed = false; ConfigurationForm form = new ConfigurationForm(); form.meta = meta; form.dbDeployForm = this; if (form.ShowDialog() == DialogResult.OK) { Configuration config = new Configuration(); config.title = form.TitleText.Text; config.transferMaxRows = long.Parse(form.maxRowsText.Text); //config.targetId = target.id; deployTypeSet(form, config); if (form.SchemaSelectRadioInclude.Checked) config.tableSelectSchema = 1; else config.tableSelectSchema = 2; if (form.DataSelectRadioInclude.Checked) config.tableSelectData = 1; else config.tableSelectData = 2; if (form.DataTransferCheckStatic.Checked) config.transferStaticData = "Y"; else config.transferStaticData = "N"; if (form.DataTransferCheckTypes.Checked) config.transferTypesData = "Y"; else config.transferTypesData = "N"; if (form.ddlLoggingRadioNone.Checked) config.ddlLogging = Configuration.DdlLogging.none; else if (form.ddlLoggingRadioChanges.Checked) config.ddlLogging = Configuration.DdlLogging.changes; else config.ddlLogging = Configuration.DdlLogging.all; // Could get this from the DB but iiSDLC says it should ALWAYS be done if (form.backupPerformCheck.Checked) config.backupPerform = "Y"; else config.backupPerform = "N"; config.backupLocation = form.backupLocationText.Text; if (form.excludeSchemaTempCheck.Checked) config.tempExcludeSchema = "Y"; else config.tempExcludeSchema = "N"; if (form.excludeDataTempCheck.Checked) config.tempExcludeData = "Y"; else config.tempExcludeData = "N"; if (form.SyncFKCheck.Checked) config.FKCheckSync = "Y"; else config.FKCheckSync = "N"; OdbcCommand command = new OdbcCommand(); command.Connection = meta; command.CommandType = CommandType.Text; command.CommandText = "insert into meta_db_deploy_configurations( " + " meta_db_deploy_type, " + " meta_db_deploy_tbl_sel_schema, " + " meta_db_deploy_tbl_sel_data, " + " meta_dbdc_title, " + " meta_dbdc_transfer_static_data, " + " meta_dbdc_transfer_types_data, " + " meta_dbdc_transfer_max_rows, " + " meta_db_deploy_log_type, " + " meta_dbdc_temp_exclude_schema, " + " meta_dbdc_temp_exclude_data, " + " meta_dbdc_backup_perform, " + " meta_dbdc_backup_location, " + " meta_dbdc_exclude_fk " + ") " + " values (" + config.type + ", " + config.tableSelectSchema + ", " + config.tableSelectData + ", " + " ?, " + " '" + config.transferStaticData + "', " + " '" + config.transferTypesData + "', " + config.transferMaxRows + ", " + ((long)config.ddlLogging) + ", " + " '" + config.tempExcludeSchema + "', " + " '" + config.tempExcludeData + "', " + " '" + config.backupPerform +"', " + " ? " + ", " + " '" + config.FKCheckSync + "'" + ")"; command.Parameters.Add(new OdbcParameter("1", config.title)); command.Parameters.Add(new OdbcParameter("2", config.backupLocation)); try { meta.Open(); try { if (command.ExecuteNonQuery() == 1) { log.log(Logger.LogLevel.info, "Configuration added successfully."); command.CommandText = "select max(meta_db_deploy_configuration) from meta_db_deploy_configurations"; config.id = (long)(command.ExecuteScalar()); meta.Close(); AlreadyClosed = true; configurationList.Items.Add(config); configurationList.SelectedItem = config; TableSelectUpdate(config, form.SchemaTableList, form.DataTableList, form.FilterTableList); } else { log.log(Logger.LogLevel.error, "Configuration was not added."); } } catch (Exception ex) { log.log(Logger.LogLevel.error, "Exception occurred while trying to add configuration..."); log.log(Logger.LogLevel.error, ex.Message); } finally { if (!AlreadyClosed) { meta.Close(); } } } catch (Exception ex) { log.log(Logger.LogLevel.error, "Exception occurred while trying to add configuration..."); log.log(Logger.LogLevel.error, ex.Message); } } } }
private void configEditButton_Click(object sender, EventArgs e) { Configuration config = (Configuration)(configurationList.SelectedItem); if (config == null) { MessageBox.Show("Please select a configuration to edit."); } else { ConfigurationForm form = new ConfigurationForm(); form.meta = meta; form.dbDeployForm = this; form.TitleText.Text = config.title; form.maxRowsText.Text = config.transferMaxRows.ToString(); switch (config.type) { case 1: form.DeployTypeRadioDropCreate.Checked = true; break; case 2: form.DeployTypeRadioAlter.Checked = true; break; case 3: form.DeployTypeRadioTransfer.Checked = true; break; case 4: form.DeployTypeRadioLogOnly.Checked = true; break; } if (config.tableSelectSchema == 1) form.SchemaSelectRadioInclude.Checked = true; else form.SchemaSelectRadioExclude.Checked = true; if (config.tableSelectData == 1) form.DataSelectRadioInclude.Checked = true; else form.DataSelectRadioExclude.Checked = true; if (config.transferStaticData == "Y") form.DataTransferCheckStatic.Checked = true; else form.DataTransferCheckStatic.Checked = false; if (config.transferTypesData == "Y") form.DataTransferCheckTypes.Checked = true; else form.DataTransferCheckTypes.Checked = false; switch (config.ddlLogging) { case Configuration.DdlLogging.none: form.ddlLoggingRadioNone.Checked = true; break; case Configuration.DdlLogging.changes: form.ddlLoggingRadioChanges.Checked = true; break; case Configuration.DdlLogging.all: form.ddlLoggingRadioAll.Checked = true; break; } // Could get this from the DB but iiSDLC says it should ALWAYS be done form.backupPerformCheck.Checked = true; form.backupLocationText.Text = config.backupLocation; if (config.tempExcludeSchema == "Y") form.excludeSchemaTempCheck.Checked = true; else form.excludeSchemaTempCheck.Checked = false; if (config.tempExcludeData == "Y") form.excludeDataTempCheck.Checked = true; else form.excludeDataTempCheck.Checked = false; if (config.FKCheckSync == "Y") form.SyncFKCheck.Checked = true; else form.SyncFKCheck.Checked = false; TableSelectSet(form.SchemaTableList, config.schemaTables); TableSelectSet(form.DataTableList, config.dataTables); TableSelectSet(form.FilterTableList, config.filterTables); if (form.ShowDialog() == DialogResult.OK) { config.title = form.TitleText.Text; config.transferMaxRows = long.Parse(form.maxRowsText.Text); deployTypeSet(form,config); if (form.SchemaSelectRadioInclude.Checked) config.tableSelectSchema = 1; else config.tableSelectSchema = 2; if (form.DataSelectRadioInclude.Checked) config.tableSelectData = 1; else config.tableSelectData = 2; if (form.DataTransferCheckStatic.Checked) config.transferStaticData = "Y"; else config.transferStaticData = "N"; if (form.DataTransferCheckTypes.Checked) config.transferTypesData = "Y"; else config.transferTypesData = "N"; if (form.ddlLoggingRadioNone.Checked) config.ddlLogging = Configuration.DdlLogging.none; else if (form.ddlLoggingRadioChanges.Checked) config.ddlLogging = Configuration.DdlLogging.changes; else config.ddlLogging = Configuration.DdlLogging.all; // Could get this from the DB but iiSDLC says it should ALWAYS be done if (form.backupPerformCheck.Checked) config.backupPerform = "Y"; else config.backupPerform = "N"; config.backupLocation = form.backupLocationText.Text; if (form.excludeSchemaTempCheck.Checked) config.tempExcludeSchema = "Y"; else config.tempExcludeSchema = "N"; if (form.excludeDataTempCheck.Checked) config.tempExcludeData = "Y"; else config.tempExcludeData = "N"; if (form.SyncFKCheck.Checked) config.FKCheckSync = "Y"; else config.FKCheckSync = "N"; OdbcCommand command = new OdbcCommand(); command.Connection = meta; command.CommandType = CommandType.Text; command.CommandText = "update meta_db_deploy_configurations" + //" set meta_db_deploy_target = " + config.targetId + "," + " set meta_db_deploy_type = " + config.type + "," + " meta_db_deploy_tbl_sel_schema = " + config.tableSelectSchema + "," + " meta_db_deploy_tbl_sel_data = " + config.tableSelectData + "," + " meta_dbdc_title = ?," + " meta_dbdc_transfer_static_data = '" + config.transferStaticData + "'," + " meta_dbdc_transfer_types_data = '" + config.transferTypesData + "', " + " meta_dbdc_transfer_max_rows = " + config.transferMaxRows + ", " + " meta_db_deploy_log_type = " + ((long)config.ddlLogging) + "," + " meta_dbdc_temp_exclude_schema = '" + config.tempExcludeSchema + "'," + " meta_dbdc_temp_exclude_data = '" + config.tempExcludeData + "'," + " meta_dbdc_backup_perform = '" + config.backupPerform + "'," + " meta_dbdc_backup_location = ?," + " meta_dbdc_exclude_fk = '" + config.FKCheckSync + "'" + " where meta_db_deploy_configuration = " + config.id; command.Parameters.Add(new OdbcParameter("1", config.title)); command.Parameters.Add(new OdbcParameter("2", config.backupLocation)); try { meta.Open(); try { if (command.ExecuteNonQuery() == 1) { log.log(Logger.LogLevel.info, "Configuration udpated successfully."); } else { log.log(Logger.LogLevel.error, "Configuration was not updated."); } } catch (Exception ex) { log.log(Logger.LogLevel.error, "Exception occurred while trying to update configuration..."); log.log(Logger.LogLevel.error, ex.Message); } finally { meta.Close(); } } catch (Exception ex) { log.log(Logger.LogLevel.error, "Exception occurred while trying to add target..."); log.log(Logger.LogLevel.error, ex.Message); } TableSelectUpdate(config, form.SchemaTableList,form.DataTableList, form.FilterTableList); // Force the title in the list to be updated. configurationList.Items.Remove(config); configurationList.Items.Add(config); configurationList.SelectedItem = config; } } }