zend-blog-3-backend

1
CREATE PROCEDURE update_all_comments_count()
2
  BEGIN
3
    DECLARE done BOOLEAN DEFAULT FALSE;
4
    DECLARE post_id INT UNSIGNED;
5
    DECLARE cur CURSOR FOR SELECT id FROM posts;
6
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done := TRUE;
7

8
    OPEN cur;
9

10
    post_loop: LOOP
11
      FETCH cur INTO post_id;
12
      IF done THEN
13
        LEAVE post_loop;
14
      END IF;
15
      CALL update_comments_count(post_id);
16
    END LOOP post_loop;
17

18
    CLOSE cur;
19
  END
20