@Test public void testOnList() throws Exception { h.registerContainerFactory(new ImmutableListContainerFactory()); h.execute("insert into something (id, name) values (1, 'Coda')"); h.execute("insert into something (id, name) values (2, 'Brian')"); ImmutableList<String> rs = h.createQuery("select name from something order by id") .map(StringMapper.FIRST) .list(ImmutableList.class); assertThat(rs, equalTo(ImmutableList.of("Coda", "Brian"))); }
@Test public void testOnList() throws Exception { h.registerContainerFactory(new ImmutableListContainerFactory()); h.execute("insert into something (id, name) values (1, 'Coda')"); h.execute("insert into something (id, name) values (2, 'Brian')"); ImmutableList<String> rs = h.createQuery("select name from something order by id") .mapTo(String.class) .list(ImmutableList.class); assertThat(rs, equalTo(ImmutableList.of("Coda", "Brian"))); }
@Test public void testExists() throws Exception { h.execute("insert into something (id, name) values (1, 'Coda')"); h.registerContainerFactory(new MaybeContainerFactory()); Maybe<String> rs = h.createQuery("select name from something where id = :id") .bind("id", 1) .mapTo(String.class) .first(Maybe.class); assertThat(rs.isKnown(), equalTo(true)); assertThat(rs.getValue(), equalTo("Coda")); }
@Test public void testDoesNotExist() throws Exception { h.execute("insert into something (id, name) values (1, 'Coda')"); h.registerContainerFactory(new MaybeContainerFactory()); Maybe<String> rs = h.createQuery("select name from something where id = :id") .bind("id", 2) .mapTo(String.class) .first(Maybe.class); assertThat(rs.isKnown(), equalTo(false)); }
@Test public void testExists() throws Exception { h.execute("insert into something (id, name) values (1, 'Coda')"); h.registerContainerFactory(new MaybeContainerFactory()); Maybe<String> rs = h.createQuery("select name from something where id = :id") .bind("id", 1) .map(StringMapper.FIRST) .first(Maybe.class); assertThat(rs.isKnown(), equalTo(true)); assertThat(rs.getValue(), equalTo("Coda")); }
@Test public void testDoesNotExist() throws Exception { h.execute("insert into something (id, name) values (1, 'Coda')"); h.registerContainerFactory(new MaybeContainerFactory()); Maybe<String> rs = h.createQuery("select name from something where id = :id") .bind("id", 2) .map(StringMapper.FIRST) .first(Maybe.class); assertThat(rs.isKnown(), equalTo(false)); }