comparison lib/db.h @ 19:de4bf839b565

misc: revamp SQL
author David Demelier <markand@malikania.fr>
date Fri, 15 Jul 2022 11:11:48 +0200
parents scid/db.h@600204c31bf0
children f98ea578b1ef
comparison
equal deleted inserted replaced
18:600204c31bf0 19:de4bf839b565
1 /*
2 * db.h -- scid database access
3 *
4 * Copyright (c) 2021 David Demelier <markand@malikania.fr>
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 #ifndef SCI_DB_H
20 #define SCI_DB_H
21
22 #include <sys/types.h>
23 #include <stddef.h>
24
25 struct project;
26 struct worker;
27 struct job;
28 struct jobresult;
29
30 struct db_ctx {
31 void *handle;
32 };
33
34 int
35 db_open(const char *);
36
37 int
38 db_job_add(struct job *);
39
40 ssize_t
41 db_job_todo(struct db_ctx *, struct job *, size_t, int);
42
43 int
44 db_jobresult_add(struct jobresult *);
45
46 int
47 db_project_add(struct project *);
48
49 int
50 db_project_update(const struct project *);
51
52 ssize_t
53 db_project_list(struct db_ctx *, struct project *, size_t);
54
55 int
56 db_project_find(struct db_ctx *, struct project *);
57
58 int
59 db_project_find_id(struct db_ctx *, struct project *);
60
61 int
62 db_worker_add(struct worker *);
63
64 ssize_t
65 db_worker_list(struct db_ctx *, struct worker *, size_t);
66
67 int
68 db_worker_find(struct db_ctx *, struct worker *);
69
70 int
71 db_worker_find_id(struct db_ctx *, struct worker *);
72
73 void
74 db_finish(void);
75
76 void
77 db_ctx_finish(struct db_ctx *);
78
79 #endif /* !SCI_DB_H */