}
protected int insert() {
- if (id != 0) {
- throw new Error("refusing to insert");
- }
synchronized (User.class) {
+ if (id != 0) {
+ throw new Error("refusing to insert");
+ }
GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("INSERT INTO certOwners() VALUES()");
ps.execute();
id = ps.lastInsertId();
}
- public Certificate[] getCertificates() {
- GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT serial FROM certs WHERE memid=? AND revoked IS NULL");
+ public Certificate[] getCertificates(boolean includeRevoked) {
+ GigiPreparedStatement ps;
+ if (includeRevoked) {
+ ps = DatabaseConnection.getInstance().prepare("SELECT serial FROM certs WHERE memid=?");
+ } else {
+ ps = DatabaseConnection.getInstance().prepare("SELECT serial FROM certs WHERE memid=? AND revoked IS NULL");
+ }
ps.setInt(1, getId());
GigiResultSet rs = ps.executeQuery();
rs.last();