@SuppressWarnings({"unchecked", "rawtypes"}) @Override public void configure(final Env env, final Config config, final Binder binder) { Key<DataSource> dskey = Key.get(DataSource.class, Names.named(name)); DataSource ds = env.get(dskey) .orElseThrow(() -> new NoSuchElementException("DataSource missing: " + dskey)); DBI dbi = new DBI2(ds); dbi.setSQLLog(new SLF4JLog()); dbi.registerArgumentFactory(new OptionalArgumentFactory()); dbi.registerArgumentFactory(new IterableArgumentFactory()); dbi.registerContainerFactory(new OptionalContainerFactory()); dbi.setStatementRewriter(new ExpandedStmtRewriter()); ServiceKey serviceKey = env.serviceKey(); serviceKey.generate(DBI.class, name, k -> binder.bind(k).toInstance(dbi)); serviceKey.generate(Handle.class, name, k -> binder.bind(k).toProvider(() -> dbi.open())); sqlObjects.forEach(sqlObject -> binder.bind(sqlObject) .toProvider((Provider) () -> dbi.open(sqlObject))); if (callback != null) { callback.accept(dbi, config); } }
dbi.setSQLLog(new LogbackLog(LOGGER, Level.TRACE));
@SuppressWarnings("SpringJavaAutowiringInspection") @Bean public DBI jdbiFactory(DataSource dataSource) { // note that for JDBI we have to wrap datasource with TransactionAwareDataSourceProxy otherwise JDBI won't respect // transactions created by spring TransactionAwareDataSourceProxy transactionAwareDataSourceProxy = new TransactionAwareDataSourceProxy(dataSource); DBI dbi = new DBI(transactionAwareDataSourceProxy); dbi.setSQLLog(new SLF4JLog()); // to enable SLF4J logging return dbi; }
SqlObjectRepository() { _dbiInstance = new DBI(_connectionHelper.getDataSource()); _dbiInstance.setSQLLog(new Log4JLog());
@SuppressWarnings({"unchecked", "rawtypes"}) @Override public void configure(final Env env, final Config config, final Binder binder) { Key<DataSource> dskey = Key.get(DataSource.class, Names.named(name)); DataSource ds = env.get(dskey) .orElseThrow(() -> new NoSuchElementException("DataSource missing: " + dskey)); DBI dbi = new DBI2(ds); dbi.setSQLLog(new SLF4JLog()); dbi.registerArgumentFactory(new OptionalArgumentFactory()); dbi.registerArgumentFactory(new IterableArgumentFactory()); dbi.registerContainerFactory(new OptionalContainerFactory()); dbi.setStatementRewriter(new ExpandedStmtRewriter()); ServiceKey serviceKey = env.serviceKey(); serviceKey.generate(DBI.class, name, k -> binder.bind(k).toInstance(dbi)); serviceKey.generate(Handle.class, name, k -> binder.bind(k).toProvider(() -> dbi.open())); sqlObjects.forEach(sqlObject -> binder.bind(sqlObject) .toProvider((Provider) () -> dbi.open(sqlObject))); if (callback != null) { callback.accept(dbi, config); } }
@Override public IDBI get() { final DBI dbi = new DBI(ds); for (final ArgumentFactory argumentFactory : argumentFactorySet) { dbi.registerArgumentFactory(argumentFactory); } for (final ResultSetMapperFactory resultSetMapperFactory : resultSetMapperFactorySet) { dbi.registerMapper(resultSetMapperFactory); } for (final ResultSetMapper resultSetMapper : resultSetMapperSet) { dbi.registerMapper(resultSetMapper); } if (transactionHandler != null) { dbi.setTransactionHandler(transactionHandler); } if (sqlLog != null) { dbi.setSQLLog(sqlLog); } else if (config != null) { final Slf4jLogging sqlLog = new Slf4jLogging(logger, config.getLogLevel()); dbi.setSQLLog(sqlLog); } if (timingCollector != null) { dbi.setTimingCollector(timingCollector); } return dbi; }
@Before public void setUp() throws Exception { dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID()); dbi.setSQLLog(new PrintStreamLog(System.out)); handle = dbi.open(); handle.execute("create table something( id integer primary key, name varchar(100) )"); }
@Before public void setUp() throws Exception { dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID()); dbi.setSQLLog(new PrintStreamLog(System.out)); handle = dbi.open(); handle.execute("create table something( id integer primary key, name varchar(100) )"); }
@Before public void setUp() throws Exception { dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID()); dbi.setSQLLog(new PrintStreamLog(System.out)); handle = dbi.open(); handle.execute("create table something( id integer primary key, name varchar(100) )"); }
@Before public void setUp() throws Exception { dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID()); dbi.setSQLLog(new PrintStreamLog(System.out)); handle = dbi.open(); handle.execute("create table something( id integer primary key, name varchar(100) )"); }
@Before public void setUp() throws Exception { dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID()); dbi.setSQLLog(new PrintStreamLog(System.out)); handle = dbi.open(); handle.execute("create table something( id integer primary key, name varchar(100) )"); handle.execute("CREATE ALIAS stored_insert FOR \"org.skife.jdbi.v2.sqlobject.TestSqlCall.insertSomething\";"); }
@Before public void setUp() throws Exception { dbi = new DBI("jdbc:h2:mem:" + UUID.randomUUID()); dbi.registerMapper(new SomethingMapper()); dbi.setSQLLog(new PrintStreamLog(System.out)); handle = dbi.open(); handle.execute("create table something( id integer primary key, name varchar(100) )"); handle.execute("CREATE ALIAS stored_insert FOR \"org.skife.jdbi.v2.sqlobject.TestSqlCall.insertSomething\";"); }
@Override public DBI get() { final DBI dbi = new DBI(transactionalDataSource); dbi.setSQLLog(new LogbackLog()); if (environment.isPresent()) { environment.get().lifecycle().manage(managedDataSource); environment.get().healthChecks().register("db", new DBIHealthCheck(dbi, dataSourceFactory.getValidationQuery())); dbi.setTimingCollector(new InstrumentedTimingCollector(environment.get().metrics(), new SanerNamingStrategy())); } dbi.registerArgumentFactory(new OptionalArgumentFactory(dataSourceFactory.getDriverClass())); dbi.registerContainerFactory(new ImmutableListContainerFactory()); dbi.registerContainerFactory(new ImmutableSetContainerFactory()); dbi.registerContainerFactory(new OptionalContainerFactory()); dbi.registerArgumentFactory(new JodaDateTimeArgumentFactory()); dbi.registerMapper(new JodaDateTimeMapper()); dbi.registerMapper(new RosettaMapperFactory()); new RosettaObjectMapperOverride(objectMapper).override(dbi); return dbi; }
@Before public void setUp() throws Exception { JdbcDataSource ds = new JdbcDataSource(); ds.setURL("jdbc:h2:mem:" + UUID.randomUUID()); DBI dbi = new DBI(ds); dbi.setSQLLog(new PrintStreamLog()); handle = dbi.open(); somethingDao = handle.attach(SomethingDao.class); handle.execute("create table something (something_id int primary key, name varchar(100), code int)"); handle.execute("insert into something(something_id, name, code) values (1, 'Brian', 12)"); handle.execute("insert into something(something_id, name, code) values (2, 'Keith', 27)"); handle.execute("insert into something(something_id, name, code) values (3, 'Coda', 14)"); }
@Override public DataSource get() { final DataSource ds = getDataSource(); final DBI dbi = new DBI(ds); dbi.registerArgumentFactory(new UUIDArgumentFactory()); dbi.registerArgumentFactory(new DateTimeZoneArgumentFactory()); dbi.registerArgumentFactory(new DateTimeArgumentFactory()); dbi.registerArgumentFactory(new LocalDateArgumentFactory()); dbi.registerArgumentFactory(new EnumArgumentFactory()); dbi.registerMapper(new UuidMapper()); if (sqlLog != null) { dbi.setSQLLog(sqlLog); } return ds; }
@Before public void setUp() throws Exception { JdbcDataSource ds = new JdbcDataSource(); ds.setURL("jdbc:h2:mem:" + UUID.randomUUID()); DBI dbi = new DBI(ds); dbi.setSQLLog(new PrintStreamLog()); handle = dbi.open(); somethingDao = handle.attach(SomethingDao.class); handle.execute("create table something (something_id int primary key, name varchar(100), code int)"); handle.execute("insert into something(something_id, name, code) values (1, 'Brian', 12)"); handle.execute("insert into something(something_id, name, code) values (2, 'Keith', 27)"); handle.execute("insert into something(something_id, name, code) values (3, 'Coda', 14)"); }
private void registerDBIFactoryComponent(Environment environment, MayocatShopSettings configuration) throws ClassNotFoundException, ComponentRepositoryException { final DBIFactory factory = new DBIFactory(); final DBI jdbi = factory.build(environment, configuration.getDataSourceFactory(), "jdbi"); jdbi.registerArgumentFactory(new PostgresUUIDArgumentFactory()); jdbi.registerArgumentFactory(new PostgresUUIDArrayArgumentFactory()); if (configuration.getDevelopmentEnvironment().isEnabled() && configuration.getDevelopmentEnvironment().isLogDatabaseRequests()) { jdbi.setSQLLog(new PrintStreamLog()); } final DBIProvider dbi = new DBIProvider() { @Override public DBI get() { return jdbi; } }; DefaultComponentDescriptor<DBIProvider> cd = new DefaultComponentDescriptor<DBIProvider>(); cd.setRoleType(DBIProvider.class); getComponentManager().registerComponent(cd, dbi); }
final DBI dbi = new DBI(ds); if (sqlLog != null) { dbi.setSQLLog(sqlLog);
dbi.setSQLLog(new LogbackLog(LOGGER, Level.TRACE));