add: split API and add CATS import API

[gigi.git] / src / org / cacert / gigi / dbObjects / CertificateOwner.java

diff --git a/src/org/cacert/gigi/dbObjects/CertificateOwner.java b/src/org/cacert/gigi/dbObjects/CertificateOwner.java
index f9e9fbd57f0f721e9ac2c4cfc8a590968e727339..2adda5ee4fea22130a37503464ad44e69c9c71c2 100644 (file)
--- a/src/org/cacert/gigi/dbObjects/CertificateOwner.java
+++ b/src/org/cacert/gigi/dbObjects/CertificateOwner.java
@@ -117,4 +117,13 @@ public abstract class CertificateOwner implements IdCachable {
         return entries.toArray(new String[0]);
     }
 
+    public static CertificateOwner getByEnabledSerial(String serial) {
+        GigiPreparedStatement prep = DatabaseConnection.getInstance().prepare("SELECT `memid` FROM `certs` WHERE serial=? AND `disablelogin`='0' AND `revoked` is NULL");
+        prep.setString(1, serial.toLowerCase());
+        GigiResultSet res = prep.executeQuery();
+        if (res.next()) {
+            return getById(res.getInt(1));
+        }
+        return null;
+    }
 }