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 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;
return url;
}
static Properties testProps = new Properties();
+ static {
+ InitTruststore.run();
+ HttpURLConnection.setFollowRedirects(false);
+ }
+
@BeforeClass
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");
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("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"));
new InetSocketAddress("localhost", 8473));
} catch (IOException e) {
throw new Error(e);
+ } catch (ClassNotFoundException e1) {
+ e1.printStackTrace();
+ } catch (SQLException e1) {
+ e1.printStackTrace();
}
}
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 {
TestMail tm = ter.recieve();
String verifyLink = tm.extractLink();
String[] parts = verifyLink.split("\\?");
- URL u = new URL("https://" + getServerName() + "/verify" + parts[1]);
+ 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);
}
}
+ 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
+ return uid;
+ }
+ static int count = 0;
+ public String createUniqueName() {
+ return "test" + System.currentTimeMillis() + "a" + (count++);
+ }
}