Changeset c8b84e1


Ignore:
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:
2 edited

Legend:

Unmodified
Added
Removed
  • BUGS

    rbad5e8a rc8b84e1  
    55BugId: 1
    66Title: Persons are not deleted when deleting a conference.
     7Status: Fixed.
    78-------------------------------------------------------------------
    89BugId: 2
    910Title: SQL injections possible.
     11Status:
    1012-------------------------------------------------------------------
  • src/sql/sqlengine.cpp

    rbad5e8a rc8b84e1  
    349349    execQueryWithParameter(db, "DELETE FROM EVENT_PERSON WHERE xid_conference = :xid_conference", params);
    350350    execQueryWithParameter(db, "DELETE FROM EVENT WHERE xid_conference = :xid_conference", params);
     351    execQueryWithParameter(db, "DELETE FROM ROOM WHERE xid_conference = :xid_conference", params);
     352    execQueryWithParameter(db, "DELETE FROM PERSON WHERE xid_conference = :xid_conference", params);
     353    execQueryWithParameter(db, "DELETE FROM TRACK WHERE xid_conference = :xid_conference", params);
    351354    execQueryWithParameter(db, "DELETE FROM CONFERENCE WHERE id = :xid_conference", params);
    352     execQuery(db, "DELETE FROM ROOM WHERE NOT EXISTS(SELECT * FROM EVENT_ROOM WHERE xid_room = ROOM.id)");
    353     execQuery(db, "DELETE FROM PERSON WHERE NOT EXISTS(SELECT * FROM EVENT_PERSON WHERE xid_person = PERSON.id)");
    354355
    355356    commitTransaction();
Note: See TracChangeset for help on using the changeset viewer.