public void insertRedeems(List<Redeem> redeemList) { if (isDBEnabled() && redeemList.size() > 0) { redeemDBDao.insertRedeems(redeemList); } }
public boolean updateRedeem(String email, String token) throws Exception { return redeemDBDao.updateRedeem(email, token); }
public Redeem selectRedeemByToken(String token) throws Exception { if (isDBEnabled()) { return redeemDBDao.selectRedeemByToken(token); } return null; }
public void insertRedeems(List<Redeem> redeemList) { try (Connection connection = ds.getConnection(); PreparedStatement ps = connection.prepareStatement(insertRedeemToken)) { for (Redeem redeem : redeemList) { insert(ps, redeem); ps.addBatch(); } ps.executeBatch(); connection.commit(); } catch (Exception e) { log.error("Error inserting redeems data in DB.", e); } }
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."); }