protected void postProcessDelete() { Delete delete = new Delete(table); String wheres = table.getColumns() .stream() .filter(col -> Model.MAIN_KEY.equals(col.getKey())) .map(col -> col.getQuotedName() + " = ?") .collect(Collectors.joining(" AND ")); delete.setWhere(wheres); deleteSqlMap.put(tableName, delete.getStatement()); }
Delete delete = new Delete(table); String where = null; for (Column column : table.getColumns()) {
Delete delete = new Delete(table); String whereString = String.format("%s = ? AND %s = ?", table.getColumn(filterColumn).getQuotedName(), table.getColumn(idsColumn).getQuotedName());
Delete delete = new Delete(table); StringBuilder whereClause = new StringBuilder(); List<Serializable> values = new ArrayList<>(1 + map.size());
protected void postProcessClusterInvalidations() { clusterInvalidationsColumns = Arrays.asList(table.getColumn(Model.CLUSTER_INVALS_NODEID_KEY), table.getColumn(Model.CLUSTER_INVALS_ID_KEY), table.getColumn(Model.CLUSTER_INVALS_FRAGMENTS_KEY), table.getColumn(Model.CLUSTER_INVALS_KIND_KEY)); Delete delete = new Delete(table); Column column = table.getColumn(Model.CLUSTER_INVALS_NODEID_KEY); delete.setWhere(column.getQuotedName() + " = ?"); deleteClusterInvalsSql = delete.getStatement(); deleteClusterInvalsColumn = column; }
@Override public void deleteEntryWithoutReferences(String id) { // second step: clean stored fields Delete delete = new Delete(table); String whereString = table.getPrimaryColumn().getQuotedName() + " = ?"; delete.setWhere(whereString); String sql = delete.getStatement(); if (logger.isLogEnabled()) { logger.logSQL(sql, Collections.singleton(id)); } try (PreparedStatement ps = sqlConnection.prepareStatement(sql)) { setFieldValue(ps, 1, table.getPrimaryColumn(), id); ps.execute(); } catch (SQLException e) { checkConcurrentUpdate(e); throw new DirectoryException("deleteEntry failed", e); } }
protected void postProcessClusterNodes() { Collection<Column> columns = table.getColumns(); Insert insert = new Insert(table); for (Column column : columns) { insert.addColumn(column); } createClusterNodeSql = insert.getStatement(); createClusterNodeColumns = new ArrayList<>(columns); Delete delete = new Delete(table); Column column = table.getColumn(Model.CLUSTER_NODES_NODEID_KEY); delete.setWhere(column.getQuotedName() + " = ?"); deleteClusterNodeSql = delete.getStatement(); deleteClusterNodeColumn = column; }