Package org.jooq.conf

Examples of org.jooq.conf.Settings

133
134
135
136
137
138
139
140
141
142
143
    }

    @Test
    public void testGetSQLWithParamTypeNAMED_OR_INLINEDandStatementTypeSTATIC() {
        Query q =
        DSL.using(SQLDialect.MYSQL, new Settings().withParamType(NAMED_OR_INLINED)
                                                  .withStatementType(STATIC_STATEMENT))
           .select(param("var", 1), val("A"));

        testGetSQL0(q, "select 1, 'A' from dual");
    }
View Full Code Here
143
144
145
146
147
148
149
150
151
152
    }

    @Test
    public void testGetSQLWithParamTypeINLINED() {
        Query q =
        DSL.using(SQLDialect.MYSQL, new Settings().withParamType(INLINED))
           .select(param("var", 1), val("A"));

        testGetSQL0(q, "select 1, 'A' from dual");
    }
View Full Code Here
152
153
154
155
156
157
158
159
160
161
162
    }

    @Test
    public void testGetSQLWithParamTypeINLINEDandStatementTypeSTATIC() {
        Query q =
        DSL.using(SQLDialect.MYSQL, new Settings().withParamType(INLINED)
                                                  .withStatementType(STATIC_STATEMENT))
           .select(param("var", 1), val("A"));

        testGetSQL0(q, "select 1, 'A' from dual");
    }
View Full Code Here
165
166
167
168
169
170
171
172
173
174
175
176
    public void testKeywords() {
        Keyword keyword = DSL.keyword("Abc");
        Field<?> f = DSL.field("{0} Untouched {Xx} Untouched {1}", keyword, keyword);

        DSLContext def = DSL.using(MYSQL);
        DSLContext lower = DSL.using(MYSQL, new Settings().withRenderKeywordStyle(LOWER));
        DSLContext upper = DSL.using(MYSQL, new Settings().withRenderKeywordStyle(UPPER));

        assertEquals("abc Untouched xx Untouched abc", def.render(f));
        assertEquals("abc Untouched xx Untouched abc", lower.render(f));
        assertEquals("ABC Untouched XX Untouched ABC", upper.render(f));
    }
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
public class Example_2_2_OptimisticLocking {

    @Test
    public void run() throws SQLException {
        Connection connection = connection();
        DSLContext dsl = DSL.using(connection, new Settings().withExecuteWithOptimisticLocking(true));

        try {
            Tools.title("Applying optimistic locking");

            BookRecord book1 = dsl.selectFrom(BOOK).where(BOOK.ID.eq(1)).fetchOne();
View Full Code Here
161
162
163
164
165
166
167
168
169
170
171
        Class.forName("org.postgresql.Driver");
        c = getConnection("jdbc:postgresql:postgres", "postgres", System.getProperty("pw", "test"));
        DSLContext ctx = DSL.using(new DefaultConfiguration()
            .set(new DefaultConnectionProvider(c))
            .set(SQLDialect.POSTGRES)
            .set(new Settings().withExecuteLogging(false)));
       
        return runnable.run(ctx);
      }
      catch (Exception e) {
        e.printStackTrace();
View Full Code Here
46
47
48
49
50
51
52
53
54
*/
public class jOOQSQLServerTestInline extends jOOQSQLServerTest {

    @Override
    protected SQLServerFactory create(Settings settings) {
        settings = (settings != null) ? settings : new Settings();
        settings.withStatementType(StatementType.STATIC_STATEMENT);
        return new SQLServerFactory(getConnection(), settings);
    }
View Full Code Here
698
699
700
701
702
703
704
705
706
707
708
    protected final Factory create() {
        String defaultSchema = System.getProperty("org.jooq.settings.defaultSchema", "");
        Boolean renderSchema = Boolean.valueOf(System.getProperty("org.jooq.settings.renderSchema", "true"));

        Settings settings = SettingsTools.defaultSettings()
            .withRenderSchema(renderSchema)
            .withRenderMapping(new RenderMapping()
                .withDefaultSchema(defaultSchema))
            .withExecuteListeners(
                TestStatisticsListener.class.getName(),
View Full Code Here
125
126
127
128
129
130
131
132
133
134
135
        T_639NumbersTableRecord,
        T_785Record> {

  @Override
    protected Factory create(Settings settings) {
      settings = (settings != null) ? settings : new Settings();
        RenderMapping mapping = SettingsTools.getRenderMapping(settings);
        List<MappedSchema> schemata = mapping.getSchemata();

        if (schemata.size() == 0) {
            schemata.add(new MappedSchema()
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
        return "2";
    }

    @Override
    protected MySQLFactory create(Settings settings) {
        settings = (settings != null) ? settings : new Settings();
        RenderMapping mapping = SettingsTools.getRenderMapping(settings);
        List<MappedSchema> schemata = mapping.getSchemata();

        if (schemata.size() == 0) {
            schemata.add(new MappedSchema()
View Full Code Here
TOP

Related Classes of org.jooq.conf.Settings

  • org.jooq.academy.section2.Example_2_2_OptimisticLocking
  • org.jooq.academy.section3.Example_3_3_PreparedStatements
  • org.jooq.academy.section4.Example_4_2_Settings
  • org.jooq.academy.section4.Example_4_3_Settings
  • org.jooq.example.jaxrs.LicenseService
  • org.jooq.impl.DefaultConfiguration
  • org.jooq.impl.DefaultRenderContext
  • org.jooq.impl.Utils
  • org.jooq.test._.testcases.ExecuteListenerTests
  • org.jooq.test._.testcases.GeneralTests
    • 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.