Bolt\Storage\Query\SelectQuery::getWhereParameters PHP Method

getWhereParameters() public method

Returns all the parameters for the query.
public getWhereParameters ( ) : array
return array
    public function getWhereParameters()
    {
        $params = [];
        foreach ($this->filters as $filter) {
            $params = array_merge($params, $filter->getParameters());
        }
        return $params;
    }

Usage Example

Esempio n. 1
0
 public function testQuery()
 {
     $app = $this->getApp();
     $filters = ['username' => '%fred%', 'email' => '%fred', 'status' => 'published'];
     $query = new SelectQuery($app['storage']->createQueryBuilder(), $app['query.parser.handler']);
     $query->setContentType('pages');
     $query->setParameters($filters);
     $expr = $query->getWhereExpression();
     $this->assertEquals('(pages.username LIKE :username_1) AND (pages.email LIKE :email_1) AND (pages.status = :status_1)', $expr->__toString());
     $this->assertEquals(['%fred%', '%fred', 'published'], array_values($query->getWhereParameters()));
 }