#include <SPI.h>
#include <SD.h>
#include <sqlite3.h>

#define memoryPin 5

sqlite3 *db;
char *errMsg = 0;

void setup(){
  Serial.begin(115200);
  MemoryInit();
  TempFile();
  DataBaseInit();
}

void loop() {
}

void TempFile(){
  SD.open("/database.db", FILE_WRITE);
}

void MemoryInit() {
    if(!SD.begin(memoryPin)){
    Serial.println("Error: memory not initialized");
    return;
  }
  Serial.println("Memory detected.");
}

void DataBaseInit(){
  if(!sqlite3_open("/database.db", &db)){
    Serial.println(("Database not start."));
    while(true);
  }

  Serial.println("Database started successfully.");

  const char *createTable = "CREATE TABLE IF NOT EXISTS user (id INTEGER PRIMARY KEY, name VARCHAR(100))";
  if(sqlite3_exec(db, createTable, NULL, NULL ,&errMsg) != SQLITE_OK){
    Serial.println(*errMsg);
    Serial.println("Failed to create table.");
  }else {
    Serial.println("Table created successfully.");
  }

}