ParagonIE\EasyDB\Tests\EasyStatementTest::testLogicalIn PHP Method

testLogicalIn() public method

public testLogicalIn ( )
    public function testLogicalIn()
    {
        $statement = EasyStatement::open()->in('role_id IN (?*)', [1, 2, 3])->orIn('user_id IN (?*)', [100]);
        $this->assertSql($statement, 'role_id IN (?, ?, ?) OR user_id IN (?)');
        $this->assertValues($statement, [1, 2, 3, 100]);
        $statement = EasyStatement::open()->orIn('role_id IN (?*)', [4, 5, 6]);
        $this->assertSql($statement, 'role_id IN (?, ?, ?)');
        $this->assertValues($statement, [4, 5, 6]);
    }