public void selectUsers() { JdbcMapper<Object> jdbcMapper = JdbcMapperFactory .newInstance() .addKeys("id", "roles_id", "phones_id") .newMapper(Object.class); }
@Test public void testMapSG() { JdbcMapperFactory.newInstance().addKeys("id").newMapper(MyPojo2.class); } }
@Test public void testMapConstructor() { JdbcMapperFactory.newInstance().addKeys("id").newMapper(MyPojo.class); } @Test
final JdbcMapper<Person> mapper = JdbcMapperFactoryHelper.noAsm() .addKeys("id", "students_id") .discriminator(Person.class, "person_type", String.class, new Consumer<AbstractMapperFactory.DiscriminatorConditionBuilder<ResultSet, String, Object>>() { @Override
@Test public void testJoinTableCNoAsmMultiThread() throws Exception { ExecutorService executor = Executors.newFixedThreadPool(4); try { final JdbcMapper<Person> mapper = JdbcMapperFactoryHelper.noAsm() .addKeys("id", "students_id") .<Person>newDiscriminator("person_type") .when("student", StudentGS.class) .when("professor", ProfessorGS.class) .mapper(); List<Future<Object>> futures = new ArrayList<Future<Object>>(100); for (int i = 0; i <300; i++) { futures.add(executor.submit(new Callable<Object>() { @Override public Object call() throws Exception { validateMapper(mapper); return null; } })); } for(Future<Object> f : futures) { f.get(); } } finally { executor.shutdown(); } }
JdbcMapper<Location> mapper = JdbcMapperFactory .newInstance() .addKeys("player") .newBuilder(Location.class) .addMapping(new JdbcColumnKey("name", 1, Types.VARCHAR))
.newInstance() .useAsm(useAsm) .addKeys("id", "photos_name", "videos_name") .newBuilder(Col.class) .addMapping("id", 1, 4)
@Test public void testNewDiscriminatorNoAsm() throws Exception { JdbcMapper<Person> mapper = JdbcMapperFactoryHelper.noAsm() .addKeys("id", "students_id") .discriminator(Person.class, "person_type", String.class, new Consumer<AbstractMapperFactory.DiscriminatorConditionBuilder<ResultSet, String, Object>>() { @Override public void accept(AbstractMapperFactory.DiscriminatorConditionBuilder<ResultSet, String, Object> builder) { builder .when("student", StudentGS.class) .when("professor", ProfessorGS.class); } } ) .newMapper(Person.class); validateMapper(mapper); }
@Test public void testNewDiscriminator() throws Exception { JdbcMapper<Person> mapper = JdbcMapperFactoryHelper.asm() .addKeys("id", "students_id") .discriminator(Person.class, "person_type", String.class, new Consumer<AbstractMapperFactory.DiscriminatorConditionBuilder<ResultSet, String, Object>>() { @Override public void accept(AbstractMapperFactory.DiscriminatorConditionBuilder<ResultSet, String, Object> builder) { builder .when("student", StudentGS.class) .when("professor", ProfessorGS.class); } } ) .newMapper(Person.class); validateMapper(mapper); }
JdbcMapperFactory .newInstance() .addKeys("id") .<DbObject, Long>crud(DbObject.class, Long.class) .table(connection, "test_db_object_serial");
@Test public void testNewDiscriminatorFieldAccessor() throws Exception { JdbcMapper<Person> mapper = JdbcMapperFactoryHelper.asm() .addKeys("id", "students_id") .discriminator(Person.class, "person_type", new CheckedBiFunction<ResultSet, String, String>() { @Override public String apply(ResultSet rs, String columnName) throws Exception { return rs.getString(columnName); } }, new Consumer<AbstractMapperFactory.DiscriminatorConditionBuilder<ResultSet, String, Object>>() { @Override public void accept(AbstractMapperFactory.DiscriminatorConditionBuilder<ResultSet, String, Object> builder) { builder .when("student", StudentGS.class) .when("professor", ProfessorGS.class); } } ) .newMapper(Person.class); validateMapper(mapper); }
@Test public void testDiscriminatorNoAsm() throws Exception { JdbcMapper<Person> mapper = JdbcMapperFactoryHelper.noAsm() .addKeys("id", "students_id") .<Person>newDiscriminator("person_type") .when("student", StudentGS.class) .when("professor", ProfessorGS.class) .mapper(); validateMapper(mapper); }
@Test public void testWithManualKey() throws SQLException { Crud<MyObject, Long> table = JdbcMapperFactory .newInstance() .addKeys("id") .<MyObject, Long>crud(MyObject.class, Long.class) .table(connection, "CRUDNOKEY"); assertEquals(new MyObject(1l, "name"), table.read(connection, 1l)); }
.newInstance() .reflectionService(ReflectionService.newInstance().withSelfScoreFullName(true)) .addKeys("resource_id", "id") .newBuilder(new TypeReference<Tuple2<Integer, List<Privilege>>>() {}) .addMapping("id", 1, 4)
@Test public void testUUID() throws SQLException { Connection connection = DbHelper.getDbConnection(DbHelper.TargetDB.POSTGRESQL); if (connection == null) { System.err.println("Db POSTGRESQL not available"); return; } try { Crud<MyEntity, UUID> objectCrud = JdbcMapperFactory .newInstance() .addKeys("uid") .<MyEntity, UUID>crud(MyEntity.class, UUID.class) .table(connection, "TEST_UUID"); final MyEntity object = new MyEntity(); object.setId(1); object.setUid(UUID.randomUUID()); object.setName("n1"); objectCrud.create(connection, object); assertEquals(object, objectCrud.read(connection, object.getUid())); object.setName("Updated Email"); objectCrud.update(connection, object); assertEquals(object, objectCrud.read(connection, object.getUid())); } finally { connection.close(); } }
@Test public void testDiscriminator() throws Exception { JdbcMapper<Person> mapper = JdbcMapperFactoryHelper.asm() .addKeys("id", "students_id") .<Person>newDiscriminator("person_type") .when("student", StudentGS.class) .addMapping("person_type") .addMapping("id") .addMapping("name", 3, FieldMapperColumnDefinition.<JdbcColumnKey>identity()) .when(new Predicate<String>() { @Override public boolean test(String s) { return "professor".equals(s); } }, ProfessorGS.class) .mapper(); validateMapper(mapper); }