Package org.skife.jdbi.v2

Examples of org.skife.jdbi.v2.DBI

45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
        assertEquals(1, count);
    }

    public void testParameterizedInsert() throws Exception
    {
        final Handle h = openHandle();
        final int count = h.createStatement("tests:parameterized_insert")
                .define("table", "something")
                .define("column_one", "id")
                .define("column_two", "name")
                .bind("column_one", 7)
                .bind("column_two", "Rebecca")
                .execute();
        assertEquals(1, count);

        final String name = h.createQuery("select name from something where id = 7")
                .map(StringMapper.FIRST)
                .first();
        assertEquals(name, "Rebecca");
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
        assertEquals(name, "Rebecca");
    }

    public void testExtraDefinesDontBreakThings() throws Exception
    {
        final Handle h = openHandle();
        final int count = h.createStatement("tests:insert_one")
                .define("name", "Nicole")
                .execute();
        assertEquals(1, count);
    }
View Full Code Here
25
26
27
28
29
30
31
32
33
*/
public class TestQueryObjectGenerator extends DBITestCase
{
    public void testApiWhichTakesConnection() throws Exception
    {
        Handle h = openHandle();
        MyQueries qo = QueryObjectFactory.createQueryObject(MyQueries.class, h.getConnection());
        assertNotNull(qo);
    }
View Full Code Here
32
33
34
35
36
37
38
39
40
        assertNotNull(qo);
    }

    public void testApiWhichTakesDatasource() throws Exception
    {
        final Handle h = openHandle();
        MyQueries qo = QueryObjectFactory.createQueryObject(MyQueries.class, Tools.getDataSource());
        assertNotNull(qo);
    }
View Full Code Here
50
51
52
53
54
55
56
57
        List<Something> ds = q.getAllSomethings();

        assertNotNull(ds);
        Iterator<Something> i = ds.iterator();
        assertTrue(i.hasNext());
        Something s = i.next();
        assertEquals("Keith", s.getName());
    }
View Full Code Here
62
63
64
65
66
67
68
69
        List<Something> ds = q.findByName("Keith");

        assertNotNull(ds);
        Iterator<Something> i = ds.iterator();
        assertTrue(i.hasNext());
        Something s = i.next();
        assertEquals("Keith", s.getName());
    }
View Full Code Here
72
73
74
75
76
77
78
79
80
    {
        handle.insert("insert into something (id, name) values (?, ?)", 1, "Keith");
        Iterator<Something> i = q.ittyAll();

        assertTrue(i.hasNext());
        Something s = i.next();
        assertEquals("Keith", s.getName());
        assertFalse(i.hasNext());
    }
View Full Code Here
80
81
82
83
84
85
86
87
    }

    public void testSingle() throws Exception
    {
        handle.insert("insert into something (id, name) values (?, ?)", 1, "Keith");
        Something s = q.findById(1);
        assertEquals("Keith", s.getName());
    }
View Full Code Here
89
90
91
92
93
94
95
96
97
    public void testInsert() throws Exception
    {
        assertEquals(true, q.insert(1, "Keith"));
        Iterator<Something> as = q.ittyAll();
        assertTrue(as.hasNext());
        Something s = as.next();
        assertEquals("Keith", s.getName());
        assertFalse(as.hasNext());
    }
View Full Code Here
98
99
100
101
102
103
104
105
106
    public void testUpdate() throws Exception
    {
        q.insert(1, "Keith");
        q.updateNameById("Eric", 1);
        Something s = q.findById(1);
        assertNotNull(s);
        assertEquals("Eric", s.getName());
    }
View Full Code Here
TOP

Related Classes of org.skife.jdbi.v2.DBI

  • co.paralleluniverse.fibers.dropwizard.FiberDBIFactory
  • com.codahale.metrics.jdbi.InstrumentedTimingCollectorTest
  • com.digitolio.jdbi.annotations.Factory
  • com.digitolio.jdbi.auto.AutoDeleteByPKWriter$MyRewrittenStatement
  • com.digitolio.jdbi.auto.AutoInsertWriter$MyRewrittenStatement
  • com.digitolio.jdbi.auto.AutoSelectByPKWriter$MyRewrittenStatement
  • com.digitolio.jdbi.auto.AutoUpdateByPKWriter$MyRewrittenStatement
  • com.digitolio.jdbi.AutoDeleteByPKWriter
  • com.digitolio.jdbi.AutoDeleteByPKWriter$MyRewrittenStatement
  • com.digitolio.jdbi.AutoInsertWriter
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.