/** * 删除用户 * 只用于单元测试 */ public function deleteUserByAccount($account) { $this->db->beginTransaction(); try { $res = Sql::select('uid')->from('uc_members')->where('username=?', $account)->forUpdate()->get($this->db); if (count($res) == 0) { $this->db->rollBack(); return false; } $uid = $res[0]['uid']; Sql::deleteFrom('pre_common_member_profile')->where('uid=?', $uid)->exec($this->db); Sql::deleteFrom('uc_members')->where('uid=?', $uid)->exec($this->db); $this->db->commit(); } catch (Exception $e) { $this->db->rollBack(); throw $e; } return true; }
public function testSelect18() { // SELECT * FROM tab FOR UPDATE of col $this->db->setExpected('SELECT * FROM tab FOR UPDATE OF col'); Sql::select('*')->from('tab')->forUpdate()->of('col')->get($this->db); }