com.easy.query.api4j.select.extension.queryable2.SQLJoinable2 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.queryable2;

import com.easy.query.api4j.select.Queryable;
import com.easy.query.api4j.select.Queryable3;
import com.easy.query.api4j.select.impl.EasyQueryable3;
import com.easy.query.api4j.sql.SQLWherePredicate;
import com.easy.query.api4j.sql.impl.SQLWherePredicateImpl;
import com.easy.query.core.basic.api.select.ClientQueryable3;
import com.easy.query.core.common.tuple.Tuple3;
import com.easy.query.core.expression.lambda.SQLExpression1;
import com.easy.query.core.expression.lambda.SQLExpression3;

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

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

    default  Queryable3 leftJoin(Queryable joinQueryable, SQLExpression3, SQLWherePredicate, SQLWherePredicate> on) {
        ClientQueryable3 entityQueryable3 = getClientQueryable2().leftJoin(joinQueryable.getClientQueryable(), (where1, where2, where3) -> {
            on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3));
        });
        return new EasyQueryable3<>(entityQueryable3);
    }

    default  Queryable3 rightJoin(Class joinClass, SQLExpression3, SQLWherePredicate, SQLWherePredicate> on) {
        ClientQueryable3 entityQueryable3 = getClientQueryable2().rightJoin(joinClass, (where1, where2, where3) -> {
            on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3));
        });
        return new EasyQueryable3<>(entityQueryable3);
    }

    default  Queryable3 rightJoin(Queryable joinQueryable, SQLExpression3, SQLWherePredicate, SQLWherePredicate> on) {
        ClientQueryable3 entityQueryable3 = getClientQueryable2().rightJoin(joinQueryable.getClientQueryable(), (where1, where2, where3) -> {
            on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3));
        });
        return new EasyQueryable3<>(entityQueryable3);
    }

    default  Queryable3 innerJoin(Class joinClass, SQLExpression3, SQLWherePredicate, SQLWherePredicate> on) {
        ClientQueryable3 entityQueryable3 = getClientQueryable2().innerJoin(joinClass, (where1, where2, where3) -> {
            on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3));
        });
        return new EasyQueryable3<>(entityQueryable3);
    }

    default  Queryable3 innerJoin(Queryable joinQueryable, SQLExpression3, SQLWherePredicate, SQLWherePredicate> on) {
        ClientQueryable3 entityQueryable3 = getClientQueryable2().innerJoin(joinQueryable.getClientQueryable(), (where1, where2, where3) -> {
            on.apply(new SQLWherePredicateImpl<>(where1), new SQLWherePredicateImpl<>(where2), new SQLWherePredicateImpl<>(where3));
        });
        return new EasyQueryable3<>(entityQueryable3);
    }

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

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

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

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

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

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

}