PHP Criteria::keys方法代碼示例

 public function testClone()
 {
     $c1 = new Criteria();
     $c1->add('tbl.COL1', 'foo', Criteria::EQUAL);
     $c2 = clone $c1;
     $c2->addAnd('tbl.COL1', 'bar', Criteria::EQUAL);
     $nbCrit = 0;
     foreach ($c1->keys() as $key) {
         foreach ($c1->getCriterion($key)->getAttachedCriterion() as $criterion) {
             $nbCrit++;
         }
     }
     $this->assertEquals(1, $nbCrit, 'cloning a Criteria clones its Criterions');
 }

 /**
  * Helper method which returns the primary key contained
  * in the given Criteria object.
  *
  * @param  Criteria  $criteria A Criteria.
  * @return ColumnMap If the Criteria object contains a primary key, or null if it doesn't.
  *
  * @throws \Propel\Runtime\Exception\RuntimeException
  */
 private static function getPrimaryKey(Criteria $criteria)
 {
     // Assume all the keys are for the same table.
     $keys = $criteria->keys();
     $key = $keys[0];
     $table = $criteria->getTableName($key);
     $pk = null;
     if (!empty($table)) {
         $dbMap = Propel::getServiceContainer()->getDatabaseMap($criteria->getDbName());
         $pks = $dbMap->getTable($table)->getPrimaryKeys();
         if (!empty($pks)) {
             $pk = array_shift($pks);
         }
     }
     return $pk;
 }

 /**
  * Method to perform inserts based on values and keys in a
  * Criteria.
  * <p>
  * If the primary key is auto incremented the data in Criteria
  * will be inserted and the auto increment value will be returned.
  * <p>
  * If the primary key is included in Criteria then that value will
  * be used to insert the row.
  * <p>
  * If no primary key is included in Criteria then we will try to
  * figure out the primary key from the database map and insert the
  * row with the next available id using util.db.IDBroker.
  * <p>
  * If no primary key is defined for the table the values will be
  * inserted as specified in Criteria and null will be returned.
  *
  * @param  Criteria            $criteria Object containing values to insert.
  * @param  ConnectionInterface $con      A ConnectionInterface connection.
  * @return mixed               The primary key for the new row if the primary key is auto-generated. Otherwise will return null.
  *
  * @throws \Propel\Runtime\Exception\RuntimeException
  */
 public static function doInsert($criteria, ConnectionInterface $con = null)
 {
     // The primary key
     $id = null;
     if (null === $con) {
         $con = Propel::getServiceContainer()->getWriteConnection($criteria->getDbName());
     }
     $db = Propel::getServiceContainer()->getAdapter($criteria->getDbName());
     // Get the table name and method for determining the primary
     // key value.
     $keys = $criteria->keys();
     if (!empty($keys)) {
         $tableName = $criteria->getTableName($keys[0]);
     } else {
         throw new RuntimeException('Database insert attempted without anything specified to insert.');
     }
     $tableName = $criteria->getTableName($keys[0]);
     $dbMap = Propel::getServiceContainer()->getDatabaseMap($criteria->getDbName());
     $tableMap = $dbMap->getTable($tableName);
     $keyInfo = $tableMap->getPrimaryKeyMethodInfo();
     $useIdGen = $tableMap->isUseIdGenerator();
     //$keyGen = $con->getIdGenerator();
     $pk = static::getPrimaryKey($criteria);
     // only get a new key value if you need to
     // the reason is that a primary key might be defined
     // but you are still going to set its value. for example:
     // a join table where both keys are primary and you are
     // setting both columns with your own values
     // pk will be null if there is no primary key defined for the table
     // we're inserting into.
     if (null !== $pk && $useIdGen && !$criteria->keyContainsValue($pk->getFullyQualifiedName()) && $db->isGetIdBeforeInsert()) {
         try {
             $id = $db->getId($con, $keyInfo);
         } catch (\Exception $e) {
             throw new RuntimeException('Unable to get sequence id.', 0, $e);
         }
         $criteria->add($pk->getFullyQualifiedName(), $id);
     }
     try {
         $adapter = Propel::getServiceContainer()->getAdapter($criteria->getDBName());
         $qualifiedCols = $criteria->keys();
         // we need table.column cols when populating values
         $columns = array();
         // but just 'column' cols for the SQL
         foreach ($qualifiedCols as $qualifiedCol) {
             $columns[] = substr($qualifiedCol, strrpos($qualifiedCol, '.') + 1);
         }
         // add identifiers
         if ($adapter->useQuoteIdentifier()) {
             $columns = array_map(array($adapter, 'quoteIdentifier'), $columns);
             $tableName = $adapter->quoteIdentifierTable($tableName);
         }
         $sql = 'INSERT INTO ' . $tableName . ' (' . implode(',', $columns) . ')' . ' VALUES (';
         // . substr(str_repeat("?,", count($columns)), 0, -1) .
         for ($p = 1, $cnt = count($columns); $p <= $cnt; $p++) {
             $sql .= ':p' . $p;
             if ($p !== $cnt) {
                 $sql .= ',';
             }
         }
         $sql .= ')';
         $params = static::buildParams($qualifiedCols, $criteria);
         $db->cleanupSQL($sql, $params, $criteria, $dbMap);
         $stmt = $con->prepare($sql);
         $db->bindValues($stmt, $params, $dbMap, $db);
         $stmt->execute();
     } catch (\Exception $e) {
         Propel::log($e->getMessage(), Propel::LOG_ERR);
         throw new RuntimeException(sprintf('Unable to execute INSERT statement [%s]', $sql), 0, $e);
     }
     // If the primary key column is auto-incremented, get the id now.
     if (null !== $pk && $useIdGen && $db->isGetIdAfterInsert()) {
         try {
             $id = $db->getId($con, $keyInfo);
         } catch (\Exception $e) {
             throw new RuntimeException("Unable to get autoincrement id.", 0, $e);
         }
//.........這裏部分代碼省略.........