steps towards list

1 files changed, 23 insertions, 3 deletions

diff --git a/src/dblayer.c b/src/dblayer.c
index 8014d08..4a356be 100644
--- a/src/dblayer.c
+++ b/src/dblayer.c
@@ -16,13 +16,13 @@
 #include "dbhelper.h"
 #include "ckutil.h"
 
-const char * const DB_NAME = "/ckdb";
+const char * const DB_FILE_NAME = "/ckdb";
 
 /* figure out the database name */
 void make_db_name(char *ret, const char *confPath) {
   char db_path[STR_L];
   strcpy(db_path, confPath);
-  strcat(db_path, DB_NAME);
+  strcat(db_path, DB_FILE_NAME);
 
   strcpy(ret, db_path);
 }
@@ -117,7 +117,7 @@ void init_make_tables(DB *db) {
 
   int rc = sqlite3_exec(db->ptr, sql, 0, 0, 0);
   if (rc != SQLITE_OK ) {
-    PRINT_ERR("Could not create empry db.");
+    PRINT_ERR("Could not create empty db.");
     db->error = SQL_ERR_SQLITE;
     return;
   }
@@ -411,3 +411,23 @@ int edit_get_prime_config_from_program(DB *db, char *pName, char *ret, int *secr
   /* No prime config found */
   return 0;
 }
+
+int list_get_paths(DB *db, cklist *ckl) {
+  sqlite3_stmt *stmt;
+  int rc;
+
+  char sql[STR_M];
+  dbh_form_query_select_paths(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;
+}