private List <ViewClass> ExportViewStructure(ExportWorkers ew)
{
var allv = new List <ViewClass>();
for (var i = 0; i < selStructureViews.ItemDatas.Count; i++)
{
var itm = (ItemDataClass)selStructureViews.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = (DataObjectClass)itm.Object;
if (tc?.GetType() != typeof(ViewClass))
{
continue;
}
var tvc = (ViewClass)tc;
tvc.State = selStructureViews.GetItemCheckState(i);
if (tvc.State != CheckState.Checked)
{
continue;
}
allv.Add(tvc);
}
return(allv);
}
private void ExportFKTableStructure(ExportWorkers ew)
{
for (var i = 0; i < selStructureTables.ItemDatasNotNulls.Count; i++)
{
var itm = (ItemDataClass)selStructureTables.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = itm.Object as DataObjectClass;
if (tc?.GetType() != typeof(TableClass))
{
continue;
}
var tcc = (TableClass)tc;
tcc.State = selStructureTables.GetItemCheckState(i);
if ((tcc.State != CheckState.Checked) || (tcc.ForeignKeys == null))
{
continue;
}
foreach (var fk in tcc.ForeignKeys.Values)
{
if (fk == null)
{
continue;
}
ew.allFKConstraints.Add(fk.Name, fk);
}
}
}
private List <TableClass> ExportTableStructure(ExportWorkers ew)
{
var allt = new List <TableClass>();
for (int i = 0; i < selStructureTables.ItemDatasNotNulls.Count; i++)
{
var itm = (ItemDataClass)selStructureTables.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = (DataObjectClass)itm.Object;
if (tc?.GetType() != typeof(TableClass))
{
continue;
}
var ttc = (TableClass)tc;
ttc.State = selStructureTables.GetItemCheckState(i);
if (ttc.State != CheckState.Checked)
{
continue;
}
allt.Add(ttc);
}
return(allt);
}
private void hsExport_Click(object sender, EventArgs e)
{
var ew = new ExportWorkers(NotifiesClass.Instance)
{
alltables = new List <TableClass>()
};
ew.alltables.Clear();
ew.AktDBReg = DBReg;
ew.ShowScripting = cbViewInScript.Checked;
if (ckWriteFileForEVeryObject.Checked)
{
ew.WriteToFile = eSQLFileWriteMode.seperated;
}
else if (cbObjectExportToFile.Checked)
{
ew.WriteToFile = eSQLFileWriteMode.all;
}
if (ew.WriteToFile != eSQLFileWriteMode.none)
{
if ((txtFileName.Text.IndexOf(".", StringComparison.Ordinal)) < 0)
{
txtFileName.Text += ".sql";
}
ew.SQLDirectoryName = txtExportDirectory.Text;
ew.SQLFileName = txtFileName.Text;
ew.CharSet = cbCharSet.SelectedItem as EncodingClass;
}
else
{
ew.SQLDirectoryName = string.Empty;
ew.SQLFileName = string.Empty;
}
for (int i = 0; i < selTables.ItemDatas.Count; i++)
{
var itm = selTables.ItemDatas[i] as ItemDataClass;
var tc = itm.Object as TableClass;
tc.State = selTables.GetItemCheckState(i);
if (tc.State != CheckState.Checked)
{
continue;
}
ew.alltables.Add(tc);
}
ew.StartworkerGetTableData(ew.alltables, DBReg, ew.SQLDirectoryName, ew.SQLFileName);
}
private void hsExport_Click(object sender, EventArgs e)
{
var ew = new ExportWorkers(NotifiesClass.Instance())
{
alltables = new List <TableClass>()
};
ew.alltables.Clear();
ew.AktDBReg = DBReg;
ew.ShowScripting = cbViewInScript.Checked;
ew.WriteToFile = cbExportToFile.Checked;
if (ew.WriteToFile)
{
if ((txtFileName.Text.IndexOf(".", StringComparison.Ordinal)) < 0)
{
txtFileName.Text += ".sql";
}
var di = ActFolder.Tag as DirectoryInfo;
ew.SQLFileInfo = new FileInfo(di?.FullName + "\\" + txtFileName.Text);
ew.CharSet = cbCharSet.SelectedItem as EncodingClass;
}
else
{
ew.SQLFileInfo = null;
}
for (int i = 0; i < selTables.ItemDatas.Count; i++)
{
var itm = selTables.ItemDatas[i] as ItemDataClass;
var tc = itm.Object as TableClass;
tc.State = selTables.GetItemCheckState(i);
if (tc.State != CheckState.Checked)
{
continue;
}
ew.alltables.Add(tc);
}
ew.StartworkerGetTableData(ew.alltables, DBReg, ew.SQLFileInfo);
}
private void ExportPKTableStructure(ExportWorkers ew)
{
for (var i = 0; i < selStructureTables.ItemDatasNotNulls.Count; i++)
{
var itm = (ItemDataClass)selStructureTables.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = (DataObjectClass)itm.Object;
if (tc?.GetType() != typeof(TableClass))
{
continue;
}
var ttc = (TableClass)tc;
ttc.State = selStructureTables.GetItemCheckState(i);
if ((ttc.State != CheckState.Checked) || (ttc.primary_constraint == null))
{
continue;
}
ew.allPKConstraints.Add(ttc.Name, ttc.primary_constraint);
}
}
private void ExportIndecesStructure(ExportWorkers ew)
{
for (var i = 0; i < selIndeces.ItemDatasNotNulls.Count; i++)
{
var itm = (ItemDataClass)selIndeces.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = (DataObjectClass)itm.Object;
if (tc?.GetType() != typeof(IndexClass))
{
continue;
}
var tci = (IndexClass)tc;
tci.State = selIndeces.GetItemCheckState(i);
if (tci.State != CheckState.Checked)
{
continue;
}
ew.allIndeces.Add(tci.Name, tci);
}
}
private void ExportFunctionStructure(ExportWorkers ew)
{
for (int i = 0; i < selFunctionsStructure.ItemDatasNotNulls.Count; i++)
{
var itm = (ItemDataClass)selFunctionsStructure.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = (DataObjectClass)itm.Object;
if (tc?.GetType() != typeof(FunctionClass))
{
continue;
}
var ttc = (FunctionClass)tc;
ttc.State = selFunctionsStructure.GetItemCheckState(i);
if (ttc.State != CheckState.Checked)
{
continue;
}
ew.allFunctions.Add(ttc.Name, ttc);
}
}
private void ExportGeneratorStructure(ExportWorkers ew)
{
for (var i = 0; i < selGenerators.ItemDatasNotNulls.Count; i++)
{
var itm = (ItemDataClass)selGenerators.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = (DataObjectClass)itm.Object;
if (tc?.GetType() != typeof(GeneratorClass))
{
continue;
}
var tgc = (GeneratorClass)tc;
tgc.State = selGenerators.GetItemCheckState(i);
if (tgc.State != CheckState.Checked)
{
continue;
}
ew.allGenerator.Add(tgc.Name, tgc);
}
}
private void ExportDomainStructure(ExportWorkers ew)
{
for (var i = 0; i < selDomains.ItemDatasNotNulls.Count; i++)
{
var itm = (ItemDataClass)selDomains.ItemDatas[i];
if (itm == null)
{
continue;
}
var tc = itm.Object as DataObjectClass;
if (tc?.GetType() != typeof(DomainClass))
{
continue;
}
var tdc = tc as DomainClass;
tdc.State = selDomains.GetItemCheckState(i);
if (tdc.State != CheckState.Checked)
{
continue;
}
ew.allDomains.Add(tdc.Name, tdc);
}
}
private void hsExportStructure_Click(object sender, EventArgs e)
{
var ew = new ExportWorkers(NotifiesClass.Instance())
{
allviews = new List <ViewClass>()
};
ew.allviews.Clear();
ew.alltables = new List <TableClass>();
ew.alltables.Clear();
ew.allPKConstraints = new Dictionary <string, PrimaryKeyClass>();
ew.allPKConstraints.Clear();
ew.allFKConstraints = new Dictionary <string, ForeignKeyClass>();
ew.allFKConstraints.Clear();
ew.allDomains = new Dictionary <string, DomainClass>();
ew.allDomains.Clear();
ew.allGenerator = new Dictionary <string, GeneratorClass>();
ew.allGenerator.Clear();
ew.allTrigger = new Dictionary <string, TriggerClass>();
ew.allTrigger.Clear();
ew.allIndeces = new Dictionary <string, IndexClass>();
ew.allIndeces.Clear();
ew.allProcedures = new Dictionary <string, ProcedureClass>();
ew.allProcedures.Clear();
ew.allFunctions = new Dictionary <string, FunctionClass>();
ew.allFunctions.Clear();
ew.AktDBReg = DBReg;
ew.ShowScripting = cbViewObjectScript.Checked;
ew.WriteToFile = cbObjectExportToFile.Checked;
ew.CommitAfterStatement = cbStructureCommit.Checked;
ew.CreateConnectionStatement = cbStructureConnectiionStatement.Checked;
ew.CreateDatabaseStatement = cbStructureCreateDatabaseStatement.Checked;
ew.CreateMode = (rbCREATEObject.Checked) ? eCreateMode.create : eCreateMode.recreate;
if (ew.WriteToFile)
{
if ((txtFileName.Text.IndexOf(".")) < 0)
{
txtFileName.Text += ".sql";
}
var di = ActFolder.Tag as DirectoryInfo;
ew.SQLFileInfo = new FileInfo(di.FullName + "\\" + txtFileName.Text);
ew.CharSet = cbCharSet.SelectedItem as EncodingClass;
}
else
{
ew.SQLFileInfo = null;
}
ew.StartworkerGetDatabaseStructure(DBReg, ew.SQLFileInfo);
foreach (var itm in selExportStructureList.CheckedItemDatasNotNulls)
{
//if ((itm.Check != CheckState.Checked)||(itm.Object == null)) continue;
if (itm.Object.GetType() == typeof(TableClass))
{
ew.alltables.AddRange(ExportTableStructure(ew));
ew.StartworkerGetTableStructure(ew.alltables, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(ViewClass))
{
ew.allviews.AddRange(ExportViewStructure(ew));
ew.StartworkerGetViewStructure(ew.allviews, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(PrimaryKeyClass))
{
ExportPKTableStructure(ew);
ew.StartworkerGetPKTableStructure(ew.allPKConstraints, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(ForeignKeyClass))
{
ExportFKTableStructure(ew);
ew.StartworkerGetFKTableStructure(ew.allFKConstraints, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(DomainClass))
{
ExportDomainStructure(ew);
ew.StartworkerGetDomainStructure(ew.allDomains, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(GeneratorClass))
{
ExportGeneratorStructure(ew);
ew.StartworkerGetGeneratorStructure(ew.allGenerator, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(IndexClass))
{
ExportIndecesStructure(ew);
ew.StartworkerGetIndecesStructure(ew.allIndeces, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(TriggerClass))
{
ExportTriggerStructure(ew);
ew.StartworkerGetTriggerStructure(ew.allTrigger, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(ProcedureClass))
{
ExportProcedureStructure(ew);
ew.StartworkerGetProcedureDefinitionStructure(ew.allProcedures, DBReg, ew.SQLFileInfo);
ew.StartworkerGetProcedureStructure(ew.allProcedures, DBReg, ew.SQLFileInfo);
}
else if (itm.Object.GetType() == typeof(FunctionClass))
{
ExportFunctionStructure(ew);
ew.StartworkerGetFunctionDefinitionStructure(ew.allFunctions, DBReg, ew.SQLFileInfo);
ew.StartworkerGetFunctionStructure(ew.allFunctions, DBReg, ew.SQLFileInfo);
}
}
ew.WaitForWorker();
ew.MakeScript();
NotificationsForm.Instance().Close();
}
