public void TestOneExcludedDatabase()
{
const string sql = "select * from AdventureWorks.dbo.table t1 inner join some.table t2 on (t1.id = t2.id)";
var schema = CachedSqlPreTransform.FindCommonSchema(sql);
var database = CachedSqlPreTransform.FindCommonDatabase(sql);
Assert.AreEqual("", schema);
Assert.AreEqual("AdventureWorks", database);
}
public void TestNotCommonSchemaAndNotCommonDatabase()
{
const string sql = "select * from database1.schema1.table t1 inner join database2.schema2.table t2 on (t1.id = t2.id)";
var schema = CachedSqlPreTransform.FindCommonSchema(sql);
var database = CachedSqlPreTransform.FindCommonDatabase(sql);
Assert.AreEqual(string.Empty, schema);
Assert.AreEqual(string.Empty, database);
}
public void TestCommonSchemaAndDatabase()
{
const string sql = "select * from database.schema.table";
var schema = CachedSqlPreTransform.FindCommonSchema(sql);
var database = CachedSqlPreTransform.FindCommonDatabase(sql);
Assert.AreEqual("schema", schema);
Assert.AreEqual("database", database);
}
public void TestCommonSchemaNoDatabase()
{
const string sql = "select * from table";
var schema = CachedSqlPreTransform.FindCommonSchema(sql);
var database = CachedSqlPreTransform.FindCommonDatabase(sql);
Assert.AreEqual("dbo", schema);
Assert.AreEqual(string.Empty, database);
}
public void TestNoTables()
{
const string sql = "set nocount on;";
var schema = CachedSqlPreTransform.FindCommonSchema(sql);
var database = CachedSqlPreTransform.FindCommonDatabase(sql);
Assert.AreEqual(string.Empty, schema);
Assert.AreEqual(string.Empty, database);
}
public void TestCommonSchemaAndCommonDatabaseDefined()
{
const string sql = "select * from database.schema.table t1 inner join database.schema.table t2 on (t1.id = t2.id)";
var schema = CachedSqlPreTransform.FindCommonSchema(sql);
var database = CachedSqlPreTransform.FindCommonDatabase(sql);
Assert.AreEqual("schema", schema);
Assert.AreEqual("database", database);
}
