wiretapper/make_db.sh at master · a-v-e-s/wiretapper · GitHub

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
#!/bin/bash

COMMAND1="CREATE TABLE Songs( \
filepath text primary key, \
title text, \
artist text, \
album text, \
length real, \
synth int default 0, \
hard_rock int default 0, \
metal int default 0, \
gothish int default 0, \
indie int default 0, \
pop int default 0, \
cerebral int default 0, \
dance int default 0, \
disco int default 0, \
folk int default 0, \
house int default 0, \
trance int default 0, \
industrial int default 0, \
new_age int default 0, \
ambient int default 0, \
classical int default 0, \
contemporary int default 0, \
emo int default 0, \
classic_rock int default 0, \
alt_rock int default 0, \
romantic int default 0, \
funny int default 0, \
melancholy int default 0, \
angry int default 0, \
happy int default 0, \
hypnotic int default 0, \
reggae int default 0, \
hip_hop int default 0, \
hardcore_rap int default 0, \
rb int default 0, \
psychedelic int default 0, \
country int default 0, \
classic_rb int default 0, \
instrumental int default 0, \
foreign_language int default 0, \
triphop int default 0, \
light_rock int default 0, \
confirmed int default 0 \
);"

COMMAND2="CREATE TABLE Pickle(title text, artist text, playlist text, downloaded int default 0, converted int default 0);"

if [[ ! -f music_db.sqlite ]]; then
    sqlite3 music_db.sqlite "$COMMAND1" || exit $?
    sqlite3 music_db.sqlite "$COMMAND2" || exit $?
else
    echo -e "music_db.sqlite exists!\nRemove and re-create?\t[y/n]"
    read reply
    if [[ "$reply" = y ]]; then
        rm music_db.sqlite
        sqlite3 music_db.sqlite "$COMMAND1" || exit $?
        sqlite3 music_db.sqlite "$COMMAND2" || exit $?
    fi
fi