@Test
public void testDelete() {
SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");
Person p = new Person();
p.setId(2L);
List<Person> list = sqlEngine.query(session, Person.class, p);
assertEquals(1, list.size());
assertEquals("Halle", list.get(0).getName().getFirst());
assertNotSame(null, list.get(0).getCreatedDate());
SqlCrudEngine crudEngine = getCrudEngine("DELETE_PERSON");
String sql = crudEngine.getDeleteSql(p, null);
logger.info(sql);
assertContains(sql, "delete from PERSON");
assertContains(sql, "WHERE ID = :id", "WHERE ID = ?");
int count = crudEngine.delete(session, p);
assertEquals(1, count);
list = sqlEngine.query(session, Person.class, p);
assertEquals(0, list.size());
}
@Test
public void testInsert2() {
if ("MYSQL".equalsIgnoreCase(dbType) || "MSSQL".equalsIgnoreCase(dbType)) return;
SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");
List<Person> list = sqlEngine.query(session, Person.class);
assertEquals(2, list.size());
Person p = new Person();
// p.setId(3L);
p.setSsn(new Ssn());
p.getSsn().setNumber("345678");
p.getSsn().setCountry(Country.UNITED_STATES);
p.setName(new PersonName());
p.getName().setFirst("Toby");
p.getName().setLast("Stephens");
p.setAge(1969, 4, 21);
p.setSex(Gender.MALE);
// p.setCreatedDate(new Date());
p.setCreatedBy("wlado");
p.setVersion(1L);
p.setClothesSize(Size.MIDDLE);
SqlCrudEngine crudEngine = getCrudEngine("INSERT_PERSON_2");
String sql = crudEngine.getInsertSql(p, null);
logger.info(sql);
int count = crudEngine.insert(session, p);
assertEquals(1, count);
list = sqlEngine.query(session, Person.class);
assertEquals(3, list.size());
}
@Test
public void testDelete6() {
SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");
Person p = new Person();
List<Person> list = sqlEngine.query(session, Person.class, p);
assertEquals(2, list.size());
SqlCrudEngine crudEngine = getCrudEngine("DELETE_PERSON_6");
p.setId(list.get(0).getId());
String sql = crudEngine.getDeleteSql(p, p);
logger.info(sql);
assertContains(sql, "delete from PERSON");
assertContains(sql, "WHERE ID = :id", "WHERE ID = ?");
assertContains(sql, "AND LASTUPDATEDBY is null");
int count = crudEngine.delete(session, p);
assertEquals(1, count);
list = sqlEngine.query(session, Person.class);
assertEquals(1, list.size());
try {
count = crudEngine.delete(session, null);
fail();
} catch (IllegalArgumentException e) {
assertContains(e.getMessage(), "notempty");
}
}
@Test
public void testGetNull() {
SqlCrudEngine sqlEngine = getCrudEngine("GET_PERSON");
Person p = new Person();
p.setId(9999L);
Person person2 = sqlEngine.get(session, Person.class, p);
assertNull(person2);
}
@Test
public void testGet() {
SqlCrudEngine sqlEngine = getCrudEngine("GET_PERSON");
Person p = new Person();
p.setId(2L);
Person person2 = sqlEngine.get(session, Person.class, p);
assertNotNull(person2);
assertEquals("Halle", person2.getName().getFirst());
assertEquals("Berry", person2.getName().getLast());
}
@Test
public void testUpdate1() {
SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");
Person p = new Person();
p.setId(2L);
List<Person> list = sqlEngine.query(session, Person.class, p);
assertEquals(1, list.size());
assertEquals("Halle", list.get(0).getName().getFirst());
assertNotSame(null, list.get(0).getCreatedDate());
p.setName(new PersonName());
p.getName().setFirst("Toby");
p.setCreatedDate(null);
SqlCrudEngine crudEngine = getCrudEngine("UPDATE_PERSON");
String sql = crudEngine.getUpdateSql(p, null);
logger.info(sql);
assertContains(sql, "update PERSON");
assertContains(sql, "SET");
assertContains(sql, "NAME_FIRST = :name_first", "NAME_FIRST = ?");
assertContains(sql, "CREATEDDATE = :createdDate", "CREATEDDATE = ?");
assertContains(sql, "WHERE");
assertContains(sql, "ID = :id", "ID = ?");
int count = crudEngine.update(session, p);
assertEquals(1, count);
list = sqlEngine.query(session, Person.class, p);
assertEquals(1, list.size());
assertEquals("Toby", list.get(0).getName().getFirst());
if ("MYSQL".equalsIgnoreCase(dbType)) assertNotNull(list.get(0).getCreatedDate());
else assertEquals(null, list.get(0).getCreatedDate());
}
@Test
public void testDelete7() {
SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");
Person p = new Person();
List<Person> list = sqlEngine.query(session, Person.class, p);
assertEquals(2, list.size());
SqlCrudEngine crudEngine = getCrudEngine("DELETE_PERSON_7");
p.setSsn(new Ssn());
p.getSsn().setNumber("123456");
p.setSex(Gender.MALE);
String sql = crudEngine.getDeleteSql(p, p);
logger.info(sql);
assertContains(sql, "delete from PERSON");
assertContains(sql, "WHERE SSN_NUMBER = :ssn.number", "WHERE SSN_NUMBER = ?");
assertContains(sql, "SEX = :sex", "SEX = ?");
int count = crudEngine.delete(session, p);
assertEquals(1, count);
list = sqlEngine.query(session, Person.class);
assertEquals(1, list.size());
try {
count = crudEngine.delete(session, null);
fail();
} catch (IllegalArgumentException e) {
assertContains(e.getMessage(), "notempty");
}
try {
p = new Person();
p.setSsn(new Ssn());
p.getSsn().setNumber("123456");
count = crudEngine.delete(session, p);
fail();
} catch (IllegalArgumentException e) {
assertContains(e.getMessage(), "notempty");
}
}
@Test
public void testInsertEmpty() {
if ("oracle".equalsIgnoreCase(dbType)) return;
SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");
List<Person> list = sqlEngine.query(session, Person.class);
assertEquals(2, list.size());
Person p = new Person();
p.setId(3L);
p.setSsn(new Ssn());
p.getSsn().setNumber("");
p.getSsn().setCountry(Country.UNITED_STATES);
p.setName(new PersonName());
p.getName().setFirst("");
p.getName().setLast("Stephens");
p.setAge(1969, 4, 21);
p.setSex(Gender.MALE);
p.setCreatedDate(new Date());
p.setCreatedBy("wlado");
p.setVersion(1L);
p.setClothesSize(Size.MIDDLE);
SqlCrudEngine crudEngine = getCrudEngine("INSERT_PERSON");
String sql = crudEngine.getInsertSql(p, null);
logger.info(sql);
int count = crudEngine.insert(session, p);
assertEquals(1, count);
logger.info("new id: " + p.getId());
assertNotNull(p.getId());
Person p2 = new Person();
p2.setId(p.getId());
list = sqlEngine.query(session, Person.class, p2);
assertEquals(1, list.size());
Person p3 = list.get(0);
assertEquals("", p3.getName().getFirst());
assertEquals("Stephens", p3.getName().getLast());
}
@Test
public void testInsert5() {
if ("ORACLE".equalsIgnoreCase(dbType) || "POSTGRESQL".equalsIgnoreCase(dbType)) return;
SqlQueryEngine sqlEngine = getQueryEngine("CRUD_PERSON_SELECT");
List<Person> list = sqlEngine.query(session, Person.class);
assertEquals(2, list.size());
Person p = new Person();
// p.setId(3L);
p.setSsn(new Ssn());
p.getSsn().setNumber("345678");
p.getSsn().setCountry(Country.UNITED_STATES);
p.setName(new PersonName());
p.getName().setFirst("Toby");
p.getName().setLast("Stephens");
p.setAge(1969, 4, 21);
p.setSex(Gender.MALE);
// p.setCreatedDate(new Date());
p.setCreatedBy("wlado");
p.setVersion(1L);
p.setClothesSize(Size.MIDDLE);
SqlCrudEngine crudEngine = getCrudEngine("INSERT_PERSON_5");
String sql = crudEngine.getInsertSql(p, null);
logger.info(sql);
assertContains(sql, "VALUES");
assertContains(
sql,
":ssn_number, :ssn_country, :name_first, :name_last, :birthDate, :sex, :createdDate, :createdBy, :version, :clothesSize)",
"?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
int count = crudEngine.insert(session, p);
assertEquals(1, count);
logger.info("new id: " + p.getId());
assertNotNull(p.getId());
list = sqlEngine.query(session, Person.class);
assertEquals(3, list.size());
}
