public void ExtractTableNameFromScriptTest_DefaultSchema()
{
string rawScript = @"ALTER TABLE [TestTable] ALTER COLUMN column3 varchar(50)";
string schema;
string schemaExpected = "dbo";
string tableName;
string tableNameExpected = "TestTable";
ScriptWrapping.ExtractTableNameFromScript(rawScript, out schema, out tableName);
Assert.AreEqual(schemaExpected, schema);
Assert.AreEqual(tableNameExpected, tableName);
}
public void ExtractTableNameFromScriptTest_CustomSchema()
{
string rawScript = @"CREATE TABLE [testSchema].[TestTable]
(
column2 int,
column3 varchar(50)
)";
string schema;
string schemaExpected = "testSchema";
string tableName;
string tableNameExpected = "TestTable";
ScriptWrapping.ExtractTableNameFromScript(rawScript, out schema, out tableName);
Assert.AreEqual(schemaExpected, schema);
Assert.AreEqual(tableNameExpected, tableName);
}
public void ExtractTableNameFromScriptTest_UnableToFindTable()
{
string rawScript = @"CREATE TABL [TestTable]
(
column2 int,
column3 varchar(50)
)";
string schema;
string schemaExpected = "dbo";
string tableName;
string tableNameExpected = "";
ScriptWrapping.ExtractTableNameFromScript(rawScript, out schema, out tableName);
Assert.AreEqual(schemaExpected, schema);
Assert.AreEqual(tableNameExpected, tableName);
}