Package org.jooq

Examples of org.jooq.RenderContext.render()

2247
2248
2249
2250
2251
2252
2253
2254
2255
2256
2257
        assertEquals("'abc''def'", r_refP.render(i1));
        assertEquals("'abc''def'", r_ref.render(i1));

        assertEquals("123", r_refI.render(i2));
        assertEquals("123", r_refP.render(i2));
        assertEquals("123", r_ref.render(i2));

        assertEquals("123.0", r_refI.render(i3));
        assertEquals("123.0", r_refP.render(i3));
        assertEquals("123.0", r_ref.render(i3));
View Full Code Here
2251
2252
2253
2254
2255
2256
2257
2258
2259
2260
2261
        assertEquals("123", r_refP.render(i2));
        assertEquals("123", r_ref.render(i2));

        assertEquals("123.0", r_refI.render(i3));
        assertEquals("123.0", r_refP.render(i3));
        assertEquals("123.0", r_ref.render(i3));

        assertEquals("{d '1981-07-10'}", r_refI.render(i4));
        assertEquals("{d '1981-07-10'}", r_refP.render(i4));
        assertEquals("{d '1981-07-10'}", r_ref.render(i4));
    }
View Full Code Here
2255
2256
2257
2258
2259
2260
2261
2262
2263
2264
2265
        assertEquals("123.0", r_refP.render(i3));
        assertEquals("123.0", r_ref.render(i3));

        assertEquals("{d '1981-07-10'}", r_refI.render(i4));
        assertEquals("{d '1981-07-10'}", r_refP.render(i4));
        assertEquals("{d '1981-07-10'}", r_ref.render(i4));
    }

    @Test
    public void testRenderNameStyle() {
        Query q = create.select(val(1)).from(TABLE1).where(FIELD_ID1.equal(2));
View Full Code Here
2272
2273
2274
2275
2276
2277
2278
2279
2280
2281
2282
        r_refP.getSettings().setRenderNameStyle(RenderNameStyle.AS_IS);
        r_ref.getSettings().setRenderNameStyle(RenderNameStyle.AS_IS);

        assertEquals("select 1 from TABLE1 where TABLE1.ID1 = 2", r_refI.render(q));
        assertEquals("select :1 from TABLE1 where TABLE1.ID1 = :2", r_refP.render(q));
        assertEquals("select ? from TABLE1 where TABLE1.ID1 = ?", r_ref.render(q));

        r_refI.getSettings().setRenderNameStyle(RenderNameStyle.LOWER);
        r_refP.getSettings().setRenderNameStyle(RenderNameStyle.LOWER);
        r_ref.getSettings().setRenderNameStyle(RenderNameStyle.LOWER);
View Full Code Here
2280
2281
2282
2283
2284
2285
2286
2287
2288
2289
2290
        r_refP.getSettings().setRenderNameStyle(RenderNameStyle.LOWER);
        r_ref.getSettings().setRenderNameStyle(RenderNameStyle.LOWER);

        assertEquals("select 1 from table1 where table1.id1 = 2", r_refI.render(q));
        assertEquals("select :1 from table1 where table1.id1 = :2", r_refP.render(q));
        assertEquals("select ? from table1 where table1.id1 = ?", r_ref.render(q));

        r_refI.getSettings().setRenderNameStyle(RenderNameStyle.UPPER);
        r_refP.getSettings().setRenderNameStyle(RenderNameStyle.UPPER);
        r_ref.getSettings().setRenderNameStyle(RenderNameStyle.UPPER);
View Full Code Here
2288
2289
2290
2291
2292
2293
2294
2295
2296
2297
2298
        r_refP.getSettings().setRenderNameStyle(RenderNameStyle.UPPER);
        r_ref.getSettings().setRenderNameStyle(RenderNameStyle.UPPER);

        assertEquals("select 1 from TABLE1 where TABLE1.ID1 = 2", r_refI.render(q));
        assertEquals("select :1 from TABLE1 where TABLE1.ID1 = :2", r_refP.render(q));
        assertEquals("select ? from TABLE1 where TABLE1.ID1 = ?", r_ref.render(q));

        r_refI.getSettings().setRenderNameStyle(RenderNameStyle.QUOTED);
        r_refP.getSettings().setRenderNameStyle(RenderNameStyle.QUOTED);
        r_ref.getSettings().setRenderNameStyle(RenderNameStyle.QUOTED);
View Full Code Here
2296
2297
2298
2299
2300
2301
2302
2303
2304
2305
2306
        r_refP.getSettings().setRenderNameStyle(RenderNameStyle.QUOTED);
        r_ref.getSettings().setRenderNameStyle(RenderNameStyle.QUOTED);

        assertEquals("select 1 from \"TABLE1\" where \"TABLE1\".\"ID1\" = 2", r_refI.render(q));
        assertEquals("select :1 from \"TABLE1\" where \"TABLE1\".\"ID1\" = :2", r_refP.render(q));
        assertEquals("select ? from \"TABLE1\" where \"TABLE1\".\"ID1\" = ?", r_ref.render(q));
    }

    @Test
    public void testRenderKeywordStyle() {
        Query q = create.select(val(1)).from(TABLE1).where(FIELD_ID1.equal(2));
View Full Code Here
2313
2314
2315
2316
2317
2318
2319
2320
2321
2322
2323
        r_refP.getSettings().setRenderKeywordStyle(RenderKeywordStyle.UPPER);
        r_ref.getSettings().setRenderKeywordStyle(RenderKeywordStyle.UPPER);

        assertEquals("SELECT 1 FROM \"TABLE1\" WHERE \"TABLE1\".\"ID1\" = 2", r_refI.render(q));
        assertEquals("SELECT :1 FROM \"TABLE1\" WHERE \"TABLE1\".\"ID1\" = :2", r_refP.render(q));
        assertEquals("SELECT ? FROM \"TABLE1\" WHERE \"TABLE1\".\"ID1\" = ?", r_ref.render(q));

        r_refI.getSettings().setRenderKeywordStyle(RenderKeywordStyle.LOWER);
        r_refP.getSettings().setRenderKeywordStyle(RenderKeywordStyle.LOWER);
        r_ref.getSettings().setRenderKeywordStyle(RenderKeywordStyle.LOWER);
View Full Code Here
2321
2322
2323
2324
2325
2326
2327
2328
2329
2330
2331
        r_refP.getSettings().setRenderKeywordStyle(RenderKeywordStyle.LOWER);
        r_ref.getSettings().setRenderKeywordStyle(RenderKeywordStyle.LOWER);

        assertEquals("select 1 from \"TABLE1\" where \"TABLE1\".\"ID1\" = 2", r_refI.render(q));
        assertEquals("select :1 from \"TABLE1\" where \"TABLE1\".\"ID1\" = :2", r_refP.render(q));
        assertEquals("select ? from \"TABLE1\" where \"TABLE1\".\"ID1\" = ?", r_ref.render(q));
    }

    @Test
    public void testYearToMonth() {
        for (int i = 0; i <= 5; i++) {
View Full Code Here
727
728
729
730
731
732
733
734
735
                }

                i++;
            }

            return function(local.render(), getDataType(), array);
        }
    }
}
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.