public function test_insertAndGetID()
{
$sql = 'alter table tb_unittest auto_increment=4000';
$ret = DBMysqlNamespace::execute($this->handle, $sql);
$this->assertEquals($ret, TRUE);
$sql = 'insert into tb_unittest(c1) values (100)';
$ret = DBMysqlNamespace::insertAndGetID($this->handle, $sql);
$this->assertEquals($ret, 4000);
}
/**
* 执行insert sql语句，并获取执行成功后插入记录的id
* @param[in] handle $handle, 操作数据库的句柄
* @param[in] string $sql, 具体执行的sql语句
* @return FALSE表示执行失败， 否则返回insert的ID
*/
public function insertAndGetID($sql)
{
assert($this->_handle);
return DBMysqlNamespace::insertAndGetID($this->_handle, $sql);
}
/**
* 插入数据
* @param type $data
* @return boolean | int
* false:失败
* int : 插入记录对应的id
*/
public function insert($data)
{
if (empty($data)) {
return false;
}
$sql = $this->sqlBuilder->createInsertSql($data);
self::addSqlHistory($sql);
return DBMysqlNamespace::insertAndGetID($this->getMasterDb(), $sql);
}
