public String createIdsTempTable(Collection<Long> ids) { String name = UUID.randomUUID().toString().replaceAll("-", ""); List<Object[]> batch = new ArrayList<Object[]>(); for (Long id : ids) { batch.add(new Object[]{name, id}); } _jdbc().batchUpdate("insert into temp_ids (key, id) values (?, ?)", batch); return name; }
@Override public void deleteOldAdminPrivileges(Collection<Long> transactionIds) { if (transactionIds.isEmpty()) { return; } final List<Object[]> transactionIdArrays = new ArrayList<>(transactionIds.size()); for (final Long transactionId : transactionIds) { transactionIdArrays.add(new Long[] {transactionId}); } _jdbc().batchUpdate(_lookup("old_privileges_delete"), transactionIdArrays, new int[] {Types.BIGINT}); }
@Override public void insertCurrentAdminPrivileges(Iterable<AdminPrivilege> privileges) { final List<Object[]> batchArguments = new ArrayList<>(); for (final AdminPrivilege privilege : privileges) { batchArguments.add(new String[] {privilege.getValue()}); } _jdbc().batchUpdate(_lookup("curr_privileges_insert"), batchArguments, new int[] {Types.VARCHAR}); }
public void insertLogs(List<Object[]> batchData) { _jdbc().batchUpdate(_lookup("insert_logs"), batchData); //$NON-NLS-1$ }