public void insertPurchase(Purchase purchase) { try (Connection connection = ds.getConnection(); PreparedStatement ps = connection.prepareStatement(insertPurchase)) { insert(ps, purchase); ps.executeUpdate(); connection.commit(); } catch (Throwable e) { log.error("Error inserting purchase data in DB. {}", e.getMessage()); } }
public void insertPurchase(Purchase purchase) { if (isDBEnabled()) { purchaseDBDao.insertPurchase(purchase); } }
public DBManager(String propsFilename, BlockingIOProcessor blockingIOProcessor, boolean isEnabled) { this.blockingIOProcessor = blockingIOProcessor; DBProperties dbProperties = new DBProperties(propsFilename); if (!isEnabled || dbProperties.size() == 0) { log.info("Separate DB storage disabled."); this.ds = null; return; } HikariConfig config = initConfig(dbProperties); log.info("DB url : {}", config.getJdbcUrl()); log.info("DB user : {}", config.getUsername()); log.info("Connecting to DB..."); HikariDataSource hikariDataSource; try { hikariDataSource = new HikariDataSource(config); } catch (Exception e) { log.error("Not able connect to DB. Skipping. Reason : {}", e.getMessage()); this.ds = null; return; } this.ds = hikariDataSource; this.userDBDao = new UserDBDao(hikariDataSource); this.redeemDBDao = new RedeemDBDao(hikariDataSource); this.purchaseDBDao = new PurchaseDBDao(hikariDataSource); this.flashedTokensDBDao = new FlashedTokensDBDao(hikariDataSource); this.cloneProjectDBDao = new CloneProjectDBDao(hikariDataSource); this.forwardingTokenDBDao = new ForwardingTokenDBDao(hikariDataSource); checkDBVersion(); log.info("Connected to database successfully."); }