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);
}
