SQLDialect sqlDialect = SQLDialect.valueOf(dataSourceConfig.getSqlDialect()); DataSource dataSource = dataSourceConfig.createDataSource(); Settings settings = new Settings(); settings.setRenderNameStyle(RenderNameStyle.AS_IS); final JdbcKeyValueService kvs = new JdbcKeyValueService( settings,
protected Settings getSettings() { return new Settings().withRenderNameStyle( RenderNameStyle.QUOTED ); }
public Settings withExecuteLogging(Boolean value) { setExecuteLogging(value); return this; }
@Bean @Primary public Settings jooqSettings() { Settings ret = new Settings(); ret.withRenderSchema(false); ret.setRenderFormatted(true); ret.setRenderNameStyle(RenderNameStyle.AS_IS); return ret; }
private static Configuration createJooqConfiguration(DataSource ds) { Settings settings = new Settings(); settings.setRenderSchema(false); settings.setRenderCatalog(false); settings.setRenderNameStyle(RenderNameStyle.AS_IS); return new DefaultConfiguration() .set(settings) .set(ds) .set(SQLDialect.POSTGRES); } }
Settings settings = new Settings(); settings.setRenderFormatted(true); if (a.keywords != null) settings.setRenderKeywordStyle(a.keywords); if (a.name != null) settings.setRenderNameStyle(a.name);
public PluginDao(final DataSource dataSource, final SQLDialect dialect) throws SQLException { this.dataSource = dataSource; this.dialect = dialect; switch (dialect) { case H2: final String schema; Connection connection = null; try { connection = dataSource.getConnection(); schema = connection.getSchema(); } finally { if (connection != null) { connection.close(); } } final MappedSchema mappedSchema = new MappedSchema().withInput(DEFAULT_SCHEMA_NAME) // As defined by the jOOQ codegen .withOutput(schema); final RenderMapping renderMapping = new RenderMapping().withSchemata(mappedSchema); this.settings = new Settings().withRenderMapping(renderMapping) .withRenderNameStyle(RenderNameStyle.UPPER); break; default: // For MySQL, schema doesn't matter. // For PostgreSQL, assume schema is part of the JDBC url this.settings = new Settings().withRenderSchema(false); break; } }
@Override public String version(SchemaDefinition schema) { return "" + new DefaultConfiguration() .set(connection) .set(new Settings().withStatementType(STATIC_STATEMENT)) .dsl() .fetchValue( // [#2906] TODO Plain SQL statements do not yet support named parameters sql.replace(":schema_name", "?"), param("schema_name", schema.getInputName()) ); } }
@Bean SpanStore spanStore() { SpanStore result; if (datasource != null && server.getStore().getType() == Type.mysql) { result = new JDBCSpanStore(datasource, new Settings().withRenderSchema(false), listener); } else { result = new InMemorySpanStore(); } return result; }
/** * Create an instance of {@link Settings } * */ public Settings createSettings() { return new Settings(); }
@Bean io.cattle.platform.db.jooq.config.Configuration LockingJooqConfiguration(DataSourceConnectionProvider dscp) { Settings settings = new Settings(); settings.setExecuteWithOptimisticLocking(true); LoggerListener logger = new LoggerListener(); logger.setMaxLength(1000); io.cattle.platform.db.jooq.config.Configuration config = new io.cattle.platform.db.jooq.config.Configuration(); config.setName("cattle"); config.setConnectionProvider(dscp); config.setListeners(Arrays.asList( logger, new StopWatchListener())); config.setSettings(settings); return config; }
@PostConstruct public void init() { String prop = "db." + name + ".database"; String database = ArchaiusUtil.getString(prop).get(); if (database == null) { throw new IllegalStateException("Failed to find config for [" + prop + "]"); } try { SQLDialect dialect = SQLDialect.valueOf(database.trim().toUpperCase()); set(dialect); } catch (IllegalArgumentException e) { throw new IllegalArgumentException("Invalid SQLDialect [" + database.toUpperCase() + "]", e); } if (connectionProvider == null) { set(new AutoCommitConnectionProvider(dataSource)); } else { set(connectionProvider); } settings.setRenderSchema(false); String renderNameStyle = ArchaiusUtil.getString("db." + name + "." + database + ".render.name.style").get(); if (renderNameStyle != null) { settings.setRenderNameStyle(RenderNameStyle.valueOf(renderNameStyle.trim().toUpperCase())); } set(settings); if (listeners != null && listeners.size() > 0) { settings().setExecuteLogging(false); set(DefaultExecuteListenerProvider.providers(listeners.toArray(new ExecuteListener[listeners.size()]))); } }
configuration.set(new SpringTransactionProvider(getTransactionManager())); configuration.settings().setExecuteLogging(this.useMetrics); if (this.useMetrics) { configuration.set(() -> new StopWatchListener()); case H2: configuration.set(SQLDialect.H2); configuration.settings().setRenderNameStyle(RenderNameStyle.UPPER); break; case MYSQL:
public Settings withRenderNameStyle(RenderNameStyle value) { setRenderNameStyle(value); return this; }
/** * Lazy access to {@link RenderMapping}. */ public static final RenderMapping getRenderMapping(Settings settings) { if (settings.getRenderMapping() == null) settings.setRenderMapping(new RenderMapping()); return settings.getRenderMapping(); }
public Settings withRenderSchema(Boolean value) { setRenderSchema(value); return this; }
@Test(groups = "fast") public void testBuildSettings() throws Exception { final String settingsXML = "<settings xmlns=\"http://www.jooq.org/xsd/jooq-runtime-3.10.2.xsd\">\n" + " <renderMapping>\n" + " <schemata>\n" + " <schema>\n" + " <input>DEV</input>\n" + " <tables>\n" + " <table>\n" + " <input>AUTHOR</input>\n" + " <output>MY_APP__AUTHOR</output>\n" + " </table>\n" + " </tables>\n" + " </schema>\n" + " </schemata>\n" + " </renderMapping>\n" + "</settings>"; final Settings settings = PluginDao.getSettings(new ByteArrayInputStream(settingsXML.getBytes())); Assert.assertNotNull(settings); Assert.assertNotNull(settings.getRenderMapping()); Assert.assertNotNull(settings.getRenderMapping().getSchemata()); Assert.assertEquals(settings.getRenderMapping().getSchemata().size(), 1); Assert.assertEquals(settings.getRenderMapping().getSchemata().get(0).getInput(), "DEV"); Assert.assertEquals(settings.getRenderMapping().getSchemata().get(0).getTables().size(), 1); Assert.assertEquals(settings.getRenderMapping().getSchemata().get(0).getTables().get(0).getInput(), "AUTHOR"); Assert.assertEquals(settings.getRenderMapping().getSchemata().get(0).getTables().get(0).getOutput(), "MY_APP__AUTHOR"); } }
@Override public String version(CatalogDefinition catalog) { return "" + new DefaultConfiguration() .set(connection) .set(new Settings().withStatementType(STATIC_STATEMENT)) .dsl() .fetchValue( // [#2906] TODO Plain SQL statements do not yet support named parameters sql.replace(":catalog_name", "?"), param("catalog_name", catalog.getInputName()) ); } }
/** * Create an instance of {@link Settings } * */ public Settings createSettings() { return new Settings(); }
public Settings withRenderNameStyle(RenderNameStyle value) { setRenderNameStyle(value); return this; }