Mercurial > sci
annotate scid/db.c @ 64:562372396019
misc: improve manual pages and documentation
author | David Demelier <markand@malikania.fr> |
---|---|
date | Thu, 18 Aug 2022 20:17:18 +0200 |
parents | 576f4b1ec79f |
children | 5076be758687 |
rev | line source |
---|---|
19 | 1 /* |
2 * db.c -- scid database access | |
3 * | |
32
081e1c258e64
misc: update copyright years
David Demelier <markand@malikania.fr>
parents:
27
diff
changeset
|
4 * Copyright (c) 2021-2022 David Demelier <markand@malikania.fr> |
19 | 5 * |
6 * Permission to use, copy, modify, and/or distribute this software for any | |
7 * purpose with or without fee is hereby granted, provided that the above | |
8 * copyright notice and this permission notice appear in all copies. | |
9 * | |
10 * THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES | |
11 * WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF | |
12 * MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR | |
13 * ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES | |
14 * WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN | |
15 * ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF | |
16 * OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE. | |
17 */ | |
18 | |
19 #include <assert.h> | |
20 #include <stdlib.h> | |
21 #include <string.h> | |
22 | |
23 #include <sqlite3.h> | |
24 | |
25 #include <utlist.h> | |
26 | |
27 #include "db.h" | |
28 #include "log.h" | |
29 #include "util.h" | |
30 | |
31 #include "sql/init.h" | |
32 #include "sql/job-add.h" | |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
33 #include "sql/job-list.h" |
19 | 34 #include "sql/job-todo.h" |
35 #include "sql/jobresult-add.h" | |
44
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
36 #include "sql/jobresult-list-by-job-group.h" |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
37 #include "sql/jobresult-list-by-job.h" |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
38 #include "sql/jobresult-list-by-worker.h" |
19 | 39 #include "sql/project-find.h" |
40 #include "sql/project-list.h" | |
22
dd078aea5d02
misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents:
20
diff
changeset
|
41 #include "sql/project-save.h" |
44
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
42 #include "sql/property-get.h" |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
43 #include "sql/property-set.h" |
19 | 44 #include "sql/worker-find.h" |
45 #include "sql/worker-list.h" | |
22
dd078aea5d02
misc: use project/worker name as primary key
David Demelier <markand@malikania.fr>
parents:
20
diff
changeset
|
46 #include "sql/worker-save.h" |
19 | 47 |
48 #define CHAR(v) (const char *)(v) | |
49 | |
50 static sqlite3 *db; | |
51 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
52 static json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
53 project_packer(sqlite3_stmt *stmt) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
54 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
55 return json_pack("{ss ss ss ss sI}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
56 "name", sqlite3_column_text(stmt, 0), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
57 "desc", sqlite3_column_text(stmt, 1), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
58 "url", sqlite3_column_text(stmt, 2), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
59 "script", sqlite3_column_text(stmt, 3), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
60 "date", (json_int_t)sqlite3_column_int64(stmt, 4) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
61 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
62 } |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
63 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
64 static int |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
65 project_binder(json_t *doc, sqlite3_stmt *stmt) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
66 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
67 const char *name, *desc, *url, *script; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
68 int ret; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
69 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
70 ret = json_unpack(doc, "{ss ss ss ss}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
71 "name", &name, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
72 "desc", &desc, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
73 "url", &url, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
74 "script", &script |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
75 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
76 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
77 if (ret < 0) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
78 return -1; |
19 | 79 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
80 sqlite3_bind_text(stmt, 1, name, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
81 sqlite3_bind_text(stmt, 2, desc, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
82 sqlite3_bind_text(stmt, 3, url, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
83 sqlite3_bind_text(stmt, 4, script, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
84 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
85 return 0; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
86 } |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
87 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
88 static json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
89 worker_packer(sqlite3_stmt *stmt) |
19 | 90 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
91 return json_pack("{ss ss}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
92 "name", sqlite3_column_text(stmt, 0), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
93 "desc", sqlite3_column_text(stmt, 1) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
94 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
95 } |
19 | 96 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
97 static int |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
98 worker_binder(json_t *doc, sqlite3_stmt *stmt) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
99 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
100 const char *name, *desc; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
101 int ret; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
102 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
103 ret = json_unpack(doc, "{ss ss}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
104 "name", &name, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
105 "desc", &desc |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
106 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
107 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
108 if (ret < 0) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
109 return -1; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
110 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
111 sqlite3_bind_text(stmt, 1, name, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
112 sqlite3_bind_text(stmt, 2, desc, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
113 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
114 return 0; |
19 | 115 } |
116 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
117 static json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
118 job_packer(sqlite3_stmt *stmt) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
119 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
120 return json_pack("{sI ss ss sI}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
121 "id", (json_int_t)sqlite3_column_int64(stmt, 0), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
122 "tag", sqlite3_column_text(stmt, 1), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
123 "project_name", sqlite3_column_text(stmt, 2), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
124 "date", (json_int_t)sqlite3_column_int64(stmt, 3) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
125 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
126 } |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
127 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
128 static int |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
129 job_binder(json_t *doc, sqlite3_stmt *stmt) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
130 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
131 const char *tag, *project_name; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
132 int ret; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
133 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
134 ret = json_unpack(doc, "{ss ss}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
135 "tag", &tag, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
136 "project_name", &project_name |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
137 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
138 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
139 if (ret) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
140 return -1; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
141 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
142 sqlite3_bind_text(stmt, 1, tag, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
143 sqlite3_bind_text(stmt, 2, project_name, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
144 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
145 return 0; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
146 } |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
147 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
148 static json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
149 jobresult_packer(sqlite3_stmt *stmt) |
19 | 150 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
151 return json_pack("{sI sI ss ss si si sI}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
152 "id", (json_int_t)sqlite3_column_int64(stmt, 0), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
153 "job_id", (json_int_t)sqlite3_column_int64(stmt, 1), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
154 "worker_name", sqlite3_column_text(stmt, 2), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
155 "console", sqlite3_column_text(stmt, 3), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
156 "exitcode", sqlite3_column_int(stmt, 4), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
157 "sigcode", sqlite3_column_int(stmt, 5), |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
158 "date", (json_int_t)sqlite3_column_int64(stmt, 6) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
159 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
160 } |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
161 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
162 static int |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
163 jobresult_binder(json_t *doc, sqlite3_stmt *stmt) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
164 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
165 json_int_t job_id; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
166 int exitcode, sigcode, ret; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
167 const char *worker_name, *console; |
19 | 168 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
169 ret = json_unpack(doc, "{sI ss ss si si}", |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
170 "job_id", &job_id, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
171 "worker_name", &worker_name, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
172 "console", &console, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
173 "exitcode", &exitcode, |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
174 "sigcode", &sigcode |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
175 ); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
176 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
177 if (ret < 0) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
178 return -1; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
179 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
180 sqlite3_bind_int64(stmt, 1, job_id); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
181 sqlite3_bind_text(stmt, 2, worker_name, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
182 sqlite3_bind_text(stmt, 3, console, -1, SQLITE_STATIC); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
183 sqlite3_bind_int(stmt, 4, exitcode); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
184 sqlite3_bind_int(stmt, 5, sigcode); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
185 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
186 return 0; |
19 | 187 } |
188 | |
189 static void | |
44
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
190 bind_params_va(sqlite3_stmt *stmt, const char *fmt, va_list ap) |
19 | 191 { |
192 for (int index = 1; *fmt; ++fmt) { | |
193 switch (*fmt) { | |
194 case 'i': | |
195 sqlite3_bind_int(stmt, index++, va_arg(ap, int)); | |
196 break; | |
20 | 197 case 'j': |
198 sqlite3_bind_int64(stmt, index++, va_arg(ap, intmax_t)); | |
199 break; | |
19 | 200 case 's': |
201 sqlite3_bind_text(stmt, index++, va_arg(ap, const char *), -1, SQLITE_STATIC); | |
202 break; | |
203 case 'z': | |
204 sqlite3_bind_int64(stmt, index++, va_arg(ap, size_t)); | |
205 break; | |
206 default: | |
207 break; | |
208 } | |
209 } | |
210 } | |
211 | |
44
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
212 static void |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
213 bind_params(sqlite3_stmt *stmt, const char *fmt, ...) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
214 { |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
215 va_list ap; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
216 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
217 va_start(ap, fmt); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
218 bind_params_va(stmt, fmt, ap); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
219 va_end(ap); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
220 } |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
221 |
19 | 222 static int |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
223 insert(int (*binder)(json_t *, sqlite3_stmt *), json_t *obj, const char *sql) |
19 | 224 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
225 assert(binder); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
226 assert(obj); |
19 | 227 assert(sql); |
228 | |
229 sqlite3_stmt *stmt = NULL; | |
230 | |
231 if (sqlite3_prepare(db, sql, -1, &stmt, NULL) != SQLITE_OK) | |
232 return log_warn("db: %s", sqlite3_errmsg(db)), -1; | |
233 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
234 if (binder(obj, stmt)) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
235 log_warn("db: unable to bind parameter"); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
236 else { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
237 if (sqlite3_step(stmt) != SQLITE_DONE) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
238 log_warn("db: %s", sqlite3_errmsg(db)); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
239 else |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
240 json_object_set(obj, "id", json_integer(sqlite3_last_insert_rowid(db))); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
241 } |
19 | 242 |
243 sqlite3_finalize(stmt); | |
244 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
245 return 0; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
246 } |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
247 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
248 static json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
249 listva(json_t * (*unpacker)(sqlite3_stmt *), const char *sql, const char *args, va_list ap) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
250 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
251 sqlite3_stmt *stmt = NULL; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
252 json_t *array, *obj; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
253 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
254 if (sqlite3_prepare(db, sql, -1, &stmt, NULL) != SQLITE_OK) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
255 return log_warn("db: %s", sqlite3_errmsg(db)), NULL; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
256 |
44
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
257 bind_params_va(stmt, args, ap); |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
258 array = json_array(); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
259 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
260 while (sqlite3_step(stmt) == SQLITE_ROW) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
261 if ((obj = unpacker(stmt))) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
262 json_array_append(array, obj); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
263 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
264 sqlite3_finalize(stmt); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
265 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
266 return array; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
267 } |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
268 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
269 static json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
270 list(json_t * (*unpacker)(sqlite3_stmt *), const char *sql, const char *args, ...) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
271 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
272 va_list ap; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
273 json_t *ret; |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
274 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
275 va_start(ap, args); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
276 ret = listva(unpacker, sql, args, ap); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
277 va_end(ap); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
278 |
19 | 279 return ret; |
280 } | |
281 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
282 /* |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
283 * Same as list but the array should have only one element that we extract for |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
284 * convenience. |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
285 */ |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
286 static json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
287 get(json_t * (*unpacker)(sqlite3_stmt *), const char *sql, const char *args, ...) |
19 | 288 { |
289 va_list ap; | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
290 json_t *ret, *obj = NULL; |
19 | 291 |
292 va_start(ap, args); | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
293 ret = listva(unpacker, sql, args, ap); |
19 | 294 va_end(ap); |
295 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
296 if (json_array_size(ret) == 1) { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
297 obj = json_array_get(ret, 0); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
298 json_incref(obj); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
299 } |
19 | 300 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
301 if (ret) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
302 json_decref(ret); |
19 | 303 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
304 return obj; |
19 | 305 } |
306 | |
44
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
307 static int |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
308 get_property(const char *which, char *out, size_t outsz) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
309 { |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
310 sqlite3_stmt *stmt; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
311 const char *val; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
312 int ret; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
313 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
314 if (sqlite3_prepare(db, CHAR(sql_property_get), -1, &stmt, NULL) != SQLITE_OK) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
315 return log_warn("db: %s", sqlite3_errmsg(db)), -1; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
316 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
317 bind_params(stmt, "s", which); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
318 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
319 switch (sqlite3_step(stmt)) { |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
320 case SQLITE_ROW: |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
321 val = CHAR(sqlite3_column_text(stmt, 0)); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
322 util_strlcpy(out, val, outsz); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
323 ret = 1; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
324 break; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
325 case SQLITE_DONE: |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
326 /* No data. */ |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
327 ret = 0; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
328 break; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
329 default: |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
330 /* Error. */ |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
331 log_warn("db: %s", sqlite3_errmsg(db)); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
332 ret = -1; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
333 break; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
334 } |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
335 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
336 sqlite3_finalize(stmt); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
337 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
338 return ret; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
339 } |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
340 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
341 static int |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
342 set_property(const char *which, const char *val) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
343 { |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
344 sqlite3_stmt *stmt; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
345 int ret = -1; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
346 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
347 if (sqlite3_prepare(db, CHAR(sql_property_set), -1, &stmt, NULL) != SQLITE_OK) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
348 return log_warn("db: %s", sqlite3_errmsg(db)), -1; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
349 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
350 bind_params(stmt, "ss", which, val); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
351 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
352 if (sqlite3_step(stmt) != SQLITE_DONE) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
353 log_warn("db: %s", sqlite3_errmsg(db)); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
354 else |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
355 ret = 0; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
356 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
357 sqlite3_finalize(stmt); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
358 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
359 return ret; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
360 } |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
361 |
19 | 362 int |
363 db_open(const char *path) | |
364 { | |
365 assert(path); | |
366 | |
367 if (sqlite3_open(path, &db) != SQLITE_OK) | |
368 return log_warn("db: open error: %s", sqlite3_errmsg(db)), -1; | |
369 | |
370 /* Wait for 30 seconds to lock the database. */ | |
371 sqlite3_busy_timeout(db, 30000); | |
372 | |
373 if (sqlite3_exec(db, CHAR(sql_init), NULL, NULL, NULL) != SQLITE_OK) | |
374 return log_warn("db: initialization error: %s", sqlite3_errmsg(db)), -1; | |
375 | |
376 return 0; | |
377 } | |
378 | |
379 int | |
44
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
380 db_key_init(char *out, size_t outsz) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
381 { |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
382 assert(out); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
383 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
384 const char table[] = "abcdefghijklmnopqrstuvwxyz1234567890"; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
385 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
386 for (size_t i = 0; i < outsz - 1; ++i) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
387 out[i] = table[rand() % (sizeof (table) - 1)]; |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
388 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
389 return set_property("api-key", out); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
390 } |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
391 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
392 int |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
393 db_key_get(char *out, size_t outsz) |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
394 { |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
395 assert(out); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
396 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
397 return get_property("api-key", out, outsz); |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
398 } |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
399 |
576f4b1ec79f
scid: implement API authentication
David Demelier <markand@malikania.fr>
parents:
32
diff
changeset
|
400 int |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
401 db_job_add(json_t *job) |
19 | 402 { |
403 assert(job); | |
404 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
405 return insert(job_binder, job, CHAR(sql_job_add)); |
19 | 406 } |
407 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
408 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
409 db_job_todo(const char *worker) |
19 | 410 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
411 assert(worker); |
19 | 412 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
413 return list(job_packer, CHAR(sql_job_todo), "ss", worker, worker); |
19 | 414 } |
415 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
416 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
417 db_job_list(const char *project) |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
418 { |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
419 assert(project); |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
420 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
421 return list(job_packer, CHAR(sql_job_list), "s", project); |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
422 } |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
423 |
19 | 424 int |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
425 db_jobresult_add(json_t *res) |
19 | 426 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
427 assert(res); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
428 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
429 return insert(jobresult_binder, res, CHAR(sql_jobresult_add)); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
430 } |
19 | 431 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
432 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
433 db_jobresult_list_by_job(intmax_t job_id) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
434 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
435 return list(jobresult_packer, CHAR(sql_jobresult_list_by_job), "j", job_id); |
19 | 436 } |
437 | |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
438 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
439 db_jobresult_list_by_job_group(intmax_t job_id) |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
440 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
441 return list(jobresult_packer, CHAR(sql_jobresult_list_by_job_group), "j", job_id); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
442 } |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
443 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
444 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
445 db_jobresult_list_by_worker(const char *worker) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
446 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
447 assert(worker); |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
448 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
449 return list(jobresult_packer, CHAR(sql_jobresult_list_by_worker), "s", worker); |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
450 } |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
451 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
452 int |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
453 db_project_save(json_t *p) |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
454 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
455 assert(p); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
456 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
457 return insert(project_binder, p, CHAR(sql_project_save)); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
458 } |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
459 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
460 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
461 db_project_list(void) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
462 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
463 return list(project_packer, CHAR(sql_project_list), ""); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
464 } |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
465 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
466 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
467 db_project_find(const char *name) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
468 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
469 return get(project_packer, CHAR(sql_project_find), "s", name); |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
470 } |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
471 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
472 int |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
473 db_worker_save(json_t *wk) |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
474 { |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
475 assert(wk); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
476 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
477 return insert(worker_binder, wk, CHAR(sql_worker_save)); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
478 } |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
479 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
480 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
481 db_worker_list(void) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
482 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
483 return list(worker_packer, CHAR(sql_worker_list), ""); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
484 } |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
485 |
27
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
486 json_t * |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
487 db_worker_find(const char *name) |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
488 { |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
489 assert(name); |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
490 |
dae2de19ca5d
misc: switch to JSON everywhere
David Demelier <markand@malikania.fr>
parents:
26
diff
changeset
|
491 return get(worker_packer, CHAR(sql_worker_find), "s", name); |
26
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
492 } |
7e10cace67a3
scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
24
diff
changeset
|
493 |
19 | 494 void |
495 db_finish(void) | |
496 { | |
497 if (db) { | |
498 sqlite3_close(db); | |
499 db = NULL; | |
500 } | |
501 } |