selectOne() public method

Run a select statement and return a single result.
public selectOne ( string $query, array $bindings = [] ) : mixed | null
$query string
$bindings array
return mixed | null
Exemplo n.º 1
0
 /**
  * {@inheritdoc}
  */
 public function findMask(RequesterInterface $requester, ResourceInterface $resource)
 {
     $oldFetchMode = $this->connection->getFetchMode();
     $this->connection->setFetchMode(\PDO::FETCH_COLUMN);
     if (null === ($mask = $this->connection->selectOne('SELECT mask FROM ' . $this->getAclSchema()->getPermissionsTableName() . ' WHERE requester = :requester AND resource = :resource', ['requester' => $requester->getAclRequesterIdentifier(), 'resource' => $resource->getAclResourceIdentifier()]))) {
         $this->connection->setFetchMode($oldFetchMode);
         throw new MaskNotFoundException();
     }
     $this->connection->setFetchMode($oldFetchMode);
     return (int) $mask;
 }
Exemplo n.º 2
0
 /**
  * function to get oracle sequence last inserted id
  *
  * @param  string $name
  * @return integer
  */
 public function lastInsertId($name)
 {
     // check if a valid name and sequence exists
     if (!$name or !$this->exists($name)) {
         return 0;
     }
     return $this->connection->selectOne("select {$name}.currval as id from dual")->id;
 }
 /**
  * get table's primary key
  *
  * @param  string $table
  * @return string
  */
 public function getPrimaryKey($table)
 {
     if (!$table) {
         return '';
     }
     $data = $this->connection->selectOne("\n            SELECT cols.column_name\n            FROM all_constraints cons, all_cons_columns cols\n            WHERE cols.table_name = upper('{$table}')\n                AND cons.constraint_type = 'P'\n                AND cons.constraint_name = cols.constraint_name\n                AND cons.owner = cols.owner\n                AND cols.position = 1\n                AND cons.owner = (select user from dual)\n            ORDER BY cols.table_name, cols.position\n            ");
     if (count($data)) {
         return $data->column_name;
     }
     return '';
 }