From: Felix Dörre <felix@dogcraft.de>
Date: Fri, 27 Jun 2014 16:04:17 +0000 (+0200)
Subject: Fill "create Assurer"
X-Git-Url: https://code.wpia.club/?p=gigi.git;a=commitdiff_plain;h=424cb41682b02fbeb6ad7ba6e49e6007c018e883

Fill "create Assurer"
---

diff --git a/tests/org/cacert/gigi/testUtils/ManagedTest.java b/tests/org/cacert/gigi/testUtils/ManagedTest.java
index 2fac3182..eaf6d8d2 100644
--- a/tests/org/cacert/gigi/testUtils/ManagedTest.java
+++ b/tests/org/cacert/gigi/testUtils/ManagedTest.java
@@ -224,7 +224,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) {
+			e.printStackTrace();
+		}
 		return uid;
 	}
 	static int count = 0;