Changeset 22703 for branches/camp/camp-2_13-tests/tests/class/helper/SC_Helper_Kiyaku/SC_Helper_Kiyaku_saveKiyakuTest.php

Timestamp:

2013/03/10 10:31:02 (11 years ago)

Author:

tokuhiro

Message:

#2182 pgsql回避処理追加

File:

• branches/camp/camp-2_13-tests/tests/class/helper/SC_Helper_Kiyaku/SC_Helper_Kiyaku_saveKiyakuTest.php (modified) (1 diff)

branches/camp/camp-2_13-tests/tests/class/helper/SC_Helper_Kiyaku/SC_Helper_Kiyaku_saveKiyakuTest.php

@@ -24 +24 @@
     public function testsaveKiyakuTest_新規で規約を登録する場合_4を返す()
     {
-/*
-        $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $this->setUpKiyaku();
-        $this->expected = array(
-        );
 
-        $sqlval = array(
-                'kiyaku_title' => '第3条 (TEST)',
-                'kiyaku_text' => 'testKiyaku',
-                'rank' => '',
-                'creator_id' => '0',
-                'create_date' => '2000-01-01 00:00:00',
-                'update_date' => '2000-01-01 00:00:00',
-                'del_flg' => '0'
-               );
+        if(DB_TYPE != 'pgsql') { //postgresqlだとどうしてもDBエラーになるのでとりいそぎ回避
         
-        $this->objKiyaku->saveKiyaku($sqlval);
-
-        $col = 'kiyaku_id';
-        $from = 'dtb_kiyaku';
-        $where = 'kiyaku_id = ?';
-        $arrWhere = array($this->expected);
-        $ret = $objQuery->getCol($col, $from, $where, $arrWhere);
-        $this->actual = $ret[0];
-        $this->verify('新規規約登録');
-*/        
+            $objQuery =& SC_Query_Ex::getSingletonInstance();
+            $this->setUpKiyaku();
+            $this->expected = '4';
+        
+            $sqlval = array(
+                    'kiyaku_title' => '第3条 (TEST)',
+                    'kiyaku_text' => 'testKiyaku',
+                    'rank' => '',
+                    'creator_id' => '0',
+                    'create_date' => '2000-01-01 00:00:00',
+                    'update_date' => '2000-01-01 00:00:00',
+                    'del_flg' => '0'
+                   );
+            
+            $this->objKiyaku->saveKiyaku($sqlval);
+        
+            $col = 'kiyaku_id';
+            $from = 'dtb_kiyaku';
+            $where = 'kiyaku_id = ?';
+            $arrWhere = array($this->expected);
+            $ret = $objQuery->getCol($col, $from, $where, $arrWhere);
+            $this->actual = $ret[0];
+            $this->verify('新規規約登録');
+        }
     }
 
     public function testsaveKiyakuTest_規約を更新する場合_2を返す()
     {
-/*
-        $objQuery =& SC_Query_Ex::getSingletonInstance();
-        $this->setUpKiyaku();
-                $sqlval = array(
-                'kiyaku_id' => '2',
-                'kiyaku_title' => '第2条 (登録)',
-                'kiyaku_text' => 'test kiyaku2',
-                'rank' => '11',
-                'creator_id' => '0',
-                'create_date' => '2000-01-01 00:00:00',
-                'update_date' => '2000-01-01 00:00:00',
-                'del_flg' => '0'
-                                );
-        $this->expected = 2;
-        // シーケンス調整
-        $this->actual = $this->objKiyaku->saveKiyaku($sqlval);
-
-        $this->verify('新規規約登録');
-*/
+        if(DB_TYPE != 'pgsql') { //postgresqlだとどうしてもDBエラーになるのでとりいそぎ回避
+    
+            $objQuery =& SC_Query_Ex::getSingletonInstance();
+            $this->setUpKiyaku();
+            $sqlval = array(
+                    'kiyaku_id' => '2',
+                    'kiyaku_title' => '第2条 (登録)',
+                    'kiyaku_text' => 'test kiyaku2',
+                    'rank' => '11',
+                    'creator_id' => '0',
+                    'create_date' => '2000-01-01 00:00:00',
+                    'update_date' => '2000-01-01 00:00:00',
+                    'del_flg' => '0'
+                    );
+            $this->expected = 2;
+            // シーケンス調整
+            $this->actual = $this->objKiyaku->saveKiyaku($sqlval);
+    
+            $this->verify('新規規約登録');
+        }
     }
 }