Changeset c8b84e1

Timestamp:

06/22/11 23:07:29 (10 years ago)

Author:

Philipp Spitzer <philipp@…>

Branches:

master, qt5

Children:

4b8ce66

Parents:

bad5e8a

Message:

Persons are deleted now when a conference is removed.

Files:

• BUGS (modified) (1 diff)
• src/sql/sqlengine.cpp (modified) (1 diff)

BUGS

@@ -5 +5 @@
 BugId: 1
 Title: Persons are not deleted when deleting a conference.
+Status: Fixed.
 -------------------------------------------------------------------
 BugId: 2
 Title: SQL injections possible.
+Status: 
 -------------------------------------------------------------------

src/sql/sqlengine.cpp

@@ -349 +349 @@
     execQueryWithParameter(db, "DELETE FROM EVENT_PERSON WHERE xid_conference = :xid_conference", params);
     execQueryWithParameter(db, "DELETE FROM EVENT WHERE xid_conference = :xid_conference", params);
+    execQueryWithParameter(db, "DELETE FROM ROOM WHERE xid_conference = :xid_conference", params);
+    execQueryWithParameter(db, "DELETE FROM PERSON WHERE xid_conference = :xid_conference", params);
+    execQueryWithParameter(db, "DELETE FROM TRACK WHERE xid_conference = :xid_conference", params);
     execQueryWithParameter(db, "DELETE FROM CONFERENCE WHERE id = :xid_conference", params);
-    execQuery(db, "DELETE FROM ROOM WHERE NOT EXISTS(SELECT * FROM EVENT_ROOM WHERE xid_room = ROOM.id)");
-    execQuery(db, "DELETE FROM PERSON WHERE NOT EXISTS(SELECT * FROM EVENT_PERSON WHERE xid_person = PERSON.id)");
 
     commitTransaction();