comparison: test/main.c
test/main.c
- changeset 3
- 69ea9040d896
- parent 0
- 1a157da63d7c
- child 4
- 1908c8b1599f
equal
deleted
inserted
replaced
| 2:4c12c95f4846 | 3:69ea9040d896 |
|---|---|
| 29 #include <stdio.h> | 29 #include <stdio.h> |
| 30 #include <sqlite3.h> | 30 #include <sqlite3.h> |
| 31 | 31 |
| 32 #include <dbutils/dbutils.h> | 32 #include <dbutils/dbutils.h> |
| 33 #include <dbutils/sqlite.h> | 33 #include <dbutils/sqlite.h> |
| 34 #include <dbutils/db.h> | |
| 34 | 35 |
| 35 const char *sql_create_table_person = | 36 const char *sql_create_table_person = |
| 36 "create table if not exists Person (" | 37 "create table if not exists Person (" |
| 37 "person_id integer primary key autoincrement, " | 38 "person_id integer primary key autoincrement, " |
| 38 "name text, " | 39 "name text, " |
| 87 | 88 |
| 88 if(create_test_data(db)) { | 89 if(create_test_data(db)) { |
| 89 return 1; | 90 return 1; |
| 90 } | 91 } |
| 91 | 92 |
| 92 CxList *persons = dbuSQLiteQuerySingleTable(ctx, db, "person", "select * from Person;"); | 93 DBUConnection *conn = dbuSQLiteConnectionFromDB(db, true); |
| 94 DBUQuery *query = conn->createQuery(conn, NULL); | |
| 95 dbuQuerySetSQL(query, "select * from Person;"); | |
| 96 CxList *persons = dbuQuerySingleType(ctx, query, "person"); | |
| 93 if(persons) { | 97 if(persons) { |
| 94 CxIterator i = cxListIterator(persons); | 98 CxIterator i = cxListIterator(persons); |
| 95 cx_foreach(Person *, p, i) { | 99 cx_foreach(Person *, p, i) { |
| 96 printf("{ person_id = %" PRId64 ", name = \"%s\", email = \"%s\", age = %d, iscustomer = %s, hash = %" PRIu64 " }\n", | 100 printf("{ person_id = %" PRId64 ", name = \"%s\", email = \"%s\", age = %d, iscustomer = %s, hash = %" PRIu64 " }\n", |
| 97 p->person_id, p->name.ptr, p->email.ptr, p->age, p->iscustomer ? "true" : "false", p->hash); | 101 p->person_id, p->name.ptr, p->email.ptr, p->age, p->iscustomer ? "true" : "false", p->hash); |
| 98 } | 102 } |
| 99 } else { | 103 } else { |
| 100 fprintf(stderr, "Error\n"); | 104 fprintf(stderr, "Error\n"); |
| 101 } | 105 } |
| 102 | 106 |
| 103 sqlite3_close(db); | 107 conn->free(conn); |
| 104 | 108 |
| 105 return 0; | 109 return 0; |
| 106 } | 110 } |
| 107 | 111 |
| 108 static int create_test_data(sqlite3 *db) { | 112 static int create_test_data(sqlite3 *db) { |
