public function testGetExpressionDataWillEscapePercent() { $expression = new Expression('X LIKE "foo%"'); $this->assertEquals(array(array('X LIKE "foo%%"', array(), array())), $expression->getExpressionData()); }
/** * @covers Zend\Db\Sql\Expression::getExpressionData */ public function testGetExpressionData() { $expression = new Expression( 'X SAME AS ? AND Y = ? BUT LITERALLY ?', array('foo', 5, 'FUNC(FF%X)'), array(Expression::TYPE_IDENTIFIER, Expression::TYPE_VALUE, Expression::TYPE_LITERAL) ); $this->assertEquals( array(array( 'X SAME AS %s AND Y = %s BUT LITERALLY %s', array('foo', 5, 'FUNC(FF%X)'), array(Expression::TYPE_IDENTIFIER, Expression::TYPE_VALUE, Expression::TYPE_LITERAL) )), $expression->getExpressionData() ); }