Repository navigation
Expand file tree
/
Copy pathJoin.java
More file actions
136 lines (118 loc) · 3.59 KB
/
Copy pathJoin.java
File metadata and controls
136 lines (118 loc) · 3.59 KB
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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
/*Copyright ©2016 TommyLemon(https://github.com/TommyLemon/APIJSON)
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 zuo.biao.apijson.server;
import com.alibaba.fastjson.JSONObject;
/**JOIN 配置
* @author Lemon
*/
public class Join {
private String joinType; // "&" - INNER, "|" - FULL, "!" - OUTTER, "<" - LEFT, ">" - RIGHT
private String relateType; // "" - 一对一, "{}" - 一对多, "<>" - 多对一
private JSONObject table; // { "id@":"/Moment/userId" }
private String name; //User
private String key; //id
private String targetName; // Moment
private String targetKey; // userId
private SQLConfig joinConfig;
private SQLConfig cacheConfig;
public String getJoinType() {
return joinType;
}
public void setJoinType(String joinType) {
this.joinType = joinType;
}
public String getRelateType() {
return relateType;
}
public void setRelateType(String relateType) {
this.relateType = relateType;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public JSONObject getTable() {
return table;
}
public void setTable(JSONObject table) {
this.table = table;
}
public String getKey() {
return key;
}
public void setKey(String key) {
this.key = key;
}
public String getTargetName() {
return targetName;
}
public void setTargetName(String targetName) {
this.targetName = targetName;
}
public String getTargetKey() {
return targetKey;
}
public void setTargetKey(String targetKey) {
this.targetKey = targetKey;
}
public SQLConfig getJoinConfig() {
return joinConfig;
}
public void setJoinConfig(SQLConfig joinConfig) {
this.joinConfig = joinConfig;
}
public SQLConfig getCacheConfig() {
return cacheConfig;
}
public void setCacheConfig(SQLConfig cacheConfig) {
this.cacheConfig = cacheConfig;
}
public void setKeyAndType(@NotNull String originKey) throws Exception { //id, id@, id{}@, contactIdList<>@ ...
if (originKey.endsWith("@")) {
originKey = originKey.substring(0, originKey.length() - 1);
}
else { //TODO 暂时只允许 User.id = Moment.userId 字段关联，不允许 User.id = 82001 这种
throw new IllegalArgumentException(joinType + "/.../" + name + "/" + originKey + " 不合法！join:'.../refKey'" + " 中 refKey 必须以 @ 结尾！");
}
if (originKey.endsWith("{}")) {
setRelateType("{}");
setKey(originKey.substring(0, originKey.length() - 2));
}
else if (originKey.endsWith("<>")) {
setRelateType("<>");
setKey(originKey.substring(0, originKey.length() - 2));
}
else {
setRelateType("");
setKey(originKey);
}
}
public String getJoinTypeName() throws Exception {
return getJoinTypeName(joinType);
}
public static String getJoinTypeName(@NotNull String type) throws Exception {
switch (type) {
case "":
case "&":
case "|": //不支持 <>, [] ，避免太多符号
case "!":
return " INNER JOIN "; //TODO & | ! 通过 WHERE NOT( {B.where} OR {B.where} ) 解决
case "<":
return " LEFT JOIN ";
case ">":
return " RIGIHT JOIN ";
default:
throw new UnsupportedOperationException("服务器内部错误：不支持JOIN类型 " + type + " !");
}
}
}