From 0168c10023f0040ae2fa31a212eb6d2e411eefb3 Mon Sep 17 00:00:00 2001
From: gramanas <anastasis.gramm2@gmail.com>
Date: Fri, 13 Apr 2018 03:09:03 +0300
Subject: Find sqlite3 and some tests

---
 src/main.c | 87 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 file changed, 83 insertions(+), 4 deletions(-)

(limited to 'src/main.c')

diff --git a/src/main.c b/src/main.c
index e4acf4d..6de5b43 100644
--- a/src/main.c
+++ b/src/main.c
@@ -1,6 +1,85 @@
-#include "stdio.h"
+#include <stdio.h>
+#include <stdlib.h>
+#include <string.h>
+#include <sqlite3.h> 
 
-int main()
-{
-  printf("Hello World\n");
+static int callback(void *NotUsed, int argc, char **argv, char **azColName) {
+  int i;
+  for(i = 0; i<argc; i++) {
+    printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
+  }
+  printf("\n");
+  return 0;
+}
+
+void initDb(sqlite3 *db) {
+  char *zErrMsg = 0;
+  char *sql;
+  int rc;
+
+  /* Create SQL statement */
+  sql = "CREATE TABLE PROGRAM("                  \
+    "id INT PRIMARY KEY     NOT NULL,"           \
+    "name           TEXT    NOT NULL);";
+  
+  /* Execute SQL statement */
+  rc = sqlite3_exec(db, sql, callback, 0, &zErrMsg);
+
+  if( rc != SQLITE_OK ){
+    fprintf(stderr, "SQL error: %s\n", zErrMsg);
+    sqlite3_free(zErrMsg);
+  } else {
+    fprintf(stdout, "Table created successfully\n");
+  }  
+  sql = "CREATE TABLE CONFIG("                   \
+    "id INT PRIMARY KEY     NOT NULL,"           \
+    "path           TEXT    NOT NULL,"           \
+    "secret         INT     NOT NULL,"           \
+    "prime          INT     NOT NULL);";
+
+  /* Execute SQL statement */
+  rc = sqlite3_exec(db, sql, callback, 0, &zErrMsg);
+
+  if( rc != SQLITE_OK ){
+    fprintf(stderr, "SQL error: %s\n", zErrMsg);
+    sqlite3_free(zErrMsg);
+  } else {
+    fprintf(stdout, "Table created successfully\n");
+  }
+  sql = "CREATE TABLE REL("                      \
+    "pId INT    NOT NULL,"                       \
+    "cId INT    NOT NULL);";
+  
+  /* Execute SQL statement */
+  rc = sqlite3_exec(db, sql, callback, 0, &zErrMsg);
+
+  if( rc != SQLITE_OK ){
+    fprintf(stderr, "SQL error: %s\n", zErrMsg);
+    sqlite3_free(zErrMsg);
+  } else {
+    fprintf(stdout, "Table created successfully\n");
+  }   
+}
+
+ int main(int argc, char* argv[]) {
+  sqlite3 *db;
+  int rc;
+
+  /* Open database */
+  rc = sqlite3_open("ckdb", &db);
+   
+  if (rc) {
+    fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
+    return(0);
+  }
+  else {
+    fprintf(stdout, "Opened database successfully\n");
+  }
+
+  if (strcmp("init", argv[1]) == 0) {
+    initDb(db);
+  }
+
+  sqlite3_close(db);
+  return 0;
 }
-- 
cgit v1.2.3