diff options
| author | Felix Kehrer <felix.kehrer@gmail.com> | 2018-05-06 16:01:10 +0200 |
|---|---|---|
| committer | Felix Kehrer <felix.kehrer@gmail.com> | 2018-05-07 14:42:08 +0200 |
| commit | 5a6c00ebc1583e0505fb795b3483f8937e7b8eb4 (patch) | |
| tree | 67bfb0c8023e1f8a37a282d0b5d4bb0e50bd9779 /src/main/resources/sql/H2RegistrationDAOTest_populate.sql | |
| parent | f4b5613fd3c6ce8e45fb7b99d10b33bec12ad43c (diff) | |
| download | sepm-groupproject-5a6c00ebc1583e0505fb795b3483f8937e7b8eb4.tar.gz sepm-groupproject-5a6c00ebc1583e0505fb795b3483f8937e7b8eb4.tar.xz sepm-groupproject-5a6c00ebc1583e0505fb795b3483f8937e7b8eb4.zip | |
Added groundwork for DAO tests
Diffstat (limited to 'src/main/resources/sql/H2RegistrationDAOTest_populate.sql')
| -rw-r--r-- | src/main/resources/sql/H2RegistrationDAOTest_populate.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/src/main/resources/sql/H2RegistrationDAOTest_populate.sql b/src/main/resources/sql/H2RegistrationDAOTest_populate.sql new file mode 100644 index 0000000..8322479 --- /dev/null +++ b/src/main/resources/sql/H2RegistrationDAOTest_populate.sql @@ -0,0 +1,10 @@ +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, constructionType, type) VALUES (1, 'RTW-1', 'Hochdach', 'RTW'); +INSERT INTO VehicleVersion (id, name, constructionType, type) VALUES (2, 'NEF-1', '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 |