--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/Command/ReorderTagsCommand.php	Wed Nov 09 16:25:13 2011 +0100
@@ -0,0 +1,88 @@
+<?php
+/*
+ * This file is part of the WikiTagBundle package.
+ *
+ * (c) IRI <http://www.iri.centrepompidou.fr/>
+ *
+ * For the full copyright and license information, please view the LICENSE
+ * file that was distributed with this source code.
+ */
+
+namespace IRI\Bundle\WikiTagBundle\Command;
+
+use Symfony\Bundle\FrameworkBundle\Command\ContainerAwareCommand;
+use Symfony\Component\Console\Input\InputArgument;
+use Symfony\Component\Console\Input\InputInterface;
+use Symfony\Component\Console\Input\InputOption;
+use Symfony\Component\Console\Output\OutputInterface;
+
+class ReorderTagsCommand extends ContainerAwareCommand
+{
+    
+    protected function configure()
+    {
+        parent::configure();
+    
+        $this
+        ->setName('wikitag:reorder-tags')
+        ->setDescription('Reorder tags')
+        ->addOption("force","f",InputOption::VALUE_NONE, "Force all reorder");
+    }
+    
+    
+    protected function execute(InputInterface $input, OutputInterface $output)
+    {
+        $doctrine = $this->getContainer()->get('doctrine');
+        $configuration = $doctrine->getConnection()->getConfiguration();
+        $configuration->setSQLLogger(null);
+        
+        $force = $input->getOption('force');
+        
+        if($force)
+        {
+            $query = $doctrine->getEntityManager()->createQuery("SELECT doc from WikiTagBundle:Document doc");
+            $querycount = $doctrine->getEntityManager()->createQuery("SELECT count(doc) from WikiTagBundle:Document doc");
+        }
+        else
+        {
+            $query = $doctrine->getEntityManager()->createQuery("SELECT doc from WikiTagBundle:Document doc WHERE doc.manualOrder = FALSE");
+            $querycount = $doctrine->getEntityManager()->createQuery("SELECT count(doc) from WikiTagBundle:Document doc WHERE doc.manualOrder = FALSE");
+        }
+        
+        $total = $querycount->getSingleScalarResult();
+        $search_service = $this->getContainer()->get('wiki_tag.search');
+        
+        $done = 0;
+        $iterable = $query->iterate();
+        $todetach = array();
+        while (($row = $iterable->next()) !== false)
+        {
+            $done++;
+            $doc = $row[0];
+            
+            $output->writeln("Process doc id ".$doc->getId()." $done/$total ".strval(intval(floatval($done)/floatval($total)*100.0))."%");
+            
+            $doc->setManualOrder(false);
+            $doctrine->getEntityManager()->persist($doc);
+            
+            $search_service->reorderTagsForDocument($doc);
+            $todetach[] = $doc;
+            
+            
+            if($done%100 == 0)
+            {
+                $doctrine->getEntityManager()->flush();
+                $doctrine->getEntityManager()->clear();
+                /*foreach($todetach as $obj)
+                {
+                    $doctrine->getEntityManager()->detach($obj);
+                }*/
+                $todetach = array();
+                $output->writeln("memory : ".strval(memory_get_usage(true)));
+            }
+            
+        }
+        
+    }
+
+}