From 18dc4c5a4cb46f01ebdd49fbb6baa3c48d8f3b3d Mon Sep 17 00:00:00 2001 From: Boris Kolpackov Date: Thu, 25 Aug 2011 11:02:20 +0200 Subject: Add experimental code (commented out) for DELETE JOIN support This would be needed to support object relationships in the erase_query() functionality. --- common/erase-query/driver.cxx | 35 ++++++++++++++++++++++++++++++++++- common/erase-query/test.hxx | 19 ++++++++++++++++++- 2 files changed, 52 insertions(+), 2 deletions(-) (limited to 'common') diff --git a/common/erase-query/driver.cxx b/common/erase-query/driver.cxx index 67d4e8d..2137377 100644 --- a/common/erase-query/driver.cxx +++ b/common/erase-query/driver.cxx @@ -63,7 +63,8 @@ main (int argc, char* argv[]) { transaction t (db->begin ()); - assert (db->erase_query ("id < 3") == 2); + assert (db->erase_query ( + "common_erase_query_object.id < 3") == 2); db->erase_query (); t.commit (); } @@ -79,6 +80,38 @@ main (int argc, char* argv[]) t.commit (); } + // Test predicates involving object pointers (DELETE JOIN). + // + /* + { + object o11 (1); + object o12 (2); + object o13 (3); + object2 o2; + + o11.o2 = &o2; + o2.num = 123; + + o12.o1 = &o13; + o13.num = 123; + + transaction t (db->begin ()); + db->persist (o2); + db->persist (o13); + db->persist (o12); + db->persist (o11); + t.commit (); + } + + { + transaction t (db->begin ()); + assert (db->erase_query (query::o1::num == 123) == 1); + assert (db->erase_query (query::o2::num == 123) == 1); + db->erase_query (); + t.commit (); + } + */ + // Make sure container data is deleted. // { diff --git a/common/erase-query/test.hxx b/common/erase-query/test.hxx index be5539f..781eedd 100644 --- a/common/erase-query/test.hxx +++ b/common/erase-query/test.hxx @@ -10,15 +10,18 @@ #include +struct object2; + #pragma db object struct object { object (unsigned long id) - : id_ (id) + : id_ (id), o1 (0), o2 (0) { } object () + : o1 (0), o2 (0) { } @@ -26,6 +29,20 @@ struct object unsigned long id_; std::vector v; + + int num; + + object* o1; + object2* o2; +}; + +#pragma db object +struct object2 +{ + #pragma db id auto + unsigned long id_; + + int num; }; #endif // TEST_HXX -- cgit v1.1