sonata-project / SonataNewsBundle

src/Entity/CommentManager.php

Doc Comments -22 removed lines

@@ -133,25 +133,3 @@
             case 'postgresql':
                 return sprintf(
                     <<<'SQL'
-UPDATE %s SET comments_count = count_comment.total
-FROM (SELECT c.post_id, count(*) AS total FROM %s AS c WHERE c.status = 1 GROUP BY c.post_id) count_comment
-WHERE %s.id = count_comment.post_id
-SQL,
-                    $postTableName,
-                    $commentTableName,
-                    $postTableName
-                );
-
-            default:
-                return sprintf(
-                    <<<'SQL'
-UPDATE %s p, (SELECT c.post_id, count(*) as total FROM %s as c WHERE c.status = 1 GROUP BY c.post_id) as count_comment
-SET p.comments_count = count_comment.total
-WHERE p.id = count_comment.post_id
-SQL,
-                    $postTableName,
-                    $commentTableName
-                );
-        }
-    }
-}

Unused Use Statements -22 removed lines

@@ -133,25 +133,3 @@
             case 'postgresql':
                 return sprintf(
                     <<<'SQL'
-UPDATE %s SET comments_count = count_comment.total
-FROM (SELECT c.post_id, count(*) AS total FROM %s AS c WHERE c.status = 1 GROUP BY c.post_id) count_comment
-WHERE %s.id = count_comment.post_id
-SQL,
-                    $postTableName,
-                    $commentTableName,
-                    $postTableName
-                );
-
-            default:
-                return sprintf(
-                    <<<'SQL'
-UPDATE %s p, (SELECT c.post_id, count(*) as total FROM %s as c WHERE c.status = 1 GROUP BY c.post_id) as count_comment
-SET p.comments_count = count_comment.total
-WHERE p.id = count_comment.post_id
-SQL,
-                    $postTableName,
-                    $commentTableName
-                );
-        }
-    }
-}