/**
* Copyright 2012 Universitat Pompeu Fabra.
*
* Licensed 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.onexus.collection.store.sql.filters;
import org.onexus.collection.api.query.AtomicFilter;
import org.onexus.collection.api.query.Contains;
import org.onexus.collection.api.query.Query;
import org.onexus.collection.api.utils.QueryUtils;
import org.onexus.collection.store.sql.SqlCollectionDDL;
import org.onexus.collection.store.sql.SqlCollectionStore;
import org.onexus.collection.store.sql.SqlDialect;
import org.onexus.resource.api.ORI;
import java.util.HashMap;
import java.util.Map;
public class AtomicFilterBuilder extends AbstractFilterBuilder<AtomicFilter> {
private final static Map<String, String> oqlToSql = new HashMap<String, String>();
static {
oqlToSql.put("CONTAINS", "LIKE");
oqlToSql.put("=", "=");
oqlToSql.put(">", ">");
oqlToSql.put(">=", ">=");
oqlToSql.put("<", "<");
oqlToSql.put("<=", "<=");
oqlToSql.put("!=", "<>");
}
public AtomicFilterBuilder(SqlDialect dialect) {
super(dialect, AtomicFilter.class);
}
@Override
protected void innerBuild(SqlCollectionStore store, Query query, StringBuilder where, AtomicFilter filter) {
String collectionAlias = filter.getCollectionAlias();
ORI collectionUri = QueryUtils.getCollectionOri(query, collectionAlias);
SqlCollectionDDL collection = store.getDDL(collectionUri);
SqlCollectionDDL.ColumnInfo column = collection.getColumnInfoByFieldName(filter.getFieldId());
where.append('`').append(filter.getCollectionAlias()).append("`.`").append(column.getColumnName()).append('`');
String operator = oqlToSql.get(filter.getOperandSymbol());
if (operator == null) {
operator = filter.getOperandSymbol();
}
where.append(' ').append(operator).append(' ');
if (filter instanceof Contains) {
encodeValue(where, String.class, "%" + filter.getValue() + "%");
} else {
encodeValue(where, column.getField().getType(), filter.getValue());
}
}
}