public void TestTwoTablesSameDboAndDefaultSchema()
{
const string sql = "select * from dbo.table1 t1 inner join table2 t2 on (t1.id = t2.id);";
var schemas = CachedSqlPreTransform.FindSchemas(sql);
Assert.AreEqual(1, schemas.Count());
Assert.AreEqual("dbo", schemas.ElementAt(0));
}
public void TestSchemaWithDoubleQuotes()
{
const string sql = "select * from \"schema\".\"table\"";
var schemas = CachedSqlPreTransform.FindSchemas(sql);
Assert.AreEqual(1, schemas.Count());
Assert.AreEqual("schema", schemas.ElementAt(0));
}
public void TestSchemaWithBracketsAndAlias()
{
const string sql = "select * from [schema].table t1;";
var schemas = CachedSqlPreTransform.FindSchemas(sql);
Assert.AreEqual(1, schemas.Count());
Assert.AreEqual("schema", schemas.ElementAt(0));
}
public void TestSchemaServerDatabaseSchema()
{
const string sql = "select * from server.database.schema.table;";
var schemas = CachedSqlPreTransform.FindSchemas(sql);
Assert.AreEqual(1, schemas.Count());
Assert.AreEqual("schema", schemas.ElementAt(0));
}
public void TestSchemaDbo()
{
const string sql = "select * from dbo.table";
var schemas = CachedSqlPreTransform.FindSchemas(sql);
Assert.AreEqual(1, schemas.Count());
Assert.AreEqual("dbo", schemas.ElementAt(0));
}
public void TestTwoTablesMixedSchema()
{
const string sql = "select * from schema.table1 t1 inner join table2 t2 on (t1.id = t2.id);";
var schemas = CachedSqlPreTransform.FindSchemas(sql);
Assert.AreEqual(2, schemas.Count());
Assert.AreEqual("schema", schemas.ElementAt(0));
Assert.AreEqual("dbo", schemas.ElementAt(1));
}
