X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2FdbObjects%2FJob.java;h=ac0c9cf7fd5ba086b7f41314a8b64ee58ca7ce57;hp=ea8fc97d560215facf75b73c94e99fea143a31da;hb=628b0bb70786afe5de5ba28a8438261dc31e25a6;hpb=bccd4cc0dba0f89aa045b113bac46eb8cc1dab4e diff --git a/src/club/wpia/gigi/dbObjects/Job.java b/src/club/wpia/gigi/dbObjects/Job.java index ea8fc97d..ac0c9cf7 100644 --- a/src/club/wpia/gigi/dbObjects/Job.java +++ b/src/club/wpia/gigi/dbObjects/Job.java @@ -6,6 +6,7 @@ import club.wpia.gigi.GigiApiException; import club.wpia.gigi.database.DBEnum; import club.wpia.gigi.database.GigiPreparedStatement; import club.wpia.gigi.database.GigiResultSet; +import club.wpia.gigi.dbObjects.Certificate.RevocationType; import club.wpia.gigi.output.CertificateValiditySelector; public class Job implements IdCachable { @@ -31,7 +32,7 @@ public class Job implements IdCachable { } } - public synchronized static Job sign(Certificate targetId, Date start, String period) throws GigiApiException { + protected synchronized static Job sign(Certificate targetId, Date start, String period) throws GigiApiException { CertificateValiditySelector.checkValidityLength(period); try (GigiPreparedStatement ps = new GigiPreparedStatement("INSERT INTO `jobs` SET targetId=?, task=?::`jobType`, executeFrom=?, executeTo=?")) { ps.setInt(1, targetId.getId()); @@ -43,7 +44,12 @@ public class Job implements IdCachable { } } - public synchronized static Job revoke(Certificate targetId) { + protected synchronized static Job revoke(Certificate targetId, RevocationType type) { + try (GigiPreparedStatement ps = new GigiPreparedStatement("UPDATE `certs` SET `revocationType`=?::`revocationType` WHERE id=?")) { + ps.setEnum(1, type); + ps.setInt(2, targetId.getId()); + ps.execute(); + } try (GigiPreparedStatement ps = new GigiPreparedStatement("INSERT INTO `jobs` SET targetId=?, task=?::`jobType`")) { ps.setInt(1, targetId.getId());