PHP Db::find方法代碼示例

 public function initialize()
 {
     parent::initialize();
     $this->view->dbs = Db::find();
     $this->view->currentDbId = $this->request->get('id');
     $this->allowRoles();
 }

 /**
  * Extend ControllerBase initialize()
  */
 public function initialize()
 {
     parent::initialize();
     $this->view->dbs = Db::find();
     //list all dbs in the left column
     $this->view->currentDbId = $this->request->get('id');
 }

 static function get_no_bind_users($wx_id)
 {
     $self_table = self::$table_name;
     $wx_connect_table = WxConnect::table();
     $sql = "select {$self_table}.wx_openid from {$self_table}";
     $sql .= " left join {$wx_connect_table}";
     $sql .= " on {$self_table}.wx_openid = {$wx_connect_table}.wx_openid";
     $sql .= " where {$self_table}.wx_id = '{$wx_id}'";
     $sql .= " and {$self_table}.status = " . self::STATUS_YES;
     $sql .= " and {$wx_connect_table}.wx_openid is null";
     return Db::find($sql);
 }

 static function list_user($page, $size, $where = '')
 {
     if ($page < 1) {
         $page = 1;
     }
     if (strlen($where)) {
         $where = " where 1 and {$where}";
     }
     $start = ($page - 1) * $size;
     $limit = "limit {$start}, {$size}";
     $sql = "select user_id from " . self::table();
     $sql .= " {$where} {$limit}";
     $ret = Db::find($sql);
     return $ret;
 }

 function calculate($ctx)
 {
     $where = 1;
     $where = "status = '" . Contract::STATUS_NEW . "'";
     $real_data = RealData::get_cache();
     $real_price = $real_data['amount'];
     $sql = "SELECT name, strike_amount, ask_amount,";
     $sql .= " ({$real_price}*(1+0.1)-strike_amount)/ask_amount as  level_10,";
     $sql .= " ({$real_price}*(1+0.15)-strike_amount)/ask_amount as level_15,";
     $sql .= " ({$real_price}*(1+0.20)-strike_amount)/ask_amount as level_20";
     $sql .= " FROM " . Contract::table();
     $sql .= " WHERE status = '" . Contract::STATUS_NEW . "'";
     $sql .= "order by level_20 desc, level_15 desc, level_10 desc";
     $ctx->ds = Db::find($sql);
 }

 /**
 * Just like Db::finda() but will return an array of objects
 *
 * @param string $class
 * @param array $query
 * @param array $options
 * @return array
 **/
 static function finda($class, $query = array(), $options = array())
 {
     $collection = self::getCollection($class);
     $result = Db::find($collection, $query, $options);
     $objects = array();
     foreach ($result as $data) {
         $objects[] = new $class($data);
     }
     return $objects;
 }

 public function on_collaboration_handle_transactions($pars)
 {
     $colls = $pars['colls'];
     if (!is_array($colls)) {
         self::raiseError('Invalid data received.');
     }
     $response = array();
     $n = sizeof($colls);
     for ($i = 0; $i < $n; $i++) {
         $coll = explode('|', $colls[$i]);
         $document_id = Db::quote_literal($coll[0]);
         $collaborator_id = Db::quote_literal($coll[1]);
         $last_transid = Db::quote_literal($coll[2]);
         unset($coll[0]);
         unset($coll[1]);
         unset($coll[2]);
         $log = Db::quote_literal(str_replace('\\', '\\\\', implode('|', $coll)));
         $coll_response = array();
         if (false !== ($res = Db::find("SELECT * FROM amy.coll_handle_transactions({$document_id}, {$collaborator_id}, {$last_transid}, '{$log}')"))) {
             while (false !== ($r = pg_fetch_assoc($res))) {
                 $coll_response[] = $r;
             }
         } else {
             $coll_response = Db::last_error();
         }
         $response[] = array('document_id' => $document_id, 'transactions' => $coll_response);
     }
     self::setResult($response);
 }

 /**
  * @param Db object <code>$db</code>, array of strings <code>$cols</code>, string <code>$cond</code>
  * @return array of associative arrays; keys are column headings or null if zero rows returned
  */
 public static function find(Db $db, $cols, $cond)
 {
     return $db->find($cols, $cond, self::$table);
 }

 /**
  * Manage permission for an defined user
  */
 public function permissionModalAction()
 {
     $db = Db::find();
     $user = User::findById($this->request->get('id'));
     $this->view->dbm = $db;
     $this->view->user = $user;
 }

 public function register($username, $password = null, $service = 'amy', $credentials = array())
 {
     $username = Db::quote_literal($username);
     if ('' == trim($username)) {
         throw new Exception('Username cannot be empty.');
     }
     $service = Db::quote_literal($service);
     $hashed_password = null == $password ? '' : md5($password);
     $q_data = array();
     if (is_array($credentials)) {
         foreach (array('email', 'nickname', 'picture', 'bio') as $key) {
             $q_data[$key] = isset($credentials[$key]) ? Db::quote_literal($credentials[$key]) : '';
         }
     }
     if (false === ($row = Db::find_first("SELECT * FROM amy.user_create('{$username}', '{$hashed_password}', '{$service}', '" . $q_data['email'] . "', '" . $q_data['nickname'] . "', '" . $q_data['picture'] . "', '" . $q_data['bio'] . "')"))) {
         throw new Exception("User registration failed: `" . Db::last_error() . "'.");
     }
     $this->load_user_info($row);
     try {
         $this->setup_support_dir();
     } catch (Exception $e) {
         Db::find("SELECT amy.user_delete(" . $this->userId . ")");
         throw new Exception($e->getMessage());
     }
     return $this;
 }