Merge branch 'libs/jetty/upstream' into libs/jetty/local

[gigi.git] / tests / org / cacert / gigi / testUtils / ManagedTest.java

diff --git a/tests/org/cacert/gigi/testUtils/ManagedTest.java b/tests/org/cacert/gigi/testUtils/ManagedTest.java
index 2fac31820e3277e0d763ffa42908339c25b4012a..ce60a295832584c5c6b282af91bee8ae1de52838 100644 (file)
--- a/tests/org/cacert/gigi/testUtils/ManagedTest.java
+++ b/tests/org/cacert/gigi/testUtils/ManagedTest.java
@@ -22,8 +22,6 @@ import java.sql.SQLException;
 import java.util.Properties;
 
 import org.cacert.gigi.DevelLauncher;
-import org.cacert.gigi.IOUtils;
-import org.cacert.gigi.InitTruststore;
 import org.cacert.gigi.database.DatabaseConnection;
 import org.cacert.gigi.testUtils.TestEmailReciever.TestMail;
 import org.cacert.gigi.util.DatabaseManager;
@@ -224,7 +222,23 @@ public class ManagedTest {
        public int createAssuranceUser(String firstName, String lastName,
                        String email, String password) {
                int uid = createVerifiedUser(firstName, lastName, email, password);
-               // TODO make him pass CATS and be assured for 100 points
+               try {
+                       PreparedStatement ps = DatabaseConnection
+                                       .getInstance()
+                                       .prepare(
+                                                       "INSERT INTO `cats_passed` SET `user_id`=?, `variant_id`=?");
+                       ps.setInt(1, uid);
+                       ps.setInt(2, 0);
+                       ps.execute();
+                       ps = DatabaseConnection.getInstance().prepare(
+                                       "INSERT INTO `notary` SET `from`=?, `to`=?, points='100'");
+                       ps.setInt(1, uid);
+                       ps.setInt(2, uid);
+                       ps.execute();
+
+               } catch (SQLException e) {
+                       throw new Error(e);
+               }
                return uid;
        }
        static int count = 0;