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
|
module Query = struct
let poasts =
[%rapper
get_many
{sql|
SELECT @int{id}, @string{title}, @string{content}, @string{date}
FROM Posts
ORDER BY id DESC LIMIT 100
|sql}]
;;
let poast =
[%rapper
get_opt
{sql|
SELECT @int{id}, @string{title}, @string{content}, @string{date}, @string{tags}, @string{url}
FROM Posts
WHERE id = %int{post_id}
|sql}]
;;
let comment =
[%rapper
get_opt
{sql|
SELECT @int{id}, @string{content}, @string{date}, @string{tags}, @string{url}
FROM Comments
WHERE id = %int{id}
|sql}]
;;
let user_comments =
[%rapper
get_opt
{sql|
SELECT @int{id}, @string{content}, @string{date}, @string{tags}, @string{url}
FROM Comments
WHERE author = %string{username}
|sql}]
;;
let post_comments =
[%rapper
get_opt
{sql|
SELECT @int{id}, @string{content}, @string{date}, @string{tags}, @string{url}
FROM Comments
WHERE post_id = %int{post_id}
|sql}]
;;
let comment_children =
[%rapper
get_opt
{sql|
SELECT @int{id}, @string{content}, @string{date}, @string{tags}, @string{url}
FROM Comments
WHERE parent= %int{post_id}
|sql}]
;;
end
let get_poasts conn = Query.poast conn
let get_poast post_id conn = Query.poast ~post_id conn
(* db.exec("PRAGMA journal_mode = WAL"); *)
(* db.exec("PRAGMA foreign_keys = ON"); *)
(* db.exec("PRAGMA cache_size = -8000"); // 8MB cache *)
(* db.exec("PRAGMA temp_store = MEMORY"); *)
(* db.exec("PRAGMA synchronous = NORMAL"); *)
(* db.exec("PRAGMA mmap_size = 30000000000"); // 30GB memory map *)
|
