Function GetSingleWorkspaceByParams

cli/internal/dal/worksapce.go:223–299

获取单个工作区的信息

(workingMode workspace.WorkingModeEnum,
	workingDir string,
	gitCloneUrl string, branch string, confingFilePath string,
	remoteId int, remoteHost string, remoteUserName string)

// 获取单个工作区的信息
func GetSingleWorkspaceByParams(workingMode workspace.WorkingModeEnum,
	workingDir string,
	gitCloneUrl string, branch string, confingFilePath string,
	remoteId int, remoteHost string, remoteUserName string) (workspaceInfo workspace.WorkspaceInfo, err error) {
	db := getDb()
	defer db.Close()

	// 查询参数
	params := workspaceDo{}
	params.w_mode = string(workingMode)

	if remoteId <= 0 {
		remoteInfo, err := getRemote(remoteId, remoteHost, remoteUserName)
		common.CheckError(err)
		if remoteInfo != nil && remoteInfo.ID > 0 {
			params.r_id = sql.NullInt32{Int32: int32(remoteInfo.ID), Valid: true}
		}
	} else {
		params.r_id = sql.NullInt32{Int32: int32(remoteId), Valid: true}
	}

	// sql
	var row *sql.Row
	whereStr := " and w_mode=? "
	args := []interface{}{workingMode}
	if workingMode == workspace.WorkingMode_Remote {
		whereStr += " and r_id = ?"
		args = append(args, params.r_id)
	}
	if workingDir != "" { // 远程主机模式时，工作目录是不确定的
		params.w_workingdir = sql.NullString{String: workingDir, Valid: true}
		whereStr += " and w_workingdir = ?"
		args = append(args, params.w_workingdir)
	}
	if gitCloneUrl != "" {
		params.w_git_clone_repo_url = sql.NullString{String: gitCloneUrl, Valid: true}
		whereStr += " and w_git_clone_repo_url = ?"
		args = append(args, params.w_git_clone_repo_url)
	}
	if branch != "" {
		params.w_branch = branch
		whereStr += " and w_branch = ?"
		args = append(args, params.w_branch)
	}
	if confingFilePath != "" {
		params.w_config_file = sql.NullString{String: confingFilePath, Valid: true}
		whereStr += " and w_config_file = ?"
		args = append(args, params.w_config_file)
	}
	row = db.QueryRow(`select w_id, w_name, w_workingdir, w_docker_compose_file_path, w_mode, w_config_file,
								w_git_clone_repo_url, w_git_auth_type, w_git_username, w_git_password, w_branch, 
								r_id, k_id, w_is_del, 
								w_json, w_config_content, w_link_compose_content, w_temp_compose_content, 
								w_created 
							from workspace 
							where w_is_del = 0 `+whereStr, args...)

	// 赋值