/**
* @covers RecordsMan\Record::_select
*/
public function test_select()
{
$condition = Condition::create(['id>0', 'title ~ item%'], 'id');
$rows = Item::_select($condition);
$this->assertInternalType('array', $rows);
$this->assertEquals(7, count($rows));
$this->assertEquals(1, $rows[0]['id']);
}
/**
* @covers RecordsMan\Condition::create
*/
public function testCreate()
{
$this->assertInstanceOf('\\RecordsMan\\BoolCondition', Condition::create(['a = 5']));
$this->assertInstanceOf('\\RecordsMan\\BoolCondition', Condition::create(['a = 5', 'b = 10'], Condition::OPERATOR_OR));
$this->assertInstanceOf('\\RecordsMan\\ComparsionCondition', Condition::create('a = 5'));
$this->assertInstanceOf('\\RecordsMan\\ComparsionCondition', Condition::create('a > 5'));
$this->assertInstanceOf('\\RecordsMan\\ComparsionCondition', Condition::create('a < 5'));
$this->assertInstanceOf('\\RecordsMan\\ComparsionCondition', Condition::create('a >= 5'));
$this->assertInstanceOf('\\RecordsMan\\ComparsionCondition', Condition::create('a <= 5'));
$this->assertInstanceOf('\\RecordsMan\\ComparsionCondition', Condition::create('a ! 5'));
$this->assertInstanceOf('\\RecordsMan\\ComparsionCondition', Condition::create("title ~ ' test%'"));
$this->assertInstanceOf('\\RecordsMan\\PureSqlCondition', Condition::create('`a` = UPPER(`b`)'));
}
