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

import com.easy.query.api4j.select.Queryable3;
import com.easy.query.api4j.sql.SQLOrderBySelector;
import com.easy.query.api4j.sql.impl.SQLOrderByColumnSelectorImpl;
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 08:50
 * 文件说明
 *
 * @author xuejiaming
 */
public interface SQLOrderable3 extends ClientQueryable3Available, Queryable3Available {

    default Queryable3 orderByAsc(SQLExpression3, SQLOrderBySelector, SQLOrderBySelector> selectExpression) {
        getClientQueryable3().orderByAsc((selector1, selector2, selector3) -> {
            selectExpression.apply(new SQLOrderByColumnSelectorImpl<>(selector1), new SQLOrderByColumnSelectorImpl<>(selector2), new SQLOrderByColumnSelectorImpl<>(selector3));
        });
        return getQueryable3();
    }

    default Queryable3 orderByAsc(boolean condition, SQLExpression3, SQLOrderBySelector, SQLOrderBySelector> selectExpression) {
        getClientQueryable3().orderByAsc(condition, (selector1, selector2, selector3) -> {
            selectExpression.apply(new SQLOrderByColumnSelectorImpl<>(selector1), new SQLOrderByColumnSelectorImpl<>(selector2), new SQLOrderByColumnSelectorImpl<>(selector3));
        });
        return getQueryable3();
    }

    default Queryable3 orderByAscMerge(SQLExpression1, SQLOrderBySelector, SQLOrderBySelector>> selectExpression) {
        return orderByAscMerge(true, selectExpression);
    }

    default Queryable3 orderByAscMerge(boolean condition, SQLExpression1, SQLOrderBySelector, SQLOrderBySelector>> selectExpression) {
        return orderByAsc(condition, (t1, t2,t3) -> {
            selectExpression.apply(new Tuple3<>(t1, t2,t3));
        });
    }


    default Queryable3 orderByDesc(SQLExpression3, SQLOrderBySelector, SQLOrderBySelector> selectExpression) {
        return orderByDesc(true, selectExpression);
    }

    default Queryable3 orderByDesc(boolean condition, SQLExpression3, SQLOrderBySelector, SQLOrderBySelector> selectExpression) {
        getClientQueryable3().orderByDesc(condition, (selector1, selector2, selector3) -> {
            selectExpression.apply(new SQLOrderByColumnSelectorImpl<>(selector1), new SQLOrderByColumnSelectorImpl<>(selector2), new SQLOrderByColumnSelectorImpl<>(selector3));
        });
        return getQueryable3();
    }

    default Queryable3 orderByDescMerge(SQLExpression1, SQLOrderBySelector, SQLOrderBySelector>> selectExpression) {
        return orderByDescMerge(true, selectExpression);
    }

    default Queryable3 orderByDescMerge(boolean condition, SQLExpression1, SQLOrderBySelector, SQLOrderBySelector>> selectExpression) {
        return orderByDesc(condition, (t1, t2,t3) -> {
            selectExpression.apply(new Tuple3<>(t1, t2,t3));
        });
    }

}