@Test
public void Insert_Query_Update() {
QPerson person = QPerson.person;
SQLInsertClause insert = new SQLInsertClause(connection, configuration, person);
insert.set(person.id, 10);
insert.set(person.firstname, "Bob");
insert.set(person.gender, Gender.MALE);
assertEquals(1l, insert.execute());
SQLQuery query = new SQLQuery(connection, configuration);
assertEquals(Gender.MALE, query.from(person).where(person.id.eq(10)).uniqueResult(person.gender));
SQLUpdateClause update = new SQLUpdateClause(connection, configuration, person);
update.set(person.gender, Gender.FEMALE);
update.set(person.firstname, "Jane");
update.where(person.id.eq(10));
update.execute();
query = new SQLQuery(connection, configuration);
assertEquals(Gender.FEMALE, query.from(person).where(person.id.eq(10)).uniqueResult(person.gender));
}