[sqlite] about addition extension

[dark0s dark0s]

Ok, but I did not understand step by step how work. In wiki there is:


#include <sqlite3ext.h>
SQLITE_EXTENSION_INIT1


static void halfFunc(
  sqlite3_context *context,
  int argc,
  sqlite3_value **argv
){
  sqlite3_result_double(context, 0.5*sqlite3_value_double(argv[0]));
}


int sqlite3_extension_init(
  sqlite3 *db,
  char **pzErrMsg,
  const sqlite3_api_routines *pApi
){
  SQLITE_EXTENSION_INIT2(pApi)
  sqlite3_create_function(db, "half", 1, SQLITE_ANY, 0, halfFunc, 0, 0);
  return 0;
}


I understood that in my program I must insert sqlite3ext.h
instead sqlite3.h, but I have got a doubt:
Must I insert sqlite3_extension_init implementation,
like below?

#include <sqlite3ext.h>
SQLITE_EXTENSION_INIT1

int main(int argc, char* argv[]) {

  int rc;
  char* sql;
  sqlite3* db;
  sqlite3_stmt* stmt;
  const char* tail;

  rc = sqlite3_open("dbforext.db",&db);
  if (rc) {
    fprintf(stderr, "E' impossibile aprire il file %s\n", sqlite3_errmsg(db));
    sqlite3_close(db);
    exit(1);
  }

static void soundex(
  sqlite3_context *context,
  int argc,
  sqlite3_value **argv
){
  ...
}


int sqlite3_extension_init(
  sqlite3 *db,
  char **pzErrMsg,
  const sqlite3_api_routines *pApi
){
  SQLITE_EXTENSION_INIT2(pApi)
  sqlite3_create_function(db, "soundex", 1, SQLITE_UTF8, NULL, soundex, NULL,
 NULL);
} 
  
  
  sql = "select soundex(saverio);";
  sqlite3_prepare(db, sql, strlen(sql), &stmt, &tail);
  if (rc != SQLITE_OK) {
    fprintf(stderr, "Errore SQL: %s\n", sqlite3_errmsg(db));
  }
  rc = sqlite3_step(stmt);

  sqlite3_close(db);

  return 0;

}

Excuse for my ignorance with sqlite3, but I am newbye.

Savio
       
---------------------------------
Inviato da Yahoo! Mail.
La casella di posta intelligente.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users