Code restructure/simplification, restore regression test

1 files changed, 206 insertions, 0 deletions

diff --git a/src/list.c b/src/list.c
new file mode 100644
index 0000000..105c101
--- /dev/null
+++ b/src/list.c
@@ -0,0 +1,206 @@
+#include <libgen.h>
+
+#include "actions.h"
+#include "dblayer.h"
+#include "queries.h"
+#include "ckerrlog.h"
+
+ListOpt list_make_options(cklist *args) {
+  list_rewind(args);
+  ListOpt listOpt = {
+    ._lt = LT_TREE,
+    ._lst = LST_PLAIN,
+    .pName = NULL,
+    .attr = 0,
+    .bName = 0,
+    .err = 0
+  };
+
+  if (list_size(args)) {
+    do {
+      if (strcmp(list_get(args), "-a") == 0) {
+        listOpt.attr = 1;
+        continue;
+      }
+      if (strcmp(list_get(args), "-b") == 0) {
+        listOpt.bName = 1;
+        continue;
+      }
+      if (strcmp(list_get(args), "-t") == 0) {
+	if (!list_next(args)) {
+	  listOpt.err = 1;
+	  break;
+	}
+	if (strcmp(list_get(args), "plain") == 0) {
+	  listOpt._lst = LST_PLAIN;
+	}
+	else if (strcmp(list_get(args), "lisp") == 0) {
+	  listOpt._lst = LST_LISP;
+	}
+	else if (strcmp(list_get(args), "python") == 0) {
+	  listOpt._lst = LST_PYTHON;
+	}
+	else {
+	  listOpt.err = 1;
+	}
+      }
+      else if (strcmp(list_get(args), "paths") == 0) {
+	listOpt._lt = LT_PATH;
+      }
+      else if (strcmp(list_get(args), "programs") == 0) {
+	listOpt._lt = LT_PROGRAM;
+      }
+      else if (strcmp(list_get(args), "tree") == 0) {
+        listOpt._lt = LT_TREE;
+      }
+      else if (strcmp(list_get(args), "ckconf") == 0) {
+        listOpt._lt = LT_CKCONF;
+      }
+      else if (strcmp(list_get(args), "-p") == 0) {
+        if (list_next(args)) {
+          listOpt._lt = LT_PROG_CONFS;
+          listOpt.pName = list_get(args);
+        }
+        else {
+          listOpt.err = 1;
+          break;
+        }
+      }
+      else {
+        listOpt.err = 1;
+      }
+    } while(list_next(args));
+  }
+  list_rewind(args);
+  return listOpt;
+}
+
+int list_get_paths(DB *db, cklist *ckl, int bName, int attr, const char *home) {
+  sqlite3_stmt *stmt;
+  int rc;
+
+  char sql[STR_M] = "";
+  dbh_form_query_select_paths_with_attributes(sql);
+
+  rc = sqlite3_prepare_v2(db->ptr, sql, -1, &stmt, 0);
+  if (rc != SQLITE_OK) {
+    return -2;
+  }
+
+  while (sqlite3_step(stmt) == SQLITE_ROW) {
+    char *tmp = strdup((char *)sqlite3_column_text(stmt, 0));
+    char path[STR_L] = "";
+    if (bName) {
+      strcat(path, basename(tmp));
+    }
+    else {
+      char tpath[STR_L] = "";
+      if (swap_tilde_with_home(tpath, tmp, home)) {
+          strcat(path, tpath);
+        }
+      else {
+        strcat(path, tmp);
+      }
+    }
+    free(tmp);
+    if (attr) {
+      decorate_entry(path, sqlite3_column_int(stmt, 1),
+                     sqlite3_column_int(stmt, 2),
+                     (char *)sqlite3_column_text(stmt, 0));
+    }
+    list_add(ckl, path);
+  }
+  sqlite3_finalize(stmt);
+
+  return 1;
+}
+
+int list_get_programs(DB *db, cklist *ckl) {
+  sqlite3_stmt *stmt;
+  int rc;
+
+  char sql[STR_M] = "";
+  dbh_form_query_select_programs(sql);
+
+  rc = sqlite3_prepare_v2(db->ptr, sql, -1, &stmt, 0);
+  if (rc != SQLITE_OK) {
+    return -2;
+  }
+
+  while (sqlite3_step(stmt) == SQLITE_ROW) {
+    list_add(ckl, (char *)sqlite3_column_text(stmt, 0));
+  }
+  sqlite3_finalize(stmt);
+
+  return 1;
+}
+
+int list_get_path_program_tree(DB *db, cklist *ckl, int bName, int attr, const char *home) {
+  sqlite3_stmt *stmt;
+  int rc;
+
+  char sql[STR_M] = "";
+  dbh_form_query_select_programs(sql);
+
+  rc = sqlite3_prepare_v2(db->ptr, sql, -1, &stmt, 0);
+  if (rc != SQLITE_OK) {
+    return -2;
+  }
+
+  while (sqlite3_step(stmt) == SQLITE_ROW) {
+    char programName[STR_M] = "";
+    strcat(programName, (char *)sqlite3_column_text(stmt, 0));
+    strcat(programName, ":");
+    list_add(ckl, programName);
+    sqlite3_stmt *stmt2;
+    int rc2;
+
+    char sql2[STR_L] = "";
+
+    char selection[STR_M] = COL_CONFIG_PATH;
+    strcat(selection, ",");
+    strcat(selection, COL_CONFIG_SECRET);
+    strcat(selection, ",");
+    strcat(selection, COL_CONFIG_PRIMARY);
+
+    char condition[STR_M] = TBL_PROGRAM;
+    strcat(condition, ".");
+    strcat(condition, COL_PROGRAM_NAME);
+
+    dbh_form_query_select_from_joined_eq(sql2, selection, condition);
+
+    rc2 = sqlite3_prepare_v2(db->ptr, sql2, -1, &stmt2, 0);
+    if (rc2 != SQLITE_OK) {
+      return -2;
+    }
+
+    sqlite3_bind_text(stmt2, 1, (char *)sqlite3_column_text(stmt, 0), -1, 0);
+    while (sqlite3_step(stmt2) == SQLITE_ROW) {
+      char treePath[STR_L] = "|- ";
+      char *tmp = strdup((char *)sqlite3_column_text(stmt2, 0));
+      if (bName) {
+        strcat(treePath, basename(tmp));
+      }
+      else {
+        char tpath[STR_L] = "";
+        if (swap_tilde_with_home(tpath, tmp, home)) {
+          strcat(treePath, tpath);
+        }
+        else {
+          strcat(treePath, tmp);
+        }
+      }
+      free(tmp);
+      if (attr) {
+        decorate_entry(treePath, sqlite3_column_int(stmt2, 1),
+                       sqlite3_column_int(stmt2, 2),
+                       (char *)sqlite3_column_text(stmt2, 0));
+      }
+      list_add(ckl, treePath);
+    }
+    sqlite3_finalize(stmt2);
+  }
+  sqlite3_finalize(stmt);
+
+  return 1;
+}