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();
34 if ((rv
= table
->markFldNull(1)) != OK
) {
35 conn
.rollback(); continue; }
36 if ( (rv
= table
->markFldNull(2)) != OK
) {
41 rv
= table
->insertTuple();
43 if (i
%2 == 0) {table
->clearFldNull(1);table
->clearFldNull(2);}
47 printf("Tuples inserted in 1/txn is %d\n", icount
);
48 table
->setCondition(NULL
);
49 rv
= table
->execute();
52 dbMgr
->closeTable(table
);
53 dbMgr
->dropTable("t1");
59 tuple
= (char*)table
->fetch() ;
60 if (tuple
== NULL
) {break;}
61 if (table
->isFldNull(1)) printf("Column 1 is null\n");
62 if (table
->isFldNull(2)) printf("Column 2 is null\n");
63 printf("Binded Tuple value is %d %d \n", id1
, id2
);
66 dbMgr
->closeTable(table
);
67 dbMgr
->dropTable("t1");