internal static void Create(Server server, string databaseName, string schemaAndView)
{
try
{
string schemaName = SqlTestTable.GetSchemaName(schemaAndView);
string viewName = SqlTestTable.GetTableName(schemaAndView);
Database database = server.Databases[databaseName];
View viewToBeFaked = database.Views[viewName, schemaName];
if (database.Views[$"{viewName}_Faked", schemaName] != null)
{
Console.WriteLine($"View: {schemaAndView} has already been faked, dropping and restoring...");
FakeView.Drop(server, databaseName, schemaAndView);
}
if (viewToBeFaked == null)
{
throw new Exception($"Error creating fake view: View not found: {schemaAndView}");
}
Table fakeTable = new Table(database, viewName, schemaName);
foreach (Column column in viewToBeFaked.Columns)
{
Column copyofCol = new Column(fakeTable, column.Name, column.DataType);
fakeTable.Columns.Add(copyofCol);
}
viewToBeFaked.Rename($"{viewName}_Faked");
fakeTable.Create();
}
catch (Exception e)
{
throw new Exception($"Error creating faked view '{schemaAndView}': {e.Message}");
}
}
internal static void Drop(Server server, string databaseName, string schemaAndView)
{
try
{
string schemaName = SqlTestTable.GetSchemaName(schemaAndView);
string viewName = SqlTestTable.GetTableName(schemaAndView);
Database database = server.Databases[databaseName];
if (database.Tables[viewName, schemaName] == null)
{
throw new NullReferenceException($"Error dropping fake view '{schemaAndView}': Does not exist");
}
database.Tables[viewName, schemaName].DropIfExists();
database.Views[$"{viewName}_Faked", schemaName].Rename(viewName);
}
catch (NullReferenceException e)
{
throw e;
}
catch (Exception e)
{
throw new Exception($"Error dropping faked view '{schemaAndView}': {e.Message}");
}
}
internal static void CreateShell(Server server, string databaseName, string schemaAndTableName, Boolean keepIdentity = false)
{
string schemaName = SqlTestTable.GetSchemaName(schemaAndTableName);
string tableName = SqlTestTable.GetTableName(schemaAndTableName);
Database database = server.Databases[databaseName];
if (database.Tables[$"{tableName}_Faked", schemaName] != null)
{
Console.WriteLine($"Table: {tableName} has already been faked, dropping and restoring...");
FakeTable.Drop(server, databaseName, schemaAndTableName);
}
Table tableToFake = database.Tables[tableName, schemaName];
if (tableToFake == null)
{
throw new Exception($"Error creating fake table: Table not found: {schemaAndTableName}");
}
Table fakeTable = new Table(database, tableName, schemaName);
foreach (Column column in tableToFake.Columns)
{
Column copyofCol = new Column(fakeTable, column.Name, column.DataType);
if (keepIdentity)
{
copyofCol.Identity = column.Identity;
}
if (column.DefaultConstraint != null)
{
copyofCol.AddDefaultConstraint($"{column.DefaultConstraint.Name}_fake");
copyofCol.DefaultConstraint.Text = column.DefaultConstraint.Text;
}
fakeTable.Columns.Add(copyofCol);
}
try
{
tableToFake.Rename($"{tableName}_Faked");
fakeTable.Create();
}
catch (Exception e)
{
throw new Exception($"Failed to create fake table '{schemaAndTableName}': {e.Message}");
}
}
internal static void Drop(Server server, string databaseName, string schemaAndTableName)
{
try
{
string schemaName = SqlTestTable.GetSchemaName(schemaAndTableName);
string tableName = SqlTestTable.GetTableName(schemaAndTableName);
Database database = server.Databases[databaseName];
if (database.Tables[$"{tableName}_Faked", schemaName] != null)
{
database.Tables[tableName, schemaName].DropIfExists();
database.Tables[$"{tableName}_Faked", schemaName].Rename(tableName);
}
}
catch (Exception e)
{
throw new Exception($"Drop table failed for Server: '{server.Name}', Database: '{databaseName}', Table: '{schemaAndTableName}' with the error: {e.Message}, Source: {e.Source}");
}
}