/** * @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`)')); }