/** * Main method builds all the targets for a typical propel project. */ public function main() { $manager = new PropelMigrationManager(); $manager->setConnections($this->getGeneratorConfig()->getBuildConnections()); $manager->setMigrationTable($this->getMigrationTable()); $manager->setMigrationDir($this->getOutputDirectory()); $previousTimestamps = $manager->getAlreadyExecutedMigrationTimestamps(); if (!($nextMigrationTimestamp = array_pop($previousTimestamps))) { $this->log('No migration were ever executed on this database - nothing to reverse.'); return false; } $this->log(sprintf('Executing migration %s down', $manager->getMigrationClassName($nextMigrationTimestamp))); if ($nbPreviousTimestamps = count($previousTimestamps)) { $previousTimestamp = array_pop($previousTimestamps); } else { $previousTimestamp = 0; } $migration = $manager->getMigrationObject($nextMigrationTimestamp); if (false === $migration->preDown($manager)) { $this->log('preDown() returned false. Aborting migration.', Project::MSG_ERR); return false; } foreach ($migration->getDownSQL() as $datasource => $sql) { $connection = $manager->getConnection($datasource); $this->log(sprintf('Connecting to database "%s" using DSN "%s"', $datasource, $connection['dsn']), Project::MSG_VERBOSE); $pdo = $manager->getPdoConnection($datasource); $res = 0; $statements = PropelSQLParser::parseString($sql); foreach ($statements as $statement) { try { $this->log(sprintf('Executing statement "%s"', $statement), Project::MSG_VERBOSE); $stmt = $pdo->prepare($statement); $stmt->execute(); $res++; } catch (PDOException $e) { $this->log(sprintf('Failed to execute SQL "%s"', $statement), Project::MSG_ERR); // continue } } if (!$res) { $this->log('No statement was executed. The version was not updated.'); $this->log(sprintf('Please review the code in "%s"', $manager->getMigrationDir() . DIRECTORY_SEPARATOR . $manager->getMigrationClassName($nextMigrationTimestamp))); $this->log('Migration aborted', Project::MSG_ERR); return false; } $this->log(sprintf('%d of %d SQL statements executed successfully on datasource "%s"', $res, count($statements), $datasource)); $manager->updateLatestMigrationTimestamp($datasource, $previousTimestamp); $this->log(sprintf('Downgraded migration date to %d for datasource "%s"', $previousTimestamp, $datasource), Project::MSG_VERBOSE); } $migration->postDown($manager); if ($nbPreviousTimestamps) { $this->log(sprintf('Reverse migration complete. %d more migrations available for reverse.', $nbPreviousTimestamps)); } else { $this->log('Reverse migration complete. No more migration available for reverse'); } }
/** * Load the sql file and then execute it * * @throws BuildException */ public function main() { $conf = new GeneratorConfig(); $conf->setBuildProperties($this->getProject()->getProperties()); $this->setBuildConnections($conf->getBuildConnections()); if ($this->sqldbmap === null || $this->getSqlDbMap()->exists() === false) { throw new BuildException("You haven't provided an sqldbmap, or " . "the one you specified doesn't exist: " . $this->sqldbmap->getPath()); } if ($this->url === null) { throw new BuildException("DSN url attribute must be set!"); } // get an ordered list of SQL files to execute $databases = $this->getFilesToExecute(); $this->log(sprintf('Reading SQL files...')); foreach ($databases as $database => $files) { $statements[$database] = array(); foreach ($files as $fileName) { $fullFileName = $this->srcDir ? $this->srcDir . DIRECTORY_SEPARATOR . $fileName : $fileName; if (file_exists($fullFileName)) { $this->log(sprintf(' Loading statements from "%s"', $fullFileName)); $fileStatements = PropelSQLParser::parseFile($fullFileName); $this->log(sprintf(' %d statements to execute', count($fileStatements)), Project::MSG_VERBOSE); $statements[$database] = array_merge($statements[$database], $fileStatements); } else { $this->log(sprintf('File "%s" in sqldbmap does not exist, skipping it.', $fullFileName)); } } } $successfullStatements = 0; $this->log(sprintf('Executing SQL statements...')); foreach ($statements as $database => $statementList) { $successfullStatements += $this->insertDatabaseSqlFiles($database, $statementList); } $this->log(sprintf('SQL execution complete. %d statements successfully executed.', $successfullStatements)); }
public function createMigrationTable($datasource) { $platform = $this->getPlatform($datasource); // modelize the table $database = new Database($datasource); $database->setPlatform($platform); $table = new Table($this->getMigrationTable()); $database->addTable($table); $column = new Column('version'); $column->getDomain()->copy($platform->getDomainForType('INTEGER')); $column->setDefaultValue(0); $table->addColumn($column); // insert the table into the database $statements = $platform->getAddTableDDL($table); $pdo = $this->getPdoConnection($datasource); $res = PropelSQLParser::executeString($statements, $pdo); if (!$res) { throw new Exception(sprintf('Unable to create migration table in datasource "%s"', $datasource)); } }
/** * @param string $datasource A datasource name. */ public function insertSql($datasource = null) { $statementsToInsert = array(); foreach ($this->getProperties($this->getSqlDbMapFilename()) as $sqlFile => $database) { if (null !== $datasource && $database !== $datasource) { // skip break; } if (!isset($statementsToInsert[$database])) { $statementsToInsert[$database] = array(); } if (null === $database || null !== $database && $database === $datasource) { $filename = $this->getWorkingDirectory() . DIRECTORY_SEPARATOR . $sqlFile; if (file_exists($filename)) { foreach (PropelSQLParser::parseFile($filename) as $sql) { $statementsToInsert[$database][] = $sql; } } } } foreach ($statementsToInsert as $database => $sqls) { if (!$this->hasConnection($database)) { continue; } $pdo = $this->getPdoConnection($database); $pdo->beginTransaction(); try { foreach ($sqls as $sql) { $stmt = $pdo->prepare($sql); $stmt->execute(); } $pdo->commit(); } catch (PDOException $e) { $pdo->rollback(); throw $e; } } return true; }
public function buildSQL(PDO $con) { $statements = PropelSQLParser::parseString($this->getSQL()); foreach ($statements as $statement) { if (strpos($statement, 'DROP') === 0) { // drop statements cause errors since the table doesn't exist continue; } $stmt = $con->prepare($statement); if ($stmt instanceof PDOStatement) { // only execute if has no error $stmt->execute(); } } return count($statements); }
/** * @dataProvider explodeIntoStatementsDataProvider */ public function testExplodeIntoStatements($input, $output) { $parser = new PropelSQLParser(); $parser->setSQL($input); $this->assertEquals($output, $parser->explodeIntoStatements()); }