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);
}
public void DeleteTwoRows()
{
var tableName = ObjectName.Parse("APP.test_table");
var expr = SqlExpression.Parse("last_name = 'Provenzano'");
var statement = new DeleteStatement(tableName, expr);
var result = Query.ExecuteStatement(statement);
Assert.IsNotNull(result);
Assert.AreEqual(1, result.RowCount);
var count = result.GetValue(0, 0).AsBigInt();
Assert.AreEqual(2L, ((SqlNumber)count.Value).ToInt64());
var table = Query.GetTable(tableName);
Assert.AreEqual(0, table.RowCount);
}
public void DeleteTwoRows()
{
var tableName = ObjectName.Parse("APP.test_table");
var expr = SqlExpression.Parse("last_name = 'Provenzano'");
var statement = new DeleteStatement(tableName, expr);
var result = Query.ExecuteStatement(statement);
Assert.IsNotNull(result);
Assert.AreEqual(1, result.RowCount);
var count = result.GetValue(0, 0).AsBigInt();
Assert.AreEqual(2L, ((SqlNumber)count.Value).ToInt64());
var table = Query.GetTable(tableName);
Assert.AreEqual(0, table.RowCount);
}
public static SqlStatement Build(PlSqlParser.DeleteStatementContext context)
{
var tableName = Name.Object(context.objectName());
var whereClause = WhereClause.Form(context.whereClause());
if (whereClause.CurrentOf != null)
return new DeleteCurrentStatement(tableName, whereClause.CurrentOf);
var statement = new DeleteStatement(tableName, whereClause.Expression);
if (context.deleteLimit() != null) {
var limit = Number.PositiveInteger(context.deleteLimit().numeric());
if (limit == null)
throw new ParseCanceledException("Invalid delete limit.");
statement.Limit = limit.Value;
}
return statement;
}
protected override SqlStatement VisitDelete(DeleteStatement statement)
{
(statement as ISqlFormattable).AppendTo(builder);
return(base.VisitDelete(statement));
}
protected virtual SqlStatement VisitDelete(DeleteStatement statement)
{
return new DeleteStatement(statement.TableName, statement.WhereExpression, statement.Limit);
}
protected override SqlStatement VisitDelete(DeleteStatement statement)
{
(statement as ISqlFormattable).AppendTo(builder);
return base.VisitDelete(statement);
}
protected virtual SqlStatement VisitDelete(DeleteStatement statement)
{
return(new DeleteStatement(statement.TableName, statement.WhereExpression, statement.Limit));
}