X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2Fping%2FDomainPinger.java;h=c5eb3926bea8d8a2fed6b0b766b11171d9a13ae0;hp=c9b8a9bb976dc65e6e280b980080d33d8fe556df;hb=c9ed09f0007fc2c813815be927a5a24b23dab83c;hpb=446d3aa82c177eb844f6f19c8f85d4a6e631efe7 diff --git a/src/org/cacert/gigi/ping/DomainPinger.java b/src/org/cacert/gigi/ping/DomainPinger.java index c9b8a9bb..c5eb3926 100644 --- a/src/org/cacert/gigi/ping/DomainPinger.java +++ b/src/org/cacert/gigi/ping/DomainPinger.java @@ -1,13 +1,46 @@ package org.cacert.gigi.ping; -import org.cacert.gigi.Domain; -import org.cacert.gigi.User; +import org.cacert.gigi.database.DBEnum; +import org.cacert.gigi.database.GigiPreparedStatement; +import org.cacert.gigi.dbObjects.CertificateOwner; +import org.cacert.gigi.dbObjects.Domain; public abstract class DomainPinger { + public static enum PingState implements DBEnum { + OPEN, SUCCESS, FAILED; + + @Override + public String getDBName() { + return toString().toLowerCase(); + } + } + public static final String PING_STILL_PENDING = null; public static final String PING_SUCCEDED = ""; - public abstract String ping(Domain domain, String configuration, User user); + public abstract void ping(Domain domain, String configuration, CertificateOwner target, int confId); + + protected static void enterPingResult(int configId, String state, String result, String token) { + PingState estate = DomainPinger.PING_STILL_PENDING == state ? PingState.OPEN : DomainPinger.PING_SUCCEDED.equals(state) ? PingState.SUCCESS : PingState.FAILED; + try (GigiPreparedStatement enterPingResult = new GigiPreparedStatement("INSERT INTO `domainPinglog` SET `configId`=?, `state`=?::`pingState`, `result`=?, `challenge`=?")) { + enterPingResult.setInt(1, configId); + enterPingResult.setEnum(2, estate); + enterPingResult.setString(3, result); + enterPingResult.setString(4, token); + enterPingResult.execute(); + } + } + + protected static void updatePingResult(int configId, String state, String result, String token) { + try (GigiPreparedStatement updatePingResult = new GigiPreparedStatement("UPDATE `domainPinglog` SET `state`=?::`pingState`, `result`=? WHERE `configId`=? AND `challenge`=?")) { + updatePingResult.setString(1, DomainPinger.PING_STILL_PENDING == state ? "open" : DomainPinger.PING_SUCCEDED.equals(state) ? "success" : "failed"); + updatePingResult.setString(2, result); + updatePingResult.setInt(3, configId); + updatePingResult.setString(4, token); + updatePingResult.execute(); + } + } + }