src/evpq_test.c
author Tero Marttila <terom@fixme.fi>
Sat, 13 Dec 2008 20:58:27 +0200
branchnew-evsql
changeset 55 0b92d553400a
parent 12 7f159ee3a3ff
permissions -rw-r--r--
evsql: more improvements
     1 #include <stdio.h>
     2 
     3 #include "evpq.h"
     4 #include "lib/log.h"
     5 
     6 #define CONNINFO_DEFAULT "dbname=test"
     7 #define QUERY_DEFAULT "SELECT a, b FROM foo"
     8 
     9 void cb_connected (struct evpq_conn *conn, void *arg) {
    10     INFO("[evpq_test] connected");
    11 
    12     if (evpq_query(conn, QUERY_DEFAULT))
    13         FATAL("evpq_query");
    14 }
    15 
    16 void cb_result (struct evpq_conn *conn, PGresult *result, void *arg) {
    17 
    18     INFO("[evpq_test] result: %s", PQresStatus(PQresultStatus(result)));
    19 
    20     // fatal error?
    21     if (PQresultStatus(result) != PGRES_TUPLES_OK)
    22         FATAL("error: %s", PQresultErrorMessage(result));
    23     
    24     // dump it to stdout
    25     PQprintOpt popt = {
    26         .header     = 1,
    27         .align      = 1,
    28         .standard   = 0,
    29         .html3      = 0,
    30         .expanded   = 1,
    31         .pager      = 0,
    32         .fieldSep   = "|",
    33         .tableOpt   = NULL,
    34         .caption    = NULL,
    35         .fieldName  = NULL,
    36     };
    37 
    38     PQprint(stdout, result, &popt);
    39 
    40     // don't care about the result anymore
    41     PQclear(result);
    42 }
    43 
    44 void cb_done (struct evpq_conn *conn, void *arg) {
    45     INFO("[evpq_test] done");
    46 }
    47 
    48 void cb_failure (struct evpq_conn *conn, void *arg) {
    49     INFO("[evpq_test] failure");
    50     INFO("\t%s", evpq_error_message(conn));
    51     
    52     FATAL("exiting");
    53 }
    54 
    55 int main (int argc, char **argv) {
    56     struct event_base *ev_base = NULL;
    57     struct evpq_conn *conn = NULL;
    58     const char *conninfo = CONNINFO_DEFAULT;
    59 
    60     struct evpq_callback_info cb_info = {
    61         .fn_connected = cb_connected,
    62         .fn_result = cb_result,
    63         .fn_done = cb_done,
    64         .fn_failure = cb_failure,
    65     };
    66 
    67     // initialize libevent
    68     if ((ev_base = event_base_new()) == NULL)
    69         ERROR("event_base_new");
    70 
    71     // establish the evpq connection
    72     if ((conn = evpq_connect(ev_base, conninfo, cb_info, NULL)) == NULL)
    73         ERROR("evpq_connect");
    74 
    75     // run libevent
    76     INFO("running libevent loop");
    77 
    78     if (event_base_dispatch(ev_base))
    79         ERROR("event_base_dispatch");
    80     
    81     // clean shutdown
    82 
    83 error:
    84     if (ev_base)
    85         event_base_free(ev_base);
    86 }
    87