t0011.c

unix上的TDS协议实现

#include <stdio.h>
#include <stdlib.h>
#include <assert.h>
#include <stdio.h>
#ifdef _WIN32
#define DBNTWIN32
#include <windows.h>
#endif
#include <sqlfront.h>
#include <sqldb.h>

#include "common.h"

/*
 * Test binding of string types
 *
 */


static char  software_version[]   = "$Id: t0011.c,v 1.2 2002/08/29 09:54:54 freddy77 Exp $";
static void *no_unused_var_warn[] = {software_version,
                                     no_unused_var_warn};



int failed = 0;
const char long_column[] = "This is a really long column to ensure that the next row ends properly.";
const char short_column[] = "Short column";

void insert_row(DBPROCESS *dbproc, char *cmd);

int main()
{
   const int   rows_to_add = 50;
   LOGINREC   *login;
   DBPROCESS   *dbproc;
   int         i;
   char   cmd[2048];

   read_login_info();
   fprintf(stdout, "Start\n");

   dbinit();

   fprintf(stdout, "About to logon\n");

   login = dblogin();
   DBSETLPWD(login,PASSWORD);
   DBSETLUSER(login,USER);
   DBSETLAPP(login,"t0011");

fprintf(stdout, "About to open\n");

   dbproc = dbopen(login, SERVER);
   if (strlen(DATABASE)) dbuse(dbproc,DATABASE);

   fprintf(stdout, "Dropping table\n");
   dbcmd(dbproc, "drop table #dblib0011");
   dbsqlexec(dbproc);
   while (dbresults(dbproc)!=NO_MORE_RESULTS)
   {
      /* nop */
   }

   fprintf(stdout, "creating table\n");
   dbcmd(dbproc, "create table #dblib0011 (i int not null, c1 char(200) not null, c2 char(200) null, vc varchar(200) null)");
   dbsqlexec(dbproc);
   while (dbresults(dbproc)!=NO_MORE_RESULTS)
   {
      /* nop */
   }

   fprintf(stdout, "insert\n");

   sprintf(cmd, "insert into #dblib0011 values (1, '%s','%s','%s')", long_column, long_column, long_column);
   insert_row(dbproc,cmd);
   sprintf(cmd, "insert into #dblib0011 values (2, '%s','%s','%s')", short_column, short_column, short_column);
   insert_row(dbproc,cmd);
   sprintf(cmd, "insert into #dblib0011 values (3, '%s',NULL,NULL)", short_column);
   insert_row(dbproc,cmd);

   failed = select_rows(dbproc, STRINGBIND);

   dbexit();

   fprintf(stdout, "dblib %s on %s\n", 
           (failed?"failed!":"okay"),
           __FILE__);
   return failed ? 1 : 0; 
}

int select_rows(DBPROCESS *dbproc, int bind_type)
{
   char        teststr[1024];
   char        teststr2[1024];
   char        testvstr[1024];
   DBINT       testint;
   DBINT       i;


   fprintf(stdout, "select\n");
   dbcmd(dbproc,"select * from #dblib0011 order by i");
   dbsqlexec(dbproc);


   if (dbresults(dbproc)!=SUCCEED)
   {
      failed = 1;
      fprintf(stdout, "Was expecting a result set.");
      exit(1);
   }

   for (i=1;i<=dbnumcols(dbproc);i++)
   {
      printf ("col %d is %s\n",i,dbcolname(dbproc,i));
   }

   if (SUCCEED != dbbind(dbproc,1,INTBIND,-1,(BYTE *) &testint))
   {
      fprintf(stderr, "Had problem with bind\n");
      return 1;
   }
   if (SUCCEED != dbbind(dbproc,2,bind_type,-1,(BYTE *) teststr))
   {
      fprintf(stderr, "Had problem with bind\n");
      return 1;
   }
   if (SUCCEED != dbbind(dbproc,3,bind_type,-1,(BYTE *) teststr2))
   {
      fprintf(stderr, "Had problem with bind\n");
      return 1;
   }
   if (SUCCEED != dbbind(dbproc,4,bind_type,-1,(BYTE *) testvstr))
   {
      fprintf(stderr, "Had problem with bind\n");
      return 1;
   }

   i=0;
   while (dbnextrow(dbproc)==REG_ROW)
   {
      i++;
      if (testint != i)
      {
         fprintf(stdout, "Failed.  Expected i to be |%d|, was |%d|\n",
                 testint);
         return 1;
      }
      printf("c:  %s$\n",teststr);
      printf("c2: %s$\n",teststr2);
      printf("vc: %s$\n",testvstr);
      if (bind_type == STRINGBIND)
      {
      } else {
      }
   }
   return 0;
}

void insert_row(DBPROCESS *dbproc, char *cmd)
{
   fprintf(stdout, "%s\n",cmd);
   dbcmd(dbproc, cmd);
   dbsqlexec(dbproc);
   while (dbresults(dbproc)!=NO_MORE_RESULTS)
   {
       /* nop */
   }
}