Ouzo\Db\ModelQueryBuilder::where PHP Метод

where() публичный Метод

public where ( string $where = '', array $values = [] ) : ModelQueryBuilder
$where string
$values array
Результат ModelQueryBuilder
    public function where($where = '', $values = array())
    {
        $this->_query->where($where, $values);
        return $this;
    }

Usage Example

Пример #1
0
 /**
  * @test
  */
 public function shouldSubstituteParams()
 {
     //given
     $pdoStatement = Mock::mock();
     $pdo = Mock::mock();
     $db = Mock::mock('Ouzo\\Db');
     $db->_dbHandle = $pdo;
     Mock::when($pdo)->query(Mock::anyArgList())->thenReturn($pdoStatement);
     Mock::when($pdo)->quote("bob")->thenReturn("'bob'");
     Mock::when($pdoStatement)->fetchAll(Mock::anyArgList())->thenReturn(array());
     $modelQueryBuilder = new ModelQueryBuilder(SimpleModel::metaInstance(), $db);
     //when
     $modelQueryBuilder->where(array('name' => 'bob'))->options(array(Options::EMULATE_PREPARES => true))->fetchAll();
     //then
     Mock::verify($pdo)->query("SELECT simple_models.name AS _simple_models_name, simple_models.id AS _simple_models_id FROM simple_models WHERE name = 'bob'");
 }
All Usage Examples Of Ouzo\Db\ModelQueryBuilder::where