com.taotao.boot.data.shardingsphere.algorithm.CreateTimeShardingDatabaseAlgorithm Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of taotao-boot-starter-data-shardingsphere Show documentation

taotao-boot-starter-data-shardingsphere

The newest version!

/*
 * Copyright (c) 2020-2030, Shuigedeng ([email protected] & https://blog.taotaocloud.top/).
 *
 * 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
 *
 *      https://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.taotao.boot.data.shardingsphere.algorithm;

import com.google.common.collect.Range;
import com.taotao.boot.common.utils.date.DateUtils;
import org.apache.shardingsphere.sharding.api.sharding.standard.PreciseShardingValue;
import org.apache.shardingsphere.sharding.api.sharding.standard.RangeShardingValue;
import org.apache.shardingsphere.sharding.api.sharding.standard.StandardShardingAlgorithm;

import java.util.ArrayList;
import java.util.Collection;
import java.util.Properties;

/** 按创建时间年份分库 */
public class CreateTimeShardingDatabaseAlgorithm implements StandardShardingAlgorithm {

    @Override
    public String doSharding(Collection collection, PreciseShardingValue preciseShardingValue) {
        Long createTime = preciseShardingValue.getValue();
        String value = DateUtils.toString(createTime, "yyyy");
        // data2019,data2020
        return "data" + value;
    }

    @Override
    @SuppressWarnings("unchecked")
    public Collection doSharding(Collection collection, RangeShardingValue rangeShardingValue) {
        Collection collect = new ArrayList<>();
        Range valueRange = rangeShardingValue.getValueRange();

        // 开始年份结束年份
        String start = DateUtils.toString(valueRange.lowerEndpoint().longValue(), "yyyy");
        String end = DateUtils.toString(valueRange.upperEndpoint().longValue(), "yyyy");
        // 循环增加区间的查询条件
        for (int i = Integer.parseInt(start); i <= Integer.parseInt(end); i++) {
            collect.add("data" + i);
        }
        return collect;
    }

    // @Override
    // public void init() {
    //
    // }

    @Override
    public String getType() {
        return null;
    }

    @Override
    public void init(Properties props) {}
}