setName('wallabag:generate-hashed-urls') ->setDescription('Generates hashed urls for each entry') ->setHelp('This command helps you to generates hashes of the url of each entry, to check through API if an URL is already saved') ->addArgument( 'username', InputArgument::OPTIONAL, 'User to process entries' ); } protected function execute(InputInterface $input, OutputInterface $output) { $this->output = $output; $username = $input->getArgument('username'); if ($username) { try { $user = $this->getUser($username); $this->generateHashedUrls($user); } catch (NoResultException $e) { $output->writeln(sprintf('User "%s" not found.', $username)); return 1; } } else { $users = $this->getDoctrine()->getRepository('WallabagUserBundle:User')->findAll(); $output->writeln(sprintf('Generating hashed urls for "%d" users', \count($users))); foreach ($users as $user) { $output->writeln(sprintf('Processing user: %s', $user->getUsername())); $this->generateHashedUrls($user); } $output->writeln('Finished generated hashed urls'); } return 0; } /** * @param User $user */ private function generateHashedUrls(User $user) { $em = $this->getContainer()->get('doctrine.orm.entity_manager'); $repo = $this->getDoctrine()->getRepository('WallabagCoreBundle:Entry'); $entries = $repo->findByUser($user->getId()); $i = 1; foreach ($entries as $entry) { $entry->setHashedUrl(hash('md5', $entry->getUrl())); $em->persist($entry); if (0 === ($i % 20)) { $em->flush(); } ++$i; } $em->flush(); $this->output->writeln(sprintf('Generated hashed urls for user: %s', $user->getUserName())); } /** * Fetches a user from its username. * * @param string $username * * @return \Wallabag\UserBundle\Entity\User */ private function getUser($username) { return $this->getDoctrine()->getRepository('WallabagUserBundle:User')->findOneByUserName($username); } private function getDoctrine() { return $this->getContainer()->get('doctrine'); } }