public function testWhereNotEquals() { $model = new Kwf_Model_FnF(); $model->setData(array(array('id' => 1, 'value' => 'foo'), array('id' => 2, 'value' => 'bar'), array('id' => 3, 'value' => 'baz'), array('id' => 4, 'value' => 'buz'))); /* $select = $model->select(); $select->whereNotEquals('value', 'foo'); $this->_assertIds($model, $select, array(2, 3, 4)); */ $select = $model->select(); $select->whereNotEquals('value', array('foo', 'baz')); $this->_assertIds($model, $select, array(2, 4)); // $this->assertEquals($model->countRows($select), 2); }
public function testExprEqualExpr() { $model = new Kwf_Model_FnF(array('exprs' => array('test' => new Kwf_Model_Select_Expr_Equals('value', new Kwf_Model_Select_Expr_Field('value'))))); $model->setData(array(array('id' => 1, 'value' => 10), array('id' => 2, 'value' => 20), array('id' => 3, 'value' => 30), array('id' => 4, 'value' => 40), array('id' => 5, 'value' => 50), array('id' => 6, 'value' => 60))); $this->assertTrue($model->getRow(1)->test); $rows = $model->getRows($model->select()->where(new Kwf_Model_Select_Expr_Equals('value', new Kwf_Model_Select_Expr_Field('value')))); $this->assertEquals(count($rows), $model->countRows()); }
public function testNonNumericIds() { $model = new Kwf_Model_FnF(array('data' => array(array('id' => '1'), array('id' => '3-foo'), array('id' => 4)))); $this->assertNotNull($model->getRow(1)); $this->assertNotNull($model->getRow('1')); $this->assertNull($model->getRow('3')); $this->assertNull($model->getRow(3)); $this->assertNull($model->getRow($model->select()->whereId(3))); $this->assertNull($model->getRow($model->select()->whereId('3'))); $this->assertEquals(0, count($model->getRows($model->select()->whereId('3')))); $this->assertEquals(0, count($model->getRows($model->select()->whereId(3)))); $this->assertEquals(0, count($model->getRows($model->select()->whereEquals('id', 3)))); $this->assertEquals(0, count($model->getRows($model->select()->whereEquals('id', '3')))); $this->assertNotNull($model->getRow('3-foo')); $this->assertNull($model->getRow('4-foo')); $this->assertNull($model->getRow($model->select()->whereId('4-foo'))); $this->assertEquals(0, count($model->getRows($model->select()->whereId('4-foo')))); $this->assertEquals(0, count($model->getRows($model->select()->whereEquals('id', '4-foo')))); }