source: branches/camp/camp-2_13-tests/tests/class/helper/SC_Helper_News/SC_Helper_News_saveNewsTest.php @ 22677

<?php

$HOME = realpath(dirname(__FILE__)) . "/../../../..";
require_once($HOME . "/tests/class/helper/SC_Helper_News/SC_Helper_News_TestBase.php");
/**
 *
 */
class SC_Helper_News_saveNewsTest extends SC_Helper_News_TestBase
{

    protected function setUp()
    {
        parent::setUp();
        $this->objNews = new SC_Helper_News_Ex();
    }

    protected function tearDown()
    {
        parent::tearDown();
    }

    /////////////////////////////////////////

    public function testSaveNewsTest_news_idが空の場合_新規登録される()
    {
        $objQuery =& SC_Query_Ex::getSingletonInstance();
        $this->setUpNews();
        
        $sqlval = array(
          'news_title' => 'ニュース情報05',
          'creator_id' => '1',
          'del_flg' => '0'
          );

        $this->expected['count'] = '5';
        $this->expected['content'] = array(
          'news_id' => '5',
          'news_title' => 'ニュース情報05',
          'creator_id' => '1',
          'del_flg' => '0'
          );

        $sqlval['news_id'] = $objQuery->setVal('dtb_news_news_id', 5);
        $ret_id = $this->objNews->saveNews($sqlval);

        $this->actual['count'] = $objQuery->count('dtb_news');
        $result = $objQuery->select(
          'news_id, news_title, creator_id, del_flg',
          'dtb_news',
          'news_id = ?',
          array($ret_id));
        $this->actual['content'] = $result[0];

        $this->verify();
    }

    public function testSaveNewsTest_news_idが存在する場合_対象のニュースが更新される()
    {
        $objQuery =& SC_Query_Ex::getSingletonInstance();
        $this->setUpNews();
        
        $sqlval = array(
          'news_id' => '2',
          'news_title' => 'ニュース情報05更新',
          'creator_id' => '1',
          'del_flg' => '0'
          );

        $this->expected['count'] = '4';
        $this->expected['content'] = array(
          'news_id' => '2',
          'news_title' => 'ニュース情報05更新',
          'creator_id' => '1',
          'del_flg' => '0'
          );

        $ret_id = $this->objNews->saveNews($sqlval);

        $this->actual['count'] = $objQuery->count('dtb_news');
        $result = $objQuery->select(
          'news_id, news_title, creator_id, del_flg',
          'dtb_news',
          'news_id = ?',
          array($ret_id));
        $this->actual['content'] = $result[0];

        $this->verify();
    }
}