test/dbapi/Table/duptable1.c

   1 #include<CSql.h>
   2 //create two table with same name
   3 int main()
   4 {
   5     Connection conn;
   6     DbRetVal rv = conn.open("root", "manager");
   7     if (rv != OK) return 1;
   8     DatabaseManager *dbMgr = conn.getDatabaseManager();
   9     if (dbMgr == NULL) { printf("Auth failed\n"); return 2;}
  10
  11     TableDef tabDef;
  12     tabDef.addField("f1", typeInt, 0, NULL, true);
  13     tabDef.addField("f2", typeInt);
  14     tabDef.addField("f3", typeString, 20);
  15     rv = dbMgr->createTable("t1", tabDef);
  16     if (rv != OK) { printf("Table creation failed\n"); conn.close(); return 3; }
  17     printf("Table created\n");
  18     int ret =0;
  19     rv = dbMgr->createTable("t1", tabDef);
  20     if (rv == OK) ret =1;
  21     dbMgr->dropTable("t1");
  22     conn.close();
  23     return ret;
  24 }