1 package org.cacert.gigi.dbObjects;
3 import org.cacert.gigi.database.DatabaseConnection;
4 import org.cacert.gigi.database.GigiPreparedStatement;
5 import org.cacert.gigi.database.GigiResultSet;
8 SUPPORTER("supporter"), ARBITRATOR("arbitrator"), BLOCKEDASSURER("blockedassurer"), BLOCKEDASSUREE("blockedassuree"), BLOCKEDLOGIN("blockedlogin"), TTP_ASSURER("ttp-assurer"), TTP_APPLICANT("ttp-applicant"), CODESIGNING("codesigning"), ORGASSURER("orgassurer");
10 private final String dbName;
12 private Group(String name) {
16 public static Group getByString(String name) {
17 return valueOf(name.toUpperCase().replace('-', '_'));
20 public String getDatabaseName() {
24 public User[] getMembers(int offset, int count) {
25 GigiPreparedStatement gps = DatabaseConnection.getInstance().prepare("SELECT user FROM user_groups WHERE permission=? AND deleted is NULL LIMIT ?,?");
26 gps.setString(1, dbName);
27 gps.setInt(2, offset);
29 GigiResultSet grs = gps.executeQuery();
31 User[] users = new User[grs.getRow()];
35 users[i++] = User.getById(grs.getInt(1));