public static function setDefaultCriteriaFilter() { if (self::$s_criteria_filter == null) { self::$s_criteria_filter = new criteriaFilter(); } $c = new Criteria(); $c->add(self::DELETED_AT, null, Criteria::EQUAL); self::$s_criteria_filter->setFilter($c); }
public function providerTestMigration() { $systemUsers = SystemUserPeer::doSelect(new Criteria()); // select all $ids = array(); foreach ($systemUsers as $user) { $ids[] = array($user->getId()); } return $ids; }
/** * Builds a Criteria object containing the primary key for this object. * * Unlike buildCriteria() this method includes the primary key values regardless * of whether or not they have been modified. * * @return Criteria The Criteria object containing value(s) for primary key(s). */ public function buildPkeyCriteria() { $criteria = new Criteria(SystemUserPeer::DATABASE_NAME); $criteria->add(SystemUserPeer::ID, $this->id); if ($this->alreadyInSave && count($this->modifiedColumns) == 2 && $this->isColumnModified(SystemUserPeer::UPDATED_AT)) { $theModifiedColumn = null; foreach ($this->modifiedColumns as $modifiedColumn) { if ($modifiedColumn != SystemUserPeer::UPDATED_AT) { $theModifiedColumn = $modifiedColumn; } } $atomicColumns = SystemUserPeer::getAtomicColumns(); if (in_array($theModifiedColumn, $atomicColumns)) { $criteria->add($theModifiedColumn, $this->getByName($theModifiedColumn, BasePeer::TYPE_COLNAME), Criteria::NOT_EQUAL); } } return $criteria; }
/** * Retrieve multiple objects by pkey. * * @param array $pks List of primary keys * @param PropelPDO $con the connection to use * @throws PropelException Any exceptions caught during processing will be * rethrown wrapped into a PropelException. */ public static function retrieveByPKs($pks, PropelPDO $con = null) { $objs = null; if (empty($pks)) { $objs = array(); } else { $criteria = new Criteria(SystemUserPeer::DATABASE_NAME); $criteria->add(SystemUserPeer::ID, $pks, Criteria::IN); $objs = SystemUserPeer::doSelect($criteria, $con); } return $objs; }
function getUsers($lastUser, $userLimitEachLoop) { SystemUserPeer::clearInstancePool(); $c = new Criteria(); $c->add(SystemUserPeer::ID, $lastUser, Criteria::GREATER_THAN); $c->addAscendingOrderByColumn(SystemUserPeer::ID); $c->setLimit($userLimitEachLoop); SystemUserPeer::setUseCriteriaFilter(false); $users = SystemUserPeer::doSelect($c); SystemUserPeer::setUseCriteriaFilter(true); return $users; }
/** * Populates the object using an array. * * This is particularly useful when populating an object from one of the * request arrays (e.g. $_POST). This method goes through the column * names, checking to see whether a matching key exists in populated * array. If so the setByName() method is called for that column. * * You can specify the key type of the array by additionally passing one * of the class type constants BasePeer::TYPE_PHPNAME, BasePeer::TYPE_STUDLYPHPNAME, * BasePeer::TYPE_COLNAME, BasePeer::TYPE_FIELDNAME, BasePeer::TYPE_NUM. * The default key type is the column's phpname (e.g. 'AuthorId') * * @param array $arr An array to populate the object from. * @param string $keyType The type of keys the array uses. * @return void */ public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME) { $keys = SystemUserPeer::getFieldNames($keyType); if (array_key_exists($keys[0], $arr)) { $this->setId($arr[$keys[0]]); } if (array_key_exists($keys[1], $arr)) { $this->setEmail($arr[$keys[1]]); } if (array_key_exists($keys[2], $arr)) { $this->setFirstName($arr[$keys[2]]); } if (array_key_exists($keys[3], $arr)) { $this->setLastName($arr[$keys[3]]); } if (array_key_exists($keys[4], $arr)) { $this->setSha1Password($arr[$keys[4]]); } if (array_key_exists($keys[5], $arr)) { $this->setSalt($arr[$keys[5]]); } if (array_key_exists($keys[6], $arr)) { $this->setCreatedBy($arr[$keys[6]]); } if (array_key_exists($keys[7], $arr)) { $this->setStatus($arr[$keys[7]]); } if (array_key_exists($keys[8], $arr)) { $this->setIsPrimary($arr[$keys[8]]); } if (array_key_exists($keys[9], $arr)) { $this->setStatusUpdatedAt($arr[$keys[9]]); } if (array_key_exists($keys[10], $arr)) { $this->setCreatedAt($arr[$keys[10]]); } if (array_key_exists($keys[11], $arr)) { $this->setUpdatedAt($arr[$keys[11]]); } if (array_key_exists($keys[12], $arr)) { $this->setDeletedAt($arr[$keys[12]]); } if (array_key_exists($keys[13], $arr)) { $this->setRole($arr[$keys[13]]); } }