Package org.skife.jdbi.v2

Examples of org.skife.jdbi.v2.DBI

112
113
114
115
116
117
118
119
120
121
122
123
124
        assertFalse(q.ittyAll().hasNext());
    }

    public void testBeanBinding() throws Exception
    {
        Something s = new Something(1, "Keith");
        q.insert(s);

        s = q.findById(1);
        assertNotNull(s);
        assertEquals("Keith", s.getName());

    }
View Full Code Here
43
44
45
46
47
48
49
50
51
52
53
                {
                    return Tools.getConnection();
                }
                catch (SQLException e)
                {
                    throw new UnableToObtainConnectionException(e);
                }
            }
        });
        Handle h = dbi.open();
        assertNotNull(h);
View Full Code Here
67
68
69
70
71
72
73
74
75
                                        getStatementLocator(),
                                        new CachingStatementBuilder(new DefaultStatementBuilder()),
                                        new ColonPrefixNamedParamStatementRewriter(),
                                        conn,
                                        new HashMap<String, Object>(),
                                        new NoOpLog());
        handles.add(h);
        return h;
    }
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
        h.close();
    }

    public void testConnectionFactoryCtor() throws Exception
    {
        DBI dbi = new DBI(new ConnectionFactory()
        {
            public Connection openConnection()
            {
                try
                {
View Full Code Here
54
55
56
57
58
59
60
61
62
63
64
        h.close();
    }

    public void testCorrectExceptionOnSQLException() throws Exception
    {
        DBI dbi = new DBI(new ConnectionFactory()
        {
            public Connection openConnection() throws SQLException
            {
                throw new SQLException();
            }
View Full Code Here
33
34
35
36
37
38
39
40
41
    }


    public void testNewlinesOkay() throws Exception
    {
        RewrittenStatement rws = rw.rewrite("select * from something\n where id = :id", new Binding(),
                                            new StatementContext(new HashMap<String, Object>()));
        assertEquals("select * from something\n where id = ?", rws.getSql());
    }
View Full Code Here
40
41
42
43
44
45
46
47
48
        assertEquals("select * from something\n where id = ?", rws.getSql());
    }

    public void testOddCharacters() throws Exception
    {
        RewrittenStatement rws = rw.rewrite(":boo ':nope' _%&^& *@ :id", new Binding(),
                                            new StatementContext(new HashMap<String, Object>()));
        assertEquals("? ':nope' _%&^& *@ ?", rws.getSql());
    }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
    }

    public void testFoo() throws Exception
    {
        Handle h = openHandle();
        h.setStatementLocator(new StatementLocator() {

            public String locate(String name, StatementContext ctx) throws Exception
            {
                return name.replaceAll("<table>", String.valueOf(ctx.getAttribute("table")));
            }
View Full Code Here
74
75
76
77
78
79
80
        return h;
    }

    protected TransactionHandler getTransactionHandler()
    {
        return new LocalTransactionHandler();
    }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
        h.begin();

        h.insert("insert into something (id, name) values (:id, :name)", 1, "Tom");
        h.checkpoint("first");
        h.insert("insert into something (id, name) values (:id, :name)", 1, "Martin");
        assertEquals(Integer.valueOf(2), h.createQuery("select count(*) from something").map(new IntegerMapper()).first());
        h.rollback("first");
        assertEquals(Integer.valueOf(1), h.createQuery("select count(*) from something").map(new IntegerMapper()).first());
        h.commit();
        assertEquals(Integer.valueOf(1), h.createQuery("select count(*) from something").map(new IntegerMapper()).first());
    }
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.