Mercurial > hg > dbutils / file diff

--- a/test/main.c	Sat Dec 07 23:10:03 2024 +0100
+++ b/test/main.c	Sun Dec 08 15:46:03 2024 +0100
@@ -31,6 +31,7 @@
 
 #include <dbutils/dbutils.h>
 #include <dbutils/sqlite.h>
+#include <dbutils/db.h>
 
 const char *sql_create_table_person =
 "create table if not exists Person ("
@@ -89,7 +90,10 @@
         return 1;
     }
     
-    CxList *persons = dbuSQLiteQuerySingleTable(ctx, db, "person", "select * from Person;");
+    DBUConnection *conn = dbuSQLiteConnectionFromDB(db, true);
+    DBUQuery *query = conn->createQuery(conn, NULL);
+    dbuQuerySetSQL(query, "select * from Person;");
+    CxList *persons = dbuQuerySingleType(ctx, query, "person");
     if(persons) {
         CxIterator i = cxListIterator(persons);
         cx_foreach(Person *, p, i) {
@@ -100,7 +104,7 @@
         fprintf(stderr, "Error\n");
     }
     
-    sqlite3_close(db);
+    conn->free(conn);
     
     return 0;
 }