Mercurial > hg > dbutils / file diff

--- a/test/database.c	Tue Dec 30 21:07:45 2025 +0100
+++ b/test/database.c	Wed Dec 31 15:40:44 2025 +0100
@@ -310,45 +310,6 @@
         CX_TEST_ASSERT(!cx_strcmp(p1->address->city, "city 18"));
         
         dbuObjectBuilderDestroy(builder);
-        
-        const char *sql2 = "select p.*, "
-                           "a.address_id as [__address__address_id], a.street, a.zip, a.city, "
-                           "c.country_id as [__country__country_id], c.name "
-                           "from Person p inner join Address a on p.address_id = a.address_id inner join Country c on a.country_id = c.country_id "
-                           "order by p.person_id;";
-        DBUQuery *query2 = dbuQueryCreate(conn, mp->allocator, sql2);
-        DBUObjectBuilder *builder2 = dbuObjectBuilder(person, query2, mp->allocator);
-        CxList *persons2 = dbuObjectBuilderGetList(builder2);
-        
-        CX_TEST_ASSERT(persons2);
-        CX_TEST_ASSERT(cxListSize(persons2) == 2);
-        
-        p0 = cxListAt(persons2, 0);
-        p1 = cxListAt(persons2, 1);
-        CX_TEST_ASSERT(p0);
-        CX_TEST_ASSERT(p1);
-        CX_TEST_ASSERT(!cx_strcmp(p0->name, "alice"));
-        CX_TEST_ASSERT(!cx_strcmp(p1->name, "bob"));
-        CX_TEST_ASSERT(!cx_strcmp(p0->email, "alice@example.com"));
-        CX_TEST_ASSERT(!cx_strcmp(p1->email, "bob@example.com"));
-        CX_TEST_ASSERT(p0->age == 30);
-        CX_TEST_ASSERT(p1->age == 25);
-        CX_TEST_ASSERT(p0->iscustomer == 0);
-        CX_TEST_ASSERT(p1->iscustomer == 1);
-        CX_TEST_ASSERT(p0->hash == 123456789);
-        CX_TEST_ASSERT(p1->hash == 987654321);
-        
-        CX_TEST_ASSERT(p0->address != NULL);
-        CX_TEST_ASSERT(p1->address != NULL);
-        
-        CX_TEST_ASSERT(!cx_strcmp(p0->address->street, "street 1"));
-        CX_TEST_ASSERT(!cx_strcmp(p1->address->street, "street 2"));
-        CX_TEST_ASSERT(!cx_strcmp(p0->address->zip, "12343"));
-        CX_TEST_ASSERT(!cx_strcmp(p1->address->zip, "23456"));
-        CX_TEST_ASSERT(!cx_strcmp(p0->address->city, "city 17"));
-        CX_TEST_ASSERT(!cx_strcmp(p1->address->city, "city 18"));
-        
-        dbuObjectBuilderDestroy(builder2);
     }
     
     cxMempoolFree(mp);
@@ -395,6 +356,11 @@
         CX_TEST_ASSERT(!cx_strcmp(p0->address->city, "city 17"));
         CX_TEST_ASSERT(!cx_strcmp(p1->address->city, "city 18"));
         
+        CX_TEST_ASSERT(p0->address->country);
+        CX_TEST_ASSERT(p1->address->country);
+        CX_TEST_ASSERT(!cx_strcmp(p0->address->country->name, "Germany"));
+        CX_TEST_ASSERT(!cx_strcmp(p1->address->country->name, "Germany"));
+        
         dbuObjectBuilderDestroy(builder);
     }