From c0f8317bb1ab47cfa0f45636938df865771b3bc5 Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Mon, 10 Feb 2025 15:27:34 +0100
Subject: Add tests file

---
 tests/insert-users.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 tests/insert-users.sql

(limited to 'tests/insert-users.sql')

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);
+
-- 
cgit v1.2.3-71-g8e6c

