test/dbapi/Index/uniqueindex1.c

   1 #include<CSql.h>
   2 #include "common.h"
   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     if ( createTable(dbMgr) != 0 ) { conn.close(); return 3; }
  12     if ( createIndex(dbMgr, true) != 0 ) { dbMgr->dropTable("t1");conn.close(); return 4;
  13  }
  14     int inscount =  insertTupleWithSameValue(dbMgr, conn);
  15     if (inscount != 1 ) { dbMgr->dropTable("t1"); conn.close(); return 5; }
  16     dbMgr->dropTable("t1");
  17     conn.close();
  18     return 0;
  19
  20 }