@Test public void mapQualifiedField() { handle.execute("insert into something (id, name) values (1, 'abc')"); FieldDao fieldDao = handle.attach(FieldDao.class); assertThat(fieldDao.getQualifiedField(1)) .isEqualTo(new QualifiedFieldThing(1, "cba")); }
@Test public void mapTo() { handle.execute("insert into something (id, name) values (1, 'abc')"); MapToDao mapToDao = handle.attach(MapToDao.class); assertThat(mapToDao.get(1, QualifiedGetterThing.class)) .isEqualTo(new QualifiedGetterThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedSetterThing.class)) .isEqualTo(new QualifiedSetterThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedSetterParamThing.class)) .isEqualTo(new QualifiedSetterParamThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedConstructorParamThing.class)) .isEqualTo(new QualifiedConstructorParamThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedFieldThing.class)) .isEqualTo(new QualifiedFieldThing(1, "cba")); }
@Test public void bindQualifiedField() { FieldDao fieldDao = handle.attach(FieldDao.class); fieldDao.insertBindFields(new QualifiedFieldThing(1, "abc")); assertThat( handle.select("select name from something") .mapTo(String.class) .findOnly()) .isEqualTo("cba"); }
@Test public void mapFieldsQualified() { dbRule.getJdbi() .registerColumnMapper(new ReversedStringMapper()) .registerRowMapper(FieldMapper.factory(QualifiedFieldThing.class)) .useHandle(handle -> { handle.execute("INSERT INTO something (id, name) VALUES (1, 'abc')"); assertThat(handle.select("SELECT * FROM something") .mapTo(QualifiedFieldThing.class) .findOnly()) .isEqualTo(new QualifiedFieldThing(1, "cba")); }); }
@Test public void bindFieldsQualified() { dbRule.getJdbi() .registerArgument(new ReversedStringArgumentFactory()) .useHandle(handle -> { handle.createUpdate("INSERT INTO something (id, name) VALUES (:id, :name)") .bindFields(new QualifiedFieldThing(1, "abc")) .execute(); assertThat(handle.select("SELECT name FROM something") .mapTo(String.class) .findOnly()) .isEqualTo("cba"); }); }
@Test public void mapQualifiedField() { handle.execute("insert into something (id, name) values (1, 'abc')"); FieldDao fieldDao = handle.attach(FieldDao.class); assertThat(fieldDao.getQualifiedField(1)) .isEqualTo(new QualifiedFieldThing(1, "cba")); }
@Test public void mapTo() { handle.execute("insert into something (id, name) values (1, 'abc')"); MapToDao mapToDao = handle.attach(MapToDao.class); assertThat(mapToDao.get(1, QualifiedGetterThing.class)) .isEqualTo(new QualifiedGetterThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedSetterThing.class)) .isEqualTo(new QualifiedSetterThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedSetterParamThing.class)) .isEqualTo(new QualifiedSetterParamThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedConstructorParamThing.class)) .isEqualTo(new QualifiedConstructorParamThing(1, "cba")); assertThat(mapToDao.get(1, QualifiedFieldThing.class)) .isEqualTo(new QualifiedFieldThing(1, "cba")); }
@Test public void bindQualifiedField() { FieldDao fieldDao = handle.attach(FieldDao.class); fieldDao.insertBindFields(new QualifiedFieldThing(1, "abc")); assertThat( handle.select("select name from something") .mapTo(String.class) .findOnly()) .isEqualTo("cba"); }