Line data    Source code

       1             : /* 
       2             :  * Purpose: Test for proper return code from dbsqlexec()
       3             :  * Functions: db_name dbcmd dberrhandle dbmsghandle dbnextrow dbopen dbresults dbsqlexec
       4             :  */
       5             : 
       6             : #include "common.h"
       7             : 
       8             : int failed = 0;
       9             : 
      10             : int err_handler(DBPROCESS * dbproc, int severity, int dberr, int oserr, char *dberrstr, char *oserrstr);
      11             : 
      12             : /*
      13             :  * The bad column name message has severity 16, causing db-lib to call the error handler after calling the message handler.
      14             :  * This wrapper anticipates that behavior, and again sets the userdata, telling the handler this error is expected. 
      15             :  */
      16             : int
      17          10 : err_handler(DBPROCESS * dbproc, int severity, int dberr, int oserr, char *dberrstr, char *oserrstr)
      18             : {       
      19          10 :         int expected_error = 207;
      20          10 :         dbsetuserdata(dbproc, (BYTE*) &expected_error);
      21          10 :         return syb_err_handler(dbproc, severity, dberr, oserr, dberrstr, oserrstr);
      22             : }
      23             : 
      24             : int
      25          10 : main(int argc, char **argv)
      26             : {
      27             :         LOGINREC *login;
      28             :         DBPROCESS *dbproc;
      29             :         RETCODE ret;
      30             :         int expected_error;
      31             : 
      32          10 :         set_malloc_options();
      33             : 
      34          10 :         read_login_info(argc, argv);
      35             : 
      36          10 :         printf("Starting %s\n", argv[0]);
      37             : 
      38             :         /* Fortify_EnterScope(); */
      39          10 :         dbinit();
      40             : 
      41          10 :         dberrhandle(err_handler);
      42          10 :         dbmsghandle(syb_msg_handler);
      43             : 
      44          10 :         printf("About to logon\n");
      45             : 
      46          10 :         login = dblogin();
      47          10 :         DBSETLPWD(login, PASSWORD);
      48          10 :         DBSETLUSER(login, USER);
      49          10 :         DBSETLAPP(login, "t0020");
      50             : 
      51          10 :         printf("About to open\n");
      52             : 
      53          10 :         dbproc = dbopen(login, SERVER);
      54          10 :         if (strlen(DATABASE))
      55          10 :                 dbuse(dbproc, DATABASE);
      56          10 :         dbloginfree(login);
      57             : 
      58          10 :         sql_cmd(dbproc);
      59          10 :         fprintf(stderr, "The following invalid column error is normal.\n");
      60             : 
      61          10 :         expected_error = 207;
      62          10 :         dbsetuserdata(dbproc, (BYTE*) &expected_error);
      63             : 
      64          10 :         ret = dbsqlexec(dbproc);
      65          10 :         if (ret != FAIL) {
      66           0 :                 failed = 1;
      67           0 :                 fprintf(stderr, "Failed.  Expected FAIL to be returned.\n");
      68           0 :                 exit(1);
      69             :         }
      70             : 
      71          10 :         sql_cmd(dbproc);
      72          10 :         ret = dbsqlexec(dbproc);
      73          10 :         if (ret != SUCCEED) {
      74           0 :                 failed = 1;
      75           0 :                 fprintf(stderr, "Failed.  Expected SUCCEED to be returned.\n");
      76           0 :                 exit(1);
      77             :         }
      78             : 
      79          20 :         while (dbresults(dbproc) != NO_MORE_RESULTS) {
      80          20 :                 while (dbnextrow(dbproc) != NO_MORE_ROWS)
      81          10 :                         continue;
      82             :         }
      83             : 
      84          10 :         dbexit();
      85             : 
      86          10 :         printf("%s %s\n", __FILE__, (failed ? "failed!" : "OK"));
      87          10 :         return failed ? 1 : 0;
      88             : }