This repository has been archived by the owner on Feb 13, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathproducts.sql
86 lines (76 loc) · 5.06 KB
/
products.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
-----------------------------------------------------------------------------
-- Usage :
-- "sqlite3 dev.sqlite3 < products.sql" pour agir sur la bd de dev
-- "sqlite3 prod.sqlite3 < products.sql" pour agir sur la bd de prod
-- Le script doit être lancé depuis la raspberry donc il faut ssh dessus
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
-- La table est delete au début, tout est insert en partant de 0
delete from products;
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
-- id, name, price, color, asso_price
-- /!\ les prix sont en int : 1.50€ -> 150 2.00€ -> 200 0.60€ -> 60
-----------------------------------------------------------------------------
--------------------- 2023 - 2024 L'Asso'ce du chef -----------------------------
insert into products values (1, "Boisson", null, "#f6e58d", 100);
insert into products values (2, "Cafés", null, "#778beb", 60);
insert into products values (3, "Capri-Sun", null, "#e17055", 70);
insert into products values (4, "Riz", null, "#c7ecee", 170);
insert into products values (5, "Nouilles", null, "#ea8685", 110);
insert into products values (6, "Monster", null, "#cf6a87", 150);
insert into products values (7, "Snack", null, "#820ecec", 80);
insert into products values (8, "Thé", null, "#a29bfe", 60);
insert into products values (9, "Inscription soirée/event", null, "#ffbe76", 100);
--------------------- 2022 - 2023 Assono -----------------------------
-- insert into products values (1, "Boisson", null, "#f6e58d", 60);
-- insert into products values (2, "Twix", null, "#55efc4", 40);
-- insert into products values (3, "Bueno", null, "#c7ecee", 70);
-- insert into products values (4, "Smarties", null, "#686de0", 60);
-- insert into products values (5, "PastaBox", null, "#fab1a0", 220);
-- insert into products values (6, "Riz", null, "#c7ecee", 170);
-- insert into products values (7, "Sandwich", null, "#c7ecee", 170);
-- insert into products values (8, "Cafés", null, "#778beb", 40);
-- insert into products values (9, "Lion", null, "#ffbe76", 40);
-- insert into products values (10, "Gauffre Sucre", null, "#ffbe76", 40);
-- insert into products values (11, "Gauffre Choco", null, "#e17055", 50);
-- insert into products values (12, "Bounty", null, "#81ecec", 50);
-- insert into products values (13, "Snickers", null, "#e17055", 50);
-- insert into products values (14, "Monster", null, "#cf6a87", 120);
-- insert into products values (15, "PomPote", null, "#55efc4", 40);
-- insert into products values (16, "Bready", null, "#c7ecee", 70);
-- insert into products values (17, "Nestle", null, "#f9ca24", 60);
-- insert into products values (18, "Crunch", null, "#a29bfe", 60);
-- insert into products values (19, "KitKat", null, "#a3cbae", 60);
-- insert into products values (20, "M&Ms", null, "#a29bfe", 60);
-- insert into products values (21, "Dragibus", null, "#820ecec", 50);
-- insert into products values (22, "Caprisun", null, "#ffeaa7", 30);
-- insert into products values (23, "PastaXtrem", null, "#f5cd79", 370);
-- insert into products values (24, "Nouilles", null, "#ea8685", 110);
-- insert into products values (25, "Chips", null, "#c7ecee", 70);
--------------------- 2021 - 2022 Assomniak -----------------------------
-- insert into products values (1, "Boisson", null, "#f6e58d", 60);
-- insert into products values (2, "Twix", null, "#55efc4", 40);
-- insert into products values (3, "Bueno", null, "#c7ecee", 70);
-- insert into products values (4, "Smarties", null, "#686de0", 60);
-- insert into products values (5, "PastaBox", null, "#fab1a0", 220);
-- insert into products values (6, "Riz", null, "#c7ecee", 170);
-- insert into products values (7, "Sandwich", null, "#c7ecee", 170);
-- insert into products values (8, "Cafés", null, "#778beb", 40);
-- insert into products values (9, "Lion", null, "#ffbe76", 40);
-- insert into products values (10, "Gauffre Sucre", null, "#ffbe76", 40);
-- insert into products values (11, "Gauffre Choco", null, "#e17055", 50);
-- insert into products values (12, "Bounty", null, "#81ecec", 50);
-- insert into products values (13, "Snickers", null, "#e17055", 50);
-- insert into products values (14, "Monster", null, "#cf6a87", 120);
-- insert into products values (15, "PomPote", null, "#55efc4", 40);
-- insert into products values (16, "Bready", null, "#c7ecee", 70);
-- insert into products values (17, "Nestle", null, "#f9ca24", 60);
-- insert into products values (18, "Crunch", null, "#a29bfe", 60);
-- insert into products values (19, "KitKat", null, "#a3cbae", 60);
-- insert into products values (20, "M&Ms", null, "#a29bfe", 60);
-- insert into products values (21, "Dragibus", null, "#820ecec", 50);
-- insert into products values (22, "Caprisun", null, "#ffeaa7", 30);
-- insert into products values (23, "PastaXtrem", null, "#f5cd79", 370);
-- insert into products values (24, "Nouilles", null, "#ea8685", 110);
-- insert into products values (25, "Chips", null, "#c7ecee", 70);