2 * Copyright 2000-2018 Vaadin Ltd.
4 * Licensed under the Apache License, Version 2.0 (the "License"); you may not
5 * use this file except in compliance with the License. You may obtain a copy of
8 * http://www.apache.org/licenses/LICENSE-2.0
10 * Unless required by applicable law or agreed to in writing, software
11 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
12 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
13 * License for the specific language governing permissions and limitations under
16 package com.vaadin.v7.data.util.sqlcontainer.query.generator.filter;
18 import java.util.Locale;
20 import com.vaadin.v7.data.Container.Filter;
21 import com.vaadin.v7.data.util.filter.Like;
22 import com.vaadin.v7.data.util.sqlcontainer.query.generator.StatementHelper;
25 * @deprecated As of 8.0, no replacement available.
28 public class LikeTranslator implements FilterTranslator {
31 public boolean translatesFilter(Filter filter) {
32 return filter instanceof Like;
36 public String getWhereStringForFilter(Filter filter, StatementHelper sh) {
37 Like like = (Like) filter;
38 if (like.isCaseSensitive()) {
39 sh.addParameterValue(like.getValue());
40 return QueryBuilder.quote(like.getPropertyId()) + " LIKE ?";
42 sh.addParameterValue(like.getValue().toUpperCase(Locale.ROOT));
43 return "UPPER(" + QueryBuilder.quote(like.getPropertyId())