comparison: test/main.c
test/main.c
- changeset 12
- 421555fa9ce4
- parent 11
- 0aa8cbd7912e
- child 14
- 59e62e65182c
equal
deleted
inserted
replaced
| 11:0aa8cbd7912e | 12:421555fa9ce4 |
|---|---|
| 150 if(create_test_data(db)) { | 150 if(create_test_data(db)) { |
| 151 return 1; | 151 return 1; |
| 152 } | 152 } |
| 153 | 153 |
| 154 DBUConnection *conn = dbuSQLiteConnectionFromDB(db, true); | 154 DBUConnection *conn = dbuSQLiteConnectionFromDB(db, true); |
| 155 | |
| 156 // test dbuConnectionExec | |
| 157 int execResult = dbuConnectionExec(conn, "drop table if exists test_table;"); | |
| 158 printf("exec result: %d\n\n", execResult); | |
| 159 | |
| 155 DBUQuery *query = conn->createQuery(conn, NULL); | 160 DBUQuery *query = conn->createQuery(conn, NULL); |
| 156 dbuQuerySetSQL(query, "select p.*, a.address_id as [__address__address_id], a.street, a.zip, a.city from Person p inner join Address a on p.address_id = a.address_id;"); | 161 dbuQuerySetSQL(query, "select p.*, a.address_id as [__address__address_id], a.street, a.zip, a.city from Person p inner join Address a on p.address_id = a.address_id;"); |
| 157 | 162 |
| 158 DBUQuery *roleQuery = conn->createQuery(conn, NULL); | 163 DBUQuery *roleQuery = conn->createQuery(conn, NULL); |
| 159 dbuQuerySetSQL(roleQuery, "select * from role;"); | 164 dbuQuerySetSQL(roleQuery, "select * from role;"); |
