@Test public void mapBeanQualifiedProperty() { handle.execute("insert into something (id, name) values (1, 'abc')"); BeanDao beanDao = handle.attach(BeanDao.class); assertThat(beanDao.getBeanQualifiedGetter(1)) .isEqualTo(new QualifiedGetterThing(1, "cba")); assertThat(beanDao.getBeanQualifiedSetter(1)) .isEqualTo(new QualifiedSetterThing(1, "cba")); assertThat(beanDao.getBeanQualifiedSetterParam(1)) .isEqualTo(new QualifiedSetterParamThing(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 bindBeanQualifiedProperty() { BeanDao beanDao = handle.attach(BeanDao.class); beanDao.insertBeanQualifiedGetter(new QualifiedGetterThing(1, "foo")); beanDao.insertBeanQualifiedSetter(new QualifiedSetterThing(2, "bar")); beanDao.insertBeanQualifiedSetterParam(new QualifiedSetterParamThing(3, "baz")); assertThat( handle.select("select name from something order by id") .mapTo(String.class) .list()) .containsExactly("oof", "rab", "zab"); }
@Test public void mapBeanQualifiedSetter() { dbRule.getJdbi() .registerColumnMapper(new ReversedStringMapper()) .registerRowMapper(BeanMapper.factory(QualifiedSetterThing.class)) .useHandle(handle -> { handle.execute("INSERT INTO something (id, name) VALUES (1, 'abc')"); assertThat(handle.select("SELECT * FROM something") .mapTo(QualifiedSetterThing.class) .findOnly()) .isEqualTo(new QualifiedSetterThing(1, "cba")); }); }
@Test public void bindBeanQualifiedSetter() { dbRule.getJdbi() .registerArgument(new ReversedStringArgumentFactory()) .useHandle(handle -> { handle.createUpdate("INSERT INTO something (id, name) VALUES (:id, :name)") .bindBean(new QualifiedSetterThing(1, "abc")) .execute(); assertThat(handle.select("SELECT name FROM something") .mapTo(String.class) .findOnly()) .isEqualTo("cba"); }); }
@Test public void mapBeanQualifiedProperty() { handle.execute("insert into something (id, name) values (1, 'abc')"); BeanDao beanDao = handle.attach(BeanDao.class); assertThat(beanDao.getBeanQualifiedGetter(1)) .isEqualTo(new QualifiedGetterThing(1, "cba")); assertThat(beanDao.getBeanQualifiedSetter(1)) .isEqualTo(new QualifiedSetterThing(1, "cba")); assertThat(beanDao.getBeanQualifiedSetterParam(1)) .isEqualTo(new QualifiedSetterParamThing(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 bindBeanQualifiedProperty() { BeanDao beanDao = handle.attach(BeanDao.class); beanDao.insertBeanQualifiedGetter(new QualifiedGetterThing(1, "foo")); beanDao.insertBeanQualifiedSetter(new QualifiedSetterThing(2, "bar")); beanDao.insertBeanQualifiedSetterParam(new QualifiedSetterParamThing(3, "baz")); assertThat( handle.select("select name from something order by id") .mapTo(String.class) .list()) .containsExactly("oof", "rab", "zab"); }