public void ormCrudWithSchema(final SessionProvider sessionProvider) throws Exception { final IClassMap<Zoo_People> classMapper = new ClassMapBuilder<Zoo_People>(Zoo_People.class).generate(); assertNotNull(classMapper); final OrmCRUDQueryGenerator<Zoo_People> ormGenerator = new OrmCRUDQueryGenerator<Zoo_People>(new DefaultDialect(), classMapper); final CRUDQuery ormCrudQuery = ormGenerator.generate(); assertNotNull(ormCrudQuery); System.out.println(ormCrudQuery.getLoadQuery()); System.out.println(ormCrudQuery.getUpdateQuery()); System.out.println(ormCrudQuery.getDeleteQuery()); System.out.println(ormCrudQuery.getSaveQuery()); }
public void ormCrudSelectFromClause(final SessionProvider sessionProvider) throws Exception { final IClassMap<Zoo_People> classMapper = new ClassMapBuilder<Zoo_People>(Zoo_People.class).generate(); assertNotNull(classMapper); final OrmCRUDQueryGenerator<Zoo_People> ormGenerator = new OrmCRUDQueryGenerator<Zoo_People>(new DefaultDialect(), classMapper); final CRUDQuery ormCrudQuery = ormGenerator.generate(); assertNotNull(ormCrudQuery); System.out.println(ormCrudQuery.getBaseSelectClause()); System.out.println(ormCrudQuery.getBaseSelectClause("alias.")); System.out.println(ormCrudQuery.getBaseFromClause()); assertEquals("ZOO.PEOPLE.FIRSTCLOB, ZOO.PEOPLE.ID, ZOO.PEOPLE.SECONDBLOB, ZOO.PEOPLE.BIRTHDATE, ZOO.PEOPLE.LASTNAME, ZOO.PEOPLE.FIRSTNAME, ZOO.PEOPLE.FIRSTBLOB, ZOO.PEOPLE.DEATHDATE", ormCrudQuery.getBaseSelectClause()); assertEquals("alias.FIRSTCLOB, alias.ID, alias.SECONDBLOB, alias.BIRTHDATE, alias.LASTNAME, alias.FIRSTNAME, alias.FIRSTBLOB, alias.DEATHDATE", ormCrudQuery.getBaseSelectClause("alias.")); assertEquals("ZOO.PEOPLE", ormCrudQuery.getBaseFromClause()); } }
public void ormCrudWithSequence(final SessionProvider sessionProvider) throws Exception { final IClassMap<People> classMapper = new ClassMapBuilder<People>(People.class).generate(); assertNotNull(classMapper); final OrmCRUDQueryGenerator<People> ormGenerator = new OrmCRUDQueryGenerator<People>(new DefaultDialect(), classMapper); final CRUDQuery ormCrudQuery = ormGenerator.generate(); assertNotNull(ormCrudQuery); System.out.println(ormCrudQuery.getLoadQuery()); System.out.println(ormCrudQuery.getUpdateQuery()); System.out.println(ormCrudQuery.getDeleteQuery()); System.out.println(ormCrudQuery.getSaveQuery()); }
public void ormCrud(final SessionProvider sessionProvider) throws Exception { final IClassMap<Employee> classMapper = new ClassMapBuilder<Employee>(Employee.class).generate(); assertNotNull(classMapper); final OrmCRUDQueryGenerator<Employee> ormGenerator = new OrmCRUDQueryGenerator<Employee>(new DefaultDialect(), classMapper); final CRUDQuery ormCrudQuery = ormGenerator.generate(); assertNotNull(ormCrudQuery); System.out.println(ormCrudQuery.getLoadQuery()); System.out.println(ormCrudQuery.getUpdateQuery()); System.out.println(ormCrudQuery.getDeleteQuery()); System.out.println(ormCrudQuery.getSaveQuery()); }