Add PopulateDB for testing

1 files changed, 20 insertions, 0 deletions

diff --git a/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/application/PopulateDB.java b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/application/PopulateDB.java
new file mode 100644
index 0000000..b115e56
--- /dev/null
+++ b/src/main/java/at/ac/tuwien/sepm/assignment/groupphase/application/PopulateDB.java
@@ -0,0 +1,20 @@
+package at.ac.tuwien.sepm.assignment.groupphase.application;
+
+import at.ac.tuwien.sepm.assignment.groupphase.util.JDBCConnectionManager;
+import java.io.InputStreamReader;
+import java.sql.SQLException;
+import org.h2.tools.RunScript;
+import org.springframework.core.io.ClassPathResource;
+
+public class PopulateDB {
+    public static void main(String[] args) throws SQLException {
+        JDBCConnectionManager jdbcConnectionManager = new JDBCConnectionManager();
+
+        RunScript.execute(
+                jdbcConnectionManager.getConnection(),
+                new InputStreamReader(
+                        ClassPathResource.class.getResourceAsStream("/sql/Testdaten.sql")));
+
+        jdbcConnectionManager.closeConnection();
+    }
+}