public static void DropTable_IfExists()
{
var statement = new DropTableStatement(ObjectName.Parse("APP.test_table"), true);
var sql = statement.ToString();
var expected = "DROP TABLE IF EXISTS APP.test_table";
Assert.AreEqual(expected, sql);
}
public static void DropTable_IfExists()
{
var statement = new DropTableStatement(ObjectName.Parse("APP.test_table"), true);
var sql = statement.ToString();
var expected = "DROP TABLE IF EXISTS APP.test_table";
Assert.AreEqual(expected, sql);
}
public void DropReferencedTable()
{
var tableName = ObjectName.Parse("APP.test_table1");
var statement = new DropTableStatement(tableName);
Assert.Throws<ConstraintViolationException>(() => statement.Execute(Query));
var exists = Query.TableExists(tableName);
Assert.IsTrue(exists);
}
public void DropNonReferencedTable()
{
var tableName = ObjectName.Parse("APP.test_table2");
var statement = new DropTableStatement(tableName);
statement.Execute(Query);
var exists = Query.TableExists(tableName);
Assert.IsFalse(exists);
}
public void DropIfExists_TableNotExists()
{
var tableName = ObjectName.Parse("APP.test_table3");
var statement = new DropTableStatement(tableName, true);
statement.Execute(Query);
var exists = Query.TableExists(tableName);
Assert.IsFalse(exists);
}
public void DropReferencedTable()
{
var tableName = ObjectName.Parse("APP.test_table1");
var statement = new DropTableStatement(tableName);
Assert.Throws <ConstraintViolationException>(() => statement.Execute(Query));
var exists = Query.TableExists(tableName);
Assert.IsTrue(exists);
}
public void DropIfExists_TableNotExists()
{
var tableName = ObjectName.Parse("APP.test_table3");
var statement = new DropTableStatement(tableName, true);
statement.Execute(Query);
var exists = Query.TableExists(tableName);
Assert.IsFalse(exists);
}
public void DropNonReferencedTable()
{
var tableName = ObjectName.Parse("APP.test_table2");
var statement = new DropTableStatement(tableName);
statement.Execute(Query);
var exists = Query.TableExists(tableName);
Assert.IsFalse(exists);
}
protected override SqlStatement VisitDropTable(DropTableStatement statement)
{
return(base.VisitDropTable(statement));
}
protected virtual SqlStatement VisitDropTable(DropTableStatement statement)
{
return new DropTableStatement(statement.TableName, statement.IfExists);
}
protected override SqlStatement VisitDropTable(DropTableStatement statement)
{
return base.VisitDropTable(statement);
}
protected virtual SqlStatement VisitDropTable(DropTableStatement statement)
{
return(new DropTableStatement(statement.TableName, statement.IfExists));
}