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
);
13 AbsSqlStatement
*dropstmt
= SqlFactory::createStatement(CSql
);
14 dropstmt
->setConnection(con
);
18 strcpy(statement
,"INSERT INTO t1 VALUES(?, 1234, 'CSQL');");
19 rv
= stmt
->prepare(statement
);
20 if(rv
!=OK
) { delete stmt
; delete con
; return 4; }
21 rv
= con
->beginTrans();
22 stmt
->setIntParam(1, 100);
23 rv
= stmt
->execute(rows
);
25 printError(rv
, "Insert failed with ret val %d", rv
);
30 printf("AFTER INSERT FREE\n");
32 printf("creating index\n");
33 strcpy(statement
, "create index idx1 on t1(f2);");
34 rv
= dropstmt
->prepare(statement
);
36 printf("DROP table failed\n");
37 con
->disconnect();delete stmt
; delete con
; return -1;
39 dropstmt
->execute(rows
);
41 printf("After create index \n");
44 strcpy(statement
,"INSERT INTO t1 VALUES(?, 1234, 'CSQL');");
45 rv
= stmt
->prepare(statement
);
46 printf("After second time prepare \n");
48 rv
= con
->beginTrans();
49 stmt
->setIntParam(1, 200);
50 rv
= stmt
->execute(rows
);
52 printError(rv
, "Insert failed with ret val %d", rv
);
57 printf("After reusing cached insert stmt\n");