diff options
| author | Santo Cariotti <santo@dcariotti.me> | 2025-02-10 15:27:34 +0100 |
|---|---|---|
| committer | Santo Cariotti <santo@dcariotti.me> | 2025-02-10 15:27:34 +0100 |
| commit | c0f8317bb1ab47cfa0f45636938df865771b3bc5 (patch) | |
| tree | f7ce20bcf25b89c8fed7b0e7dcbfc60f6d4e62b8 | |
| parent | c1b50cde0a8f390e21333241a3637497b04c4784 (diff) | |
Add tests filemain
| -rw-r--r-- | tests/insert-positions.sql | 19 | ||||
| -rw-r--r-- | tests/insert-users.sql | 20 |
2 files changed, 39 insertions, 0 deletions
diff --git a/tests/insert-positions.sql b/tests/insert-positions.sql new file mode 100644 index 0000000..c287f29 --- /dev/null +++ b/tests/insert-positions.sql @@ -0,0 +1,19 @@ +INSERT INTO positions (user_id, location, activity) +VALUES + (1, ST_GeogFromText('SRID=4326;POINT(11.3339 44.5010)'), 'Still'), + (2, ST_GeogFromText('SRID=4326;POINT(11.3565 44.4967)'), 'Still'), + (3, ST_GeogFromText('SRID=4326;POINT(11.3490 44.4958)'), 'InVehicle'), + (4, ST_GeogFromText('SRID=4326;POINT(11.3411 44.4952)'), 'Still'), + (5, ST_GeogFromText('SRID=4326;POINT(11.3439 44.4971)'), 'Walking'), + (6, ST_GeogFromText('SRID=4326;POINT(11.3403 44.4936)'), 'Running'), + (7, ST_GeogFromText('SRID=4326;POINT(11.3485 44.4969)'), 'InVehicle'), + (8, ST_GeogFromText('SRID=4326;POINT(11.3442 44.4932)'), 'Still'), + (9, ST_GeogFromText('SRID=4326;POINT(11.3465 44.4978)'), 'Walking'), + (10, ST_GeogFromText('SRID=4326;POINT(11.3453 44.4941)'), 'Running'), + (11, ST_GeogFromText('SRID=4326;POINT(11.3155 44.5313)'), 'InVehicle'), + (12, ST_GeogFromText('SRID=4326;POINT(11.5789 44.5246)'), 'Still'), + (13, ST_GeogFromText('SRID=4326;POINT(11.7339 44.2956)'), 'Walking'), + (14, ST_GeogFromText('SRID=4326;POINT(11.2258 44.6452)'), 'Running'), + (15, ST_GeogFromText('SRID=4326;POINT(11.0708 44.5426)'), 'InVehicle'); + (16, ST_GeogFromText('SRID=4326;POINT(11.3426 44.4949)'), 'Walking'), + (17, ST_GeogFromText('SRID=4326;POINT(11.3450 44.4965)'), 'Running'), diff --git a/tests/insert-users.sql b/tests/insert-users.sql new file mode 100644 index 0000000..3bb1174 --- /dev/null +++ b/tests/insert-users.sql @@ -0,0 +1,20 @@ +INSERT INTO users (email, password, name, address, notification_token, is_admin) +VALUES + ('santo@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Santo Cariotti', 'Mura Anteo Zamboni 7, Bologna, Italy', NULL, true), + ('luca@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Luca Polese', 'Mura Anteo Zamboni 7, Bologna, Italy', NULL, true), + ('user1@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Alice Rossi', 'Via Indipendenza 45, Bologna, Italy', NULL, false), + ('user2@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Marco Bianchi', 'Via Rizzoli 12, Bologna, Italy', NULL, false), + ('user3@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Giulia Verdi', 'Via Zamboni 33, Bologna, Italy', NULL, false), + ('user4@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Luca Neri', 'Via San Vitale 22, Bologna, Italy', NULL, false), + ('user5@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Francesca Gallo', 'Via Saragozza 55, Bologna, Italy', NULL, false), + ('user6@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Matteo Rizzi', 'Piazza Maggiore 1, Bologna, Italy', NULL, false), + ('user7@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Elena Costa', 'Via Delle Belle Arti 10, Bologna, Italy', NULL, false), + ('user8@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Davide Ferrari', 'Via Santo Stefano 98, Bologna, Italy', NULL, false), + ('user9@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Sara Moretti', 'Viale Carducci 77, Bologna, Italy', NULL, false), + ('user10@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Andrea Fontana', 'Via Irnerio 3, Bologna, Italy', NULL, false), + ('user11@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Valentina Conti', 'Via Marconi 44, Bologna, Italy', NULL, false), + ('user12@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Giorgio De Luca', 'Via Mazzini 65, Bologna, Italy', NULL, false), + ('user13@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Martina Ricci', 'Via San Felice 29, Bologna, Italy', NULL, false), + ('user14@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Riccardo Lombardi', 'Piazza Malpighi 9, Bologna, Italy', NULL, false), + ('user15@cs.unibo.it', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', 'Chiara Gentile', 'Via Farini 21, Bologna, Italy', NULL, false); + |