From 80e1aaf4a0eba29a7dd304aa52c1116d76c417fc Mon Sep 17 00:00:00 2001
From: Dominic Rogetzer <e1627756@student.tuwien.ac.at>
Date: Mon, 11 Jun 2018 15:02:26 +0200
Subject: Refactor insert/delete scripts to DB-Unit xml file [#27302]

---
 .../resources/sql/H2RegistrationDAOTest_depopulate.sql    |  5 -----
 src/main/resources/sql/H2RegistrationDAOTest_populate.sql | 15 ---------------
 2 files changed, 20 deletions(-)
 delete mode 100644 src/main/resources/sql/H2RegistrationDAOTest_depopulate.sql
 delete mode 100644 src/main/resources/sql/H2RegistrationDAOTest_populate.sql

(limited to 'src/main/resources/sql')

diff --git a/src/main/resources/sql/H2RegistrationDAOTest_depopulate.sql b/src/main/resources/sql/H2RegistrationDAOTest_depopulate.sql
deleted file mode 100644
index f43b641..0000000
--- a/src/main/resources/sql/H2RegistrationDAOTest_depopulate.sql
+++ /dev/null
@@ -1,5 +0,0 @@
-DELETE FROM Registration;
-DELETE FROM Vehicle;
-DELETE FROM VehicleVersion;
-DELETE FROM Employee;
-DELETE FROM EmployeeVersion;
\ No newline at end of file
diff --git a/src/main/resources/sql/H2RegistrationDAOTest_populate.sql b/src/main/resources/sql/H2RegistrationDAOTest_populate.sql
deleted file mode 100644
index 7e7b428..0000000
--- a/src/main/resources/sql/H2RegistrationDAOTest_populate.sql
+++ /dev/null
@@ -1,15 +0,0 @@
-DELETE FROM Registration;
-DELETE FROM Vehicle;
-DELETE FROM VehicleVersion;
-DELETE FROM Employee;
-DELETE FROM EmployeeVersion;
-INSERT INTO EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) VALUES (1, 'John Doe', '2000-01-01', 'RS', TRUE, TRUE);
-INSERT INTO EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) VALUES (2, 'Nick "Kage" Verily', '1990-01-01', 'NKV', TRUE, FALSE);
-INSERT INTO EmployeeVersion (id, name, birthday, educationLevel, isDriver, isPilot) VALUES (3, 'Nicht Arzt', '1980-01-01', 'NA', FALSE, FALSE);
-INSERT INTO Employee (id, version) VALUES (1, 1);
-INSERT INTO Employee (id, version) VALUES (2, 2);
-INSERT INTO Employee (id, version) VALUES (3, 3);
-INSERT INTO VehicleVersion (id, name, hasNef, constructionType, type) VALUES (1, 'RTW-1', TRUE, 'HOCHDACH', 'RTW');
-INSERT INTO VehicleVersion (id, name, hasNef, constructionType, type) VALUES (2, 'NEF-1', FALSE, 'NORMAL', 'NEF');
-INSERT INTO Vehicle (id, version, status) VALUES (1, 1, 'ABGEMELDET');
-INSERT INTO Vehicle (id, version, status) VALUES (2, 2, 'ABGEMELDET');
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2