public void ormCrudWithSchema(SessionProvider sessionProvider) throws Exception { final Class<Zoo_People> clazz = Zoo_People.class; final TableMap<Zoo_People> tableMap = new TableMap<Zoo_People>(); new ClassTableMapBuilder<Zoo_People>(clazz, tableMap).updateTableMap(); final IClassMapperBuilder<Zoo_People> classMapperGenerator = new ClassMapperBuilder<Zoo_People>(clazz, tableMap); final IClassMapper<Zoo_People> classMapper = classMapperGenerator.generate(); assertNotNull(classMapper); final IOrmCRUDQueryGenerator<Zoo_People> ormGenerator = new OrmCRUDQueryGenerator<Zoo_People>(new DefaultDialect(), classMapper); final IOrmCRUDQuery 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 ormCrudWithSequence(SessionProvider sessionProvider) throws Exception { final Class<People> clazz = People.class; final TableMap<People> tableMap = new TableMap<People>(); new ClassTableMapBuilder<People>(clazz, tableMap).updateTableMap(); final IClassMapperBuilder<People> classMapperGenerator = new ClassMapperBuilder<People>(clazz, tableMap); final IClassMapper<People> classMapper = classMapperGenerator.generate(); assertNotNull(classMapper); final IOrmCRUDQueryGenerator<People> ormGenerator = new OrmCRUDQueryGenerator<People>(new DefaultDialect(), classMapper); final IOrmCRUDQuery 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(SessionProvider sessionProvider) throws Exception { final Class<Employee> clazz = Employee.class; final TableMap<Employee> tableMap = new TableMap<Employee>(); new ClassTableMapBuilder<Employee>(clazz, tableMap).updateTableMap(); final IClassMapperBuilder<Employee> classMapperGenerator = new ClassMapperBuilder<Employee>(clazz, tableMap); final IClassMapper<Employee> classMapper = classMapperGenerator.generate(); assertNotNull(classMapper); final IOrmCRUDQueryGenerator<Employee> ormGenerator = new OrmCRUDQueryGenerator<Employee>(new DefaultDialect(), classMapper); final IOrmCRUDQuery 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()); }
@Override public final <T> T find(final Class<T> clazz, final Object[] values) throws OrmException { final IOrmClassTool<T> ormClassTool = this.getOrmClassToolMap().getOrmClassTool(clazz); final ResultSetReader<T> resultSetReader = new ResultSetReader<T>() { @Override public T read(final ResultSet resultSet) throws SQLException { if ( resultSet.next() ) { T result = ormClassTool.getOrmPersistor().mapRow("", resultSet, 0); if (resultSet.next()) { throw new OrmNotUniqueResultException("The query execution returned more than one object. Zero or one expected."); } return result; } return null; } }; final SqlPerformer sqlExec = this.sqlPerformer(); sqlExec.setMaxRows(1); return sqlExec.query(ormClassTool.getOrmCRUDQuery().getLoadQuery(), resultSetReader, this.wrapperTypeArray.unWrap(values)); }