Function RemoveWorkspace

cli/internal/dal/worksapce.go:454–499

@title RemoveWorkspace @description 删除工作区 @auth jasonchen @param workspaceId int "工作区id" @return error

(workspaceId int)

// @param     workspaceId        int         "工作区id"
// @return           error
func RemoveWorkspace(workspaceId int) error {
	db := getDb()
	defer db.Close()

	// 数据校验
	var count int
	row := db.QueryRow("select count(1) from workspace where w_id=? and w_is_del = 0", workspaceId)
	switch err := row.Scan(&count); err {
	case sql.ErrNoRows:
		msg := fmt.Sprintf(" workspace (%v) ", workspaceId)
		common.SmartIDELog.WarningF(i18nInstance.Common.Warn_dal_record_not_exit_condition, msg)
	case nil:
		if count <= 0 {
			return errors.New(i18nInstance.Common.Warn_dal_record_not_exit)
		} else if count > 1 {
			return errors.New(i18nInstance.Common.Err_dal_update_count_too_much)
		}
	default:
		panic(err)
	}

	//
	stmt, err := db.Prepare("update workspace set w_is_del=1 where (w_id=?) and w_is_del = 0")
	if err != nil {
		return err
	}
	res, err := stmt.Exec(workspaceId)
	if err != nil {
		return err
	}
	affect, err := res.RowsAffected()
	if err != nil {
		return err
	}

	//
	if affect != 1 {
		if affect <= 0 {
			return errors.New(i18nInstance.Common.Err_dal_update_fail) // 更新失败
		} else if affect > 1 {
			common.SmartIDELog.Warning(i18nInstance.Common.Err_dal_update_count_too_much) // 更新条目 > 1
		}
	}

	return nil
}