Changeset 69 for trunk/CrossPare/src/de/ugoe/cs/cpdp/eval/MySQLResultStorage.java

Timestamp:

05/03/16 15:17:36 (8 years ago)

Author:

sherbold

Message:

• updated new result storage concept and cross-project experiments to first check if a result is available. If this is the case, the experiment is not executed.

File:

• trunk/CrossPare/src/de/ugoe/cs/cpdp/eval/MySQLResultStorage.java (modified) (4 diffs)

trunk/CrossPare/src/de/ugoe/cs/cpdp/eval/MySQLResultStorage.java

@@ -4 +4 @@
 import java.sql.Connection;
 import java.sql.DriverManager;
+import java.sql.ResultSet;
 import java.sql.SQLException;
 import java.sql.Statement;
@@ -34 +35 @@
 
     public void addResult(ExperimentResult result) {
-        Statement stmt;
-        try {
-            stmt = con.createStatement();
-        }
-        catch (SQLException e) {
-            Console.printerr("Problem with MySQL connection: ");
-            Console.printerr("SQLException: " + e.getMessage());
-            Console.printerr("SQLState: " + e.getSQLState());
-            Console.printerr("VendorError: " + e.getErrorCode());
-            return;
-        }
         StringBuilder sql = new StringBuilder();
         sql.append("INSERT INTO crosspare.results VALUES (NULL,");
@@ -72 +62 @@
         sql.append(result.getTn()+",");
         sql.append(result.getFp()+");");
+        
+        Statement stmt;
         try {
+            stmt = con.createStatement();
             stmt.executeUpdate(sql.toString().replace("NaN", "NULL"));
         }
@@ -84 +77 @@
     }
     
-    //public boolean containsResult(String configurationName, String productName, String classifier);
+    @Override
+    public boolean containsResult(String experimentName, String productName) {
+        String sql = "SELECT COUNT(*) as cnt FROM crosspare.results WHERE configurationName=\'" + experimentName + "\' AND productName=\'" + productName + "\';";
+        Statement stmt;
+        boolean contained = false;
+        try {
+            stmt = con.createStatement();
+            ResultSet results = stmt.executeQuery(sql);
+            results.next();
+            int count = results.getInt("cnt");
+            contained = count>0;
+        }
+        catch (SQLException e) {
+            Console.printerr("Problem with MySQL connection: \n");
+            Console.printerr("SQLException: " + e.getMessage() + "\n");
+            Console.printerr("SQLState: " + e.getSQLState() + "\n");
+            Console.printerr("VendorError: " + e.getErrorCode() + "\n");
+        }
+        return contained;
+    }
 }