Contents

#include <stdio.h>
#include <stdlib.h>
#include "sqlite3.h"
/**
 * gcc -o test_error test_error.c sqlite3.c
 * ./test_error
 */

int test_progress_callback( void* data )
{
    fprintf(stderr, "Progress handler callback\n");
    return 1;
}


void abort_if_error( sqlite3* db, char* msg, int rc ) 
{
    if ( SQLITE_OK != rc ) {
        fprintf( stderr, "%s: [%d] -> %s\n", msg, sqlite3_errcode( db ), sqlite3_errmsg( db ) );
        sqlite3_close( db );
        exit( 1 );
    }
}

int main( int argc, char **argv )
{
  sqlite3      *db;
  sqlite3_stmt *stmt;
  const char   *tail;
  char         *errmsg;
  int           rc;

  printf("SQLite Version: %s\n", sqlite3_libversion() );

  rc = sqlite3_open_v2( ":memory:", &db, SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE, NULL );
  abort_if_error( db, "Failure opening database", rc );

  rc = sqlite3_exec( db, "CREATE TABLE t1( c1, c2 );", NULL, NULL, NULL );
  abort_if_error( db, "Failure creating table t1", rc );

  sqlite3_progress_handler( db, 5, test_progress_callback, (void*) NULL );

  rc = sqlite3_prepare_v2( db, "SELECT * FROM t1", -1, &stmt, &tail );
  abort_if_error( db, "Failure preparing statement", rc );

  rc = sqlite3_step( stmt );
  if ( SQLITE_ROW != rc ) {
    printf( "Return code from sqlite3_step      : %d\n", rc );
    printf( "Before finalizing error code is    : %d\n", sqlite3_errcode( db )); 
    printf( "Before finalizing error message is : %s\n", sqlite3_errmsg( db ));
  }

  rc = sqlite3_finalize( stmt );
  if ( SQLITE_OK != rc ) {
      printf( "Return value from sqlite3_finalize : %d\n", rc );
      printf( "After finalizing errcode is        : %d\n", sqlite3_errcode( db ));
      printf( "After finalizing error message is  : %s\n", sqlite3_errmsg( db ));
  }
  sqlite3_close( db );
  return 0;

}

Version data entries

6 entries across 6 versions & 1 rubygems

Version	Path
amalgalite-0.7.6-x86-mswin32-60	ext/test_error.c
amalgalite-0.7.7	ext/test_error.c
amalgalite-0.7.7-x86-mswin32-60	ext/test_error.c
amalgalite-0.7.6	ext/test_error.c
amalgalite-0.8.0-x86-mswin32-60	ext/test_error.c
amalgalite-0.8.0	ext/test_error.c