com.easy.query.api4j.select.Queryable 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;

import com.easy.query.api4j.select.extension.queryable.SQLAggregatable1;
import com.easy.query.api4j.select.extension.queryable.SQLCountable1;
import com.easy.query.api4j.select.extension.queryable.SQLFilterable1;
import com.easy.query.api4j.select.extension.queryable.SQLForEachConfigurable1;
import com.easy.query.api4j.select.extension.queryable.SQLGroupable1;
import com.easy.query.api4j.select.extension.queryable.SQLHavingable1;
import com.easy.query.api4j.select.extension.queryable.SQLIncludeable1;
import com.easy.query.api4j.select.extension.queryable.SQLJoinable1;
import com.easy.query.api4j.select.extension.queryable.SQLOrderable1;
import com.easy.query.api4j.select.extension.queryable.SQLSelectable1;
import com.easy.query.api4j.select.extension.queryable.SQLTreeable1;
import com.easy.query.api4j.select.extension.queryable.SQLUnionable1;
import com.easy.query.api4j.sql.SQLColumnSelector;
import com.easy.query.core.api.client.EasyQueryClient;
import com.easy.query.core.basic.api.internal.ContextConfigure;
import com.easy.query.core.basic.api.internal.FilterConfigurable;
import com.easy.query.core.basic.api.internal.Interceptable;
import com.easy.query.core.basic.api.internal.LogicDeletable;
import com.easy.query.core.basic.api.internal.QueryStrategy;
import com.easy.query.core.basic.api.internal.TableReNameable;
import com.easy.query.core.basic.api.select.ClientQueryableAvailable;
import com.easy.query.core.basic.api.select.Query;
import com.easy.query.core.enums.sharding.ConnectionModeEnum;
import com.easy.query.core.expression.lambda.SQLExpression1;

/**
 * @author xuejiaming
 * @FileName: Select0.java
 * @Description: 文件说明
 * @Date: 2023/2/6 21:28
 */
public interface Queryable extends Query,
        Interceptable>,
        LogicDeletable>,
        TableReNameable>,
        QueryStrategy>,
        ContextConfigure>,
        FilterConfigurable>,
        SQLAggregatable1,
        SQLGroupable1,
        SQLHavingable1,
        SQLJoinable1,
        SQLOrderable1,
        SQLSelectable1,
        SQLUnionable1,
        SQLFilterable1,
        SQLIncludeable1,
        SQLCountable1,
        ClientQueryableAvailable,
        SQLForEachConfigurable1,
        SQLTreeable1 {

    /**
     * 只clone表达式共享上下文
     * 如果是两个独立的表达式建议重新创建如果是
     *
     * @return
     */
    @Override
    Queryable cloneQueryable();

    long countDistinct(SQLExpression1> selectExpression);

    /**
     * 设置column所有join表都会生效
     *
     * @param columns
     * @return
     */
    @Override
    Queryable select(String columns);

    default Queryable distinct() {
        return distinct(true);
    }

    Queryable distinct(boolean condition);

    @Override
    default Queryable limit(long rows) {
        return limit(true, rows);
    }

    @Override
    default Queryable limit(boolean condition, long rows) {
        return limit(condition, 0, rows);
    }

    @Override
    default Queryable limit(long offset, long rows) {
        return limit(true, offset, rows);
    }

    @Override
    Queryable limit(boolean condition, long offset, long rows);


    /**
     * 自动将查询结果集合全部添加到当前上下文追踪中,如果当前查询结果十分庞大,并且更新数据只有个别条数,建议不要使用
     * 追踪查询，可以通过开启追踪后使用普通的查询，然后添加到当前的追踪上下文中{@link EasyQueryClient#addTracking(Object)},开始先数据追踪的差异更新
     * 如果当前启用了追踪查询并且在当前上下文已经追加了当前trackKey的对象那么当前查询结果的对象不会被返回,返回的是被追踪的当前对象,
     * 如果对象A:{id:1,name:2}已经被追踪了,新查询的结果是对象A:{id:1,name:3},那么查询到的数据是{id:1,name:3}但是用户获取到的数据是{id:1,name:2}
     * 所以尽可能在追踪后调用entity update,而不是重复查询对应对象
     *
     * @return
     */
    Queryable asTracking();

    Queryable asNoTracking();

    Queryable useShardingConfigure(int maxShardingQueryLimit, ConnectionModeEnum connectionMode);

    Queryable useMaxShardingQueryLimit(int maxShardingQueryLimit);

    Queryable useConnectionMode(ConnectionModeEnum connectionMode);

//    SQLExpressionProvider getSQLExpressionProvider1();

}