public function testGetExpressionDataWithSubselectAndArrayIdentifier()
{
$select = new Select();
$in = new In(array('foo', 'bar'), $select);
$expected = array(array('(%s, %s) IN %s', array('foo', 'bar', $select), array($in::TYPE_IDENTIFIER, $in::TYPE_IDENTIFIER, $in::TYPE_VALUE)));
$this->assertEquals($expected, $in->getExpressionData());
}
public function testRetrievingWherePartsReturnsSpecificationArrayOfIdentifierAndValuesAndArrayOfTypes()
{
$in = new In();
$in->setIdentifier('foo.bar')->setValueSet(array(1, 2, 3));
$expected = array(array('%s IN (%s, %s, %s)', array('foo.bar', 1, 2, 3), array(In::TYPE_IDENTIFIER, In::TYPE_VALUE, In::TYPE_VALUE, In::TYPE_VALUE)));
$this->assertEquals($expected, $in->getExpressionData());
}
public function testGetExpressionDataWithSubselect()
{
$in = new In('foo', $select = new Select());
$expected = array(array('%s IN %s', array('foo', $select), array($in::TYPE_IDENTIFIER, $in::TYPE_VALUE)));
$this->assertEquals($expected, $in->getExpressionData());
}
public function testCanPassIdentifierAndValueSetToConstructor()
{
$predicate = new In('foo.bar', array(1, 2));
$this->assertEquals('foo.bar', $predicate->getIdentifier());
$this->assertEquals(array(1, 2), $predicate->getValueSet());
}
/**
* Constructor
*
* @param string $specification
* @param null|string $identifier
* @param array $valueSet
*/
public function __construct($specification, $identifier = null, $valueSet = null)
{
$this->selectSpecification = preg_replace('/\\?/', '%s', $specification, 1) . $this->selectSpecification;
$this->valueSpecSpecification = preg_replace('/\\?/', '%%s', $specification, 1) . $this->valueSpecSpecification;
parent::__construct($identifier, $valueSet);
}
