test/dbapi/TableDef/fieldcount3.c

   1 //Create table with 1024 fields and call getFldCount()
   2 //and check return value is 1024
   3 #include<CSql.h>
   4 int main()
   5 {
   6     Connection conn;
   7     DbRetVal rv = conn.open("root", "manager");
   8     if (rv != OK) return 1;
   9     DatabaseManager *dbMgr = conn.getDatabaseManager();
  10     if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}
  11     int test;
  12     TableDef tabDef;
  13     char str[6]="f",field[6];
  14     for (int i=1;i<=1024;i++)
  15     {
  16         sprintf(field,"%s%d",str,i);
  17         test=tabDef.addField(field, typeInt);
  18         if(test!=0)
  19         {
  20                 printf("Field f%d could not be created",i);
  21                 return test;
  22         }
  23     }
  24     int fieldcount=tabDef.getFieldCount();
  25     printf("Number of Fields = %d\n",fieldcount);
  26     rv=dbMgr->createTable("t1", tabDef);
  27     if(rv!=OK)
  28     {
  29         printf("Table creation Failed\n");
  30         printf("Test failed\n");
  31         return 3;
  32     }
  33     printf("Table created \n");
  34     printf("Test passed\n");
  35     dbMgr->dropTable("t1");
  36     conn.close();
  37     return 0;
  38 }
  39