How to use

QualifiedFieldThing

in

org.jdbi.v3.core.qualifier

@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");
}