From 225600aadffc6fdb188fef230cdab67e1242e3a3 Mon Sep 17 00:00:00 2001
From: gramanas <anastasis.gramm2@gmail.com>
Date: Sun, 22 Apr 2018 18:07:50 +0300
Subject: Add almost done, opt parsing remains

---
 src/dbhelper.c | 105 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 105 insertions(+)
 create mode 100644 src/dbhelper.c

(limited to 'src/dbhelper.c')

diff --git a/src/dbhelper.c b/src/dbhelper.c
new file mode 100644
index 0000000..2be76ed
--- /dev/null
+++ b/src/dbhelper.c
@@ -0,0 +1,105 @@
+#include "dbhelper.h"
+
+void dbh_form_query_make_tables(char *query) {
+  char tmp[STR_L] = "CREATE TABLE ";
+  strcat(tmp, TBL_PROGRAM);
+  strcat(tmp, "(");
+  strcat(tmp, COL_PROGRAM_ID);
+  strcat(tmp, " INT NOT NULL PRIMARY KEY, "); 
+  strcat(tmp, COL_PROGRAM_NAME);
+  strcat(tmp, " TEXT NOT NULL); ");
+
+  strcat(tmp, "CREATE TABLE ");
+  strcat(tmp, TBL_CONFIG);
+  strcat(tmp, "(");
+  strcat(tmp, COL_CONFIG_ID);
+  strcat(tmp, " INT NOT NULL PRIMARY KEY, "); 
+  strcat(tmp, COL_CONFIG_PATH);
+  strcat(tmp, " TEXT NOT NULL, ");
+  strcat(tmp, COL_CONFIG_SECRET);
+  strcat(tmp, " INT NOT NULL, ");
+  strcat(tmp, COL_CONFIG_PRIME);
+  strcat(tmp, " INT NOT NULL); ");
+
+  strcat(tmp, "CREATE TABLE ");
+  strcat(tmp, TBL_REL);
+  strcat(tmp, "(");
+  strcat(tmp, COL_REL_PROGRAM_ID);
+  strcat(tmp, " INT NOT NULL, "); 
+  strcat(tmp, COL_REL_CONFIG_ID);
+  strcat(tmp, " INT NOT NULL);");
+
+  strcpy(query, tmp);
+}
+
+void dbh_form_query_insert_program(char *query) {
+  char tmp[STR_L] = "INSERT INTO ";
+  strcat(tmp, TBL_PROGRAM);
+  strcat(tmp, " VALUES(?, ?);");
+
+  strcpy(query, tmp);
+}
+
+void dbh_form_query_insert_config(char *query) {
+  char tmp[STR_L] = "INSERT INTO ";
+  strcat(tmp, TBL_CONFIG);
+  strcat(tmp, " VALUES(?, ?, ?, ?);");
+
+  strcpy(query, tmp);
+}
+
+void dbh_form_query_select_id_from(char *query, const char* tableName) {
+  char tmp[STR_M] = "SELECT ID FROM ";
+  strcat(tmp, tableName);
+  strcat(tmp, " ORDER BY ID;");
+
+  strcpy(query, tmp);
+}
+
+void dbh_form_query_select_all_tables(char *query) {
+  strcpy(query, "SELECT * FROM SQLITE_MASTER WHERE type='table';");
+}
+
+void dhb_form_query_insert_relationship(char *query) {
+  char tmp[STR_M] = "INSERT INTO ";
+  strcat(tmp, TBL_REL);
+  strcat(tmp, " VALUES(?, ?);");
+
+  strcpy(query, tmp);
+}
+
+void dhb_form_query_find_program(char *query) {
+  char tmp[STR_M] = "SELECT ID FROM ";
+  strcat(tmp, TBL_PROGRAM);
+  strcat(tmp, " WHERE ");
+  strcat(tmp, COL_PROGRAM_NAME);
+  strcat(tmp, " = ?;");
+
+  strcpy(query, tmp);
+}
+
+void dhb_form_query_find_config(char *query) {
+  char tmp[STR_M] = "SELECT ID FROM ";
+  strcat(tmp, TBL_CONFIG);
+  strcat(tmp, " WHERE ");
+  strcat(tmp, COL_CONFIG_PATH);
+  strcat(tmp, " = ?;");
+
+  strcpy(query, tmp);
+}
+
+void dhb_form_query_find_relationship(char *query) {
+  char tmp[STR_M] = "SELECT ";
+  strcat(tmp, COL_REL_PROGRAM_ID);
+  strcat(tmp, ", ");
+  strcat(tmp, COL_REL_CONFIG_ID);
+  strcat(tmp, " FROM ");
+  strcat(tmp, TBL_REL);
+  strcat(tmp, " WHERE ");
+  strcat(tmp, COL_REL_PROGRAM_ID);
+  strcat(tmp, " = ? AND ");
+  strcat(tmp, COL_REL_CONFIG_ID);
+  strcat(tmp, " = ?;");
+
+  strcpy(query, tmp);
+}
-- 
cgit v1.2.3