test/dbapi/TableDef/fieldname1.c

   1 //Create table with the field name made up of special characters other than
   2 //underscore. it should not be allowed.
   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
  12     TableDef tabDef;
  13     int i=0;
  14     rv=(DbRetVal)tabDef.addField("f-2", typeInt);
  15     if(rv==OK) i++;
  16     rv=(DbRetVal)tabDef.addField("2f", typeInt);
  17     if(rv==OK) i++;
  18     rv=(DbRetVal)tabDef.addField("f2@", typeInt);
  19     if(rv==OK) i++;
  20     rv=(DbRetVal)tabDef.addField("_f2#", typeInt);
  21     if(rv==OK) i++;
  22     rv=(DbRetVal)tabDef.addField("$f2", typeInt);
  23     if(rv==OK) i++;
  24     rv=(DbRetVal)tabDef.addField("$@*#", typeInt);
  25     if(rv==OK) i++;
  26
  27
  28     if(i){printf(" Test Failed \n"); return i;}
  29
  30     rv=dbMgr->createTable("t1", tabDef);
  31     if(rv==OK)
  32     {
  33         printf("Allowing fieldnames made up of all special characters\n");
  34         printf("Test failed\n");
  35         dbMgr->dropTable("t1");
  36         return 3;
  37     }
  38
  39     printf("Test Passed\n");
  40     conn.close();
  41     return 0;
  42 }
  43 //Table is created  and allowing field names with special characters other than underscores also