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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
|
/*
* SonarQube
* Copyright (C) 2009-2017 SonarSource SA
* mailto:info AT sonarsource DOT com
*
* This program is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 3 of the License, or (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public License
* along with this program; if not, write to the Free Software Foundation,
* Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
*/
package org.sonar.db.user;
import com.google.common.collect.ImmutableSet;
import java.util.Locale;
import java.util.Set;
import javax.annotation.CheckForNull;
import javax.annotation.Nullable;
import org.apache.commons.lang.StringUtils;
import static com.google.common.base.MoreObjects.firstNonNull;
import static com.google.common.base.Preconditions.checkArgument;
import static com.google.common.base.Preconditions.checkNotNull;
import static org.sonar.db.DatabaseUtils.buildLikeValue;
import static org.sonar.db.WildcardPosition.BEFORE_AND_AFTER;
public class UserMembershipQuery {
public static final int DEFAULT_PAGE_INDEX = 1;
public static final int DEFAULT_PAGE_SIZE = 100;
public static final String ANY = "ANY";
public static final String IN = "IN";
public static final String OUT = "OUT";
public static final Set<String> AVAILABLE_MEMBERSHIPS = ImmutableSet.of(ANY, IN, OUT);
private final int groupId;
private final String membership;
private final String memberSearch;
// for internal use in MyBatis
final String memberSearchSql;
final String memberSearchSqlLowercase;
// max results per page
private final int pageSize;
// index of selected page. Start with 1.
private final int pageIndex;
private UserMembershipQuery(Builder builder) {
this.groupId = builder.groupId;
this.membership = builder.membership;
this.memberSearch = builder.memberSearch;
this.memberSearchSql = memberSearch == null ? null : buildLikeValue(memberSearch, BEFORE_AND_AFTER);
this.memberSearchSqlLowercase = memberSearchSql == null ? null : memberSearchSql.toLowerCase(Locale.ENGLISH);
this.pageSize = builder.pageSize;
this.pageIndex = builder.pageIndex;
}
public int groupId() {
return groupId;
}
@CheckForNull
public String membership() {
return membership;
}
/**
* Search for users email, login and name containing a given string
*/
@CheckForNull
public String memberSearch() {
return memberSearch;
}
public int pageSize() {
return pageSize;
}
public int pageIndex() {
return pageIndex;
}
public static Builder builder() {
return new Builder();
}
public static class Builder {
private Integer groupId;
private String membership;
private String memberSearch;
private Integer pageIndex = DEFAULT_PAGE_INDEX;
private Integer pageSize = DEFAULT_PAGE_SIZE;
private Builder() {
}
public Builder groupId(Integer groupId) {
this.groupId = groupId;
return this;
}
public Builder membership(@Nullable String membership) {
this.membership = membership;
return this;
}
public Builder memberSearch(@Nullable String s) {
this.memberSearch = StringUtils.defaultIfBlank(s, null);
return this;
}
public Builder pageSize(@Nullable Integer i) {
this.pageSize = i;
return this;
}
public Builder pageIndex(@Nullable Integer i) {
this.pageIndex = i;
return this;
}
private void initMembership() {
membership = firstNonNull(membership, ANY);
checkArgument(AVAILABLE_MEMBERSHIPS.contains(membership),
"Membership is not valid (got " + membership + "). Availables values are " + AVAILABLE_MEMBERSHIPS);
}
private void initPageSize() {
pageSize = firstNonNull(pageSize, DEFAULT_PAGE_SIZE);
}
private void initPageIndex() {
pageIndex = firstNonNull(pageIndex, DEFAULT_PAGE_INDEX);
checkArgument(pageIndex > 0, "Page index must be greater than 0 (got " + pageIndex + ")");
}
public UserMembershipQuery build() {
checkNotNull(groupId, "Group ID cant be null.");
initMembership();
initPageIndex();
initPageSize();
return new UserMembershipQuery(this);
}
}
}
|
