/**
* @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());
}
