-
Notifications
You must be signed in to change notification settings - Fork 20
/
MyComplexShardingAlgorithm.java
92 lines (86 loc) · 3.59 KB
/
MyComplexShardingAlgorithm.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
/*
* Copyright 2014-2020 the original author or authors.
*
* 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
*
* http://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.webank.webase.transaction.config;
import com.alibaba.fastjson.JSON;
import io.shardingsphere.api.algorithm.sharding.ListShardingValue;
import io.shardingsphere.api.algorithm.sharding.ShardingValue;
import io.shardingsphere.api.algorithm.sharding.complex.ComplexKeysShardingAlgorithm;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collection;
import java.util.Date;
import java.util.Iterator;
import java.util.List;
import lombok.extern.slf4j.Slf4j;
/**
* ComplexShardingAlgorithm.
*
*/
@Slf4j
public class MyComplexShardingAlgorithm implements ComplexKeysShardingAlgorithm {
@Override
public Collection<String> doSharding(Collection<String> collection,
Collection<ShardingValue> shardingValues) {
log.debug("collection:" + JSON.toJSONString(collection) + ",shardingValues:"
+ JSON.toJSONString(shardingValues));
// table sharding by id and gmt_create
Collection<Long> idValues = getLongShardingValue(shardingValues, "id");
Collection<Date> gmtValues = getDateShardingValue(shardingValues, "gmt_create");
List<String> shardingSuffix = new ArrayList<>();
for (Long idValue : idValues) {
for (Date gmtValue : gmtValues) {
Calendar cld = Calendar.getInstance();
cld.setTime(gmtValue);
int year = cld.get(Calendar.YEAR);
String suffix = "_" + year + "_" + idValue % 2;
collection.forEach(x -> {
if (x.endsWith(suffix)) {
shardingSuffix.add(x);
}
});
}
}
return shardingSuffix;
}
private Collection<Long> getLongShardingValue(Collection<ShardingValue> shardingValues,
final String key) {
Collection<Long> valueSet = new ArrayList<>();
Iterator<ShardingValue> iterator = shardingValues.iterator();
while (iterator.hasNext()) {
ShardingValue next = iterator.next();
if (next instanceof ListShardingValue) {
ListShardingValue value = (ListShardingValue) next;
if (value.getColumnName().equals(key)) {
return value.getValues();
}
}
}
return valueSet;
}
private Collection<Date> getDateShardingValue(Collection<ShardingValue> shardingValues,
final String key) {
Collection<Date> valueSet = new ArrayList<>();
Iterator<ShardingValue> iterator = shardingValues.iterator();
while (iterator.hasNext()) {
ShardingValue next = iterator.next();
if (next instanceof ListShardingValue) {
ListShardingValue value = (ListShardingValue) next;
if (value.getColumnName().equals(key)) {
return value.getValues();
}
}
}
return valueSet;
}
}