com.easy.query.api4j.select.extension.queryable4.SQLJoinable4 Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of sql-api4j Show documentation
There is a newer version: 2.3.3
package com.easy.query.api4j.select.extension.queryable4;

import com.easy.query.api4j.select.Queryable;
import com.easy.query.api4j.select.Queryable5;
import com.easy.query.api4j.select.impl.EasyQueryable5;
import com.easy.query.api4j.sql.SQLWherePredicate;
import com.easy.query.api4j.sql.impl.SQLWherePredicateImpl;
import com.easy.query.core.basic.api.select.ClientQueryable5;
import com.easy.query.core.common.tuple.Tuple5;
import com.easy.query.core.expression.lambda.SQLExpression1;
import com.easy.query.core.expression.lambda.SQLExpression5;

/**
 * create time 2023/8/16 09:11
 * 文件说明
 *
 * @author xuejiaming
 */
public interface SQLJoinable4 extends ClientQueryable4Available {

    /**
     * {@code
     * leftJoin(Entity2.class, (t1, t2,t3,t4, t5) -> t.eq(t2, Entity::getId, Entity2::getId))
     * }
     * t代表from的表,t1代表第一次join的表,t2代表第二次join的表
     *
     * @param joinClass 和哪张表进行join
     * @param on        条件
     * @param 
     * @return 返回可查询的表达式支持3表参数
     */
   default   Queryable5 leftJoin(Class joinClass, SQLExpression5, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate> on){
       ClientQueryable5 entityQueryable5 = getClientQueryable4().leftJoin(joinClass, (where1, where2, where3, where4, where5) -> {
           on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3), new SQLWherePredicateImpl<>(where4), new SQLWherePredicateImpl<>(where5));
       });
       return new EasyQueryable5<>(entityQueryable5);
   }

  default    Queryable5 leftJoin(Queryable joinQueryable, SQLExpression5, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate> on){
      ClientQueryable5 entityQueryable5 = getClientQueryable4().leftJoin(joinQueryable.getClientQueryable(), (where1, where2, where3, where4, where5) -> {
          on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3), new SQLWherePredicateImpl<>(where4), new SQLWherePredicateImpl<>(where5));
      });
      return new EasyQueryable5<>(entityQueryable5);
  }

   default   Queryable5 rightJoin(Class joinClass, SQLExpression5, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate> on){
       ClientQueryable5 entityQueryable5 = getClientQueryable4().rightJoin(joinClass, (where1, where2, where3, where4, where5) -> {
           on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3), new SQLWherePredicateImpl<>(where4), new SQLWherePredicateImpl<>(where5));
       });
       return new EasyQueryable5<>(entityQueryable5);
   }

   default   Queryable5 rightJoin(Queryable joinQueryable, SQLExpression5, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate> on){
       ClientQueryable5 entityQueryable5 = getClientQueryable4().rightJoin(joinQueryable.getClientQueryable(), (where1, where2, where3, where4, where5) -> {
           on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3), new SQLWherePredicateImpl<>(where4), new SQLWherePredicateImpl<>(where5));
       });
       return new EasyQueryable5<>(entityQueryable5);
   }

    default  Queryable5 innerJoin(Class joinClass, SQLExpression5, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate> on){
        ClientQueryable5 entityQueryable5 = getClientQueryable4().innerJoin(joinClass, (where1, where2, where3, where4, where5) -> {
            on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3), new SQLWherePredicateImpl<>(where4), new SQLWherePredicateImpl<>(where5));
        });
        return new EasyQueryable5<>(entityQueryable5);
    }

    default  Queryable5 innerJoin(Queryable joinQueryable, SQLExpression5, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate> on){
        ClientQueryable5 entityQueryable5 = getClientQueryable4().innerJoin(joinQueryable.getClientQueryable(), (where1, where2, where3, where4, where5) -> {
            on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3), new SQLWherePredicateImpl<>(where4), new SQLWherePredicateImpl<>(where5));
        });
        return new EasyQueryable5<>(entityQueryable5);
    }


    default  Queryable5 leftJoinMerge(Class joinClass, SQLExpression1, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate>> on) {
        return leftJoin(joinClass, (t1, t2,t3,t4, t5) -> {
            on.apply(new Tuple5<>(t1, t2,t3,t4, t5));
        });
    }

    default  Queryable5 leftJoinMerge(Queryable joinQueryable, SQLExpression1, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate>> on) {
        return leftJoin(joinQueryable, (t1, t2,t3,t4, t5) -> {
            on.apply(new Tuple5<>(t1, t2,t3,t4, t5));
        });
    }

    default  Queryable5 rightJoinMerge(Class joinClass, SQLExpression1, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate>> on) {
        return rightJoin(joinClass, (t1, t2,t3,t4, t5) -> {
            on.apply(new Tuple5<>(t1, t2,t3,t4, t5));
        });
    }

    default  Queryable5 rightJoinMerge(Queryable joinQueryable, SQLExpression1, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate>> on) {
        return rightJoin(joinQueryable, (t1, t2,t3,t4, t5) -> {
            on.apply(new Tuple5<>(t1, t2,t3,t4, t5));
        });
    }

    default  Queryable5 innerJoinMerge(Class joinClass, SQLExpression1, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate>> on) {
        return innerJoin(joinClass, (t1, t2,t3,t4, t5) -> {
            on.apply(new Tuple5<>(t1, t2,t3,t4, t5));
        });
    }

    default  Queryable5 innerJoinMerge(Queryable joinQueryable, SQLExpression1, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate, SQLWherePredicate>> on) {
        return innerJoin(joinQueryable, (t1, t2,t3,t4, t5) -> {
            on.apply(new Tuple5<>(t1, t2,t3,t4, t5));
        });
    }
}