8000 Fixture 2 migration by lsmith77 · Pull Request #90 · symfony/symfony · GitHub
[go: up one dir, main page]
Skip to content

Fixture 2 migration #90

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
3 commits merged into from
Feb 24, 2011
Merged

Fixture 2 migration #90

Changes from 1 commit
Commits
Show all changes
3 commits
Select commit Hold shift + click to select a range
0f353c1
A command to generate a migration from the sql queries executed when …
jwage Feb 23, 2011
988b8f3
initial steps to handling objects
lsmith77 Feb 24, 2011
e356c2a
cosmetic tweak
lsmith77 Feb 24, 2011
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
initial steps to handling objects
  • Loading branch information
@lsmith77
lsmith77 committed Feb 24, 2011
commit 988b8f37360cf53bd87be66f3b4d7ca7dcb1bb66
25 changes: 20 additions & 5 deletions ...ony/Bundle/DoctrineMigrationsBundle/Command/MigrationsGenerateFromDataFixturesCommand.php
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -22,6 +22,7 @@
use Doctrine\DBAL\Tools\Console\Helper\ConnectionHelper;
use Doctrine\DBAL\Migrations\Configuration\Configuration;
use Symfony\Bundle\DoctrineMigrationsBundle\SQLLogger\FixturesToMigrationSQLLogger;
use Symfony\Bundle\DoctrineMigrationsBundle\Command\DoctrineCommand;

/**
* Command for generating a Doctrine database migration class from a set of fixtures.
Expand Down Expand Up @@ -56,13 +57,14 @@ public function execute(InputInterface $input, OutputInterface $output)

DoctrineCommand::setApplicationEntityManager($this->application, $emName);

$configuration = $this->getMigrationConfiguration($input, $output);
DoctrineCommand::configureMigrations($this->application->getKernel()->getContainer(), $configuration);

$emServiceName = sprintf('doctrine.orm.%s_entity_manager', $emName);
$em = $container->get($emServiceName);

$em->getConnection()->getConfiguration()->setSQLLogger($sqlLogger);

$configuration = $this->getMigrationConfiguration($input, $output);

$dirOrFile = $input->getOption('fixtures');
if ($dirOrFile) {
$paths = is_array($dirOrFile) ? $dirOrFile : array($dirOrFile);
Expand All @@ -88,10 +90,23 @@ public function execute(InputInterface $input, OutputInterface $output)
$executor->execute($fixtures);

$queries = $sqlLogger->getQueries();
foreach ($queries as $key => $query) {
foreach ($query[1] as $key2 => $param) {
if (is_object($param)) {
if ($param instanceOf \DateTime) {
$queries[$key][1][$key2] = $param->format('Y-m-d\TH:i:s\Z');
} else if (in_array('__toString', get_class_methods($param))) {
$queries[$key][1][$key2] = (string)$param;
} else {
$output->writeln(sprintf(' <comment>></comment> <info>cannot convert object of type %s to a string</info>', get_class($param)));
}
}
}
}

$output->writeln(sprintf(' <comment>></comment> <info>%s queries logged</info>', count($queries)));
foreach ($queries as $query) {
$output->writeln(sprintf(' <comment>-</comment> <info>%s (%s)</info>', $query[0], implode(',', $query[1])));
$output->writeln(sprintf(' <comment>-</comment> <info>%s (parameters? %s)</info>', $query[0], is_array($query[1]) ? 'yes' : 'no'));
}

$version = date('YmdHis');
Expand All @@ -110,8 +125,8 @@ private function buildCodeFromSql(Configuration $configuration, array $queries)
if (strpos($query[0], $configuration->getMigrationsTableName()) !== false) {
continue;
}
$code[] = sprintf("\$this->_addSql(\"%s\", %s);", $query[0], var_export($query[1], true));
$code[] = sprintf("\$this->addSql(\"%s\", %s);", $query[0], var_export($query[1], true));
}
return implode("\n", $code);
}
}
}
0