Examples of org.jooq.tools.jdbc.MockConnection

org.jooq.tools.jdbc.MockConnection
A mock connection.
Mock connections can be used to supply jOOQ with unit test data, avoiding the round-trip of using an actual in-memory test database, such as Derby, H2 or HSQLDB. A usage example:
```
 MockDataProvider provider = new MockDataProvider() { public MockResult[] execute(MockExecuteContext context) throws SQLException { Result<MyTableRecord> result = executor.newResult(MY_TABLE); result.add(executor.newRecord(MY_TABLE)); return new MockResult[] { new MockResult(1, result) }; } }; Connection connection = new MockConnection(provider); DSLContext create = DSL.using(connection, dialect); assertEquals(1, create.selectOne().fetch().size()); 
```
While this MockConnection can be used independently of jOOQ, it has been optimised for usage with jOOQ. JDBC features that are not used by jOOQ (e.g. procedure bind value access by parameter name) are not supported in this mock framework @author Lukas Eder

        byte[] b = new byte[(int) f.length()];
        f.readFully(b);
        String s = new String(b);
        s = s.replace("{version}", Constants.FULL_VERSION);


        MOCK = DSL.using(new MockConnection(new MockFileDatabase(s)), SQLDialect.POSTGRES);
    }

View Full Code Here

        MOCK = DSL.using(new MockConnection(new MockFileDatabase(s)), SQLDialect.POSTGRES);
    }


    @Test
    public void testEmptyResult() {
        DSLContext e = DSL.using(new MockConnection(new EmptyResult()), SQLDialect.H2);
        Result<Record> result = e.fetch("select ?, ? from dual", 1, 2);


        assertEquals(0, result.size());
        assertEquals(3, result.fields().length);
        for (int i = 0; i < 3; i++) {

View Full Code Here

        }
    }


    @Test
    public void testSingleResult() {
        DSLContext e = DSL.using(new MockConnection(new SingleResult()), SQLDialect.H2);
        Result<Record> result = e.fetch("select ?, ? from dual", 1, 2);


        assertEquals(1, result.size());
        assertEquals(3, result.fields().length);

View Full Code Here

        }
    }


    @Test
    public void testTripleResult() {
        DSLContext e = DSL.using(new MockConnection(new TripleResult()), SQLDialect.H2);
        List<Result<Record>> result = e.fetchMany("select ?, ? from dual", 1, 2);


        assertEquals(3, result.size());
        assertEquals(1, result.get(0).size());
        assertEquals(2, result.get(1).size());

View Full Code Here

        }
    }


    @Test
    public void testBatchSingle() {
        DSLContext e = DSL.using(new MockConnection(new BatchSingle()), SQLDialect.H2);


        int[] result =
        e.batch(
            e.query("insert into x values(1)"),
            e.query("insert into x values(2)")

View Full Code Here

        }
    }


    @Test
    public void testBatchMultiple() {
        DSLContext e = DSL.using(new MockConnection(new BatchMultiple()), SQLDialect.H2);


        Query query = e.query("insert into x values(?, ?)", null, null);


        int[] result =
        e.batch(query)

View Full Code Here

        }
    }


    @Test
    public void testException() {
        DSLContext e = DSL.using(new MockConnection(new Exceptional()), SQLDialect.H2);


        Query query = e.query("insert into x values(1)");


        try {
            query.execute();

View Full Code Here


    @Test
    public void testInsertReturning() {


        // Note: INSERT .. RETURNING is hard to mock for all dialects...
        DSLContext e = DSL.using(new MockConnection(new InsertReturning()), SQLDialect.POSTGRES);


        InsertResultStep<Table1Record> query = e
            .insertInto(TABLE1, FIELD_ID1)
            .values(1)
            .returning();

View Full Code Here

        }
    }


    @Test
    public void testArrays() {
        DSLContext e = DSL.using(new MockConnection(new ArrayResult(3)), SQLDialect.POSTGRES);


        Result<Record2<String[], Integer[]>> r = e.select(strings, integers).fetch();
        assertEquals(4, r.size());
        assertEquals(2, r.fields().length);
        assertNull(r.getValue(0, "STRINGS"));

View Full Code Here

        assertArrayEquals(new Integer[] { 2, 2 }, (Integer[]) r.getValue(3, "INTEGERS"));
    }


    @Test
    public void testJDBCArrays() throws SQLException {
        DSLContext e = DSL.using(new MockConnection(new ArrayResult(3)), SQLDialect.POSTGRES);


        ResultSet r = e.select(strings, integers).fetchResultSet();
        assertEquals(2, r.getMetaData().getColumnCount());


        assertTrue(r.next());

View Full Code Here

0 1

TOP

Related Classes of org.jooq.tools.jdbc.MockConnection

org.jooq.test.ConverterTest

org.jooq.test.MockTest

org.jooq.test.VisitContextTest

java.sql.SQLException

java.sql.SQLFeatureNotSupportedException

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.