public override string GenerateSQLQuery()
{
StringBuilder query = new StringBuilder();
if (IsNew)
{
query.Append($"create table {ConnectionSettings.getInstance().NameScheme}.{NameTable} ( ");
}
else
{
query.Append($"alter table {ConnectionSettings.getInstance().NameScheme}.{NameTable} add ");
}
foreach (var col in ColumnInTable)
{
query.Append($"{col.NameColumn} {col.NameType} {col.SizeTypeQuery}, ");
}
if (IsNew)
{
query.Replace(", ", ") ", query.Length - 2, 2);
}
else
{
query.Replace(", ", " ", query.Length - 2, 2);
}
return(IsNew ? GenerateQueryWorker.CurentGenerate.GetCreateTableQuery($"{ConnectionSettings.getInstance().NameScheme}.{NameTable}",
ColumnInTable.ToList().Select(col => $"{col.NameColumn} {col.NameType} {col.SizeTypeQuery}").ToList()) :
GenerateQueryWorker.CurentGenerate.GetAddColumnsQuery($"{ConnectionSettings.getInstance().NameScheme}.{NameTable}",
ColumnInTable.ToList().Select(col => $"{col.NameColumn} {col.NameType} {col.SizeTypeQuery}").ToList()));
}
public override string GenerateSQLQuery()
{
return(GenerateQueryWorker.CurentGenerate.GetDeleteColumnsQuery($"{ConnectionSettings.getInstance().NameScheme}.{NameTable}",
ColumnInTable.ToList().FindAll(c => c.IsSelect).Select(c => c.NameColumn).ToList()));
}