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