Ejemplo n.º 1
0
 public function delete_from_database()
 {
     $this->runCallbacks('destroy', function () {
         $this->delete_file();
         self::connection()->executeSql('UPDATE pools SET post_count = post_count - 1 WHERE id IN (SELECT pool_id FROM pools_posts WHERE post_id = ?)', $this->id);
         self::connection()->executeSql('UPDATE tags SET post_count = post_count - 1 WHERE id IN (SELECT tag_id FROM posts_tags WHERE post_id = ?)', $this->id);
         # MI: Destroying pool posts manually so their histories are deleted by foreign keys.
         # This is done in Pool too. This could be done with a MySQL trigger.
         PoolPost::destroyAll('post_id = ?', $this->id);
         self::connection()->executeSql("DELETE FROM posts WHERE id = ?", $this->id);
     });
 }
Ejemplo n.º 2
0
 protected function destroy_pool_posts()
 {
     PoolPost::destroyAll('pool_id = ?', $this->id);
 }