+ entity.getName()
+ " SET DELETED = ? WHERE SOFT_TEST_ID = ? AND NAME IS NULL", generatedSql);
}
public void testCreateSqlStringWithIdentifiersQuote() throws Exception {
DbEntity entity = getDomain().getEntityResolver().lookupObjEntity(
SoftTest.class).getDbEntity();
try {
entity.getDataMap().setQuotingSQLIdentifiers(true);
List idAttributes = Collections.singletonList(entity
.getAttribute("SOFT_TEST_ID"));
DeleteBatchQuery deleteQuery = new DeleteBatchQuery(
entity,
idAttributes,
null,
1);
JdbcAdapter adapter = (JdbcAdapter) getAccessStackAdapter().getAdapter();
DeleteBatchQueryBuilder builder = createBuilder(adapter);
String generatedSql = builder.createSqlString(deleteQuery);
String charStart = adapter.getIdentifiersStartQuote();
String charEnd = adapter.getIdentifiersEndQuote();
assertNotNull(generatedSql);
assertEquals("UPDATE "
+ charStart
+ entity.getName()
+ charEnd
+ " SET "
+ charStart
+ "DELETED"
+ charEnd
+ " = ? WHERE "
+ charStart
+ "SOFT_TEST_ID"
+ charEnd
+ " = ?", generatedSql);
}
finally {
entity.getDataMap().setQuotingSQLIdentifiers(false);
}
}