protobuf4j.orm.sql.QueryCreator Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of protobuf4j-sql Show documentation

A Facility Framework to Develop with Google Protobuf

The newest version!

package protobuf4j.orm.sql;

import protobuf4j.orm.sql.clause.*;
import protobuf4j.orm.sql.expr.Column;
import protobuf4j.orm.sql.expr.Value;

/**
 * 构建sql语句元素的util
 * 
 * author: yuanwq
 * date: 2018/7/16
 */
public abstract class QueryCreator {
  private QueryCreator() {
  }

  public static ISqlValue sqlValue(Object value) {
    if (value instanceof ISqlValue) {
      return (ISqlValue) value;
    }
    return Value.of(value);
  }

  public static Column column(String field) {
    return Column.of(field);
  }

  public static SelectClause select() {
    return new SelectClause();
  }

  public static FromClause from(String tableName) {
    return new FromClause(table(tableName));
  }

  public static FromClause fromType(Class messageType) {
    return new FromClause(table(SqlUtil.defaultTableName(messageType)));
  }

  public static ITableRef table(String tableName) {
    return new SimpleTable(tableName);
  }

  public static WhereClause where() {
    return new WhereClause();
  }

  public static GroupByClause groupBy() {
    return new GroupByClause();
  }

  public static OrderByClause orderBy() {
    return new OrderByClause();
  }

  public static PaginationClause.Builder pagination(int limit) {
    return PaginationClause.newBuilder(limit);
  }

  public static SetClause set() {
    return new SetClause();
  }

  public static SelectSql selectFrom(String table) {
    return new SelectSql(select(), from(table));
  }

  public static DeleteSql deleteFrom(String table) {
    return new DeleteSql(from(table));
  }

  public static UpdateSql updateSql(String table) {
    return new UpdateSql(table(table), set());
  }

  public static InsertSql insertInto(String table) {
    return new InsertSql(table(table));
  }
}