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()
    {
        $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');
        $mod_member->beginTransaction();
        $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 testConnection()
    {
        $mysql = @new mysqli('192.168.1.103', 'root', '55668899', 'pandashop', '3306');
    }
}