X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=tests%2Forg%2Fcacert%2Fgigi%2FtestUtils%2FManagedTest.java;h=2d164f580b11ea6beab2f0e7a01cf6c72d4d7600;hb=dc56db5699a7381aadbc5d167aa03ce037bc9b4f;hp=c9a44b8a158046c778ac6291f53faee948e078d9;hpb=7cf984749cf0027ccae90a53ebef07ab97ff164b;p=gigi.git diff --git a/tests/org/cacert/gigi/testUtils/ManagedTest.java b/tests/org/cacert/gigi/testUtils/ManagedTest.java index c9a44b8a..2d164f58 100644 --- a/tests/org/cacert/gigi/testUtils/ManagedTest.java +++ b/tests/org/cacert/gigi/testUtils/ManagedTest.java @@ -8,19 +8,26 @@ import java.io.DataOutputStream; import java.io.FileInputStream; import java.io.IOException; import java.io.InputStreamReader; +import java.io.OutputStream; import java.io.UnsupportedEncodingException; import java.net.HttpURLConnection; import java.net.InetSocketAddress; import java.net.URL; +import java.net.URLConnection; import java.net.URLEncoder; import java.nio.file.Files; import java.nio.file.Paths; +import java.sql.PreparedStatement; +import java.sql.ResultSet; +import java.sql.SQLException; import java.util.Properties; +import java.util.regex.Matcher; +import java.util.regex.Pattern; 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; import org.junit.After; import org.junit.AfterClass; import org.junit.BeforeClass; @@ -45,6 +52,16 @@ public class ManagedTest { public static void connectToServer() { try { testProps.load(new FileInputStream("config/test.properties")); + if (!DatabaseConnection.isInited()) { + DatabaseConnection.init(testProps); + } + System.out.println("... purging Database"); + DatabaseManager.run(new String[]{ + testProps.getProperty("sql.driver"), + testProps.getProperty("sql.url"), + testProps.getProperty("sql.user"), + testProps.getProperty("sql.password")}); + String type = testProps.getProperty("type"); if (type.equals("local")) { url = testProps.getProperty("server"); @@ -53,33 +70,40 @@ public class ManagedTest { Integer.parseInt(parts[1]))); return; } - url = "localhost:" + testProps.getProperty("serverPort"); + url = testProps.getProperty("name.www") + ":" + + testProps.getProperty("serverPort"); gigi = Runtime.getRuntime().exec(testProps.getProperty("java")); DataOutputStream toGigi = new DataOutputStream( gigi.getOutputStream()); System.out.println("... starting server"); Properties mainProps = new Properties(); - mainProps.load(new FileInputStream("config/gigi.properties")); mainProps.setProperty("host", "127.0.0.1"); + mainProps.setProperty("name.secure", "sec"); + mainProps + .setProperty("name.www", testProps.getProperty("name.www")); + mainProps.setProperty("name.static", "stat"); + mainProps.setProperty("port", testProps.getProperty("serverPort")); mainProps.setProperty("emailProvider", "org.cacert.gigi.email.TestEmailProvider"); mainProps.setProperty("emailProvider.port", "8473"); + mainProps.setProperty("sql.driver", + testProps.getProperty("sql.driver")); + mainProps.setProperty("sql.url", testProps.getProperty("sql.url")); + mainProps + .setProperty("sql.user", testProps.getProperty("sql.user")); + mainProps.setProperty("sql.password", + testProps.getProperty("sql.password")); byte[] cacerts = Files .readAllBytes(Paths.get("config/cacerts.jks")); byte[] keystore = Files.readAllBytes(Paths .get("config/keystore.pkcs12")); - DevelLauncher.writeGigiConfig(toGigi, new byte[]{}, + DevelLauncher.writeGigiConfig(toGigi, "changeit".getBytes(), "changeit".getBytes(), mainProps, cacerts, keystore); toGigi.flush(); - // TODO wait for ready - try { - Thread.sleep(3000); - } catch (InterruptedException e) { - e.printStackTrace(); - } + final BufferedReader br = new BufferedReader(new InputStreamReader( gigi.getErrorStream())); String line; @@ -108,18 +132,22 @@ public class ManagedTest { new InetSocketAddress("localhost", 8473)); } catch (IOException e) { throw new Error(e); + } catch (ClassNotFoundException e1) { + e1.printStackTrace(); + } catch (SQLException e1) { + e1.printStackTrace(); } } @AfterClass public static void tearDownServer() { String type = testProps.getProperty("type"); + ter.destroy(); if (type.equals("local")) { return; } gigi.destroy(); } - @After public void removeMails() { ter.reset(); @@ -143,8 +171,7 @@ public class ManagedTest { String d = IOUtils.readURL(uc); return d; } - public String fetchStartErrorMessage(String query) throws IOException { - String d = runRegister(query); + public String fetchStartErrorMessage(String d) throws IOException { String formFail = "
"; int idx = d.indexOf(formFail); assertNotEquals(-1, idx); @@ -162,7 +189,7 @@ public class ManagedTest { + "&pword1=" + URLEncoder.encode(password, "UTF-8") + "&pword2=" + URLEncoder.encode(password, "UTF-8") + "&day=1&month=1&year=1910&cca_agree=1"; - String data = fetchStartErrorMessage(query); + String data = fetchStartErrorMessage(runRegister(query)); assertTrue(data, data.startsWith("
")); } catch (UnsupportedEncodingException e) { throw new Error(e); @@ -170,7 +197,7 @@ public class ManagedTest { throw new Error(e); } } - public void createVerifiedUser(String firstName, String lastName, + public int createVerifiedUser(String firstName, String lastName, String email, String password) { registerUser(firstName, lastName, email, password); try { @@ -180,10 +207,83 @@ public class ManagedTest { URL u = new URL("https://" + getServerName() + "/verify?" + parts[1]); u.openStream().close();; + PreparedStatement ps = DatabaseConnection.getInstance().prepare( + "SELECT id FROM users where email=?"); + ps.setString(1, email); + ResultSet rs = ps.executeQuery(); + if (rs.next()) { + return rs.getInt(1); + } + throw new Error(); } catch (InterruptedException e) { throw new Error(e); } catch (IOException e) { throw new Error(e); + } catch (SQLException e) { + throw new Error(e); + } + } + /** + * Creates a new user with 100 Assurance points given by an (invalid) + * assurance. + * + * @param firstName + * the first name + * @param lastName + * the last name + * @param email + * the email + * @param password + * the password + * @return a new userid. + */ + public int createAssuranceUser(String firstName, String lastName, + String email, String password) { + int uid = createVerifiedUser(firstName, lastName, email, password); + 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; + public String createUniqueName() { + return "test" + System.currentTimeMillis() + "a" + (count++); + } + public String login(String email, String pw) throws IOException { + URL u = new URL("https://" + getServerName() + "/login"); + HttpURLConnection huc = (HttpURLConnection) u.openConnection(); + huc.setDoOutput(true); + OutputStream os = huc.getOutputStream(); + String data = "username=" + URLEncoder.encode(email, "UTF-8") + + "&password=" + URLEncoder.encode(pw, "UTF-8"); + os.write(data.getBytes()); + os.flush(); + String headerField = huc.getHeaderField("Set-Cookie"); + headerField = headerField.substring(0, headerField.indexOf(';')); + return headerField; + } + + public String getCSRF(URLConnection u) throws IOException { + String content = IOUtils.readURL(u); + Pattern p = Pattern.compile(""); + Matcher m = p.matcher(content); + if (!m.find()) { + throw new Error("New CSRF Token"); } + return m.group(1); } }