protected function insert()
{
$usersModel = MyPDOAdapter::model('users');
$usersModel->setDbUse('master');
$usersModel->setPK('user_id');
$password = '******';
$userData = ['username' => $this->randomChar(), 'role_id' => mt_rand(0, 10), 'score' => mt_rand(0, 10000), 'email' => $this->randomChar() . "@gmail.com", 'created_at' => date('Y-m-d H:i:s')];
$update = false;
if ($usersModel->insert($userData)->result()) {
$user = $usersModel->lastInsert()->row();
echo "INSERT User{{$user->user_id}}\n";
$update = $usersModel->update(['password' => sha1($user->user_id . '=>' . $password)], ['user_id' => $user->user_id])->result();
if ($update) {
echo "UPDATE User{{$user->user_id}}\n\n";
}
}
}
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
require_once "../PDOAdapter/MyPDOAdapter.php";
$db = MyPDOAdapter::model();
(new tester($db))->run();
class tester
{
protected $db = null;
protected $action = null;
public function __construct($db)
{
$this->db = $db;
$this->action = count($GLOBALS['argv']) > 1 ? $GLOBALS['argv'][1] : 'test';
}
public function run()
{
call_user_func([$this, $this->action]);
}
protected function test()
{
// instant model
// 每次调用 db->{{tableName}} 将产生一个实例
//
$usersModel = $this->db->users->setPK('user_id');
//equals
$usersModel = $this->db->users;
$usersModel = $usersModel->setPK('user_id');
//equals
$usersModel = $this->db->users;
public function __construct($table = null)
{
parent::__construct($table);
}
