comparison: test/main.c
test/main.c
- changeset 11
- 0aa8cbd7912e
- parent 10
- 80f9d007cb52
- child 12
- 421555fa9ce4
equal
deleted
inserted
replaced
| 10:80f9d007cb52 | 11:0aa8cbd7912e |
|---|---|
| 157 | 157 |
| 158 DBUQuery *roleQuery = conn->createQuery(conn, NULL); | 158 DBUQuery *roleQuery = conn->createQuery(conn, NULL); |
| 159 dbuQuerySetSQL(roleQuery, "select * from role;"); | 159 dbuQuerySetSQL(roleQuery, "select * from role;"); |
| 160 | 160 |
| 161 DBUQuery *query2 = conn->createQuery(conn, NULL); | 161 DBUQuery *query2 = conn->createQuery(conn, NULL); |
| 162 dbuQuerySetSQL(query2, "select p.*, a.address_id as [__address__address_id], a.street, a.zip, a.city, r.role_id as [__role__role_id], r.person_id, r.name from Person p inner join Address a on p.address_id = a.address_id left join Role r on p.person_id = r.person_id;"); | 162 dbuQuerySetSQL(query2, "select p.*, a.address_id as [__address__address_id], a.street, a.zip, a.city, r.role_id as [__role__role_id], r.person_id, r.name from Person p inner join Address a on p.address_id = a.address_id left join Role r on p.person_id = r.person_id order by p.person_id, r.role_id;"); |
| 163 | 163 |
| 164 DBUObjectBuilder *builder = dbuObjectBuilder(person, query2, cxDefaultAllocator); | 164 DBUObjectBuilder *builder = dbuObjectBuilder(person, query2, cxDefaultAllocator); |
| 165 dbuObjectBuilderSetDenseResult(builder, true); | 165 dbuObjectBuilderSetDenseResult(builder, true); |
| 166 //dbuObjectBuilderAddAdditionalQuery(builder, role, roleQuery); | 166 //dbuObjectBuilderAddAdditionalQuery(builder, role, roleQuery); |
| 167 CxList *persons = dbuObjectBuilderGetList(builder); | 167 CxList *persons = dbuObjectBuilderGetList(builder); |
