-
Notifications
You must be signed in to change notification settings - Fork 0
/
generate_test_data.sh
executable file
·37 lines (30 loc) · 1.71 KB
/
generate_test_data.sh
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
#!/bin/bash
sqlite3 "var/app.db" "DELETE FROM event";
sqlite3 "var/app.db" "DELETE FROM comment";
sqlite3 "var/app.db" "VACUUM";
sqlite3 "var/app.db" <<EOF
INSERT INTO event (id, edit_key, title, description, organizer)
VALUES
('e1111', 'k1111', 'Movie Night - Inception', '
You are invited to watch the movie "Inception"!
### Program
1. Dinner
2. Movie
3. Dessert
### Place & time
30/09/19, 7pm, Steves home
### Support
You are welcome to bring something for dinner, desert or drinks. Please leave a comment, what you bring.', 'Jamie & Steve'),
('e2222', 'k2222', 'Rooftop Dance', 'You want to dance on the rooftop of Zurich? Our legendary Rooftop Dance takes place like last year. When the sun goes down, we will start dancing on Johns roof, watching the national firework.
### Where & when
01/08/19, 8pm, Main Street 8, Zurich.
Please leave a note, if you join us at 6pm to prepare the floor or bring drinks or snacks. We are waiting for you', 'John & team');
EOF
sqlite3 "var/app.db" <<EOF
INSERT INTO comment (event_id, author, message)
VALUES
('e1111', 'Patric', 'For sure I will part of this. I will bring Sandy with me and some popcorn.'),
('e1111', 'Miranda', 'I will come. I will bring Coke and Fanta.'),
('e2222', 'John', 'Cindy and myself will participate and help to prepare the floor.');
EOF