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