xyzshop/test/DBTest.php

<?php

/**
 * Created by PhpStorm.
 * User: stanley-king
 * Date: 2017/1/31
 * Time: 上午11:28
 */

define('BASE_ROOT_PATH',str_replace('/test','',dirname(__FILE__)));
define('MOBILE_SERVER',true);
require_once(BASE_ROOT_PATH . '/fooder.php');

class DBTest extends PHPUnit_Framework_TestCase
{
    public static function setUpBeforeClass()
    {
        Base::run_util();
    }

    public function testQuery()
    {

//        $sql = "select * from lrlz_user_bonus where type_id=\'{$type_id}\' and \'session_id=\'{$sess_id}\' order by bonus_status asc,bonus_id asc limit 1";
        $mobile = '18911779278';
        $sql = "select * from lrlz_member where member_mobile='{$mobile}'";
        $items = Db::getAll($sql,array('lock' => true));

        //$items = Db::getAll('select * from lrlz_member');
    }

    public static function tearDownAfterClass()
    {

    }
    public function testModel()
    {
        $result = Model()->table('config')->select();
        $y = Model('member');
        $start = microtime(true);
        for ($i = 0; $i < 100; ++$i) {
            $member1 = Model('member');
        }
        $t = $member1;
        $period = microtime(true) - $start;

        $x = sprintf("%.6f",$period);

        echo  $period;
    }
    public function testTransaction()
    {
        $mod_member = Model('member');
        Db::start_transaction(MYSQLI_TRANS_START_READ_WRITE);
        $mod_member->where(array('member_id' => 36490))->update(array('member_name' => '江南舟子F'));
        $affect_rows_a = $mod_member->affected_rows();
        //$mod_member->rollback();
        $mod_member->commit();
        $affect_rows_b = $mod_member->affected_rows();
    }
    public function testMaster()
    {
        $mod_member = Model('member');
        //$items = $mod_member->where(array('member_mobile' => '18911779278'))->limit(false)->select(array('lock' => true));
        $item = $mod_member->where(array('member_mobile' => '18911779278'))->find(array('lock' => true));
    }

    public function testConnection()
    {
        $mysql = @new mysqli('192.168.1.205', 'root', '55668899', 'pandashop', '3306');
    }

    public function testConnectionhost()
    {
        $mysql = @new mysqli('192.168.1.103', 'root', '55668899', 'pandashop', '3306');
    }



    public function testTableInfo()
    {
        $mod_member = Model('member');
        $iterm = $mod_member->tableInfo('memble');

        $mod_member = Model();
        $iterm = $mod_member->tableInfo('memble');

    }

    public function testUpdate()
    {
        $mod_member = Model('member');
        $data = array(
            'member_mobile' => '15512468630'
        );
        $mod_member->where(array('member_id'=>1))->update($data);

        $mod_member->execute('UPDATE `lrlz_member` SET member_mobile=\'15512468638\' WHERE ( member_id = \'1\' )');
    }

    public function testInsert()
    {
        $mod_member = Model('member');
        $data = array(
            'member_mobile' => '18330118841'
        );
        $ret = $mod_member->insert($data);
    }

    public function testInsertAll()
    {
        $mod_member = Model('member');
        $data = array(
            array(
                'member_mobile'=>'18330118840'
            ),
            array(
                'member_mobile'=>'18330118839'
            )
        );
        $mod_member->insertAll($data);
    }

    public function testDelete()
    {
        $mod_member = Model('member');
        $mod_member->where(array('member_mobile'=>'18330118841'))->delete();
    }

    public function testSelect()
    {
        $mod_member = Model('member');
        $iterm = $mod_member->where(array('member_mobile' => '15512468630'))->select();
    }

    public function testFind()
    {
        $mod_member = Model('member');
        $iterm = $mod_member->where(array('member_mobile' => '15512468630'))->find();
    }

    public function testLimit()
    {
        $mod_member = Model('member');
        $iterm = $mod_member->limit(4)->select();
    }

    public function testTable()
    {
        $mod_member = Model();
        $iterm = $mod_member->table('member')->limit(4)->where(array('member_mobile'=>'15512468630'))->select();
    }

    public function testJoin()
    {
        $mod_member = Model();
        $on = 'member.member_id=member_common.member_id';
        $iterm = $mod_member->table('member,member_common')->join('inner')->on($on)->limit(2)->select();
    }

    public function testOrder()
    {
        $mod_member = Model();
        $iterm = $mod_member->field('member_id,member_sex')->table('member')->order('member_id desc')->limit(50)->select();
        $itermb = $mod_member->field('member_id,member_sex')->table('member')->order('member_id desc,member_sex asc')->limit(50)->select();
    }

    public function testCount()
    {
        $mod_member = Model('member');
        $num = $mod_member->count();
        $num_big = $mod_member->where('member_id>15')->count();

    }

    public function testPage()
    {
        $mod_member = Model('member');
        //$reta = $mod_member->page(10)->order('member_id desc')->select();
        $retb = $mod_member->page(10, 100)->order('member_id desc')->select();
  //      $retc = $mod_member->page(10)->where('member_id=1')->select();
 //       $retd = $mod_member->where('member_id=1')->page(10)->select();
    }

    public function testGroup()
    {
        $mod_member = Model('member');
        $result = $mod_member->field('member_id,member_login_num,count(*)as count')->group('member_login_num')->select();
    }

    public function testHaving()
    {
       //$mod_goods = Model('goods');
        //$result = $mod_goods->field('store_id,count(*) as nc_count')->group('store_id')->having('nc_count>500')->select();

        $mod_member = Model('member');
        $result = $mod_member->field('member_id,member_login_num,count(*)as count')->group('member_login_num')->select();
        $result = $mod_member->field('member_id,member_login_num,count(*)as count')->group('member_login_num')->having('count>500')->select();

    }

    public function testQuerya()
    {
        $mod_member = Model('member');
        Model()->query('SELECT * FROM `shopnc_member` LIMIT 10');
        Model()->execute('UPDATE `shopnc_member` SET member_mobile=18330118841 WHERE member_id=1');

        $mod_member = Model();
        $mod_member->query('SELECT * FROM `shopnc_member` LIMIT 10');

    }

    public function testSum()
    {
        $mod_goods = Model();
        $mod_goods->table('goods')->sum('price');
    }

    public function testSetInc()
    {
        $mod_member = Model('member');
        $ret = $mod_member->where('member_id=2')->setInc('member_id', 1000);
        $retb = $mod_member->where(array('member_id=2'))->setInc('member_id', 1000);
    }

    public function testGetby_member_name()
    {
        $mod_member = Model('member');
        $ret = $mod_member->getby_member_name('江海苗');
    }

    public function testAttr()
    {
        $model = Model('goods');
        $ret = $model->where(array('goods_id' => 100))->attr('LOW_PRIORITY');
        $ret = $model->update(array('goods_click' =>array('exp','goods_click+1')));
    }

    public function testAutoCommit()
    {
        $model = Model('member');
        while (true)
        {
            $model->beginTransaction();
            $ret = $model->where(array('member_id' => 10000000))->update(array('member_mobilex' => '18911779278'));
            $affect_rows = $model->affected_rows();
            $model->beginTransaction();
            $ret = $model->where(array('member_id' => 36490))->update(array('member_mobile' => '18911779279'));
            $affect_rows = $model->affected_rows();

            $model->commit();
        }
    }
}