public function execute()
{
if (is_dir($this->getArgument('sql_path'))) {
$path = $this->getArgument('sql_path') . DIRECTORY_SEPARATOR . 'schema.sql';
} else {
if (is_file($this->getArgument('sql_path'))) {
$path = $this->getArgument('sql_path');
} else {
throw new Doctrine_Task_Exception('Invalid sql path.');
}
}
$sql = Doctrine_Core::generateSqlFromModels($this->getArgument('models_path'));
file_put_contents($path, $sql);
$this->notify('Generated SQL successfully for models');
}
/**
* model2sql
* This generates Sql From Models.
*
* @see Doctrine_Core::generateSqlFromModels()
*/
public function action_admin_models2sql()
{
$sql = Doctrine_Core::generateSqlFromModels();
$sqlSchemaFile = DOCTRINE_SQL_PATH . DIRECTORY_SEPARATOR . DB_PREFIX . '_sqlschema_backup_' . date('dmY_His') . '.sql';
file_put_contents($sqlSchemaFile, $sql);
$message = 'Successfully written SQL for the current schema to disc.';
$message .= 'Destination File: ' . $sqlSchemaFile;
unset($sql);
unset($sqlSchemaFile);
$this->setFlashmessage('success', $message);
$this->redirectToReferer();
}
public function generateSql()
{
$this->_loadDoctrineModels();
$sqlDir = $this->_getSqlDirectoryPath();
$sql = Doctrine_Core::generateSqlFromModels();
$sqlSchemaFile = $sqlDir . DIRECTORY_SEPARATOR . "schema_" . date('Ymd_His') . ".sql";
file_put_contents($sqlSchemaFile, $sql);
$this->_print('Successfully written SQL for the current schema to disc.', array('color' => 'green'));
$this->_print('Destination File: ' . $sqlSchemaFile);
}
