diff options
| author | Felix Kehrer <felix.kehrer@gmail.com> | 2018-05-07 18:06:00 +0200 |
|---|---|---|
| committer | Felix Kehrer <felix.kehrer@gmail.com> | 2018-05-07 18:06:00 +0200 |
| commit | 834f9b4fff11c778dbb09dc74a88d658fc094a54 (patch) | |
| tree | 7268754eeb7053c52ce2490984c75592d1d96046 /src/main/resources/sql | |
| parent | dab91fac74c2c51ad823dc53b68acf5aea5b3111 (diff) | |
| download | sepm-groupproject-834f9b4fff11c778dbb09dc74a88d658fc094a54.tar.gz sepm-groupproject-834f9b4fff11c778dbb09dc74a88d658fc094a54.tar.xz sepm-groupproject-834f9b4fff11c778dbb09dc74a88d658fc094a54.zip | |
Changed test behaviour to leave "clean" database for other tests
Diffstat (limited to 'src/main/resources/sql')
| -rw-r--r-- | src/main/resources/sql/H2RegistrationDAOTest_populate.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/main/resources/sql/H2RegistrationDAOTest_populate.sql b/src/main/resources/sql/H2RegistrationDAOTest_populate.sql index 3c268a0..7e7b428 100644 --- a/src/main/resources/sql/H2RegistrationDAOTest_populate.sql +++ b/src/main/resources/sql/H2RegistrationDAOTest_populate.sql @@ -1,3 +1,8 @@ +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); |