From 1cfbedd0b199d77ed53e5224435a76978875e2fb Mon Sep 17 00:00:00 2001
From: Anastasis Grammenos <anastasis.gramm2@gmail.com>
Date: Wed, 3 Oct 2018 13:25:21 +0300
Subject: Work on delete

---
 src/dbhelper.c | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'src/dbhelper.c')

diff --git a/src/dbhelper.c b/src/dbhelper.c
index b183770..8e4d9ad 100644
--- a/src/dbhelper.c
+++ b/src/dbhelper.c
@@ -193,3 +193,35 @@ void dbh_form_query_select_programs(char *query) {
 
   strcpy(query, tmp);
 }
+
+void dbh_form_query_delete_x_from_y(char *query, const char *x, const char *y) {
+  char tmp[STR_M] = "DELETE FROM ";
+  strcat(tmp, y);
+  strcat(tmp, " WHERE ");
+  strcat(tmp, x);
+  strcat(tmp, " = ?;");
+
+  strcpy(query, tmp);
+}
+
+void dbh_from_query_count_program_relations(char *query) {
+  char tmp[STR_M] = "SELECT COUNT(*) FROM ";
+  strcat(tmp, TBL_REL);
+  strcat(tmp, " WHERE ");
+  strcat(tmp, COL_REL_PROGRAM_ID);
+  strcat(tmp, " = ?;");
+
+  strcpy(query, tmp);
+}
+
+void dbh_form_query_get_pid_from_cid(char *query) {
+  char tmp[STR_M] = "SELECT ";
+  strcat(tmp, COL_REL_PROGRAM_ID);
+  strcat(tmp, " FROM ");
+  strcat(tmp, TBL_REL);
+  strcat(tmp, " WHERE ");
+  strcat(tmp, COL_REL_CONFIG_ID);
+  strcat(tmp, " = ?;");
+
+  strcpy(query, tmp);
+}
-- 
cgit v1.2.3