/**
* 获取所有
* @param string $fetchStyle
* @throws \HuiLib\Error\Exception
* @return array|object
*/
public function fetchAll()
{
if ($this->innerStatment == NULL) {
throw new \HuiLib\Error\Exception('fetchAll必须先调用Query::query');
}
return $this->innerStatment->fetchAll($this->fetchStyle);
}
/**
* Fetches all of the rows returned by the query.
*
* @return array
*/
protected function rows()
{
if ($this->rows === null) {
$this->rows = $this->pdoStatement->fetchAll(PDO::FETCH_ASSOC);
}
return $this->rows;
}
/**
* <b>Não é passado com os Joins</b>
*
* @return array[Objetos]
*/
public function findAll()
{
$sql = "SELECT * FROM {$this->Table}";
$this->Stmt = Conn::prepare($sql);
$this->Stmt->execute();
return $this->Stmt->fetchAll();
}
/**
* @param string $dbObjectName
*
* @return array
*/
public function fetchAll($dbObjectName = '')
{
if ('' === $dbObjectName) {
$dbObjectName = $this->_objectName;
}
return $this->_statement->fetchAll(\PDO::FETCH_CLASS | \PDO::FETCH_PROPS_LATE, $dbObjectName);
}
/**
* @param string $entity [null]
* @return array $entities
*/
public function fetchEntities($entity = null)
{
$entity = $entity ?: $this->entity;
if (is_null($entity)) {
$entity = 'stdClass';
}
return $this->statement->fetchAll(\PDO::FETCH_CLASS, $entity);
}
function fetchAll(PDOStatement $result, $result_type = Database::FETCH_ASSOC, $className = "stdClass", $classArgs = null)
{
if ($result_type == self::FETCH_CLASS) {
$rows = $result->fetchAll($result_type, $className, $classArgs);
} else {
$rows = $result->fetchAll($result_type);
}
return $rows;
}
/**
* @param \PDOStatement $statement
* @param MObject|null $parent
*/
public function __construct(\PDOStatement $statement, MObject $parent = null)
{
parent::__construct($parent);
$this->statement = $statement;
$this->rows = $this->statement->fetchAll(\PDO::FETCH_ASSOC);
$this->fields = empty($this->rows) ? array() : array_keys((array) $this->rows[0]);
$this->rowCount = count($this->rows);
$this->columnCount = count($this->fields);
}
public function all($param = null, $args = [])
{
if (is_callable($param)) {
return $this->statement->fetchAll(\PDO::FETCH_FUNC, $param);
}
if ($param !== null && is_string($param)) {
$this->bindToClass($param, $args);
}
return $this->statement->fetchAll();
}
/**
* Fetch all results
*
* @param boolean|string $object Fetch as object
* @return \stdClass[]
*/
public function all($object = TRUE)
{
if ($object) {
if ($object === TRUE) {
return $this->stmt->fetchAll(\PDO::FETCH_OBJ);
}
return $this->stmt->fetchAll(\PDO::FETCH_CLASS, $object);
}
return $this->stmt->fetchAll(\PDO::FETCH_ASSOC);
}
private function Execute()
{
$this->Connect();
try {
$this->getSyntax();
$this->read->execute();
$this->result = $this->read->fetchAll();
} catch (PDOException $e) {
echo "<b>Erro ao ler:</b> {$e->getMessage()}";
}
}
/**
* {@inheritdoc}
*/
public function load($locale)
{
$parameters = array_merge([$locale], $this->parameters);
$this->statement->execute($parameters);
$rows = $this->statement->fetchAll(\PDO::FETCH_NUM);
$result = [];
foreach ($rows as $row) {
$result[$row[0]] = $row[1];
}
return $result;
}
private function Execute()
{
$this->Connect();
try {
$this->getSyntax();
$this->Read->execute();
$this->Result = $this->Read->fetchAll();
} catch (PDOException $e) {
$this->Result = null;
WSErro("<b>Erro ao Ler:</b> {$e->getMessage()}", $e->getCode());
}
}
public function fetch()
{
$this->executeQuery();
if ($this->fetchResults === null) {
$this->fetchResults = $this->statement->fetchAll(PDO::FETCH_ASSOC);
$this->statement->closeCursor();
}
if (array_key_exists($this->currentFetchIndex, $this->fetchResults) && $this->fetchResults[$this->currentFetchIndex] !== null) {
return $this->fetchResults[$this->currentFetchIndex++];
}
return false;
}
private function Execute()
{
$this->getCon();
try {
$this->setParameters();
$this->read->execute();
$this->result = $this->read->fetchAll();
} catch (PDOException $ex) {
$this->result = false;
$erro = 'algo errado...' . $ex->getMessage();
}
}
public function __construct(PDOStatement $stm, $model = null, $fetchMode = PDO::FETCH_OBJ)
{
$this->offset = 0;
if (is_string($model)) {
$this->rows = $stm->fetchAll(PDO::FETCH_ASSOC);
$this->model = strtolower(str_ireplace('_model', '', $model));
} else {
$this->rows = $stm->fetchAll($fetchMode);
$this->model = null;
}
$this->rowCount = count($this->rows);
}
public function fetch($fetchStyle = null, $all = true)
{
if (is_null($this->query)) {
throw new \Exception('Cannot invoke fetch. Try using query or prepare/execute before fetch.');
}
if (is_null($fetchStyle)) {
$fetchStyle = \PDO::FETCH_OBJ;
}
if ($all === true) {
return $this->query->fetchAll($fetchStyle);
}
return $this->query->fetch($fetchStyle);
}
/**
* Load data if it hasn't been loaded yet
*/
protected function loadData()
{
if (null === $this->data) {
$this->statement->execute();
$this->data = $this->statement->fetchAll(\PDO::FETCH_ASSOC);
}
}
public static function executeFetchAllStatement(\PDOStatement $stmt)
{
if (!$stmt->execute()) {
return [];
}
return $stmt->fetchAll(\PDO::FETCH_ASSOC);
}
/**
* Returns the data result of the statement
* @return array
*/
public function getData()
{
if ($this->data === null) {
$this->data = $this->statement->fetchAll($this->fetchMode);
}
return $this->data;
}
public function all($class = null)
{
if (!$this->result) {
throw new Exception('Can\'t fetch results if no query!');
}
return $class === false ? $this->result->fetchAll(PDO::FETCH_ASSOC) : $this->result->fetchAll(PDO::FETCH_CLASS, $class ?: self::config('fetch'));
}
/**
* 获取全部记录
* 由于该方法会造成安全问题，所以不建议使用。在必须使用的场合，需要程序人员对sql语句做严格验证
* @param string $sql 预处理执行的sql
* @param array $data 符合pdo预处理模式键值对
* @return array
* @deprecated since version 108
*/
public function fetchAll($sql, $data = null)
{
$this->execute($sql, $data);
$data = $this->stmt instanceof \PDOStatement ? $this->stmt->fetchAll() : FALSE;
$this->stmt = null;
return $data;
}
protected function _fetchAll()
{
switch ($this->_fetchMode) {
case self::FETCH_DATAOBJECT:
self::$_stmt->setFetchMode(PDO::FETCH_ASSOC);
$rowset = new \SplFixedArray(self::$_stmt->rowCount());
$rowClass = $this->_fetchArgument;
foreach (self::$_stmt as $index => $data) {
$rowset[$index] = new $rowClass($data, true, $this->_ctorArgs);
}
return $rowset;
case self::FETCH_CLASSFUNC:
self::$_stmt->setFetchMode(PDO::FETCH_ASSOC);
$rowset = new \SplFixedArray(self::$_stmt->rowCount());
$classFunc = $this->_fetchArgument;
foreach (self::$_stmt as $index => $data) {
$rowClass = $classFunc($data);
$rowset[$index] = new $rowClass($data, true, $this->_ctorArgs);
}
return $rowset;
default:
if (isset($this->_ctorArgs)) {
return self::$_stmt->fetchAll($this->_fetchMode, $this->_fetchArgument, $this->_ctorArgs);
}
if (isset($this->_fetchArgument)) {
return self::$_stmt->fetchAll($this->_fetchMode, $this->_fetchArgument);
}
if (isset($this->_fetchMode)) {
return self::$_stmt->fetchAll($this->_fetchMode);
}
}
}
/**
* Вернет все строки результата как массив объектов указанного класса.
* Если класс не указан - объекты будут \StdClass
*
* @param string $className
*
* @return array
*/
public function fetchClass($className = null)
{
if ($className === null) {
$className = '\\StdClass';
}
return $this->stmt->fetchAll(\PDO::FETCH_CLASS, $className);
}
/**
* Fetches all rows based on the current pdo_statement and returns them.
* @return array
*/
public function fetchAll()
{
$this->checkStatement();
$result = $this->pdo_statement->fetchAll(\PDO::FETCH_ASSOC);
$this->clearStatement();
return $result;
}
/**
* 根据prepare类函数中的参数个数，传入$params
* @param array $params 如array(':Avalue'=>'10', ':Bvalue'=>'yellow');
* @param string $fetchRows 默认All时获取所有的，One则只获取一条
* @param string $fetchType 默认array获得字段索引数组，row获得以数字为索引数组，both获得array和row，obj获得一个对象，col获取列则必须传入colIndex，如果$fetchRows和$fetchType都为空，则返回PDOStatement对象
* @return \PDOStatement “注意此对象可能会被修改，所以不要写类似保存后在另外的地方使用的方法”
*/
public function selectPrepared($params = array(), $fetchRows = 'All', $fetchType = 'array', $colIndex = 0)
{
$result = $this->execute($params);
if ($result) {
if ($fetchType == 'row') {
$fetched = \PDO::FETCH_NUM;
} elseif ($fetchType == 'obj') {
$fetched = \PDO::FETCH_FETCH_CLASS;
} elseif ($fetchType == '') {
$fetched = \PDO::FETCH_BOTH;
} elseif ($fetchType == 'col') {
$fetched = \PDO::FETCH_COLUMN;
} else {
$fetched = \PDO::FETCH_ASSOC;
}
if ($fetchRows == 'All' || $fetchRows == 'all') {
if ($fetchType == 'col') {
return $this->pdoStatement->fetchAll($fetched, $colIndex);
} else {
return $this->pdoStatement->fetchAll($fetched);
}
} elseif ($fetchRows == 'One' || $fetchRows == 'one') {
if ($fetchType == 'col') {
return $this->pdoStatement->fetch($fetched, $colIndex);
} else {
return $this->pdoStatement->fetch($fetched);
}
}
return $this->pdoStatement;
} else {
return FALSE;
}
}
/**
* Returns an array containing all of the result set rows.
*
* @param string $fetch_style
* Controls how the rows will be returned.
* @return mixed
*/
public function fetchAll($fetch_style = null)
{
$this->setFetchMode($fetch_style);
$rows = $this->statement->fetchAll();
$this->statement->closeCursor();
return $rows;
}
/**
* @param $entityClass
* @return array
*/
public function getResultList($entityClass)
{
$this->sqlStatement->execute($this->params);
if ($this->sqlStatement->rowCount() > 0) {
$entities = array();
$rows = $this->sqlStatement->fetchAll();
foreach ($rows as $row) {
/** @var Entity $entity */
$entity = new $entityClass($this);
$entity->init($row);
array_push($entities, $entity);
}
return $entities;
}
return array();
}
public function fetchAll()
{
if (!$this->_sth) {
throw new \Exception();
}
return $this->_sth->fetchAll(\PDO::FETCH_ASSOC);
}
/**
* @method execute
* @param $query|string
* @return DataBase
*/
public function execute($query)
{
$this->error = false;
if ($query) {
if ($this->query = $this->pdo->prepare($this->escapeDoubleSpaces($query))) {
if (count($this->paramArray)) {
foreach ($this->paramArray as $param => $val) {
if (is_null($val)) {
$var = PDO::PARAM_NULL;
} elseif (is_int($val)) {
$var = PDO::PARAM_INT;
} elseif (is_bool($val)) {
$var = PDO::PARAM_BOOL;
} else {
$var = PDO::PARAM_STR;
if ($this->queryType === self::QUERY_TYPE_UPDATE) {
$val = $this->wrapInSingleQuotes($val);
}
}
$this->query->bindValue($param, $val, $var);
}
#End Foreach
}
if ($this->query->execute()) {
$this->results = $this->query->fetchAll(PDO::FETCH_OBJ);
$this->count = $this->query->rowCount();
} else {
$this->error = true;
}
}
}
$this->reset();
return $this;
}
public function select(\PDOStatement $stmnt, array $params = array(), $fetchStyle = null, $fetchArgument = null, array $ctorArgs = array())
{
$fetchStyle = $fetchStyle !== null ? $fetchStyle : self::$defaultFetchStyle;
try {
$this->triggerListeners('beforeSelect', array($this, $stmnt, $params));
$stmnt->execute($params);
$this->triggerListeners('afterSelect', array($this, $stmnt, $params));
if ($fetchStyle !== \PDO::FETCH_CLASS && $fetchStyle !== self::FETCH_FUNC) {
return $stmnt->fetchAll($fetchStyle);
} else {
return $stmnt->fetchAll($fetchStyle, $fetchArgument);
}
} catch (\PDOException $e) {
throw new DBException($e, $stmnt->queryString, $params);
}
}
