String url = "jdbc:hsqldb:hsql://localhost";
try {
Class.forName("org.hsqldb.jdbcDriver").newInstance();
conn = DriverManager.getConnection(url, userName, password);
TestFactory create = new TestFactory(conn);
//MP-MANAGED-UPDATABLE-BEGINNING-DISABLE @jooq-unittest-testTBook-test@
// write your own tests, just set DISABLE to ENABLE in the comment above
// future generation will not erase your code ;)
Result<Record> result = create.select().from(__T_BOOK).limit(1).fetch();
for (Record r : result) {
java.lang.Integer id = r.getValue(__T_BOOK.ID);
java.lang.Integer authorId = r.getValue(__T_BOOK.AUTHOR_ID);
java.lang.Integer coAuthorId = r.getValue(__T_BOOK.CO_AUTHOR_ID);
java.lang.Integer detailsId = r.getValue(__T_BOOK.DETAILS_ID);