private void DropIndexesTables(IDbCommand cmd, IndexesTableStatuses statuses, IndexesTableNames names)
{
var sqlDropTableFormat = SqlStatements.GetSql("DropTable");
if (statuses.IntegersTableExists)
{
cmd.CommandText = sqlDropTableFormat.Inject(names.IntegersTableName);
cmd.ExecuteNonQuery();
}
if (statuses.FractalsTableExists)
{
cmd.CommandText = sqlDropTableFormat.Inject(names.FractalsTableName);
cmd.ExecuteNonQuery();
}
if (statuses.BooleansTableExists)
{
cmd.CommandText = sqlDropTableFormat.Inject(names.BooleansTableName);
cmd.ExecuteNonQuery();
}
if (statuses.DatesTableExists)
{
cmd.CommandText = sqlDropTableFormat.Inject(names.DatesTableName);
cmd.ExecuteNonQuery();
}
if (statuses.GuidsTableExists)
{
cmd.CommandText = sqlDropTableFormat.Inject(names.GuidsTableName);
cmd.ExecuteNonQuery();
}
if (statuses.StringsTableExists)
{
cmd.CommandText = sqlDropTableFormat.Inject(names.StringsTableName);
cmd.ExecuteNonQuery();
}
if (statuses.TextsTableExists)
{
cmd.CommandText = sqlDropTableFormat.Inject(names.TextsTableName);
cmd.ExecuteNonQuery();
}
}
private static ModelTableStatuses CreateStatuses(
bool structureTableExists = true,
bool spatialTableExists = true,
bool uniquesTableExists = true,
bool integersTableExists = true,
bool fractalsTableExists = true,
bool datesTableExists = true,
bool booleansTableExists = true,
bool guidsTableExists = true,
bool stringsTableExists = true,
bool textsTableExists = true)
{
var indexesStatuses = new IndexesTableStatuses(
integersTableExists,
fractalsTableExists,
datesTableExists,
booleansTableExists,
guidsTableExists,
stringsTableExists,
textsTableExists);
return(new ModelTableStatuses(structureTableExists, spatialTableExists, uniquesTableExists, indexesStatuses));
}
