Function getRemote

cli/internal/dal/remote.go:220–275

(remoteId int, host string, userName string)

}

func getRemote(remoteId int, host string, userName string) (remoteInfo *workspace.RemoteInfo, err error) {

	db := getDb()
	defer db.Close()

	do := remoteDO{}

	var row *sql.Row
	if len(host) > 0 {
		row = db.QueryRow(`select r_id, r_addr, r_port, r_username, r_auth_type, r_password, r_created 
		from remote 
		where r_addr=? and r_username = ? and r_is_del = 0`, host, userName)
	} else if remoteId > 0 {
		row = db.QueryRow(`select r_id, r_addr, r_port, r_username, r_auth_type, r_password, r_created 
		from remote where r_id=? and r_is_del = 0`, remoteId)
	} else {
		return
	}

	switch err := row.Scan(&do.r_id, &do.r_addr, &do.r_port, &do.r_username, &do.r_auth_type, &do.r_password, &do.r_created); err {
	case sql.ErrNoRows:
		msg := fmt.Sprintf("host (%v | %v)", host, remoteId)
		common.SmartIDELog.WarningF(i18nInstance.Common.Warn_dal_record_not_exit_condition, msg) // 不存在
	case nil:
		remoteInfo = &workspace.RemoteInfo{}
		remoteInfo.ID = do.r_id
		remoteInfo.Addr = do.r_addr
		remoteInfo.UserName = do.r_username
		if do.r_auth_type == string(workspace.RemoteAuthType_SSH) {
			remoteInfo.AuthType = workspace.RemoteAuthType_SSH
		} else if do.r_auth_type == string(workspace.RemoteAuthType_Password) {
			remoteInfo.AuthType = workspace.RemoteAuthType_Password
		} else {
			panic(do.r_auth_type + i18nInstance.Common.Err_enum_error) // 不能被识别
		}

		if int(do.r_port.Int32) > 0 {
			remoteInfo.SSHPort = int(do.r_port.Int32)
		} else {
			remoteInfo.SSHPort = 22
		}

		if do.r_password.Valid && len(do.r_password.String) > 0 {
			passwordDecrypt := aes4go.Decrypt(do.r_password.String, aesDecryptKey)
			remoteInfo.Password = passwordDecrypt
		}

		remoteInfo.CreatedTime = do.r_created
		//remote.CreatedTime = r_id

	default:
		panic(err)
	}

	return
}