test1.c File Reference

#include <stdio.h>
#include <stdlib.h>
#include <sqlite3.h>

Go to the source code of this file.

Macros
#define	_GNU_SOURCE

Functions
int	myvfs_init (void)
static int	callback (void *junk __attribute__((unused)), int cnt, char **vals, char **col_name)
int	main (int argc, char **argv)

Macro Definition Documentation

#define _GNU_SOURCE

Definition at line 1 of file test1.c.

Function Documentation

static int callback ( void *junk   __attribute__(unused), int  cnt, char **  vals, char **  col_name  )

static

Definition at line 8 of file test1.c.

{
  int i = 0;
  printf("\n");
  for (i = 0; i < cnt; ++i) {
    if (vals[i]) {
      printf("%s: %s\n", col_name[i], vals[i]);
    }
    else {
      printf("%s: %s\n", col_name[i], "NULL");
    }
  }
  return 0;
}

int main	(	int	argc,
		char **	argv
	)

Definition at line 23 of file test1.c.

{
  sqlite3 * db = 0;
  char * error_msg = 0;
  int err = 0;
  if (argc < 2 || argc > 3) {
    fprintf(stderr, "usage: %s: <db-filename> [<sql-statement>]. If <sql-statement> is omitted take from stdin.\n", argv[0]);
    exit(1);
  }
  myvfs_init();
  err = sqlite3_open_v2(argv[1], &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, "myvfs");
  if (err) {
    fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
    sqlite3_close(db);
    exit(1);
  }
  if (argc == 3) {
    err = sqlite3_exec(db, argv[2], callback, 0, &error_msg);
  }
  else {
    char * buf = 0;
    size_t n = 0;
    getline(&buf, &n, stdin);
    err = sqlite3_exec(db, buf, callback, 0, &error_msg);
    free(buf);
  }
  if (err != SQLITE_OK) {
    fprintf(stderr, "SQL error: %s\n", error_msg);
    sqlite3_free(error_msg);
  }
  sqlite3_close(db);
  return 0;
}

int myvfs_init

(

void

)

Definition at line 1748 of file myvfs.c.

{
  /*
  ** The following macro defines an initializer for an sqlite3_vfs object.
  ** The name of the VFS is NAME.  The pAppData is a pointer to a pointer
  ** to the "finder" function.  (pAppData is a pointer to a pointer because
  ** silly C90 rules prohibit a void* from being cast to a function pointer
  ** and so we have to go through the intermediate pointer to avoid problems
  ** when compiling with -pedantic-errors on GCC.)
  **
  ** The FINDER parameter to this macro is the name of the pointer to the
  ** finder-function.  The finder-function returns a pointer to the
  ** sqlite_io_methods object that implements the desired locking
  ** behaviors.  See the division above that contains the IOMETHODS
  ** macro for addition information on finder-functions.
  **
  ** Most finders simply return a pointer to a fixed sqlite3_io_methods
  ** object.  But the "autolockIoFinder" available on MacOSX does a little
  ** more than that; it looks at the filesystem type that hosts the
  ** database file and tries to choose an locking method appropriate for
  ** that filesystem time.
  */
#define UNIXVFS(VFSNAME, FINDER) {                        \
    1,                    /* iVersion */                    \
    sizeof(unixFile),     /* szOsFile */                    \
    MAX_PATHNAME,         /* mxPathname */                  \
    0,                    /* pNext */                       \
    VFSNAME,              /* zName */                       \
    (void*)&FINDER,       /* pAppData */                    \
    unixOpen,             /* xOpen */                       \
    unixDelete,           /* xDelete */                     \
    unixAccess,           /* xAccess */                     \
    unixFullPathname,     /* xFullPathname */               \
    unixDlOpen,           /* xDlOpen */                     \
    unixDlError,          /* xDlError */                    \
    unixDlSym,            /* xDlSym */                      \
    unixDlClose,          /* xDlClose */                    \
    unixRandomness,       /* xRandomness */                 \
    unixSleep,            /* xSleep */                      \
    unixCurrentTime,      /* xCurrentTime */                \
    unixGetLastError,     /* xGetLastError */               \
    /* unixCurrentTimeInt64, v2, xCurrentTimeInt64 */       \
    /* unixSetSystemCall,    v3, xSetSystemCall */          \
    /* unixGetSystemCall,    v3, xGetSystemCall */          \
    /* unixNextSystemCall,   v3, xNextSystemCall */         \
  }
  /*
  ** All default VFSes for unix are contained in the following array.
  **
  ** Note that the sqlite3_vfs.pNext field of the VFS object is modified
  ** by the SQLite core when the VFS is registered.  So the following
  ** array cannot be const.
  */
  static sqlite3_vfs aVfs[] = {
    UNIXVFS("myvfs",     nolockIoFinder),
  };
  unsigned int i;          /* Loop counter */
  /* Double-check that the aSyscall[] array has been constructed
  ** correctly.  See ticket [bb3a86e890c8e96ab] */
  assert(ArraySize(aSyscall) == 16);
  /* Register all VFSes defined in the aVfs[] array */
  for (i = 0; i < (sizeof(aVfs) / sizeof(sqlite3_vfs)); i++) {
    sqlite3_vfs_register(&aVfs[i], i == 0);
  }
  return SQLITE_OK;
}