public function yieldMessages() {
            $query = "SELECT message_id FROM messages";
            
            foreach ($this->db->fetchAll($query) as $row) {
                yield new SiteMessage($row['message_id']);