protected function schemaToXML($checkSchema = self::CHECK_SCHEMA, $prefix = '', $verbose = false)
{
$finder = sfFinder::type('file')->name('*schema.yml')->prune('doctrine');
$dirs = array_merge(array(sfConfig::get('sf_config_dir')), $this->configuration->getPluginSubPaths('/config'));
$schemas = $finder->in($dirs);
if (self::CHECK_SCHEMA === $checkSchema && !count($schemas)) {
throw new sfCommandException('You must create a schema.yml file.');
}
$dbSchema = new sfPropelDatabaseSchema();
foreach ($schemas as $schema) {
$this->logSection('convert-xml', $schema);
$schemaArray = sfYaml::load($schema);
if (!is_array($schemaArray)) {
continue;
// No defined schema here, skipping
}
if (!isset($schemaArray['classes'])) {
// Old schema syntax: we convert it
$schemaArray = $dbSchema->convertOldToNewYaml($schemaArray);
}
$customSchemaFilename = str_replace(array(str_replace(DIRECTORY_SEPARATOR, '/', sfConfig::get('sf_root_dir')) . '/', 'plugins/', 'config/', '/', 'schema.yml'), array('', '', '', '_', 'schema.custom.yml'), $schema);
$customSchemas = sfFinder::type('file')->name($customSchemaFilename)->in($dirs);
foreach ($customSchemas as $customSchema) {
if ($verbose) {
$this->logSection('schema', sprintf(' found custom schema %s', $customSchema), null, 'COMMENT');
}
$customSchemaArray = sfYaml::load($customSchema);
if (!isset($customSchemaArray['classes'])) {
// Old schema syntax: we convert it
$customSchemaArray = $dbSchema->convertOldToNewYaml($customSchemaArray);
}
$schemaArray = sfToolkit::arrayDeepMerge($schemaArray, $customSchemaArray);
}
$dbSchema->loadArray($schemaArray);
if ($verbose) {
$this->logSection('schema', sprintf(' converting "%s" to XML', $schema), null, 'COMMENT');
}
$localprefix = $prefix;
// change prefix for plugins
foreach ($this->configuration->getPlugins() as $plugin) {
$plugin_config = $this->configuration->getPluginConfiguration((string) $plugin);
$plugin_root_dir = rtrim($plugin_config->getRootDir(), '/') . '/';
// if $schema starts with $plugin_root_dir
if (substr($schema, 0, strlen($plugin_root_dir)) === $plugin_root_dir) {
$localprefix = $prefix . $plugin_config->getName() . '-';
break;
}
}
// save converted xml files in original directories
$xml_file_name = str_replace('.yml', '.xml', basename($schema));
$file = str_replace(basename($schema), $localprefix . $xml_file_name, $schema);
if ($verbose) {
$this->logSection('schema', sprintf(' putting %s', $file), null, 'COMMENT');
}
file_put_contents($file, $dbSchema->asXML());
}
}
protected function schemaToXML($checkSchema = self::CHECK_SCHEMA, $prefix = '')
{
$finder = sfFinder::type('file')->name('*schema.yml');
$dirs = array('config');
if ($pluginDirs = glob(sfConfig::get('sf_plugins_dir') . '/*/config')) {
$dirs = array_merge($dirs, $pluginDirs);
}
$schemas = $finder->in($dirs);
if (self::CHECK_SCHEMA === $checkSchema && !count($schemas)) {
throw new sfCommandException('You must create a schema.yml file.');
}
$dbSchema = new sfPropelDatabaseSchema();
foreach ($schemas as $schema) {
$schemaArray = sfYaml::load($schema);
if (!is_array($schemaArray)) {
continue;
// No defined schema here, skipping
}
if (!isset($schemaArray['classes'])) {
// Old schema syntax: we convert it
$schemaArray = $dbSchema->convertOldToNewYaml($schemaArray);
}
$customSchemaFilename = str_replace(array(str_replace(DIRECTORY_SEPARATOR, '/', sfConfig::get('sf_root_dir')) . '/', 'plugins/', 'config/', '/', 'schema.yml'), array('', '', '', '_', 'schema.custom.yml'), $schema);
$customSchemas = sfFinder::type('file')->name($customSchemaFilename)->in($dirs);
foreach ($customSchemas as $customSchema) {
$this->logSection('schema', sprintf('found custom schema %s', $customSchema));
$customSchemaArray = sfYaml::load($customSchema);
if (!isset($customSchemaArray['classes'])) {
// Old schema syntax: we convert it
$customSchemaArray = $dbSchema->convertOldToNewYaml($customSchemaArray);
}
$schemaArray = sfToolkit::arrayDeepMerge($schemaArray, $customSchemaArray);
}
$dbSchema->loadArray($schemaArray);
$this->logSection('schema', sprintf('converting "%s" to XML', $schema));
$localprefix = $prefix;
// change prefix for plugins
if (preg_match('#plugins[/\\\\]([^/\\\\]+)[/\\\\]#', $schema, $match)) {
$localprefix = $prefix . $match[1] . '-';
}
// save converted xml files in original directories
$xml_file_name = str_replace('.yml', '.xml', basename($schema));
$file = str_replace(basename($schema), $localprefix . $xml_file_name, $schema);
$this->logSection('schema', sprintf('putting %s', $file));
file_put_contents($file, $dbSchema->asXML());
}
}
$t = new my_lime_test(409);
$t->diag('Classical YAML to XML conversion');
$p = new sfPropelDatabaseSchema();
$p->loadYAML(dirname(__FILE__) . '/fixtures/schema.yml');
$target = file_get_contents(dirname(__FILE__) . '/fixtures/schema.xml');
$t->is_line_by_line($p->asXML(), $target);
$t->diag('New YAML to XML conversion');
$p = new sfPropelDatabaseSchema();
$p->loadYAML(dirname(__FILE__) . '/fixtures/new_schema.yml');
$target = file_get_contents(dirname(__FILE__) . '/fixtures/schema.xml');
$t->is_line_by_line($p->asXML(), $target);
$t->diag('New YAML to Old YAML conversion');
$old_yml_target = sfYaml::load(dirname(__FILE__) . '/fixtures/schema.yml');
$p = new sfPropelDatabaseSchema();
$new_yml_transformed = $p->convertNewToOldYaml(sfYaml::load(dirname(__FILE__) . '/fixtures/new_schema.yml'));
$t->is_array_explicit($new_yml_transformed, $old_yml_target);
$t->diag('Old YAML to New YAML conversion');
$new_yml_target = sfYaml::load(dirname(__FILE__) . '/fixtures/new_schema.yml');
$p = new sfPropelDatabaseSchema();
$old_yml_transformed = $p->convertOldToNewYaml(sfYaml::load(dirname(__FILE__) . '/fixtures/schema.yml'));
$t->is_array_explicit($old_yml_transformed, $new_yml_target);
$t->todo('XML and classical YAML internal representation');
$p1 = new sfPropelDatabaseSchema();
$p1->loadXML(dirname(__FILE__) . '/fixtures/schema.xml');
$p2 = new sfPropelDatabaseSchema();
$p2->loadYAML(dirname(__FILE__) . '/fixtures/schema.yml');
//$t->is_array_explicit($p1->asArray(), $p2->asArray());
$t->todo('XML and classical YAML compared as XML');
//$t->is_line_by_line($p1->asXML(), $p2->asXML());
$t->todo('XML and classical YAML compared as YAML');
//$t->is_line_by_line($p1->asYAML(), $p2->asYAML());
/**
* Getting schemas array from configs
*
* @return array - Connections and tables
* @author Sergey Startsev
*/
private static function getSchemas()
{
$aPropelSchemaArray = array();
$configuration = new ProjectConfiguration(null, new sfEventDispatcher());
$db_schema = new sfPropelDatabaseSchema();
$dirs = array_merge(array(sfConfig::get('sf_config_dir')), $configuration->getPluginSubPaths('/config'));
foreach ($dirs as $k => $dir) {
if (substr_count($dir, 'appFlower') > 0 || substr_count($dir, 'sfPropelPlugin') > 0 || substr_count($dir, 'sfProtoculousPlugin') > 0) {
unset($dirs[$k]);
}
}
$dirs = array_values($dirs);
$schemas = sfFinder::type('file')->name('*schema.yml')->prune('doctrine')->in($dirs);
foreach ($schemas as $schema_path) {
$schema = DIRECTORY_SEPARATOR != '/' ? str_replace('/', DIRECTORY_SEPARATOR, $schema_path) : $schema_path;
$aOriginalSchemaArray[$schema] = sfYaml::load($schema);
if (!is_array($aOriginalSchemaArray[$schema])) {
$aOriginalSchemaArray[$schema];
continue;
// No defined schema here, skipping
}
if (!isset($aOriginalSchemaArray[$schema]['classes'])) {
// Old schema syntax: we convert it
$aPropelSchemaArray[$schema] = $db_schema->convertOldToNewYaml($aOriginalSchemaArray[$schema]);
}
$customSchemaFilename = str_replace(array(str_replace(DIRECTORY_SEPARATOR, '/', sfConfig::get('sf_root_dir')) . '/', 'plugins/', 'config/', '/', 'schema.yml'), array('', '', '', '_', 'schema.custom.yml'), $schema);
$customSchemas = sfFinder::type('file')->name($customSchemaFilename)->in($dirs);
foreach ($customSchemas as $customSchema) {
$aOriginalSchemaArray[$customSchema] = sfYaml::load($customSchema);
if (!isset($aOriginalSchemaArray[$customSchema]['classes'])) {
// Old schema syntax: we convert it
$aPropelSchemaArray[$customSchema] = $db_schema->convertOldToNewYaml(${$aOriginalSchemaArray}[$customSchema]);
}
}
}
return $aPropelSchemaArray;
}
