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