com.querydsl.sql.mysql.MySQLQueryFactory Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of querydsl-sql Show documentation
SQL support for Querydsl
There is a newer version: 6.9
/*
 * Copyright 2015, The Querydsl Team (http://www.querydsl.com/team)
 *
 * 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 com.querydsl.sql.mysql;

import com.querydsl.core.QueryFlag.Position;
import com.querydsl.core.Tuple;
import com.querydsl.core.types.Expression;
import com.querydsl.core.types.ExpressionUtils;
import com.querydsl.core.types.dsl.Expressions;
import com.querydsl.sql.*;
import com.querydsl.sql.dml.SQLInsertClause;
import java.sql.Connection;
import java.util.function.Supplier;

/**
 * MySQL specific implementation of SQLQueryFactory
 *
 * @author tiwe
 */
public class MySQLQueryFactory extends AbstractSQLQueryFactory> {

  public MySQLQueryFactory(Configuration configuration, Supplier connection) {
    super(configuration, connection);
  }

  public MySQLQueryFactory(Supplier connection) {
    this(new Configuration(new MySQLTemplates()), connection);
  }

  public MySQLQueryFactory(SQLTemplates templates, Supplier connection) {
    this(new Configuration(templates), connection);
  }

  /**
   * Create a INSERT IGNORE INTO clause
   *
   * @param entity table to insert to
   * @return insert clause
   */
  public SQLInsertClause insertIgnore(RelationalPath entity) {
    SQLInsertClause insert = insert(entity);
    insert.addFlag(Position.START_OVERRIDE, "insert ignore into ");
    return insert;
  }

  /**
   * Create a INSERT ... ON DUPLICATE KEY UPDATE clause
   *
   * @param entity table to insert to
   * @param clause clause
   * @return insert clause
   */
  public SQLInsertClause insertOnDuplicateKeyUpdate(RelationalPath entity, String clause) {
    SQLInsertClause insert = insert(entity);
    insert.addFlag(Position.END, " on duplicate key update " + clause);
    return insert;
  }

  /**
   * Create a INSERT ... ON DUPLICATE KEY UPDATE clause
   *
   * @param entity table to insert to
   * @param clause clause
   * @return insert clause
   */
  public SQLInsertClause insertOnDuplicateKeyUpdate(
      RelationalPath entity, Expression clause) {
    SQLInsertClause insert = insert(entity);
    insert.addFlag(
        Position.END,
        ExpressionUtils.template(String.class, " on duplicate key update {0}", clause));
    return insert;
  }

  /**
   * Create a INSERT ... ON DUPLICATE KEY UPDATE clause
   *
   * @param entity table to insert to
   * @param clauses clauses
   * @return insert clause
   */
  public SQLInsertClause insertOnDuplicateKeyUpdate(
      RelationalPath entity, Expression... clauses) {
    SQLInsertClause insert = insert(entity);
    StringBuilder flag = new StringBuilder(" on duplicate key update ");
    for (int i = 0; i < clauses.length; i++) {
      flag.append(i > 0 ? ", " : "").append("{").append(i).append("}");
    }
    insert.addFlag(Position.END, ExpressionUtils.template(String.class, flag.toString(), clauses));
    return insert;
  }

  @Override
  public MySQLQuery query() {
    return new MySQLQuery(connection, configuration);
  }

  public MySQLReplaceClause replace(RelationalPath entity) {
    return new MySQLReplaceClause(connection.get(), configuration, entity);
  }

  @Override
  public  MySQLQuery select(Expression expr) {
    return query().select(expr);
  }

  @Override
  public MySQLQuery select(Expression... exprs) {
    return query().select(exprs);
  }

  @Override
  public  MySQLQuery selectDistinct(Expression expr) {
    return query().select(expr).distinct();
  }

  @Override
  public MySQLQuery selectDistinct(Expression... exprs) {
    return query().select(exprs).distinct();
  }

  @Override
  public MySQLQuery selectZero() {
    return select(Expressions.ZERO);
  }

  @Override
  public MySQLQuery selectOne() {
    return select(Expressions.ONE);
  }

  @Override
  public  MySQLQuery selectFrom(RelationalPath expr) {
    return select(expr).from(expr);
  }
}