Artifact 893928fc2b797fcc2103f8897915cbe68afbf232:

• File test-cpdo.c
  • 2011-04-16 11:37:12 - part of checkin [a17739cf15] on branch trunk - Fixed horrible bug in the handling of the special value 0 for integer types, which was using some address as its value instead of 0. (user: stephan) [annotate]

#if defined(NDEBUG)
#  undef NDEBUG /* force assert() to always work */
#endif
#include <assert.h>
#include <stdio.h>
#include <stdlib.h> /* atexit() */
#include <string.h> /* strlen() */
#include "wh/cson/cson_cpdo.h"

#define MARKER if(1) printf("MARKER: %s:%d:%s():\t",__FILE__,__LINE__,__func__); if(1) printf
#define SHOWRC(RC) MARKER("rc=%d (%s)\n",RC,cson_rc_string(RC))

static struct {
    cpdo_driver * db;
    char const * dsn;
    cson_output_opt outOpt;
} ThisApp = {
    NULL/*db*/,
#if 1
    "sqlite3::memory:"/*dsn*/,
#else
    "sqlite3:byoo.sqlite3"/*dsn*/,
#endif
    cson_output_opt_empty_m
};

static void setup_db()
{
    MARKER("db setup starting dsn=[%s]...\n", ThisApp.dsn);
    int rc = cpdo_driver_new_connect( &ThisApp.db, ThisApp.dsn, NULL, NULL);
    MARKER("connect rc=%d\n",rc);
    assert( (0 == rc) && "db open failed!" );

#define RUNSQL(SQL) \
    puts(SQL); \
    rc = cpdo_exec( ThisApp.db, SQL, strlen(SQL) );     \
    assert( (0 == rc) && "QUERY FAILED")

    char const * sql = "CREATE TABLE IF NOT EXISTS stuff ("
                        "name UNIQUE ON CONFLICT REPLACE, "
                        "count integer"
                        ");";
    RUNSQL(sql);
    RUNSQL("DELETE FROM stuff");
    RUNSQL("INSERT INTO STUFF (name,count) VALUES('this',3)" );
    RUNSQL("INSERT INTO STUFF (name,count) VALUES('that',2)" );
    RUNSQL("INSERT INTO STUFF (name,count) VALUES('intZero',0)" );
    RUNSQL("INSERT INTO STUFF (name,count) VALUES('doubleZero',0.0)" );
    RUNSQL("INSERT INTO STUFF (name,count) VALUES('emptyString','')" );
    RUNSQL("INSERT INTO STUFF (name,count) VALUES('theOtherThing',NULL)" );
#undef RUNSQL
    MARKER("db setup done.\n");
}


static void test1()
{
    MARKER("test1() starting.\n");
    assert( NULL != ThisApp.db );

    cpdo_stmt * st = NULL;
    char const * select = "SELECT * FROM stuff";
    int rc = cpdo_prepare( ThisApp.db, &st, select, strlen(select) );
    assert( 0 == rc );
    cson_value * json = NULL;
    char fat = 1;
    rc = cson_cpdo_stmt_to_json( st, &json, fat );
    st->api->finalize( st );
    assert( 0 == rc );
    assert( NULL != json );
    MARKER("Via cson_cpdo_stmt_to_json(%s mode) [%s]...\n",fat?"fat":"slim",select);
    cson_output_FILE( json, stdout, &ThisApp.outOpt );
    cson_value_free(json);
    json = NULL;
    fat = !fat;
    rc = cson_cpdo_sql_to_json( ThisApp.db, &json, select, fat);
    assert( 0 == rc );
    MARKER("Via cson_cpdo_sql_to_json(%s mode) [%s]...\n",fat?"fat":"slim",select);
    cson_output_FILE( json, stdout, &ThisApp.outOpt );
    cson_value_free(json);
    MARKER("test1() done.\n");
}

static void atexit_handler()
{
    if( NULL != ThisApp.db ) {
        cpdo_close(ThisApp.db);
        ThisApp.db = NULL;
    }
}
int main(int argc, char **argv)
{
    atexit( atexit_handler );
#if CPDO_ENABLE_SQLITE3
    cpdo_driver_sqlite3_register();
#endif
#if CPDO_ENABLE_MYSQL5
    cpdo_driver_mysql5_register();
#endif
    setup_db();
    ThisApp.outOpt.addNewline = 1;
    ThisApp.outOpt.indentation = 1;
    test1();
	return 0;
}