todo.c

   1 #include <myarray.h>
   2 #include <sqlite3.h>
   3 #include <stdio.h>
   4 #include <readline/readline.h>
   5 #include <readline/history.h>
   6 #include <stdlib.h>
   7 #include <string.h>
   8
   9 MArray tokenize(char *string, char *delimiter) {
  10     MArray tokens = myarray_new(5, 5, sizeof(char *));
  11
  12     char *temp;
  13     char *substring;
  14     while ((temp = strstr(string, delimiter)) != NULL) {
  15         substring = malloc((temp - string + 1) * sizeof(char));
  16         strncpy(substring, string, temp-string);
  17         substring[temp-string] = '\0';
  18         myarray_append(tokens, substring);
  19         string = temp + strlen(delimiter);
  20     }
  21
  22     if (strlen(string)) {
  23         substring = malloc((strlen(string) + 1) * sizeof(char));
  24         strcpy(substring, string);
  25         myarray_append(tokens, substring);
  26     }
  27
  28     return tokens;
  29 }
  30
  31 void free_tokens(MArray tokens) {
  32     int i;
  33     for (i = 0; i < tokens->len; i++) {
  34         free(myarray_get(tokens, char *, i));
  35     }
  36
  37     myarray_free(tokens);
  38 }
  39
  40 int command_prompt(sqlite3 *db) {
  41     int retVal = 0;
  42     char *line;
  43     char *token;
  44
  45     line = readline("todo> ");
  46     add_history(line);
  47
  48     if (!line || !strlen(line)) {
  49         printf("\n");
  50         return 1;
  51     }
  52
  53     MArray tokens = tokenize(line, " ");
  54     token = myarray_get(tokens, char *, 0);
  55
  56     if (!strcmp(token, "quit")) {
  57         retVal = quit(db, tokens);
  58     } else if (!strcmp(token, "list")) {
  59         retVal = list(db, tokens);
  60     } else if (!strcmp(token, "help")) {
  61         retVal = help(db, tokens);
  62     } else if (!strcmp(token, "show")) {
  63         retVal = show(db, tokens);
  64     } else {
  65         printf("Unknown command %s\n", token);
  66         remove_history(where_history());
  67     }
  68
  69     free(line);
  70     free_tokens(tokens);
  71
  72     return retVal;
  73 }
  74
  75 int main(int argc, char **argv) {
  76     int retVal;
  77     sqlite3 *db;
  78     char *errmsg;
  79
  80     retVal = sqlite3_open("todo.db", &db);
  81
  82     if (retVal != SQLITE_OK) {
  83         printf("Couldn't open the database file: %s\n", sqlite3_errmsg(db));
  84     }
  85
  86     retVal = sqlite3_exec(db,
  87             "CREATE TABLE IF NOT EXISTS todo \
  88                 (key INTEGER PRIMARY KEY ASC ON CONFLICT ABORT AUTOINCREMENT,\
  89                  description STRING,\
  90                  createdDate INTEGER,\
  91                  dueDate INTEGER,\
  92                  parent INTEGER REFERENCES todo (key));"
  93             , NULL, NULL, &errmsg);
  94
  95     if (retVal != SQLITE_OK) {
  96         printf("Couldn't create the table for this application: %s\n", errmsg);
  97     }
  98
  99     sqlite3_free(errmsg);
 100
 101     while (!command_prompt(db)) {};
 102
 103     return 0;
 104 }