From 225600aadffc6fdb188fef230cdab67e1242e3a3 Mon Sep 17 00:00:00 2001 From: gramanas Date: Sun, 22 Apr 2018 18:07:50 +0300 Subject: Add almost done, opt parsing remains --- src/dbhelper.h | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 56 insertions(+) create mode 100644 src/dbhelper.h (limited to 'src/dbhelper.h') diff --git a/src/dbhelper.h b/src/dbhelper.h new file mode 100644 index 0000000..7385b16 --- /dev/null +++ b/src/dbhelper.h @@ -0,0 +1,56 @@ +/* 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) + * + * ----------------------------------------------------------------------------- + * + * Give access to the database. + * + * -------------------------------------------------------------------------- */ +#ifndef DBHELPER_H +#define DBHELPER_H + +#include + +#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_PRIME "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); + +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); + +#endif /* DBHELPER_H */ -- cgit v1.2.3