diff options
Diffstat (limited to 'src/dbhelper.h')
-rw-r--r-- | src/dbhelper.h | 65 |
1 files changed, 0 insertions, 65 deletions
diff --git a/src/dbhelper.h b/src/dbhelper.h deleted file mode 100644 index 31559cc..0000000 --- a/src/dbhelper.h +++ /dev/null @@ -1,65 +0,0 @@ -/* 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 "clparser.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 */ -/****************/ - -void dbh_form_query_make_tables(char *query); -void dbh_form_query_insert_program(char *query); -void dbh_form_query_insert_config(char *query); -void dbh_form_query_select_id_from(char *query, const char* tableName); -void dbh_form_query_select_all_tables(char *query); -void dhb_form_query_insert_relationship(char *query); -void dhb_form_query_find_program(char *query); -void dhb_form_query_find_config(char *query); -void dhb_form_query_find_relationship(char *query); -void dbh_form_query_select_paths_with_attributes(char *query); -void dbh_form_query_select_programs(char *query); -void dbh_form_query_select_from_joined_eq(char *query, const char *selection, const char* condition); -void dbh_form_query_select_from_joined_like(char *query, const char *selection, const char* condition); -void dbh_form_query_delete_x_from_y(char *query, const char *x, const char *y); -void dbh_form_query_count_program_relations(char *query); -void dbh_form_query_get_pid_from_cid(char *query); -#endif /* DBHELPER_H */ |