- Timestamp:
- 2012/02/11 05:48:00 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/test/class/db/SC_DB_DBFactory_Test.php
r21480 r21481 43 43 $objQuery = new SC_Query(DEFAULT_DSN, true, true); 44 44 switch (DB_TYPE) { 45 case "pgsql":45 case 'pgsql': 46 46 $this->assertEquals(true, preg_match("/^PostgreSQL [78].[0-9].[0-9]{1,}$/", $dbFactory->sfGetDBVersion())); 47 47 break; 48 48 49 case "mysql":49 case 'mysql': 50 50 $this->assertEquals(true, preg_match("/^MySQL [78].[0-9].[0-9]{1,}$/", $dbFactory->sfGetDBVersion())); 51 51 break; … … 58 58 $dbFactory = SC_DB_DBFactory::getInstance(); 59 59 $objQuery = new SC_Query(DEFAULT_DSN); 60 $actual = $dbFactory->findTableNames( "mtb_pre");61 $this->assertEquals( "mtb_pref", $actual[0]);60 $actual = $dbFactory->findTableNames('mtb_pre'); 61 $this->assertEquals('mtb_pref', $actual[0]); 62 62 } 63 63 64 64 function testConcatColumn() { 65 65 66 $params = array( "column1", "column2");66 $params = array('column1', 'column2'); 67 67 68 68 switch (DB_TYPE) { 69 case "pgsql":69 case 'pgsql': 70 70 $expected = "column1 || column2"; 71 71 break; 72 72 73 case "mysql":73 case 'mysql': 74 74 $expected = "concat(column1, column2)"; 75 75 break; … … 90 90 91 91 switch (DB_TYPE) { 92 case "pgsql":92 case 'pgsql': 93 93 $expected = "SELECT COUNT(total) FROM dtb_order " 94 94 . "WHERE del_flg = 0 " … … 97 97 break; 98 98 99 case "mysql":99 case 'mysql': 100 100 $expected = "SELECT COUNT(total) FROM dtb_order " 101 101 . "WHERE del_flg = 0 " … … 118 118 function testGetOrderMonthSql() { 119 119 switch (DB_TYPE) { 120 case "pgsql":120 case 'pgsql': 121 121 $expected = "SELECT COUNT(total) FROM dtb_order " 122 122 . "WHERE del_flg = 0 " … … 126 126 break; 127 127 128 case "mysql":128 case 'mysql': 129 129 $expected = "SELECT COUNT(total) FROM dtb_order " 130 130 . "WHERE del_flg = 0 " … … 148 148 function testGetReviewYesterdaySql() { 149 149 switch (DB_TYPE) { 150 case "pgsql":150 case 'pgsql': 151 151 $expected = "SELECT COUNT(*) FROM dtb_review AS A " 152 152 . "LEFT JOIN dtb_products AS B " … … 158 158 break; 159 159 160 case "mysql":160 case 'mysql': 161 161 $expected = "SELECT COUNT(*) FROM dtb_review AS A " 162 162 . "LEFT JOIN dtb_products AS B "
Note: See TracChangeset
for help on using the changeset viewer.