3: models/question_model and models/answer_model: Delete Functions

[AbdulRazzaq]

Create functions for cascading delete for Questions and Answers.

If a question is deleted, delete all its comments and all its answers. If an answer is deleted, delete all its comments. Return the number of deletions and 0 if the item to delete was not found Find a solution for the deletions of users (why can't we just delete them like now?). How can it be done, should we cascade on delete? Develop a strategy and implement it.

[tilman-schieber]

Wrap up last week's task:

• modify tables.sql: add anonymous user that is of userTypeID TYPE_DEACTIVATED
• introduce a constant with the UserID of anonymous
• implement the User_model::delete($x,ANONYMIZE)
• test if the different deletions (especially cascade) is working correctly
• make sure documentation is up to date

Add Deletion Functionality

• every displayed question and answer that belongs to the user should have a delete button (use image)
• decide if the button is displayed inside the view (compare question->userID to $this->session->userdata('uid') )
• call the appropriate model delete functions but make sure there is a confirmation dialog (use controller methods OR javascript)
• make sure the User_model::login function returns false if the user is deactivated

[jonassanoj]

Wrap up last week's task:

• modify tables.sql: add anonymous user that is of userTypeID TYPE_DEACTIVATED

complete

• introduce a constant with the UserID of anonymous

complete

• implement the User_model::delete($x,ANONYMIZE)

complete

• test if the different deletions (especially cascade) is working correctly

complete

• make sure documentation is up to date

complete

Add Deletion Functionality

• every displayed question and answer that belongs to the user should have a delete button (use image)
• decide if the button is displayed inside the view (compare question->userID to $this->session->userdata('uid') )
• call the appropriate model delete functions but make sure there is a confirmation dialog (use controller methods OR javascript)
• make sure the User_model::login function returns false if the user is deactivated

duplicate with question group