/** * @param InputInterface $input * @param OutputInterface $output * @param bool $export * @return void */ protected function port(InputInterface $input, OutputInterface $output, $export = true) { $entities = $this->getEntities($input->getOption('list')); $em = $this->getContainer()->get('orm.em'); $porter = new Porter(new OutputLogger($output)); $porter->registerManager('PRIMARY', $em); $io = new PharIoDriver($input->getOption($export ? 'output' : 'input'), ArchiveType::memberByKey(strtoupper($input->getOption('format')))); $driver = new FilesystemDriver($io); $aux = EntityManager::build($driver, $em->getMapper(), $em->getSerialiserMap()); $porter->registerManager('AUX', $aux); $batch_size = max(1, min(1000, (int) $input->getOption('batch'))); $term = $export ? 'Exporting' : 'Importing'; foreach ($entities as $class_name) { $output->writeln($term . " <info>" . $class_name . "</info>.."); try { if ($export) { $porter->portTable($class_name, 'PRIMARY', 'AUX', $batch_size); } else { $porter->portTable($class_name, 'AUX', 'PRIMARY', $batch_size); } } catch (\Exception $e) { $output->writeln("<error>ERROR:</error> " . $e->getMessage()); } } if ($export) { $output->writeln("<comment>EXPORT COMPLETE</comment>"); } else { $output->writeln("<comment>IMPORT COMPLETE</comment>"); } }
public function testPortation() { $mapper = new AnnotationMapper(); $src = EntityManager::build($this->getRedisDriver(), $mapper); $dest = EntityManager::build($this->getFsDriver('porter-db'), $mapper); $porter = new Porter(); $porter->registerManager('redis', $src); $porter->registerManager('tar', $dest); // Create some dummy data $category = new Category(); $category->setId(600); $src->persist($category); for ($i = 0; $i < 15; $i++) { $article = new Article(); $article->setId(601 + $i); $article->setTitle('Art ' . (601 + $i)); $time = new \DateTime(); $time->modify('+' . ($i + 1) . ' minutes'); $article->setSortDate($time); $article->setCanonicalCategory($category); $src->persist($article); } $src->flush(); // Port the database $porter->portTable(Article::class, 'redis', 'tar'); $porter->portTable(Category::class, 'redis', 'tar'); // Check entity counts $articles = $dest->indexedQuery(new IndexedQuery(Article::class, ['@id' => '*']), false); $this->assertCount(15, $articles); $categories = $dest->indexedQuery(new IndexedQuery(Category::class, ['@id' => '*']), false); $this->assertCount(1, $categories); // Test indices were preserved /** @var Article $article */ // Date sorting - $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'sort_date')); $this->assertCount(15, $results); $article = $results[0]; $this->assertEquals('Art 601', $article->getTitle()); $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'sort_date', Direction::DESC())); $this->assertCount(15, $results); $this->assertEquals(15, $results->getFullSize()); $article = $results[0]; $this->assertEquals('Art 615', $article->getTitle()); $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'sort_date', Direction::DESC(), 5, -6), true); $this->assertCount(5, $results); $this->assertEquals(15, $results->getFullSize()); $article = $results[0]; $this->assertEquals('Art 610', $article->getTitle()); $article = $results[4]; $this->assertEquals('Art 606', $article->getTitle()); $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'sort_date', Direction::ASC(), 2, 5)); $this->assertCount(4, $results); $this->assertNull($results->getFullSize()); $article = $results[0]; $this->assertEquals('Art 603', $article->getTitle()); $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'sort_date', Direction::ASC(), 20, 29)); $this->assertCount(0, $results); $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'title')); $this->assertCount(15, $results); $article = $results[0]; $this->assertEquals('Art 601', $article->getTitle()); // Lexicographic sorting - $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'title')); $this->assertCount(15, $results); $article = $results[0]; $this->assertEquals('Art 601', $article->getTitle()); $results = $dest->sortedQuery(new SortedQuery($category, 'articles', 'title', Direction::DESC())); $this->assertCount(15, $results); $article = $results[0]; $this->assertEquals('Art 615', $article->getTitle()); }