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'))));
}
