/**
  * Load SQL fixtures
  *
  * @param \Symfony\Component\Console\Input\InputInterface $input
  * @param \Symfony\Component\Console\Output\OutputInterface $output
  * @return void
  */
 protected function loadSqlFixtures(InputInterface $input, OutputInterface $output)
 {
     $finder = new Finder();
     $tmpdir = $this->getApplication()->getKernel()->getRootDir() . '/cache/propel';
     $datas = $finder->name('*.sql')->in($this->absoluteFixturesPath);
     $this->prepareCache($tmpdir);
     list($name, $defaultConfig) = $this->getConnection($input, $output);
     // Create a "sqldb.map" file
     $sqldbContent = '';
     foreach ($datas as $data) {
         $output->writeln(sprintf('<info>Loading SQL fixtures from</info> <comment>%s</comment>.', $data));
         $sqldbContent .= $data->getFilename() . '=' . $name . PHP_EOL;
         $this->filesystem->copy($data, $tmpdir . '/fixtures/' . $data->getFilename(), true);
     }
     if ('' === $sqldbContent) {
         return -1;
     }
     $sqldbFile = $tmpdir . '/fixtures/sqldb.map';
     file_put_contents($sqldbFile, $sqldbContent);
     if (!$this->insertSql($defaultConfig, $tmpdir . '/fixtures', $tmpdir, $output)) {
         return -1;
     }
     $this->filesystem->remove($tmpdir);
     return 0;
 }
 /**
  * @see Command
  *
  * @throws \InvalidArgumentException When the target directory does not exist
  */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     list($name, $defaultConfig) = $this->getConnection($input, $output);
     $this->callPhing('reverse', array('propel.project' => $name, 'propel.database.url' => $defaultConfig['connection']['dsn'], 'propel.database.database' => $defaultConfig['adapter'], 'propel.database.user' => $defaultConfig['connection']['user'], 'propel.database.password' => $defaultConfig['connection']['password']));
     $filesystem = new Filesystem();
     $dest = $this->getApplication()->getKernel()->getRootDir() . '/propel/' . $name . '_reversed_schema.xml';
     $filesystem->copy($this->getTmpDir() . '/schema.xml', $dest);
     $output->writeln(sprintf('New generated schema is <comment>%s</comment>.', $dest));
 }
 /**
  * @see Command
  *
  * @throws \InvalidArgumentException When the target directory does not exist
  */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     list($name, $defaultConfig) = $this->getConnection($input, $output);
     $this->callPhing('datadump', array('propel.database.url' => $defaultConfig['connection']['dsn'], 'propel.database.database' => $defaultConfig['adapter'], 'propel.database.user' => $defaultConfig['connection']['user'], 'propel.database.password' => $defaultConfig['connection']['password'], 'propel.schema.dir' => $this->getApplication()->getKernel()->getRootDir() . '/propel/schema/'));
     $finder = new Finder();
     $filesystem = new Filesystem();
     $datas = $finder->name('*_data.xml')->in($this->getTmpDir());
     foreach ($datas as $data) {
         $dest = $this->getApplication()->getKernel()->getRootDir() . self::$destPath . '/xml/' . $data->getFilename();
         $filesystem->copy((string) $data, $dest);
         $filesystem->remove($data);
         $output->writeln(sprintf('Wrote dumped data in "<info>%s</info>".', $dest));
     }
     if (count($datas) <= 0) {
         $output->writeln('No new dumped files.');
     }
 }
 /**
  * @see Command
  *
  * @throws \InvalidArgumentException When the target directory does not exist
  */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $container = $this->getApplication()->getKernel()->getContainer();
     $propelConfiguration = $container->get('propel.configuration');
     $name = $input->getOption('connection') ? $input->getOption('connection') : $container->getParameter('propel.dbal.default_connection');
     if (isset($propelConfiguration['datasources'][$name])) {
         $defaultConfig = $propelConfiguration['datasources'][$name];
     } else {
         throw new \InvalidArgumentException(sprintf('Connection named %s doesn\'t exist', $name));
     }
     $output->writeln(sprintf('<info>Generate XML schema from connection named <comment>%s</comment></info>', $name));
     $this->callPhing('reverse', array('propel.project' => $name, 'propel.database.url' => $defaultConfig['connection']['dsn'], 'propel.database.database' => $defaultConfig['adapter'], 'propel.database.user' => $defaultConfig['connection']['user'], 'propel.database.password' => $defaultConfig['connection']['password']));
     $filesystem = new Filesystem();
     $dest = $this->getApplication()->getKernel()->getRootDir() . '/propel/' . $name . '_reversed_schema.xml';
     $filesystem->copy($this->getTmpDir() . '/schema.xml', $dest);
     $output->writeln(sprintf('New generated schema is "<info>%s</info>".', $dest));
 }
 /**
  * @see Command
  *
  * @throws \InvalidArgumentException When the target directory does not exist
  */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $rootDir = $this->getApplication()->getKernel()->getRootDir();
     $schemaDir = $rootDir . '/propel/schema/';
     $sqlDir = $rootDir . '/propel/sql/';
     $xmlDumpDir = $rootDir . '/propel/dump/xml/';
     $filesystem = new Filesystem();
     $finder = new Finder();
     foreach ($finder->name('*_data.xml')->in($xmlDumpDir) as $data) {
         $filesystem->copy((string) $data, $schemaDir . $data->getFilename());
     }
     $this->callPhing('datasql', array('propel.sql.dir' => $sqlDir, 'propel.schema.dir' => $schemaDir));
     $finder = new Finder();
     foreach ($finder->name('*_data.xml')->in($schemaDir) as $data) {
         $filesystem->remove($data);
     }
     $this->summary($output, 'propel-data-sql');
     $output->writeln(sprintf('SQL from XML data dump file is in <comment>%s</comment>.', $sqlDir));
 }
