5 DbRetVal rv
= conn
.open("root", "manager");
6 if (rv
!= OK
) return 1;
7 DatabaseManager
*dbMgr
= conn
.getDatabaseManager();
8 if (dbMgr
== NULL
) { printf("Auth failed\n"); return 2;}
11 tabDef
.addField("f1", typeInt
, 0, NULL
, true);//NOT NULL
12 tabDef
.addField("f2", typeInt
, 0, NULL
, false);
13 rv
= dbMgr
->createTable("t1", tabDef
);
14 if (rv
!= OK
) { printf("Table creation failed\n"); conn
.close(); return 3; }
15 printf("Table created\n");
17 Table
*table
= dbMgr
->openTable("t1");
20 printf("Unable to open table\n");
21 dbMgr
->dropTable("t1");
26 table
->bindFld("f1", &id1
);
27 table
->bindFld("f2", &id2
);
28 conn
.startTransaction();
29 rv
= table
->markFldNull(1);
31 printf("test passed\n");
32 dbMgr
->dropTable("t1");
33 printf("table dropped\n");
37 rv
= table
->insertTuple();
41 dbMgr
->dropTable("t1");
45 table
->clearFldNull(1);
48 table
->setCondition(NULL
);
49 rv
= table
->execute();
52 dbMgr
->closeTable(table
);
53 dbMgr
->dropTable("t1");
56 table
->bindFld("f2", &id2
);
60 tuple
= (char*)table
->fetch() ;
61 if (tuple
== NULL
) {break;}
62 if (table
->isFldNull(1)) printf("Column 1 is null\n");
63 if (table
->isFldNull(2)) printf("Column 2 is null\n");
64 printf("Binded Tuple value is %d %d \n", id1
, id2
);
68 dbMgr
->closeTable(table
);
69 dbMgr
->dropTable("t1");