Examples of org.jooq.DSLContext

org.jooq.DSLContext
diately fetch results after constructing a query create.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)).fetch(); // The above is equivalent to this "non-fluent" style create.fetch(DSL.selectFrom(MY_TABLE).where(MY_TABLE.ID.eq(1)));
The DSL provides convenient constructors to create a {@link Configuration}, which will be shared among all Query objects thus created. Optionally, you can pass a reusable Configuration to the {@link DSL#using(Configuration)}constructor. Please consider thread-safety concerns documented in {@link Configuration}, should you want to reuse the same Configuration instance in various threads and / or transactions. @see DSL @see Configuration @author Lukas Eder

        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++) {
            assertEquals(TABLE1.field(i).getName(), result.field(i).getName());

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);


        for (int i = 0; i < 3; i++) {

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());
        assertEquals(3, result.get(0).fields().length);

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)")
        ).execute();


        assertEquals(2, result.length);
        assertEquals(0, result[0]);
        assertEquals(1, result[1]);

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)
         .bind(1, 2)
         .bind(3, 4)
         .execute();


        assertEquals(2, result.length);

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();
            fail();
        }

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();


        assertEquals(1, query.execute());

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"));
        assertNull(r.getValue(0, "INTEGERS"));
        assertArrayEquals(new String[0], (String[]) r.getValue(1, "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());
        assertNull(r.getArray("STRINGS"));
        assertNull(r.getArray("INTEGERS"));

View Full Code Here

    @Test
    public void testRenderSchema() {
        Schema schema = new SchemaImpl("S");
        Table<?> table = new TableImpl<Record>("T", schema);


        DSLContext create0 = DSL.using(SQLDialect.POSTGRES);
        assertEquals("\"S\".\"T\"", create0.render(table));


        DSLContext create1 = DSL.using(SQLDialect.POSTGRES, new Settings().withRenderSchema(false));
        assertEquals("\"T\"", create1.render(table));


        DSLContext create2 = DSL.using(SQLDialect.POSTGRES);
        create2.configuration().settings().setRenderSchema(false);
        assertEquals("\"T\"", create2.render(table));
    }

View Full Code Here

0 1 2

TOP

Related Classes of org.jooq.DSLContext

com.adamlewis.guice.persist.jooq.JooqPersistService

org.jooq.academy.section1.Example_1_3_DMLStatements

org.jooq.academy.section1.Example_1_4_Predicates

org.jooq.academy.section1.Example_1_5_ColumnExpressions

org.jooq.academy.section2.Example_2_1_ActiveRecords

org.jooq.academy.section2.Example_2_2_OptimisticLocking

org.jooq.example.jaxrs.LicenseService

org.jooq.impl.AbstractRoutine

org.jooq.impl.AbstractStoreQuery

org.jooq.impl.ResultImpl

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.