X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=tests%2Forg%2Fcacert%2Fgigi%2Futil%2FTestNotary.java;h=1c2119f97182e2e33d18671ab40a4f3b93d20d31;hb=9136e3e03b6881b32aada896be3241e46cbd33d9;hp=36cd5c12424c7076cb76c0a96eccd2e687170d5e;hpb=1080b258a15e784ebad30be6f9e20df0de7c5938;p=gigi.git diff --git a/tests/org/cacert/gigi/util/TestNotary.java b/tests/org/cacert/gigi/util/TestNotary.java index 36cd5c12..1c2119f9 100644 --- a/tests/org/cacert/gigi/util/TestNotary.java +++ b/tests/org/cacert/gigi/util/TestNotary.java @@ -1,18 +1,18 @@ package org.cacert.gigi.util; -import java.sql.PreparedStatement; +import static org.junit.Assert.*; + import java.sql.SQLException; import java.util.Date; import org.cacert.gigi.GigiApiException; import org.cacert.gigi.database.DatabaseConnection; +import org.cacert.gigi.database.GigiPreparedStatement; import org.cacert.gigi.dbObjects.User; import org.cacert.gigi.output.DateSelector; import org.cacert.gigi.testUtils.ManagedTest; import org.junit.Test; -import static org.junit.Assert.*; - public class TestNotary extends ManagedTest { @Test @@ -64,7 +64,7 @@ public class TestNotary extends ManagedTest { users[i] = User.getById(id); } int id = createAssuranceUser("fn", "ln", createUniqueName() + "@email.org", TEST_PASSWORD); - PreparedStatement ps = DatabaseConnection.getInstance().prepare("UPDATE users SET dob=NOW() WHERE id=?"); + GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("UPDATE users SET dob=TIMESTAMPADD(YEAR,-15,NOW()) WHERE id=?"); ps.setInt(1, id); ps.execute(); User assurer = User.getById(id);