Examples with Handle org.jdbi.v3.core.Handle used on opensource projects

Example 71 with Handle

use of org.jdbi.v3.core.Handle in project tutorials by eugenp.

the class JdbiTest method whenSelectMapToMap_thenResultsAreMapEntries.

@Test
public void whenSelectMapToMap_thenResultsAreMapEntries() {
    Jdbi jdbi = Jdbi.create("jdbc:hsqldb:mem:testDB", "sa", "");
    jdbi.useHandle(handle -> {
        handle.execute("create table PROJECT_3 (ID IDENTITY, NAME VARCHAR (50), URL VARCHAR (100))");
        handle.execute("INSERT INTO PROJECT_3 (NAME, URL) VALUES ('tutorials', 'github.com/eugenp/tutorials')");
        handle.execute("INSERT INTO PROJECT_3 (NAME, URL) VALUES ('REST with Spring', 'github.com/eugenp/REST-With-Spring')");
        Query query = handle.createQuery("select * from PROJECT_3 order by id");
        List<Map<String, Object>> list = query.mapToMap().list();
        assertEquals("tutorials", list.get(0).get("name"));
        assertEquals("REST with Spring", list.get(1).get("name"));
    });
}

Example 72 with Handle

use of org.jdbi.v3.core.Handle in project tutorials by eugenp.

the class JdbiTest method whenNoResults_thenFindOnlyThrows.

@Test
public void whenNoResults_thenFindOnlyThrows() {
    Jdbi jdbi = Jdbi.create("jdbc:hsqldb:mem:testDB", "sa", "");
    jdbi.useHandle(handle -> {
        handle.execute("create table PROJECT_8 (ID IDENTITY, NAME VARCHAR (50), URL VARCHAR (100))");
        try {
            handle.createQuery("select * from project_8").mapToMap().findOnly();
            fail("Exception expected");
        } catch (Exception e) {
            e.printStackTrace();
        }
    });
}

Example 73 with Handle

use of org.jdbi.v3.core.Handle in project tutorials by eugenp.

the class JdbiTest method whenException_thenTransactionIsRolledBack.

@Test
public void whenException_thenTransactionIsRolledBack() {
    Jdbi jdbi = Jdbi.create("jdbc:hsqldb:mem:testDB", "sa", "");
    jdbi.useHandle(handle -> {
        try {
            handle.useTransaction(h -> {
                h.execute("create table PROJECT_14 (ID IDENTITY, NAME VARCHAR (50), URL VARCHAR (100))");
                h.execute("INSERT INTO PROJECT_14 (NAME, URL) VALUES ('tutorials', 'https://github.com/eugenp/tutorials')");
                List<Map<String, Object>> list = handle.select("SELECT * FROM PROJECT_14").mapToMap().list();
                assertTrue(h.isInTransaction());
                assertEquals(1, list.size());
                throw new Exception("rollback");
            });
        } catch (Exception ignored) {
        }
        List<Map<String, Object>> list = handle.select("SELECT * FROM PROJECT_14").mapToMap().list();
        assertFalse(handle.isInTransaction());
        assertEquals(0, list.size());
    });
}

Example 74 with Handle

use of org.jdbi.v3.core.Handle in project tutorials by eugenp.

the class JdbiTest method whenNoResults_thenFindFirstReturnsNone.

@Test
public void whenNoResults_thenFindFirstReturnsNone() {
    Jdbi jdbi = Jdbi.create("jdbc:hsqldb:mem:testDB", "sa", "");
    jdbi.useHandle(handle -> {
        handle.execute("create table PROJECT_6 (ID IDENTITY, NAME VARCHAR (50), URL VARCHAR (100))");
        assertFalse(handle.createQuery("select * from project_6").mapToMap().findFirst().isPresent());
    });
}

Example 75 with Handle

use of org.jdbi.v3.core.Handle in project tutorials by eugenp.

the class JdbiTest method whenHandle_thenBoh.

@Test
public void whenHandle_thenBoh() {
    Jdbi jdbi = Jdbi.create("jdbc:hsqldb:mem:testDB", "sa", "");
    final Handle[] handleRef = new Handle[1];
    boolean closed = jdbi.withHandle(handle -> {
        handleRef[0] = handle;
        return handle.isClosed();
    });
    assertFalse(closed);
    assertTrue(handleRef[0].isClosed());
}