1 #include <SqlFactory.h>
3 int main(int argc
, char **argv
)
6 struct timeval timeout
;
7 struct timeval timeStamp
;
8 AbsSqlConnection
*con
= SqlFactory::createConnection(CSql
);
9 rv
= con
->connect("root","manager");
11 AbsSqlStatement
*stmt
= SqlFactory::createStatement(CSql
);
12 stmt
->setConnection(con
);
17 strcpy(statement
,"INSERT INTO t1 VALUES(1234,?);");
18 rv
= stmt
->prepare(statement
);
19 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
21 rv
= con
->beginTrans();
22 stmt
->setIntParam(1, 100);
23 rv
= stmt
->execute(rows
);
24 stmt
->setIntParam(1, 200);
25 rv
= stmt
->execute(rows
);
27 printError(rv
, "Insert failed with ret val %d", rv
);
32 strcpy(statement
, "create index idx on t1 (f2) primary hash;");
33 rv
= stmt
->prepare(statement
);
34 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
35 rv
= stmt
->execute(rows
);
37 printError(rv
, "create idx failed with ret val %d", rv
);
41 strcpy(statement
,"INSERT INTO t1 VALUES(1234,?);");
42 rv
= stmt
->prepare(statement
);
43 stmt
->setIntParam(1, 100);
44 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
45 rv
= con
->beginTrans();
46 rv
= stmt
->execute(rows
);
48 printError(rv
, "insert failed with ret val %d", rv
);
53 strcpy(statement
,"drop index idx;");
54 rv
= stmt
->prepare(statement
);
55 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
56 rv
= stmt
->execute(rows
);
58 printError(rv
, "drop idx failed with ret val %d", rv
);
62 strcpy(statement
,"INSERT INTO t1 VALUES(1234,?);");
63 rv
= stmt
->prepare(statement
);
64 stmt
->setIntParam(1, 100);
65 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
66 rv
= con
->beginTrans();
68 rv
= stmt
->execute(rows
);