NEED to configurate path to DATABASE 'db.mv.db' in application.properties. Like this -> spring.datasource.url=jdbc:h2:C:/[...your path to database...]/db
--REQUESTS by which you can test Api.
http://localhost:8080/byhour?num_of_hours=2
http://localhost:8080/load_forcast_to_db
http://localhost:8080/time?time_from=2022-06-29+14:00:00&time_to=2022-06-30+01:00:00
--TO CREATE AND POPULATE DATABASE--
drop table if exists DATA_HOUR_TABLE;
CREATE TABLE IF NOT EXISTS DATA_HOUR_TABLE ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, time VARCHAR(255), precipitation NUMERIC(4, 1), snowfraction NUMERIC(4, 1), rainspot VARCHAR(255), temperature NUMERIC(5, 2), felttemperature NUMERIC(4, 2), pictocode INT, windspeed NUMERIC(6, 2), winddirection INT, relativehumidity INT, sealevelpressure NUMERIC(6, 2), precipitation_probability INT, convective_precipitation NUMERIC(2, 1), isdaylight INT, uvindex INT ); INSERT INTO DATA_HOUR_TABLE VALUES (1,'2022-06-29 15:00:00',0.0,0.0,0000000000000000000000000000000000000000000000000,-5.00,00.00,9,100.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (2,'2022-06-29 16:00:00',1.0,0.0,0000000000000000000000000000000000000000000000000,00.00,00.00,9,1.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (3,'2022-06-29 17:00:00',5.0,0.0,0000000000000000000000000000000000000000000000000,00.00,00.00,9,00.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (4,'2022-06-29 18:00:00',50.0,0.0,0000000000000000000000000000000000000000000000000,00.00,00.00,9,3.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (5,'2022-06-29 19:00:00',301.0,0.0,0000000000000000000000000000000000000000000000000,00.00,00.00,9,70.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (6,'2022-06-29 20:00:00',0.0,0.0,0000000000000000000000000000000000000000000000000,00.00,00.00,9,50.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (7,'2022-06-29 21:00:00',0.0,1.0,0000000000000000000000000000000000000000000000000,10.00,00.00,9,10.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (8,'2022-06-29 22:00:00',0.0,10.0,0000000000000000000000000000000000000000000000000,00.00,00.00,9,10.00,303,38,1016.77,1,0.0,1,7); INSERT INTO DATA_HOUR_TABLE VALUES (9,'2022-06-29 20:00:00',0.0,0.0,0000000000000000000000000000000000000000000000000,00.00,00.00,9,20.00,303,38,1016.77,1,0.0,1,7);
SELECT * FROM DATA_HOUR_TABLE;