sonata-project / SonataNewsBundle

src/Entity/CommentManager.php

Unused Use Statements -21 removed lines

@@ -132,24 +132,3 @@
         switch ($this->getConnection()->getDriver()->getDatabasePlatform()->getName()) {
             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
-                );
-        }
-    }
-}