/**
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*/
package org.apache.metamodel.delete;
import java.util.ArrayList;
import java.util.List;
import org.apache.metamodel.data.Row;
import org.apache.metamodel.query.FilterClause;
import org.apache.metamodel.query.FilterItem;
import org.apache.metamodel.query.SelectItem;
import org.apache.metamodel.query.builder.AbstractFilterBuilder;
import org.apache.metamodel.query.builder.FilterBuilder;
import org.apache.metamodel.schema.Column;
import org.apache.metamodel.schema.Table;
/**
* Abstract {@link RowDeletionBuilder} implementation
*/
public abstract class AbstractRowDeletionBuilder implements RowDeletionBuilder {
private final Table _table;
private final List<FilterItem> _whereItems;
public AbstractRowDeletionBuilder(Table table) {
if (table == null) {
throw new IllegalArgumentException("Table cannot be null");
}
_table = table;
_whereItems = new ArrayList<FilterItem>();
}
protected List<FilterItem> getWhereItems() {
return _whereItems;
}
@Override
public FilterBuilder<RowDeletionBuilder> where(Column column) {
SelectItem selectItem = new SelectItem(column);
return new AbstractFilterBuilder<RowDeletionBuilder>(selectItem) {
@Override
protected RowDeletionBuilder applyFilter(FilterItem filter) {
return where(filter);
}
};
}
@Override
public FilterBuilder<RowDeletionBuilder> where(String columnName) {
Column column = _table.getColumnByName(columnName);
if (column == null) {
throw new IllegalArgumentException("No such column: " + columnName);
}
return where(column);
}
@Override
public RowDeletionBuilder where(FilterItem... filterItems) {
for (FilterItem filterItem : filterItems) {
_whereItems.add(filterItem);
}
return this;
}
@Override
public RowDeletionBuilder where(Iterable<FilterItem> filterItems) {
for (FilterItem filterItem : filterItems) {
_whereItems.add(filterItem);
}
return this;
}
@Override
public Table getTable() {
return _table;
}
/**
* Determines if a row should be deleted or not (can be used by subclasses
* as a convenient determinator).
*
* @param row
* @return true if the row should be deleted.
*/
protected boolean deleteRow(Row row) {
final List<FilterItem> whereItems = getWhereItems();
for (FilterItem filterItem : whereItems) {
if (!filterItem.evaluate(row)) {
// since filter items are ANDed, if any item does not evaluate
// to true, the row is not deleted
return false;
}
}
return true;
}
/**
* Convenience method to tell subclasses if the delete operation represents
* a full table truncate operation. Usually such operations can be optimized
* by simply removing the table (and maybe restoring similar headers in a
* new table).
*
* @return
*/
protected boolean isTruncateTableOperation() {
final List<FilterItem> whereItems = getWhereItems();
return whereItems.isEmpty();
}
@Override
public String toString() {
return toSql();
}
@Override
public String toSql() {
return "DELETE FROM " + _table.getQualifiedLabel() + new FilterClause(null, " WHERE ").addItems(_whereItems);
}
}