public function test_lastAffected() { $sql = 'insert into tb_unittest(c1) values (100)'; $ret = DBMysqlNamespace::execute($this->handle, $sql); $ret = DBMysqlNamespace::execute($this->handle, $sql); $this->assertEquals($ret, TRUE); $ret = DBMysqlNamespace::lastAffected($this->handle); $this->assertEquals($ret, 1); $sql = 'delete from tb_unittest'; $ret = DBMysqlNamespace::execute($this->handle, $sql); $this->assertEquals($ret, TRUE); $ret = DBMysqlNamespace::lastAffected($this->handle); $this->assertEquals($ret, 2); }
/** * 更新数据 * @param type $where 条件 * @param array $updateData 更新的内容 * @return boolean */ public function update($where, $updateData) { if (empty($where) || empty($updateData)) { return false; } $sql = $this->sqlBuilder->createUpdateSql($updateData, $where); self::addSqlHistory($sql); return DBMysqlNamespace::execute($this->getMasterDb(), $sql); }
/** * 执行sql语句, 该语句必须是insert, update, delete, create table, drop table等更新语句 * @param[in] string $sql, 具体执行的sql语句 * @return TRUE:表示成功, FALSE:表示失败 */ public function execute($sql) { assert($this->_handle); return DBMysqlNamespace::execute($this->_handle, $sql); }
/** * 运行SQL * @param string $sql * @return mixed */ private function _runSQL($sql) { return DBMysqlNamespace::execute($this->_handle, $sql); }