sqlite_read

sqlite_read.c

#include "stdlib.h"
#include "stdio.h"
#include "sqlite/sqlite3.h"

int gotmail(void* NotUsed, int colcount, char** qresult, char** colname);

sqlite3* db;
char * EMSG = NULL;

int main(){
  const char* sql_data = "SELECT value from config WHERE key='email'";
 int rc = sqlite3_open_v2("config.db", &db, SQLITE_OPEN_READONLY, NULL);

  if( rc )
    exit(-1);

  rc = sqlite3_exec(db, sql_data, &gotmail, NULL, &EMSG);
  if( rc ){
    fprintf(stderr, "%s\n", EMSG);
    exit(-2);
  }

  return(0);
}

int gotmail(void* NotUsed, int colcount, char** qresult, char** colname){
  printf("%s\n",*qresult);
  return 0;
}