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;
7 public abstract class CertificateOwner implements IdCachable {
11 public CertificateOwner(int id) {
15 public CertificateOwner() {}
21 private static ObjectCache<CertificateOwner> myCache = new ObjectCache<>();
23 public static synchronized CertificateOwner getById(int id) {
24 CertificateOwner u = myCache.get(id);
26 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT *, users.id AS uid, organisations.id AS oid FROM certOwners LEFT JOIN users ON users.id=certOwners.id LEFT JOIN organisations ON organisations.id = certOwners.id WHERE certOwners.id=? AND deleted is null");
28 GigiResultSet rs = ps.executeQuery();
32 if (rs.getString("uid") != null) {
33 myCache.put(u = new User(rs));
34 } else if (rs.getString("oid") != null) {
35 myCache.put(u = new Organisation(rs));
37 System.err.print("Malformed cert owner: " + id);
43 protected int insert() {
45 throw new Error("refusing to insert");
47 synchronized (User.class) {
48 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("INSERT INTO certOwners() VALUES()");
50 id = ps.lastInsertId();
56 public EmailAddress[] getEmails() {
57 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT id FROM emails WHERE memid=? AND deleted is NULL");
58 ps.setInt(1, getId());
59 GigiResultSet rs = ps.executeQuery();
61 int count = rs.getRow();
62 EmailAddress[] data = new EmailAddress[count];
64 for (int i = 0; i < data.length; i++) {
66 throw new Error("Internal sql api violation.");
68 data[i] = EmailAddress.getById(rs.getInt(1));
75 public Domain[] getDomains() {
76 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT id FROM domains WHERE memid=? AND deleted IS NULL");
77 ps.setInt(1, getId());
78 GigiResultSet rs = ps.executeQuery();
80 int count = rs.getRow();
81 Domain[] data = new Domain[count];
83 for (int i = 0; i < data.length; i++) {
85 throw new Error("Internal sql api violation.");
87 data[i] = Domain.getById(rs.getInt(1));
94 public Certificate[] getCertificates() {
95 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT serial FROM certs WHERE memid=? AND revoked IS NULL");
96 ps.setInt(1, getId());
97 GigiResultSet rs = ps.executeQuery();
99 int count = rs.getRow();
100 Certificate[] data = new Certificate[count];
102 for (int i = 0; i < data.length; i++) {
104 throw new Error("Internal sql api violation.");
106 data[i] = Certificate.getBySerial(rs.getString(1));
113 public boolean isValidDomain(String domainname) {
114 for (Domain d : getDomains()) {
115 String sfx = d.getSuffix();
116 if (domainname.equals(sfx) || domainname.endsWith("." + sfx)) {
123 public boolean isValidEmail(String email) {
124 for (EmailAddress em : getEmails()) {
125 if (em.getAddress().equals(email)) {
132 public void delete() {
133 GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("UPDATE certOwners set deleted=NOW() WHERE id=?");
134 ps.setInt(1, getId());
136 myCache.remove(this);