public static void SimpleDelete()
{
var condition = SqlExpression.GreaterThan(SqlExpression.Reference(new ObjectName("id")), SqlExpression.Constant(22));
var statement = new DeleteStatement(ObjectName.Parse("t1"), condition);
var sql = statement.ToString();
var expected = "DELETE FROM t1 WHERE id > 22";
Assert.AreEqual(expected, sql);
}
public static void SimpleDelete()
{
var condition = SqlExpression.GreaterThan(SqlExpression.Reference(new ObjectName("id")), SqlExpression.Constant(22));
var statement = new DeleteStatement(ObjectName.Parse("t1"), condition);
var sql = statement.ToString();
var expected = "DELETE FROM t1 WHERE id > 22";
Assert.AreEqual(expected, sql);
}
public static void Limited()
{
var condition = SqlExpression.SmallerThan(SqlExpression.Reference(new ObjectName("code")), SqlExpression.Constant(1002));
var statement = new DeleteStatement(ObjectName.Parse("t1"), condition);
statement.Limit = 10;
var sql = statement.ToString();
var expected = "DELETE FROM t1 WHERE code < 1002 LIMIT 10";
Assert.AreEqual(expected, sql);
}
public static void Limited()
{
var condition = SqlExpression.SmallerThan(SqlExpression.Reference(new ObjectName("code")), SqlExpression.Constant(1002));
var statement = new DeleteStatement(ObjectName.Parse("t1"), condition);
statement.Limit = 10;
var sql = statement.ToString();
var expected = "DELETE FROM t1 WHERE code < 1002 LIMIT 10";
Assert.AreEqual(expected, sql);
}
