io.github.matteobertozzi.easerinsights.jdbc.sql.SqlExpr Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of easer-insights-jdbc Show documentation
EASER Insights - JDBC.
The newest version!
/*
 * 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 io.github.matteobertozzi.easerinsights.jdbc.sql;

import java.util.Collection;
import java.util.function.Consumer;
import java.util.function.Function;

import io.github.matteobertozzi.easerinsights.jdbc.sql.SqlTableSchema.SqlField;

public interface SqlExpr {
  SqlExpr or();
  SqlExpr and();
  SqlExpr not();

  SqlExpr or(Consumer> consumer);
  SqlExpr and(Consumer> consumer);

  SqlExpr eq(SqlField field, Object value);
  SqlExpr ne(SqlField field, Object value);
  SqlExpr le(SqlField field, Object value);
  SqlExpr lt(SqlField field, Object value);
  SqlExpr ge(SqlField field, Object value);
  SqlExpr gt(SqlField field, Object value);

  SqlExpr like(SqlField field, String value);
  SqlExpr notLike(SqlField field, String value);

  SqlExpr in(SqlField field, short[] values);
  SqlExpr notIn(SqlField field, short[] values);
  SqlExpr in(SqlField field, int[] values);
  SqlExpr notIn(SqlField field, int[] values);
  SqlExpr in(SqlField field, long[] values);
  SqlExpr notIn(SqlField field, long[] values);
  SqlExpr in(SqlField field, Object... values);
  SqlExpr notIn(SqlField field, Object... values);
   SqlExpr in(SqlField field, V[] values, Function mapper);
   SqlExpr notIn(SqlField field, V[] values, Function mapper);
   SqlExpr in(SqlField field, Collection values, Function mapper);
   SqlExpr notIn(SqlField field, Collection values, Function mapper);

  SqlExpr between(SqlField field, Object a, Object b);

  SqlExpr isNull(SqlField field);
  SqlExpr isNotNull(SqlField field);

  SqlExpr openExpr();
  SqlExpr closeExpr();

  T bind();
}