-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_debug.js
60 lines (52 loc) · 1.4 KB
/
db_debug.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
49
50
51
52
53
54
55
56
57
58
59
60
var sqlite3 = require('sqlite3').verbose();
var db = new sqlite3.Database('Data_Base.db');
db.serialize(function() {
/*
db.all(`
SELECT * FROM Comments;
`, (err, rows)=>{
console.log(rows);
})
db.all(`
SELECT * FROM Users;
`, (err, rows)=>{
console.log(rows);
})
db.all(
`
SELECT Posts.content, Posts.image_link, Posts.date, Users.pseudo
FROM Posts JOIN Users ON Posts.author_id = Users.id;
`, (err, rows)=>{
console.log(rows)
})
db.all(`
SELECT Users.pseudo, Comments.date, Comments.content
FROM Comments
JOIN Users ON Users.id = Comments.author_id
JOIN Posts ON Posts.id = Comments.post_id
WHERE Posts.id = ?;
`, 1, (sub_err, sub_rows)=>{
console.log(sub_rows);
})
*/
db.get(`
SELECT Comments.id, Users.pseudo, Comments.date, Comments.content
FROM Comments
JOIN Users ON Users.id = Comments.author_id
JOIN Posts ON Posts.id = Comments.post_id;
`, (err, raw)=>{
console.log(raw);
})
/*
db.all(`
SELECT Reacts.react, COUNT(*)
FROM Reacts
JOIN Posts ON Reacts.post_id = Posts.id
WHERE Reacts.post_id = 1
GROUP BY Reacts.react;
`, (err, raw)=>{
console.log(raw);
})
*/
});
db.close();