[Svn-src-all:3234] [version-2_12-dev 22135] DB操作の例を追加
shift_hiroko.tamagawa
admin ＠ mail.ec-cube.net
2012年 12月 15日 (土) 13:02:22 JST
Subversion committed to /home/svn/open 22135
http://svn.ec-cube.net/open_trac/changeset/22135
┌────────────────────────────┐
│更新者 : shift_hiroko.tamagawa │
│更新日時: 2012-12-15 13:02:21 +0900 (土, 15 12月 2012)│
└────────────────────────────┘
Log:
--------------------------------------------------------
DB操作の例を追加
Changed: [U:修正，A:追加，D:削除]
--------------------------------------------------------
A branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_clearShipmentItemTempTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingPrefTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingTempTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isAddPointTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isUsePointTest.php
A branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_registerShippingTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_saveShippingTempTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetAllShippingTempTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetOneShippingTest.php
U branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetShippingTempTest.php
追加: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php (rev 0)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -0,0 +1,78 @@
+<?php
+
+$HOME = realpath(dirname(__FILE__)) . "/../../../..";
+require_once($HOME . "/tests/class/Common_TestCase.php");
+/**
+ *
+ */
+class SC_Helper_Purchase_TestBase extends Common_TestCase {
+
+ protected function setUp() {
+ parent::setUp();
+ }
+
+ protected function tearDown() {
+ parent::tearDown();
+ }
+
+ /////////////////////////////////////////
+ /**
+ * セッションに配送情報を設定します。
+ */
+ protected function setUpShipping($shipping) {
+ if (!$shipping) {
+ $shipping = getSingleShipping();
+ }
+
+ $_SESSION['shipping'] = $shipping;
+ }
+
+ protected function getSingleShipping() {
+ return array(
+ '00001' => array(
+ 'shipment_id' => '00001',
+ 'shipment_item' => '商品1',
+ 'shipping_pref' => '東京都')
+ );
+ }
+
+ protected function getMultipleShipping() {
+ return array(
+ '00001' => array(
+ 'shipment_id' => '00001',
+ 'shipment_item' => array('商品1'),
+ 'shipping_pref' => '東京都'),
+ '00002' => array(
+ 'shipment_id' => '00002',
+ 'shipment_item' => array('商品2'),
+ 'shipping_pref' => '沖縄県'),
+ '00003' => array(
+ 'shipment_id' => '00003',
+ 'shipment_item' => array(),
+ 'shipping_pref' => '埼玉県')
+ );
+ }
+
+ /**
+ * DBに配送情報を設定します。
+ */
+ protected function setUpShippingOnDb() {
+ $data = array(
+ array(
+ 'shipping_id' => '00001',
+ 'order_id' => '00001',
+ 'shipping_name01' => '配送情報01',
+ 'shipping_date' => '2012-01-12'
+ ),
+ array(
+ 'shipping_id' => '00002',
+ 'order_id' => '00002',
+ 'shipping_name01' => '配送情報02',
+ 'shipping_date' => '2011-10-01'
+ )
+ );
+ $this->objQuery->insert('dtb_shipping', $data[0]);
+ $this->objQuery->insert('dtb_shipping', $data[1]);
+ }
+}
+
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_clearShipmentItemTempTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_clearShipmentItemTempTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_clearShipmentItemTempTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_clearShipmentItemTempTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_clearShipmentItemTempTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingPrefTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingPrefTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingPrefTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestiBase.php");
/**
*
*/
-class SC_Helper_Purchase_getShippingPrefTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_getShippingPrefTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingTempTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingTempTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_getShippingTempTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_getShippingTempTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_getShippingTempTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isAddPointTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isAddPointTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isAddPointTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_isAddPointTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_isAddPointTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isUsePointTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isUsePointTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_isUsePointTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_isUsePointTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_isUsePointTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
追加: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_registerShippingTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_registerShippingTest.php (rev 0)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_registerShippingTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -0,0 +1,171 @@
+<?php
+
+$HOME = realpath(dirname(__FILE__)) . "/../../../..";
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
+/**
+ *
+ */
+class SC_Helper_Purchase_registerShippingTempTest extends SC_Helper_Purchase_TestBase {
+
+ protected function setUp() {
+ parent::setUp();
+ $this->setUpShippingOnDb();
+ }
+
+ protected function tearDown() {
+ parent::tearDown();
+ }
+
+ /////////////////////////////////////////
+ public function testRegsiterShipping_元々存在しない受注IDの場合_新規にデータが作られる() {
+ $order_id = '10';
+ $arrParams = array(
+ '20' =>
+ array(
+ 'order_id' => '10',
+ 'shipping_id' => '20',
+ 'shipping_name01' => '配送情報10',
+ 'shipping_date' => '2012/01/12'
+ )
+ );
+
+ $this->expected['count'] = '3'; // 1件増える
+ $this->expected['content'] = array(
+ 'order_id' => '10',
+ 'shipping_id' => '20',
+ 'shipping_name01' => '配送情報10',
+ 'shipping_date' => '2012-01-12 00:00:00'
+ );
+
+ SC_Helper_Purchase::registerShipping($order_id, $arrParams);
+
+ $this->actual['count'] = $this->objQuery->count('dtb_shipping');
+ $this->result = $this->objQuery->setWhere('order_id = ?')
+ ->select(
+ 'order_id,shipping_id,shipping_name01,shipping_date,create_date,update_date',
+ 'dtb_shipping',
+ '',
+ array($order_id));
+ $this->actual['content'] = $this->result[0];
+ unset($this->actual['content']['create_date']);
+ unset($this->actual['content']['update_date']);
+ $this->verify('登録した配送情報');
+ $this->assertNotNull($this->result[0]['create_date']);
+ $this->assertNotNull($this->result[0]['update_date']);
+ }
+
+ public function testRegisterShipping_元々存在する受注IDの場合_既存のデータが置き換えられる() {
+ $order_id = '2';
+ $arrParams = array(
+ '30' =>
+ array(
+ 'order_id' => '2',
+ 'shipping_id' => '30',
+ 'shipping_name01' => '配送情報02-update',
+ 'shipping_date' => '2013/12/03'
+ )
+ );
+
+ $this->expected['count'] = '2'; // 件数が変わらない
+ $this->expected['content'] = array(
+ 'order_id' => '2',
+ 'shipping_id' => '30',
+ 'shipping_name01' => '配送情報02-update',
+ 'shipping_date' => '2013-12-03 00:00:00'
+ );
+
+ SC_Helper_Purchase::registerShipping($order_id, $arrParams);
+
+ $this->actual['count'] = $this->objQuery->count('dtb_shipping');
+ $this->result = $this->objQuery->setWhere('order_id = ?')
+ ->select(
+ 'order_id,shipping_id,shipping_name01,shipping_date,create_date,update_date',
+ 'dtb_shipping',
+ '',
+ array($order_id));
+ $this->actual['content'] = $this->result[0];
+ unset($this->actual['content']['create_date']);
+ unset($this->actual['content']['update_date']);
+ $this->verify('登録した配送情報');
+ $this->assertNotNull($this->result[0]['create_date']);
+ $this->assertNotNull($this->result[0]['update_date']);
+ }
+
+ public function testRegisterShipping_配送日付が空の場合_エラーが起きず変換処理がスキップされる() {
+ $order_id = '2';
+ $arrParams = array(
+ '30' =>
+ array(
+ 'order_id' => '2',
+ 'shipping_id' => '30',
+ 'shipping_name01' => '配送情報02-update'
+ // 'shipping_date' => '2013/12/03 00:00:00'
+ )
+ );
+
+ $this->expected['count'] = '2';
+ $this->expected['content'] = array(
+ 'order_id' => '2',
+ 'shipping_id' => '30',
+ 'shipping_name01' => '配送情報02-update',
+ 'shipping_date' => NULL
+ );
+
+ SC_Helper_Purchase::registerShipping($order_id, $arrParams);
+
+ $this->actual['count'] = $this->objQuery->count('dtb_shipping');
+ $this->result = $this->objQuery->setWhere('order_id = ?')
+ ->select(
+ 'order_id,shipping_id,shipping_name01,shipping_date,create_date,update_date',
+ 'dtb_shipping',
+ '',
+ array($order_id));
+ $this->actual['content'] = $this->result[0];
+ unset($this->actual['content']['create_date']);
+ unset($this->actual['content']['update_date']);
+ $this->verify('登録した配送情報');
+ $this->assertNotNull($this->result[0]['create_date']);
+ $this->assertNotNull($this->result[0]['update_date']);
+ }
+
+ public function testRegisterShipping_非会員購入の場合_配送IDが設定される() {
+ $order_id = '2';
+ $arrParams = array(
+ '30' =>
+ array(
+ 'order_id' => '2',
+ // 'shipping_id' => '30',
+ 'shipping_name01' => '配送情報02-update',
+ 'shipping_date' => '2013/12/03 00:00:00'
+ )
+ );
+
+ $this->expected['count'] = '2'; // 件数が変わらない
+ $this->expected['content'] = array(
+ 'order_id' => '2',
+ 'shipping_id' => '30',
+ 'shipping_name01' => '配送情報02-update',
+ 'shipping_date' => '2013-12-03 00:00:00'
+ );
+
+ SC_Helper_Purchase::registerShipping($order_id, $arrParams);
+
+ $this->actual['count'] = $this->objQuery->count('dtb_shipping');
+ $this->result = $this->objQuery->setWhere('order_id = ?')
+ ->select(
+ 'order_id,shipping_id,shipping_name01,shipping_date,create_date,update_date',
+ 'dtb_shipping',
+ '',
+ array($order_id));
+ $this->actual['content'] = $this->result[0];
+ unset($this->actual['content']['create_date']);
+ unset($this->actual['content']['update_date']);
+ $this->verify('登録した配送情報');
+ $this->assertNotNull($this->result[0]['create_date']);
+ $this->assertNotNull($this->result[0]['update_date']);
+ }
+
+ //////////////////////////////////////////
+
+}
+
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_saveShippingTempTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_saveShippingTempTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_saveShippingTempTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_saveShippingTempTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_saveShippingTempTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetAllShippingTempTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetAllShippingTempTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetAllShippingTempTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_unsetAllShippingTempTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_unsetAllShippingTempTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetOneShippingTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetOneShippingTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetOneShippingTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_unsetOneShippingTempTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_unsetOneShippingTempTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
変更: branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetShippingTempTest.php
===================================================================
--- branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetShippingTempTest.php 2012-12-14 07:57:03 UTC (rev 22134)
+++ branches/version-2_12-dev/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_unsetShippingTempTest.php 2012-12-15 04:02:21 UTC (rev 22135)
@@ -1,11 +1,11 @@
<?php
$HOME = realpath(dirname(__FILE__)) . "/../../../..";
-require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_BaseTest.php");
+require_once($HOME . "/tests/class/helper/SC_Helper_Purchase/SC_Helper_Purchase_TestBase.php");
/**
*
*/
-class SC_Helper_Purchase_unsetShippingTempTest extends SC_Helper_Purchase_BaseTest {
+class SC_Helper_Purchase_unsetShippingTempTest extends SC_Helper_Purchase_TestBase {
protected function setUp() {
parent::setUp();
Svn-src-all メーリングリストの案内