-
Notifications
You must be signed in to change notification settings - Fork 0
/
database.js
48 lines (35 loc) · 1.5 KB
/
database.js
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
let sqlite3 = require('sqlite3');
let database = new sqlite3.Database('./database.db');
/////////////////
// Create BEACHES table
////////////////////
const createTableBeachesQuery = "CREATE TABLE IF NOT EXISTS beaches (name TEXT, description TEXT)";
database.run(createTableBeachesQuery, (error) => {
if (error) console.log("Create Beaches table failed.", error);
else console.log("Success created Beaches Table");
});
/////////////////
// Create BOARDTYPES table
/////////////////
const createTableBoardTypesQuery = "CREATE TABLE IF NOT EXISTS boardTypes (name TEXT, description TEXT)";
database.run(createTableBoardTypesQuery, (error) => {
if (error) console.log("couldn't create BoardTypes table", error);
else console.log("created boardTypes table");
});
/////////////////
// Create boards table
//////////////////
const createTableBoardsQuery = "CREATE TABLE IF NOT EXISTS boards (name TEXT, description TEXT, boardType_id INTEGER)";
database.run(createTableBoardsQuery, (error) => {
if (error) console.log("couldn't create Boards table", error);
else console.log("created boards table");
});
////////////////
// Create beaches_boardTypes JOIN table
////////////////
const createBeaches_boardTypesStatement = "CREATE TABLE IF NOT EXISTS beaches_boardTypes (beaches_id INTEGER, boardTypes_id INTEGER)";
database.run(createBeaches_boardTypesStatement, (error) => {
if (error) console.log("Couldn't create JOIN table", error);
else console.log("made JOIN table");
});
module.exports = database;