From 903ae8a581fac1e6917fc3e31d2ad8fb91df80c3 Mon Sep 17 00:00:00 2001 From: ctrlaltca <> Date: Thu, 12 Jul 2012 11:21:01 +0000 Subject: standardize the use of unix eol; use svn properties to enforce native eol --- tests/unit/Data/SqlMap/DynamicParameterTest.php | 216 ++++++++++++------------ 1 file changed, 108 insertions(+), 108 deletions(-) (limited to 'tests/unit/Data/SqlMap/DynamicParameterTest.php') diff --git a/tests/unit/Data/SqlMap/DynamicParameterTest.php b/tests/unit/Data/SqlMap/DynamicParameterTest.php index f9b39b96..0bd5334e 100644 --- a/tests/unit/Data/SqlMap/DynamicParameterTest.php +++ b/tests/unit/Data/SqlMap/DynamicParameterTest.php @@ -1,109 +1,109 @@ -setActive(true); - - if($sqlMapManager === null) - { - $sqlMapManager = new TSqlMapManager($conn); - $sqlMapManager->configureXml( dirname(__FILE__) . '/DynamicParameterTestMap.xml'); - } - - return $sqlMapManager; - } - - public function testMysqlSelectStaticSql() - { - $mapper = $this->getMysqlSqlMapManager(); - $gateway = $mapper->getSqlmapGateway(); - - $value = $gateway->queryForObject('SelectStaticSql1'); - self::assertEquals('staticsql1', $value); - - $value = $gateway->queryForObject('SelectStaticSql2'); - self::assertEquals('staticsql2', $value); - } - - public function testMysqlSelectDynamicTable() - { - $mapper = $this->getMysqlSqlMapManager(); - $gateway = $mapper->getSqlmapGateway(); - - $value = $gateway->queryForObject('SelectDynamicTable', 'dynamicparametertest1'); - self::assertEquals('dynamictableparametertest1', $value); - - $value = $gateway->queryForObject('SelectDynamicTable', 'dynamicparametertest2'); - self::assertEquals('dynamictableparametertest2', $value); - } - - public function testMysqlSelectDynamicComplex() - { - $mapper = $this->getMysqlSqlMapManager(); - $gateway = $mapper->getSqlmapGateway(); - - $aParams = array( - 'tablename' => 'dynamicparametertest1', - 'testname' => 'dynamictable' - ); - $value = $gateway->queryForObject('SelectDynamicComplex', $aParams); - self::assertEquals('#dynamictableparametertest1$', $value); - - $aParams = array( - 'tablename' => 'dynamicparametertest2', - 'testname' => 'dynamictable' - ); - $value = $gateway->queryForObject('SelectDynamicComplex', $aParams); - self::assertEquals('#dynamictableparametertest2$', $value); - } - - public function testMysqlSelectNoDynamic() - { - $mapper = $this->getMysqlSqlMapManager(); - $gateway = $mapper->getSqlmapGateway(); - - $value = $gateway->queryForObject('SelectNoDynamic', 'dynamictable'); - self::assertEquals('dynamictableparametertest1', $value); - - $value = $gateway->queryForObject('SelectNoDynamic', 'staticsql'); - self::assertEquals('staticsql1', $value); - } - - /** - * Issue#209 test - */ - public function testMysqlInlineEscapeParam() - { - $mapper = $this->getMysqlSqlMapManager(); - $gateway = $mapper->getSqlmapGateway(); - - $value = $gateway->queryForObject('SelectInlineEscapeParam', "'1234567*123$456789$012345' AS foobar"); - self::assertEquals('1234567*123$456789$012345', $value); - - $value = $gateway->queryForObject('SelectInlineEscapeParam', '"1234567*123$456789$012345" AS foobar'); - self::assertEquals('1234567*123$456789$012345', $value); - - } - -} - +setActive(true); + + if($sqlMapManager === null) + { + $sqlMapManager = new TSqlMapManager($conn); + $sqlMapManager->configureXml( dirname(__FILE__) . '/DynamicParameterTestMap.xml'); + } + + return $sqlMapManager; + } + + public function testMysqlSelectStaticSql() + { + $mapper = $this->getMysqlSqlMapManager(); + $gateway = $mapper->getSqlmapGateway(); + + $value = $gateway->queryForObject('SelectStaticSql1'); + self::assertEquals('staticsql1', $value); + + $value = $gateway->queryForObject('SelectStaticSql2'); + self::assertEquals('staticsql2', $value); + } + + public function testMysqlSelectDynamicTable() + { + $mapper = $this->getMysqlSqlMapManager(); + $gateway = $mapper->getSqlmapGateway(); + + $value = $gateway->queryForObject('SelectDynamicTable', 'dynamicparametertest1'); + self::assertEquals('dynamictableparametertest1', $value); + + $value = $gateway->queryForObject('SelectDynamicTable', 'dynamicparametertest2'); + self::assertEquals('dynamictableparametertest2', $value); + } + + public function testMysqlSelectDynamicComplex() + { + $mapper = $this->getMysqlSqlMapManager(); + $gateway = $mapper->getSqlmapGateway(); + + $aParams = array( + 'tablename' => 'dynamicparametertest1', + 'testname' => 'dynamictable' + ); + $value = $gateway->queryForObject('SelectDynamicComplex', $aParams); + self::assertEquals('#dynamictableparametertest1$', $value); + + $aParams = array( + 'tablename' => 'dynamicparametertest2', + 'testname' => 'dynamictable' + ); + $value = $gateway->queryForObject('SelectDynamicComplex', $aParams); + self::assertEquals('#dynamictableparametertest2$', $value); + } + + public function testMysqlSelectNoDynamic() + { + $mapper = $this->getMysqlSqlMapManager(); + $gateway = $mapper->getSqlmapGateway(); + + $value = $gateway->queryForObject('SelectNoDynamic', 'dynamictable'); + self::assertEquals('dynamictableparametertest1', $value); + + $value = $gateway->queryForObject('SelectNoDynamic', 'staticsql'); + self::assertEquals('staticsql1', $value); + } + + /** + * Issue#209 test + */ + public function testMysqlInlineEscapeParam() + { + $mapper = $this->getMysqlSqlMapManager(); + $gateway = $mapper->getSqlmapGateway(); + + $value = $gateway->queryForObject('SelectInlineEscapeParam', "'1234567*123$456789$012345' AS foobar"); + self::assertEquals('1234567*123$456789$012345', $value); + + $value = $gateway->queryForObject('SelectInlineEscapeParam', '"1234567*123$456789$012345" AS foobar'); + self::assertEquals('1234567*123$456789$012345', $value); + + } + +} + ?> \ No newline at end of file -- cgit v1.2.3