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
|
/* dbhelper.h - Database layer for ck ----------------------------------*- C -*-
*
* This file is part of ck, the config keeper
*
* -----------------------------------------------------------------------------
*
* Copyright (C) 2018 Anastasis Grammenos
* GPLv3 (see LICENCE for the full notice)
*
* -----------------------------------------------------------------------------
*
* SQlite tables and columns.
* Form query functions.
*
* -------------------------------------------------------------------------- */
#ifndef DBHELPER_H
#define DBHELPER_H
#include <sqlite3.h>
#include "actionparser.h"
#include "ckutil.h"
/********************/
/* sqlite constants */
/********************/
#define TBL_PROGRAM "PROGRAM"
#define TBL_CONFIG "CONFIG"
#define TBL_REL "REL"
#define COL_PROGRAM_ID "ID"
#define COL_PROGRAM_NAME "NAME"
#define COL_CONFIG_ID "ID"
#define COL_CONFIG_PATH "PATH"
#define COL_CONFIG_SECRET "SECRET"
#define COL_CONFIG_PRIMARY "PRIME"
#define COL_REL_PROGRAM_ID "PID"
#define COL_REL_CONFIG_ID "CID"
#define __BEGIN_TRANSACTION__ sqlite3_exec(db->ptr, "BEGIN TRANSACTION;", NULL, NULL, NULL);
#define __END_TRANSACTION__ sqlite3_exec(db->ptr, "END TRANSACTION;", NULL, NULL, NULL);
/****************/
/* form queries */
/****************/
extern void dbh_form_query_make_tables(char *query);
extern void dbh_form_query_insert_program(char *query);
extern void dbh_form_query_insert_config(char *query);
extern void dbh_form_query_select_id_from(char *query, const char* tableName);
extern void dbh_form_query_select_all_tables(char *query);
extern void dhb_form_query_insert_relationship(char *query);
extern void dhb_form_query_find_program(char *query);
extern void dhb_form_query_find_config(char *query);
extern void dhb_form_query_find_relationship(char *query);
extern void dbh_form_query_select_paths_with_attributes(char *query);
extern void dbh_form_query_select_programs(char *query);
extern void dbh_form_query_select_from_joined_eq(char *query, const char *selection, const char* condition);
extern void dbh_form_query_select_from_joined_like(char *query, const char *selection, const char* condition);
extern void dbh_form_query_delete_x_from_y(char *query, const char *x, const char *y);
extern void dbh_form_query_count_program_relations(char *query);
extern void dbh_form_query_get_pid_from_cid(char *query);
#endif /* DBHELPER_H */
|
