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=?");
28 GigiResultSet rs = ps.executeQuery();
30 System.out.println("no " + id);
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();