Path: blob/main/components/gitpod-db/go/dbtest/workspace.go
2500 views
// Copyright (c) 2022 Gitpod GmbH. All rights reserved.1// Licensed under the GNU Affero General Public License (AGPL).2// See License.AGPL.txt in the project root for license information.34package dbtest56import (7"database/sql"89"github.com/gitpod-io/gitpod/common-go/namegen"1011"testing"1213db "github.com/gitpod-io/gitpod/components/gitpod-db/go"14"github.com/google/uuid"15"github.com/stretchr/testify/require"16"gorm.io/gorm"17)1819const (20WorkspaceContext = `{"title":"[usage] List workspaces for each workspace instance in usage period","repository":{"cloneUrl":"https://github.com/gitpod-io/gitpod.git","host":"github.com","name":"gitpod","owner":"gitpod-io","private":false},"ref":"mp/usage-list-workspaces","refType":"branch","revision":"586f22ecaeeb3b4796fd92f9ae1ca3512ca1e330","nr":10495,"base":{"repository":{"cloneUrl":"https://github.com/gitpod-io/gitpod.git","host":"github.com","name":"gitpod","owner":"gitpod-io","private":false},"ref":"mp/usage-validate-instances","refType":"branch"},"normalizedContextURL":"https://github.com/gitpod-io/gitpod/pull/10495","checkoutLocation":"gitpod"}`21WorkspaceConfig = `{"image":"eu.gcr.io/gitpod-core-dev/dev/dev-environment:me-me-image.1","workspaceLocation":"gitpod/gitpod-ws.code-workspace","checkoutLocation":"gitpod","ports":[{"port":1337,"onOpen":"open-preview"},{"port":3000,"onOpen":"ignore"},{"port":3001,"onOpen":"ignore"},{"port":3306,"onOpen":"ignore"},{"port":4000,"onOpen":"ignore"},{"port":5900,"onOpen":"ignore"},{"port":6080,"onOpen":"ignore"},{"port":7777,"onOpen":"ignore"},{"port":9229,"onOpen":"ignore"},{"port":9999,"onOpen":"ignore"},{"port":13001,"onOpen":"ignore"},{"port":13444}],"tasks":[{"name":"Install Preview Environment kube-context","command":"(cd dev/preview/previewctl && go install .)\npreviewctl install-context\nexit\n"},{"name":"Add Harvester kubeconfig","command":"./dev/preview/util/download-and-merge-harvester-kubeconfig.sh\nexit 0\n"},{"name":"Java","command":"if [ -z \"$RUN_GRADLE_TASK\" ]; then\n read -r -p \"Press enter to continue Java gradle task\"\nfi\nleeway exec --package components/supervisor-api/java:lib --package components/gitpod-protocol/java:lib -- ./gradlew --build-cache build\nleeway exec --package components/ide/jetbrains/backend-plugin:plugin --package components/ide/jetbrains/gateway-plugin:publish --parallel -- ./gradlew --build-cache buildPlugin\n"},{"name":"TypeScript","before":"scripts/branch-namespace.sh","init":"yarn --network-timeout 100000 && yarn build"},{"name":"Go","before":"pre-commit install --install-hooks","init":"leeway exec --filter-type go -v -- go mod verify","openMode":"split-right"}],"vscode":{"extensions":["bradlc.vscode-tailwindcss","EditorConfig.EditorConfig","golang.go","hashicorp.terraform","ms-azuretools.vscode-docker","ms-kubernetes-tools.vscode-kubernetes-tools","stkb.rewrap","zxh404.vscode-proto3","matthewpi.caddyfile-support","heptio.jsonnet","timonwong.shellcheck","vscjava.vscode-java-pack","fwcd.kotlin","dbaeumer.vscode-eslint","esbenp.prettier-vscode"]},"jetbrains":{"goland":{"prebuilds":{"version":"stable"}}},"_origin":"repo","_featureFlags":[]}`22)2324// NewWorkspace creates a new stub workspace with default values, unless these are set on the workspace argument25// Records are not stored, use `Create(dbtest.NewWorkspace(t, Workspace{})) to store it.26// Only used for tests. Additional default properties may be added in the future.27func NewWorkspace(t *testing.T, workspace db.Workspace) db.Workspace {28t.Helper()2930id := GenerateWorkspaceID()31if workspace.ID != "" {32id = workspace.ID33}3435ownerID := uuid.New()36if workspace.OwnerID.ID() != 0 { // empty value37ownerID = workspace.OwnerID38}3940projectID := sql.NullString{41String: "",42Valid: false,43}44if workspace.ProjectID.Valid {45projectID = workspace.ProjectID46}4748workspaceType := db.WorkspaceType_Regular49if workspace.Type != "" {50workspaceType = workspace.Type51}5253contextURL := "https://github.com/gitpod-io/gitpod"54if workspace.ContextURL != "" {55contextURL = workspace.ContextURL56}5758context := []byte(WorkspaceContext)59if workspace.Context.String() != "" {60context = workspace.Context61}6263config := []byte(WorkspaceConfig)64if workspace.Config.String() != "" {65config = workspace.Config66}6768return db.Workspace{69ID: id,70OwnerID: ownerID,71Type: workspaceType,72ProjectID: projectID,73ContextURL: contextURL,74Context: context,75Config: config,76}77}7879func GenerateWorkspaceID() string {80id, _ := namegen.GenerateWorkspaceID()81return id82}8384func CreateWorkspaces(t *testing.T, conn *gorm.DB, workspaces ...db.Workspace) []db.Workspace {85t.Helper()8687var records []db.Workspace88var ids []string89for _, w := range workspaces {90record := NewWorkspace(t, w)91records = append(records, record)92ids = append(ids, record.ID)93}9495require.NoError(t, conn.CreateInBatches(&records, 1000).Error)9697t.Cleanup(func() {98require.NoError(t, conn.Where(ids).Delete(&db.Workspace{}).Error)99})100101return records102}103104105