GenericTestCaseBase.<Condition>list(
new ConditionList(
Joiner.AND,
list(
new BooleanCondition(new FieldValue("a", "partyTypeId"), "=", new StringValue("PERSON")),
new BooleanCondition(new FieldValue("b", "lastName"), "LIKE", new ParameterValue("lastName")),
new BetweenCondition(new FieldValue("b", "birthDate"), new StringValue("1974-12-01"), new StringValue("1974-12-31"))
)
),
new ConditionList(
Joiner.AND,
list(
new ListCondition(new FieldValue("b", "partyId"), "IN", GenericTestCaseBase.<Value>list(
new StringValue("1"),
new StringValue("2"),
new StringValue("3"),
new StringValue("4")
)),
new BooleanCondition(new FieldValue("b", "gender"), "=", new StringValue("M"))
)
)
)
),
new BooleanCondition(new FieldValue("b", "firstName"), "LIKE", new StringValue("%foo%")),
null,
list(
new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, new FunctionCall("LOWER", GenericTestCaseBase.<Value>list(new FieldValue(null, "lastName")))),
new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, new FieldValue(null, "firstName")),
new OrderByItem(OrderByItem.Order.DESCENDING, OrderByItem.Nulls.DEFAULT, new FieldValue(null, "birthDate"))
),
5,
10
);
SQLStatement<?> stmt = stmtIt.next();
assertEquals("firstSelect", select, stmt);
assertEquals("firstSelect:parse", parser(select).SelectStatement(), parser(stmt).SelectStatement());
}
{
SQLInsert insert = new SQLInsert(
new TableName("Party", null),
new InsertValues(
list(
new InsertRow(GenericTestCaseBase.<Value>list(new StringValue("a"), new StringValue("PERSON"), new StringValue("PARTY_DISABLED"))),
new InsertRow(list(new NumberValue<Integer>(Integer.valueOf(5)), new StringValue("PARTY_GROUP"), new ParameterValue("name")))
)
),
list("partyId", "partyTypeId", "statusId")
);
SQLStatement<?> stmt = stmtIt.next();