Beispiel #6
0
 /**
  * @see Command
  *
  * @throws \InvalidArgumentException When the target directory does not exist
  */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $this->writeSection($output, '[Propel] You are running the command: propel:reverse');
     if ($input->getOption('verbose')) {
         $this->additionalPhingArgs[] = 'verbose';
     }
     list($name, $defaultConfig) = $this->getConnection($input, $output);
     $ret = $this->callPhing('reverse', array('propel.project' => $name, 'propel.database.url' => $defaultConfig['connection']['dsn'], 'propel.database.database' => $defaultConfig['adapter'], 'propel.database.user' => $defaultConfig['connection']['user'], 'propel.database.password' => isset($defaultConfig['connection']['password']) ? $defaultConfig['connection']['password'] : ''));
     if (true === $ret) {
         $filesystem = new Filesystem();
         $generated = $this->getCacheDir() . '/schema.xml';
         $filename = $name . '_reversed_schema.xml';
         $destFile = $this->getApplication()->getKernel()->getRootDir() . '/propel/generated-schemas/' . $filename;
         if (file_exists($generated)) {
             $filesystem->copy($generated, $destFile);
             $output->writeln(array('', sprintf('>>  <info>File+</info>    %s', $destFile)));
         } else {
             $output->writeln(array('', 'No generated files.'));
         }
     } else {
         $this->writeTaskError($output, 'reverse');
     }
 }
 /**
  * @see Command
  *
  * @throws \InvalidArgumentException When the target directory does not exist
  */
 protected function execute(InputInterface $input, OutputInterface $output)
 {
     $container = $this->getApplication()->getKernel()->getContainer();
     $propelConfiguration = $container->get('propel.configuration');
     $name = $input->getOption('connection') ? $input->getOption('connection') : $container->getParameter('propel.dbal.default_connection');
     if (isset($propelConfiguration['datasources'][$name])) {
         $defaultConfig = $propelConfiguration['datasources'][$name];
     } else {
         throw new \InvalidArgumentException(sprintf('Connection named %s doesn\'t exist', $name));
     }
     $output->writeln(sprintf('<info>Generate XML schema from connection named <comment>%s</comment></info>', $name));
     $this->callPhing('datadump', array('propel.database.url' => $defaultConfig['connection']['dsn'], 'propel.database.database' => $defaultConfig['adapter'], 'propel.database.user' => $defaultConfig['connection']['user'], 'propel.database.password' => $defaultConfig['connection']['password'], 'propel.schema.dir' => $this->getApplication()->getKernel()->getRootDir() . '/propel/schema/'));
     $finder = new Finder();
     $filesystem = new Filesystem();
     $datas = $finder->name('*_data.xml')->in($this->getTmpDir());
     foreach ($datas as $data) {
         $dest = $this->getApplication()->getKernel()->getRootDir() . self::$destPath . '/xml/' . $data->getFilename();
         $filesystem->copy((string) $data, $dest);
         $output->writeln(sprintf('Wrote dumped data in "<info>%s</info>".', $dest));
     }
     if (count($datas) <= 0) {
         $output->writeln('No new dumped files.');
     }
 }
