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);
12 tabDef
.addField("f2", typeInt
);
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
);
29 for (int i
= 0 ; i
< 10 ; i
++)
31 conn
.startTransaction();
33 if (i
%2 == 0){ table
->markFldNull(1);table
->markFldNull(2);}
34 rv
= table
->insertTuple();
36 if (i
%2 == 0) {table
->clearFldNull(1);table
->clearFldNull(2);}
40 printf("Tuples inserted in 1/txn is %d\n", icount
);
41 table
->setCondition(NULL
);
42 rv
= table
->execute();
45 dbMgr
->closeTable(table
);
46 dbMgr
->dropTable("t1");
52 tuple
= (char*)table
->fetch() ;
53 if (tuple
== NULL
) {break;}
54 if (table
->isFldNull(1)) printf("Column 1 is null\n");
55 if (table
->isFldNull(2)) printf("Column 2 is null\n");
56 printf("Binded Tuple value is %d %d \n", id1
, id2
);
59 dbMgr
->closeTable(table
);
60 dbMgr
->dropTable("t1");