feat: Add a more "refined" UI

1 files changed, 4 insertions, 2 deletions

diff --git a/lib/data.c b/lib/data.c
index e94e0a7..1c1a754 100644
--- a/lib/data.c
+++ b/lib/data.c
@@ -3,9 +3,10 @@
 #include <stdio.h>
 
 #include "data.h"
+#include "../lib/util.h"
 
 const char *insert_into = "INSERT INTO words (LINE) VALUES($VVV);";
-const char *select_words = "SELECT Id, Line FROM words WHERE line like $VVV LIMIT 10;";
+const char *select_words = "SELECT Id, Line FROM words WHERE line like $VVV LIMIT $NNN;";
 const char *create_table =  "CREATE TABLE IF NOT EXISTS words (ID INTEGER PRIMARY KEY AUTOINCREMENT, LINE TEXT NOT NULL);";
 
 Data* new_data(const char* con)
@@ -80,7 +81,7 @@ void bootstrap(Data* data)
     sqlite3_finalize(stmt);
 }
 
-LIST* data_select(Data* data, char *sch, int len)
+LIST* data_select(Data* data, char *sch, int len, int limit)
 {
     sqlite3_stmt *stmt;
     int r = sqlite3_prepare_v2(data->db, select_words, -1, &stmt, NULL);
@@ -95,6 +96,7 @@ LIST* data_select(Data* data, char *sch, int len)
     LIST *list = NULL;
 
     sqlite3_bind_text(stmt, 1, sch, len, NULL);
+    sqlite3_bind_int(stmt, 2, limit);
 
     int m =  sqlite3_step(stmt);
     while(m == SQLITE_ROW) {