DEBUG - Finished creating instance of bean 'dataSourceConfig'
INFO - Starting embedded database: url='jdbc:hsqldb:mem:testdb', username='sa'
DEBUG - Fetching JDBC Connection from DataSource
DEBUG - Creating new JDBC Driver Connection to [jdbc:hsqldb:mem:testdb]
INFO - Executing SQL script from class path resource [sql/schema.sql]
DEBUG - 0 returned as update count for SQL: CREATE TABLE "flight" ( "id" integer PRIMARY KEY, "from" varchar(20), "to" varchar(20), "departure" timestamp, "arrival" timestamp, "airplane_id" integer )
DEBUG - 0 returned as update count for SQL: CREATE TABLE "passenger" ( "id" integer PRIMARY KEY, "name" varchar(20), "gender" varchar(20) )
DEBUG - 0 returned as update count for SQL: CREATE TABLE "passenger_contact_info" ( "id" integer NOT NULL, "email" varchar(20), "phone" varchar(20) )
DEBUG - 0 returned as update count for SQL: CREATE TABLE "airplane" ( "id" integer PRIMARY KEY, "model_number" varchar(20), "capacity" integer )
DEBUG - 0 returned as update count for SQL: CREATE TABLE "booking" ( "id" integer PRIMARY KEY, "flight_id" integer, "passenger_id" integer )
DEBUG - 0 returned as update count for SQL: ALTER TABLE "flight" ADD CONSTRAINT "flies" FOREIGN KEY ("airplane_id") REFERENCES "airplane"("id") MATCH SIMPLE ON DELETE NO ACTION ON UPDATE NO ACTION
DEBUG - 0 returned as update count for SQL: ALTER TABLE "passenger_contact_info" ADD CONSTRAINT "has_contact_info" FOREIGN KEY ("id") REFERENCES "passenger"("id") MATCH SIMPLE ON DELETE NO ACTION ON UPDATE NO ACTION
DEBUG - 0 returned as update count for SQL: ALTER TABLE "booking" ADD CONSTRAINT "has_booking" FOREIGN KEY ("flight_id") REFERENCES "flight"("id") MATCH SIMPLE ON DELETE NO ACTION ON UPDATE NO ACTION
DEBUG - 0 returned as update count for SQL: ALTER TABLE "booking" ADD CONSTRAINT "books" FOREIGN KEY ("passenger_id") REFERENCES "passenger"("id") MATCH SIMPLE ON DELETE NO ACTION ON UPDATE NO ACTION
INFO - Executed SQL script from class path resource [sql/schema.sql] in 12 ms.
INFO - Executing SQL script from class path resource [sql/test-data.sql]
DEBUG - 2 returned as update count for SQL: INSERT INTO "airplane" ("id", "model_number", "capacity") VALUES (1, 'Boeing737', 150), (2, 'Boeing777', 200)
DEBUG - 3 returned as update count for SQL: INSERT INTO "flight" ("id", "from", "to", "departure", "arrival", "airplane_id") VALUES (1, 'A', 'B', '2017-10-10 10:00:00', '2017-10-10 13:00:00', 1), (2, 'B', 'A', '2017-10-12 10:00:00', '2017-10-12 13:00:00', 1), (3, 'C', 'D', '2017-10-14 10:00:00', '2017-10-14 13:00:00', 2)
DEBUG - 4 returned as update count for SQL: INSERT INTO "passenger" ("id", "name", "gender") VALUES (1, 'John', 'MALE'), (2, 'Jack', 'MALE'), (3, 'Emily', 'FEMALE'), (4, 'Susan', 'FEMALE')
DEBUG - 2 returned as update count for SQL: INSERT INTO "passenger_contact_info" ("id", "email", "phone") VALUES (2, 'Jacks email', 'Jacks phone'), (3, 'Emilys email', 'Emilys phone')
DEBUG - 7 returned as update count for SQL: INSERT INTO "booking" ("id", "flight_id", "passenger_id") VALUES (1, 1, 1), (2, 1, 3), (3, 2, 1), (4, 2, 3), (5, 2, 4), (6, 3, 2), (7, 3, 4)
INFO - Executed SQL script from class path resource [sql/test-data.sql] in 8 ms.
DEBUG - Returning JDBC Connection to DataSource
DEBUG - Eagerly caching bean 'dataSource' to allow for resolving potential circular references