public function testDoDeleteAll()
{
try {
BasePeer::doDeleteAll('BAD TABLE', Propel::getConnection());
} catch (PropelException $e) {
$this->assertContains('[DELETE FROM `BAD` `TABLE`]', $e->getMessage(), 'SQL query is written in the exception message');
}
}
public static function doDeleteAll($con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$affectedRows = 0;
try {
$con->begin();
$affectedRows += BasePeer::doDeleteAll(LorfieldsPeer::TABLE_NAME, $con);
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollback();
throw $e;
}
}
/**
* Method to DELETE all rows from the exam_comment_dig table.
*
* @return int The number of affected rows (if supported by underlying database driver).
*/
public static function doDeleteAll($con = null)
{
if ($con === null) {
$con = Propel::getConnection(ExamCommentDigPeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$affectedRows = 0;
// initialize var to track total num of affected rows
try {
// use transaction because $criteria could contain info
// for more than one table or we could emulating ON DELETE CASCADE, etc.
$con->beginTransaction();
$affectedRows += BasePeer::doDeleteAll(ExamCommentDigPeer::TABLE_NAME, $con);
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
/**
* Method to DELETE all rows from the metadata_profile table.
*
* @return int The number of affected rows (if supported by underlying database driver).
*/
public static function doDeleteAll($con = null)
{
if ($con === null) {
$con = Propel::getConnection(MetadataProfilePeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$affectedRows = 0;
// initialize var to track total num of affected rows
try {
// use transaction because $criteria could contain info
// for more than one table or we could emulating ON DELETE CASCADE, etc.
$con->beginTransaction();
$affectedRows += BasePeer::doDeleteAll(MetadataProfilePeer::TABLE_NAME, $con);
// Because this db requires some delete cascade/set null emulation, we have to
// clear the cached instance *after* the emulation has happened (since
// instances get re-added by the select statement contained therein).
MetadataProfilePeer::clearInstancePool();
MetadataProfilePeer::clearRelatedInstancePool();
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
public static function doDeleteAll($con = null)
{
if ($con === null) {
$con = Propel::getConnection(TipodocentePeer::DATABASE_NAME, Propel::CONNECTION_WRITE);
}
$affectedRows = 0;
try {
$con->beginTransaction();
$affectedRows += BasePeer::doDeleteAll(TipodocentePeer::TABLE_NAME, $con);
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollBack();
throw $e;
}
}
public static function doDeleteAll($con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$affectedRows = 0;
try {
$con->begin();
$affectedRows += VClassGroupPeer::doOnDeleteCascade(new Criteria(), $con);
$affectedRows += BasePeer::doDeleteAll(VClassGroupPeer::TABLE_NAME, $con);
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollback();
throw $e;
}
}
/**
* Restore database from file.
*
* @todo Fix $maxExecutionTime.
*
* @param string|resource $file
* @param array|null $tables
* @param float $maxExecutionTime
* @param int $continueLine
* @param AbstractLegacyBackend|null $backend
* @return bool True on success, false otherwise.
*/
public static function restoreFromFile($file, $tables = null, $maxExecutionTime = 0, $continueLine = 0, AbstractLegacyBackend $backend = null)
{
global $CURRY_DATABASE_RESTORE;
$CURRY_DATABASE_RESTORE = true;
$fp = is_string($file) ? fopen($file, "r") : $file;
$t = microtime(true);
$total = 0;
$skipped = 0;
$failed = 0;
$session = new \Zend\Session\Container(__CLASS__);
$con = Propel::getConnection();
$con->beginTransaction();
$adapter = Propel::getDB();
if ($adapter instanceof DBMySQL) {
$con->exec("SET foreign_key_checks = 0");
}
// Read header
$firstline = stream_get_line($fp, self::MAX_LINE_LENGTH, "\n");
$header = json_decode($firstline, true);
if (is_array($header) && isset($header['header'])) {
$header = $header['header'];
// Check header version
$version = isset($header['version']) ? (int) $header['version'] : 0;
if ($version > self::VERSION) {
throw new Exception('Unsupported database version. The file you are trying to restore from is from a newer version of currycms.');
}
// Check page version
$pageVersion = isset($header['page-version']) ? (int) $header['page-version'] : 0;
if ($pageVersion > Page::VERSION) {
throw new Exception('Unsupported page version. The file you are trying to restore from is from a newer version of currycms.');
}
if ($backend) {
$backend->addMessage("Restoring from " . $header['date']);
}
if ($pageVersion !== Page::VERSION) {
if ($backend) {
$backend->addMessage("Migrating data from version {$pageVersion} to " . Page::VERSION, AbstractBackend::MSG_WARNING);
}
Page::preMigrate($pageVersion);
}
} else {
throw new Exception('Invalid header');
}
// Empty tables
if ($continueLine == 0) {
foreach (Propel::getModels() as $classes) {
foreach ($classes as $table) {
try {
if (is_array($tables) && !in_array($table, $tables)) {
continue;
}
if (!method_exists($table, 'delete')) {
if ($backend) {
$backend->addMessage("Skipping read-only table: {$table}", AbstractBackend::MSG_WARNING);
}
continue;
}
$tableName = PropelQuery::from($table)->getTableMap()->getName();
// use basePeer to avoid foreign key emulation in Normal peer class
BasePeer::doDeleteAll($tableName, $con);
} catch (Exception $e) {
throw new Exception('Unable to empty table ' . $table . ': ' . $e->getMessage());
}
}
}
if ($backend) {
$backend->addMessage("Cleared tables in " . round(microtime(true) - $t, 2) . "s");
}
$t = microtime(true);
} else {
$total = $session->total;
$skipped = $session->skipped;
$failed = $session->failed;
if ($backend) {
$backend->addMessage("Continuing from line {$continueLine}.");
}
for ($i = 0; $i < $continueLine; ++$i) {
stream_get_line($fp, self::MAX_LINE_LENGTH, "\n");
}
}
$currentTable = null;
$buffer = array();
while (!feof($fp)) {
// Read line
$data = json_decode(stream_get_line($fp, self::MAX_LINE_LENGTH, "\n"), true);
++$total;
if (is_array($data) && isset($data['table'])) {
if (is_array($tables) && !in_array($data['table'], $tables) || !method_exists($data['table'], 'delete')) {
++$skipped;
continue;
}
// Verify columns for new table
if ($data['table'] !== $currentTable && $currentTable !== null && $backend) {
$backend->addMessage('Restoring rows for table ' . $data['table']);
$columns = ArrayHelper::objectsToArray(PropelQuery::from($data['table'])->getTableMap()->getColumns(), null, 'getPhpName');
$added = array_diff($columns, array_keys($data['values']));
$removed = array_diff(array_keys($data['values']), $columns);
if (count($added)) {
$backend->addMessage('New column(s): ' . join(', ', $added), AbstractBackend::MSG_WARNING);
}
if (count($removed)) {
$backend->addMessage('Removed column(s): ' . join(', ', $removed), AbstractBackend::MSG_WARNING);
}
}
// Flush buffer when changing tables
if ($data['table'] !== $currentTable || count($buffer) >= self::MULTIINSERT_MAXBUFFER) {
if ($currentTable !== null && count($buffer)) {
Propel::doMultiInsert($currentTable, $buffer);
}
$currentTable = $data['table'];
$buffer = array();
}
// Migrate data
if ($pageVersion !== Page::VERSION) {
if (!Page::migrateData($data['table'], $data['values'], $pageVersion)) {
continue;
}
}
$buffer[] = $data['values'];
} else {
if ($backend) {
$backend->addMessage('Unable to read data on line ' . $total, AbstractBackend::MSG_ERROR);
}
++$failed;
}
// check execution time
if ($maxExecutionTime && App::getInstance()->getExecutionTime() > $maxExecutionTime) {
if ($currentTable !== null && count($buffer)) {
Propel::doMultiInsert($currentTable, $buffer);
}
$session->total = $total;
$session->skipped = $skipped;
$session->failed = $failed;
$params = array('module' => 'Curry_Backend_Database', 'view' => 'ContinueRestore', 'file' => $file, 'tables' => $tables, 'line' => $total, 'max_execution_time' => $maxExecutionTime);
AbstractLegacyBackend::redirect(url('', $params)->getAbsolute("&", true));
}
}
// Flush buffer
if ($currentTable !== null && count($buffer)) {
Propel::doMultiInsert($currentTable, $buffer);
}
if ($pageVersion !== Page::VERSION) {
Page::postMigrate($pageVersion);
}
if ($adapter instanceof DBMySQL) {
$con->exec("SET foreign_key_checks = 1");
}
$con->commit();
$CURRY_DATABASE_RESTORE = false;
if ($backend) {
if ($skipped) {
$backend->addMessage("Skipped {$skipped} rows");
}
if ($failed) {
$backend->addMessage("Failed to add {$failed} rows", AbstractBackend::MSG_ERROR);
}
$backend->addMessage("Added " . ($total - $skipped - $failed) . " / {$total} rows in " . round(microtime(true) - $t, 2) . "s", !$failed ? AbstractBackend::MSG_SUCCESS : AbstractBackend::MSG_ERROR);
}
if (is_string($file)) {
fclose($fp);
}
return !$failed;
}
/**
* Method to DELETE all rows from the post table.
*
* @return int The number of affected rows (if supported by underlying database driver).
*/
public static function doDeleteAll($con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$affectedRows = 0;
// initialize var to track total num of affected rows
try {
// use transaction because $criteria could contain info
// for more than one table or we could emulating ON DELETE CASCADE, etc.
$con->begin();
$affectedRows += PostPeer::doOnDeleteCascade(new Criteria(), $con);
$affectedRows += BasePeer::doDeleteAll(PostPeer::TABLE_NAME, $con);
$con->commit();
return $affectedRows;
} catch (PropelException $e) {
$con->rollback();
throw $e;
}
}