| 44 | } |
| 45 | |
| 46 | func GetRemoteList() (remoteList []workspace.RemoteInfo, err error) { |
| 47 | db := getDb() |
| 48 | defer db.Close() |
| 49 | |
| 50 | rows, err := db.Query(`select r_id, r_addr, r_port, r_auth_type, r_username, r_created |
| 51 | from remote |
| 52 | where r_is_del = 0`) |
| 53 | for rows.Next() { |
| 54 | do := remoteDO{} |
| 55 | |
| 56 | switch errSql := rows.Scan(&do.r_id, &do.r_addr, &do.r_port, &do.r_auth_type, &do.r_username, &do.r_created); errSql { |
| 57 | /* case sql.ErrNoRows: |
| 58 | common.SmartIDELog.Warning() //TODO */ |
| 59 | case nil: |
| 60 | |
| 61 | remoteInfo := workspace.RemoteInfo{} |
| 62 | |
| 63 | remoteInfo.ID = do.r_id |
| 64 | remoteInfo.Addr = do.r_addr |
| 65 | |
| 66 | if do.r_port.Valid { |
| 67 | remoteInfo.SSHPort = int(do.r_port.Int32) |
| 68 | } else { |
| 69 | remoteInfo.SSHPort = model.CONST_Container_SSHPort |
| 70 | } |
| 71 | |
| 72 | remoteInfo.AuthType = workspace.RemoteAuthType(do.r_auth_type) |
| 73 | remoteInfo.UserName = do.r_username |
| 74 | remoteInfo.CreatedTime = do.r_created |
| 75 | |
| 76 | remoteList = append(remoteList, remoteInfo) |
| 77 | |
| 78 | default: |
| 79 | err = errSql |
| 80 | } |
| 81 | // fmt.Println(uid, username, department, created) |
| 82 | } |
| 83 | |
| 84 | return remoteList, err |
| 85 | } |
| 86 | |
| 87 | func GetRemoteById(remoteId int) (remoteInfo *workspace.RemoteInfo, err error) { |
| 88 | return getRemote(remoteId, "", "") |