import org.cacert.gigi.dbObjects.CATS.CATSType;
import org.cacert.gigi.dbObjects.Domain;
import org.cacert.gigi.dbObjects.DomainPingType;
+import org.cacert.gigi.dbObjects.User;
import org.cacert.gigi.testUtils.TestEmailReceiver.TestMail;
import org.cacert.gigi.util.DatabaseManager;
import org.cacert.gigi.util.DomainAssessment;
}
public static void makeAssurer(int uid) {
- try (GigiPreparedStatement ps1 = new GigiPreparedStatement("INSERT INTO cats_passed SET user_id=?, variant_id=?, language='en_EN', version=1")) {
+ try (GigiPreparedStatement ps1 = new GigiPreparedStatement("INSERT INTO cats_passed SET user_id=?, variant_id=?, language='en_EN', version='1'")) {
ps1.setInt(1, uid);
ps1.setInt(2, CATSType.ASSURER_CHALLENGE.getId());
ps1.execute();
try (GigiPreparedStatement ps2 = new GigiPreparedStatement("INSERT INTO `notary` SET `from`=?, `to`=?, points='100'")) {
ps2.setInt(1, uid);
- ps2.setInt(2, uid);
+ ps2.setInt(2, User.getById(uid).getPreferredName().getId());
ps2.execute();
}
}
}
public static void purgeOnlyDB() throws SQLException, IOException {
- System.out.print("... resetting Database");
+ System.out.println("... resetting Database");
long ms = System.currentTimeMillis();
try {
DatabaseManager.run(new String[] {
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
- System.out.println(" in " + (System.currentTimeMillis() - ms) + " ms");
+ System.out.println("Database reset complete in " + (System.currentTimeMillis() - ms) + " ms.");
}
}