Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.6 KB
Raw Blame
package tests

import (
	"context"
	"testing"

	"connectrpc.com/connect"
	"github.com/google/uuid"
	"github.com/stretchr/testify/require"

	v1pb "github.com/bytebase/bytebase/backend/generated-go/v1"
)

//nolint:tparallel // Subtests share one server lifecycle.
func TestArchiveProject(t *testing.T) {
	t.Parallel()
	a := require.New(t)
	ctx := context.Background()
	ctl, ctx := startProject(ctx, t)

	pgContainer := sharedPgTarget(t)

	// Add an instance.
	instanceResp, err := ctl.instanceServiceClient.CreateInstance(ctx, connect.NewRequest(&v1pb.CreateInstanceRequest{
		InstanceId: generateRandomString("instance"),
		Instance: &v1pb.Instance{
			SyncDatabases: &v1pb.SyncDatabases{},
			Title:         "test",
			Engine:        v1pb.Engine_POSTGRES,
			Environment:   new("environments/prod"),
			Activation:    true,
			DataSources:   []*v1pb.DataSource{pgContainer.adminDataSource()},
		},
	}))
	a.NoError(err)
	instance := instanceResp.Msg

	t.Run("ArchiveProjectWithDatabase", func(_ *testing.T) {
		databaseName := uniqueDB("db1")
		err = ctl.createDatabase(ctx, ctl.project, instance, nil /* environment */, databaseName, "")
		a.NoError(err)

		// Archive (purge=false) should succeed even with databases
		_, err = ctl.projectServiceClient.DeleteProject(ctx, connect.NewRequest(&v1pb.DeleteProjectRequest{
			Name: ctl.project.Name,
		}))
		a.NoError(err)

		// Restore the project for the next test
		_, err = ctl.projectServiceClient.UndeleteProject(ctx, connect.NewRequest(&v1pb.UndeleteProjectRequest{
			Name: ctl.project.Name,
		}))
		a.NoError(err)
	})

	t.Run("ArchiveProjectWithOpenIssue", func(_ *testing.T) {
		planResp, err := ctl.planServiceClient.CreatePlan(ctx, connect.NewRequest(&v1pb.CreatePlanRequest{
			Parent: ctl.project.Name,
			Plan: &v1pb.Plan{
				Specs: []*v1pb.Plan_Spec{
					{
						Id: uuid.NewString(),
						Config: &v1pb.Plan_Spec_CreateDatabaseConfig{
							CreateDatabaseConfig: &v1pb.Plan_CreateDatabaseConfig{
								Target:   instance.Name,
								Database: "fakedb",
							},
						},
					},
				},
			},
		}))
		a.NoError(err)
		plan := planResp.Msg
		_, err = ctl.issueServiceClient.CreateIssue(ctx, connect.NewRequest(&v1pb.CreateIssueRequest{
			Parent: ctl.project.Name,
			Issue: &v1pb.Issue{
				Title:       "dummy issue",
				Description: "dummy issue",
				Type:        v1pb.Issue_DATABASE_CHANGE,
				Plan:        plan.Name,
			},
		}))
		a.NoError(err)

		// Archive (purge=false) should succeed even with open issues
		_, err = ctl.projectServiceClient.DeleteProject(ctx, connect.NewRequest(&v1pb.DeleteProjectRequest{
			Name: ctl.project.Name,
		}))
		a.NoError(err)
	})
}