PHP ModelCriteria::delete方法代码示例

 /**
  * Performs a DELETE on the database, given a ChildGoogleshoppingProductSynchronisation or Criteria object OR a primary key value.
  *
  * @param mixed               $values Criteria or ChildGoogleshoppingProductSynchronisation object or primary key or array of primary keys
  *              which is used to create the DELETE statement
  * @param ConnectionInterface $con the connection to use
  * @return int The number of affected rows (if supported by underlying database driver).  This includes CASCADE-related rows
  *                if supported by native driver or if emulated using Propel.
  * @throws PropelException Any exceptions caught during processing will be
  *         rethrown wrapped into a PropelException.
  */
 public function delete(ConnectionInterface $con = null)
 {
     if (null === $con) {
         $con = Propel::getServiceContainer()->getWriteConnection(GoogleshoppingProductSynchronisationTableMap::DATABASE_NAME);
     }
     $criteria = $this;
     // Set the correct dbName
     $criteria->setDbName(GoogleshoppingProductSynchronisationTableMap::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->beginTransaction();
         GoogleshoppingProductSynchronisationTableMap::removeInstanceFromPool($criteria);
         $affectedRows += ModelCriteria::delete($con);
         GoogleshoppingProductSynchronisationTableMap::clearRelatedInstancePool();
         $con->commit();
         return $affectedRows;
     } catch (PropelException $e) {
         $con->rollBack();
         throw $e;
     }
 }

 public function testDeleteUsingTableAlias()
 {
     $con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
     $c->setModelAlias('b', false);
     $c->where('b.Title = ?', 'foo');
     $c->delete();
     $expectedSQL = $this->getSql("DELETE FROM book WHERE book.title = 'foo'");
     $this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'delete() also works on tables with table alias');
     if ($this->runningOnMySQL() || $this->runningOnPostgreSQL()) {
         $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
         $c->setModelAlias('b', true);
         $c->where('b.Title = ?', 'foo');
         $c->delete();
         if (!$this->runningOnMySQL()) {
             $expectedSQL = $this->getSql("DELETE FROM book AS b WHERE b.title = 'foo'");
         } else {
             $expectedSQL = $this->getSql("DELETE b FROM book AS b WHERE b.title = 'foo'");
         }
         $this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'delete() also works on tables with true table alias');
     }
 }

 /**
  * Performs a DELETE on the database based on the current ModelCriteria
  *
  * @param ConnectionInterface $con the connection to use
  * @return int             The number of affected rows (if supported by underlying database driver).  This includes CASCADE-related rows
  *                         if supported by native driver or if emulated using Propel.
  * @throws PropelException Any exceptions caught during processing will be
  *                         rethrown wrapped into a PropelException.
  */
 public function delete(ConnectionInterface $con = null)
 {
     if (null === $con) {
         $con = Propel::getServiceContainer()->getWriteConnection(TranslationCatalogTableMap::DATABASE_NAME);
     }
     $criteria = $this;
     // Set the correct dbName
     $criteria->setDbName(TranslationCatalogTableMap::DATABASE_NAME);
     // use transaction because $criteria could contain info
     // for more than one table or we could emulating ON DELETE CASCADE, etc.
     return $con->transaction(function () use($con, $criteria) {
         $affectedRows = 0;
         // initialize var to track total num of affected rows
         TranslationCatalogTableMap::removeInstanceFromPool($criteria);
         $affectedRows += ModelCriteria::delete($con);
         TranslationCatalogTableMap::clearRelatedInstancePool();
         return $affectedRows;
     });
 }

 public function testDeleteUsingTableAlias()
 {
     $con = Propel::getServiceContainer()->getConnection(BookTableMap::DATABASE_NAME);
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
     $c->setModelAlias('b', false);
     $c->where('b.Title = ?', 'foo');
     $c->delete();
     $expectedSQL = "DELETE FROM `book` WHERE book.TITLE = 'foo'";
     $this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'delete() also works on tables with table alias');
     $c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
     $c->setModelAlias('b', true);
     $c->where('b.Title = ?', 'foo');
     $c->delete();
     $expectedSQL = "DELETE b FROM `book` AS b WHERE b.TITLE = 'foo'";
     $this->assertEquals($expectedSQL, $con->getLastExecutedQuery(), 'delete() also works on tables with true table alias');
 }