dbmorecmds.c

Go to the documentation of this file.

Go to the SVN repository for this file.

/* 
 * Purpose: Test behaviour of dbmorecmds()
 * Functions: dbmorecmds 
 */
 
#include "common.h"
 
#include <common/test_assert.h>
 
int failed = 0;
 
int
main(int argc, char **argv)
{
    const int rows_to_add = 10;
    LOGINREC *login;
    DBPROCESS *dbproc;
    int i, nresults;
 
    set_malloc_options();
 
    read_login_info(argc, argv);
    fprintf(stdout, "Starting %s\n", argv[0]);
 
    /* Fortify_EnterScope(); */
    dbinit();
 
    dberrhandle(syb_err_handler);
    dbmsghandle(syb_msg_handler);
 
    fprintf(stdout, "About to logon\n");
 
    login = dblogin();
    fprintf(stdout, "after dblogin\n");
    DBSETLPWD(login, PASSWORD);
    DBSETLUSER(login, USER);
    DBSETLAPP(login, "t0024");
 
    fprintf(stdout, "About to open [%s]\n", USER);
 
    dbproc = dbopen(login, SERVER);
    fprintf(stdout, "After dbopen [%s]\n", SERVER);
 
    if (strlen(DATABASE)) {
        fprintf(stdout, "About to dbuse [%s]\n", DATABASE);
        dbuse(dbproc, DATABASE);
    }
    dbloginfree(login);
 
    fprintf(stdout, "After dbuse [%s]\n", DATABASE);
 
    fprintf(stdout, "creating table\n");
    sql_cmd(dbproc);
    dbsqlexec(dbproc);
    while (dbresults(dbproc) != NO_MORE_RESULTS) {
        /* nop */
    }
 
    fprintf(stdout, "insert\n");
    for (i = 0; i < rows_to_add; i++) {
        sql_cmd(dbproc);
        dbsqlexec(dbproc);
        while (dbresults(dbproc) != NO_MORE_RESULTS) {
            /* nop */
        }
    }
 
    fprintf(stdout, "select one resultset\n");
    sql_cmd(dbproc);
    dbsqlexec(dbproc);
 
    nresults = 0;
 
    if (dbresults(dbproc) == SUCCEED) {
        do {
            while (dbnextrow(dbproc) != NO_MORE_ROWS)
                continue;
            nresults++;
        } while (dbmorecmds(dbproc) == SUCCEED);
    }
 
    /* dbmorecmds should return success 0 times for select 1 */
    if (nresults != 1) {
        failed = 1;
        fprintf(stdout, "Was expecting nresults == 1.\n");
        exit(1);
    }
 
    dbcancel(dbproc);
 
    fprintf(stdout, "select two resultsets\n");
    sql_cmd(dbproc);
    dbsqlexec(dbproc);
 
    nresults = 0;
 
    do {
        if (dbresults(dbproc) == SUCCEED) {
            while (dbnextrow(dbproc) != NO_MORE_ROWS)
                continue;
            nresults++;
        }
    } while (dbmorecmds(dbproc) == SUCCEED);
 
 
    /* dbmorecmds should return success 2 times for select 2 */
    if (nresults != 2) {    /* two results sets plus a return code */
        failed = 1;
        fprintf(stdout, "nresults was %d; was expecting nresults = 2.\n", nresults);
        exit(1);
    }
 
    /* end of test processing */
    dbexit();
 
    fprintf(stdout, "%s %s\n", __FILE__, (failed ? "failed!" : "OK"));
    return failed ? 1 : 0;
}