PHP CM_Db_Db::count方法代码示例

 public function testDelete()
 {
     $language = CM_Model_Language::create('Foo', 'foo', true);
     $language->setTranslation('foo', 'bar');
     $this->assertSame(array('foo' => array('value' => 'bar', 'variables' => array())), $language->getTranslations()->getAssociativeArray());
     $languageKey = CM_Model_LanguageKey::findByName('foo');
     $languageKey->delete();
     $this->assertSame(array(), $language->getTranslations()->getAssociativeArray());
     $this->assertSame(0, CM_Db_Db::count('cm_model_languagekey', array('name' => 'foo')));
     $this->assertSame(0, CM_Db_Db::count('cm_languageValue', array('languageKeyId' => $languageKey->getId(), 'languageId' => $language->getId())));
 }

 public function testQueue()
 {
     $user = $this->getMock('CM_Model_User', array('getEmail', 'getSite'), array(CMTest_TH::createUser()->getId()));
     $user->expects($this->any())->method('getEmail')->will($this->returnValue('foo@example.com'));
     $user->expects($this->any())->method('getSite')->will($this->returnValue(CM_Site_Abstract::factory()));
     $msg = new CM_Mail($user, null);
     $msg->setSubject('testSubject');
     $msg->setHtml('<b>hallo</b>');
     $msg->addReplyTo('foo@bar.com');
     $msg->addCc('foo@bar.org', 'foobar');
     $msg->addBcc('foo@bar.net');
     $msg->sendDelayed();
     $this->assertRow('cm_mail', array('subject' => 'testSubject', 'text' => 'hallo', 'html' => '<b>hallo</b>', 'to' => serialize($msg->getTo()), 'replyTo' => serialize($msg->getReplyTo()), 'cc' => serialize($msg->getCc()), 'bcc' => serialize($msg->getBcc())));
     $this->assertEquals(1, CM_Db_Db::count('cm_mail', 'id'));
     CM_Mail::processQueue(1);
     $this->assertEquals(0, CM_Db_Db::count('cm_mail', 'id'));
 }

 /**
  * @return int
  */
 public function getFixtureCount()
 {
     return CM_Db_Db::count('cm_splitfeature_fixture', array('splitfeatureId' => $this->getId()));
 }

 /**
  * @param string $name
  * @return bool
  */
 public static function exists($name)
 {
     $name = (string) $name;
     return (bool) CM_Db_Db::count('cm_model_languagekey', array('name' => $name));
 }

 public function testCount()
 {
     $this->assertSame(0, CM_Db_Db::count('test'));
     CM_Db_Db::insert('test', array('bar' => 'bar1', 'sequence' => 1));
     $this->assertSame(1, CM_Db_Db::count('test'));
 }

 public function testCreateCountry()
 {
     $country = CM_Model_Location::createCountry('Example Country', 'EC');
     $this->assertSame(CM_Model_Location::LEVEL_COUNTRY, $country->getLevel());
     $this->assertSame(1, CM_Db_Db::count('cm_model_location_country', array('abbreviation' => 'EC')));
     $this->assertSame('Example Country', $country->getName());
     $this->assertSame('EC', $country->getAbbreviation());
 }

 /**
  * @return int
  */
 public static function getQueueSize()
 {
     return CM_Db_Db::count('cm_mail');
 }

 public function testCollapse()
 {
     $values[] = array(1, null, 1, 1, null, 1, 1);
     $values[] = array(1, null, 1, 1, null, 1, 2);
     $values[] = array(1, null, 1, 1, null, 2, 1);
     $values[] = array(1, null, 1, 1, null, 3, 1);
     $values[] = array(1, null, 1, 1, null, 4, 10);
     $values[] = array(1, null, 1, 1, 1, 4, 10);
     $values[] = array(1, null, 2, 1, null, 4, 100);
     $values[] = array(1, null, 1, 2, null, 4, 100);
     $values[] = array(1, null, 1, 1, null, 5, 100);
     CM_Db_Db::insert('cm_action', array('actorId', 'ip', 'verb', 'type', 'actionLimitType', 'createStamp', 'count'), $values);
     CM_Action_Abstract::collapse(1, 4);
     $this->assertEquals(6, CM_Db_Db::count('cm_action'));
     $this->assertRow('cm_action', array('verb' => 1, 'type' => 1, 'createStamp' => 2, 'count' => 5));
 }

 /**
  * @param int|null $role
  * @param int      $period
  */
 public function setPeriod($role, $period)
 {
     $role = $role ? (int) $role : null;
     $period = (int) $period;
     if (CM_Db_Db::count('cm_actionLimit', array('actionType' => $this->getActionType(), 'actionVerb' => $this->getActionVerb(), 'type' => $this->getType(), 'role' => $role))) {
         CM_Db_Db::update('cm_actionLimit', array('period' => $period), array('actionType' => $this->getActionType(), 'actionVerb' => $this->getActionVerb(), 'type' => $this->getType(), 'role' => $role));
     } else {
         CM_Db_Db::insert('cm_actionLimit', array('period' => $period, 'actionType' => $this->getActionType(), 'actionVerb' => $this->getActionVerb(), 'type' => $this->getType(), 'role' => $role));
     }
     $this->_change();
 }

 /**
  * @param string     $table
  * @param string     $column
  * @param int        $position
  * @param array      $whereRow Associative array field=>value
  * @param array|null $where    Associative array field=>value
  * @throws CM_Exception_Invalid
  */
 public static function updateSequence($table, $column, $position, array $whereRow, array $where = null)
 {
     $table = (string) $table;
     $column = (string) $column;
     $position = (int) $position;
     if (null === $where) {
         $where = array();
     }
     if ($position <= 0 || $position > CM_Db_Db::count($table, $where)) {
         throw new CM_Exception_Invalid('Sequence out of bounds.');
     }
     $whereMerged = array_merge($whereRow, $where);
     $positionOld = CM_Db_Db::select($table, $column, $whereMerged)->fetchColumn();
     if (false === $positionOld) {
         throw new CM_Exception_Invalid('Could not retrieve original sequence number.');
     }
     $positionOld = (int) $positionOld;
     if ($position > $positionOld) {
         $upperBound = $position;
         $lowerBound = $positionOld;
         $direction = -1;
     } else {
         $upperBound = $positionOld;
         $lowerBound = $position;
         $direction = 1;
     }
     $client = self::getClient();
     $query = new CM_Db_Query_UpdateSequence($client, $table, $column, $direction, $where, $lowerBound, $upperBound);
     $query->execute();
     self::update($table, array($column => $position), $whereMerged);
 }

 /**
  * @param int $trainingsMax
  */
 public static function deleteOldTrainings($trainingsMax)
 {
     $trainingsMax = (int) $trainingsMax;
     $ids = CM_Db_Db::select('cm_svm', 'id')->fetchAllColumn();
     foreach ($ids as $id) {
         $trainingsCount = CM_Db_Db::count('cm_svmtraining', array('svmId' => $id));
         if ($trainingsCount > $trainingsMax) {
             $limit = (int) ($trainingsCount - $trainingsMax);
             $deletedCount = CM_Db_Db::exec('DELETE FROM `cm_svmtraining` WHERE `svmId` = ? ORDER BY `createStamp` LIMIT ' . $limit, array($id))->getAffectedRows();
             if ($deletedCount > 0) {
                 CM_Db_Db::replace('cm_svm', array('id' => $id, 'updateStamp' => time()));
             }
         }
     }
 }

 /**
  * @param int $id
  * @return null|static
  */
 public static function findById($id)
 {
     if (!CM_Db_Db::count('cm_streamChannelArchive_video', array('id' => $id))) {
         return null;
     }
     return new static($id);
 }