Beispiel #8
0
 /**
  * Call a Phing task.
  *
  * @param string $taskName  A Propel task name.
  * @param array $properties An array of properties to pass to Phing.
  */
 protected function callPhing($taskName, $properties = array())
 {
     $kernel = $this->getApplication()->getKernel();
     $filesystem = new Filesystem();
     if (isset($properties['propel.schema.dir'])) {
         $this->tmpDir = $properties['propel.schema.dir'];
     } else {
         $this->tmpDir = sys_get_temp_dir() . '/propel-gen';
         $filesystem->remove($this->tmpDir);
         $filesystem->mkdir($this->tmpDir);
     }
     foreach ($kernel->getBundles() as $bundle) {
         if (is_dir($dir = $bundle->getPath() . '/Resources/config')) {
             $finder = new Finder();
             $schemas = $finder->files()->name('*schema.xml')->followLinks()->in($dir);
             $parts = explode(DIRECTORY_SEPARATOR, realpath($bundle->getPath()));
             $length = count(explode('\\', $bundle->getNamespace())) * -1;
             $prefix = implode('.', array_slice($parts, 1, $length));
             foreach ($schemas as $schema) {
                 $tempSchema = md5($schema) . '_' . $schema->getBaseName();
                 $this->tempSchemas[$tempSchema] = array('bundle' => $bundle->getName(), 'basename' => $schema->getBaseName(), 'path' => $schema->getPathname());
                 $file = $this->tmpDir . DIRECTORY_SEPARATOR . $tempSchema;
                 $filesystem->copy((string) $schema, $file);
                 // the package needs to be set absolute
                 // besides, the automated namespace to package conversion has not taken place yet
                 // so it needs to be done manually
                 $database = simplexml_load_file($file);
                 if (isset($database['package'])) {
                     $database['package'] = $prefix . '.' . $database['package'];
                 } elseif (isset($database['namespace'])) {
                     $database['package'] = $prefix . '.' . str_replace('\\', '.', $database['namespace']);
                 } else {
                     throw new \RuntimeException(sprintf('Please define a `package` attribute or a `namespace` attribute for schema `%s`', $schema->getBaseName()));
                 }
                 foreach ($database->table as $table) {
                     if (isset($table['package'])) {
                         $table['package'] = $prefix . '.' . $table['package'];
                     } elseif (isset($table['namespace'])) {
                         $table['package'] = $prefix . '.' . str_replace('\\', '.', $table['namespace']);
                     } else {
                         $table['package'] = $database['package'];
                     }
                 }
                 file_put_contents($file, $database->asXML());
             }
         }
     }
     // build.properties
     $this->buildPropertiesFile = $kernel->getRootDir() . '/config/propel.ini';
     $filesystem->touch($this->buildPropertiesFile);
     $filesystem->copy($this->buildPropertiesFile, $this->tmpDir . '/build.properties');
     // Required by the Phing task
     $this->createBuildTimeFile($this->tmpDir . '/buildtime-conf.xml');
     $args = array();
     $properties = array_merge(array('propel.database' => 'mysql', 'project.dir' => $this->tmpDir, 'propel.output.dir' => $kernel->getRootDir() . '/propel', 'propel.php.dir' => '/', 'propel.packageObjectModel' => true), $properties);
     $properties = array_merge($properties, $this->getContainer()->get('propel.build_properties')->getProperties());
     foreach ($properties as $key => $value) {
         $args[] = "-D{$key}={$value}";
     }
     // Build file
     $args[] = '-f';
     $args[] = realpath($this->getContainer()->getParameter('propel.path') . '/generator/build.xml');
     $bufferPhingOutput = !$this->getContainer()->getParameter('kernel.debug');
     // Add any arbitrary arguments last
     foreach ($this->additionalPhingArgs as $arg) {
         if (in_array($arg, array('verbose', 'debug'))) {
             $bufferPhingOutput = false;
         }
         $args[] = '-' . $arg;
     }
     $args[] = $taskName;
     // enable output buffering
     Phing::setOutputStream(new \OutputStream(fopen('php://output', 'w')));
     Phing::setErrorStream(new \OutputStream(fopen('php://output', 'w')));
     Phing::startup();
     Phing::setProperty('phing.home', getenv('PHING_HOME'));
     ob_start();
     $phing = new Phing();
     $returnStatus = true;
     // optimistic way
     try {
         $phing->execute($args);
         $phing->runBuild();
         $this->buffer = ob_get_contents();
         $returnStatus = false !== preg_match('#failed. Aborting.#', $this->buffer);
     } catch (Exception $e) {
         $returnStatus = false;
     }
     if ($bufferPhingOutput) {
         ob_end_clean();
     } else {
         ob_end_flush();
     }
     chdir($kernel->getRootDir());
     return $returnStatus;
 }
 /**
  * Create a 'build.properties' file.
  *
  * @param KernelInterface $kernel   The application kernel.
  * @param string $file  Should be 'build.properties'.
  */
 protected function createBuildPropertiesFile(KernelInterface $kernel, $file)
 {
     $filesystem = new Filesystem();
     $buildPropertiesFile = $kernel->getRootDir() . '/config/propel.ini';
     if (file_exists($buildPropertiesFile)) {
         $filesystem->copy($buildPropertiesFile, $file);
     } else {
         $filesystem->touch($file);
     }
 }