source: branches/version-2_13-dev/tests/class/helper/SC_Helper_DB/SC_Helper_DB_sfColumnAddTest.php @ 22678

Revision 22678, 2.0 KB checked in by poego, 11 years ago (diff)

#2185 SC_Helper_DBが10%くらいできたのでコミット。一部リファクタ

Line 
1<?php
2
3$HOME = realpath(dirname(__FILE__)) . "/../../../..";
4require_once($HOME . "/tests/class/helper/SC_Helper_DB/SC_Helper_DB_TestBase.php");
5/*
6 * This file is part of EC-CUBE
7 *
8 * Copyright(c) 2000-2013 LOCKON CO.,LTD. All Rights Reserved.
9 *
10 * http://www.lockon.co.jp/
11 *
12 * This program is free software; you can redistribute it and/or
13 * modify it under the terms of the GNU General Public License
14 * as published by the Free Software Foundation; either version 2
15 * of the License, or (at your option) any later version.
16 *
17 * This program is distributed in the hope that it will be useful,
18 * but WITHOUT ANY WARRANTY; without even the implied warranty of
19 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
20 * GNU General Public License for more details.
21 *
22 * You should have received a copy of the GNU General Public License
23 * along with this program; if not, write to the Free Software
24 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
25 */
26
27/**
28 * SC_Helper_DB::sfColumnAdd()のテストクラス.
29 *
30 * @author Hiroko Tamagawa
31 * @version $Id: SC_Helper_DB_sfColumnAdd.php 22567 2013-02-18 10:09:54Z shutta $
32 */
33class SC_Helper_DB_sfColumnAdd extends SC_Helper_DB_TestBase
34{
35
36    protected function setUp()
37    {
38        parent::setUp();
39        $this->helper = new SC_Helper_DB_Ex();
40    }
41
42    protected function tearDown()
43    {
44        parent::tearDown();
45    }
46
47    /////////////////////////////////////////
48    public function testSfColumnAdd_指定のカラムが追加できたら_TRUEを返す()
49    {
50        $tableName = 'dtb_news';
51        $colName = 'news_id2';
52        $colType = 'int';
53        $this->expected = true;
54        $this->helper->sfColumnAdd($tableName, $colName, $colType);
55        $columns = $this->objQuery->listTableFields($tableName);
56        $this->actual = in_array($colName, $columns);
57        // rolbackできないのでカラムを削除する
58        $this->objQuery->query("ALTER TABLE $tableName DROP $colName");
59        $this->verify();
60    }
61
62}
Note: See TracBrowser for help on using the repository browser.