Skip to content

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

3.4 KB
Raw Blame
package tests

import (
	"context"
	"fmt"
	"testing"

	"connectrpc.com/connect"
	"github.com/stretchr/testify/require"
	"google.golang.org/protobuf/types/known/fieldmaskpb"

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

func TestDatabaseEnvironment(t *testing.T) {
	t.Parallel()
	a := require.New(t)
	ctx := context.Background()
	ctl, ctx := startProject(ctx, t)

	pgContainer := sharedPgTarget(t)

	prodEnvironment, err := ctl.getEnvironment(ctx, "prod")
	a.NoError(err)
	testEnvironment, err := ctl.getEnvironment(ctx, "test")
	a.NoError(err)

	instanceResp, err := ctl.instanceServiceClient.CreateInstance(ctx, connect.NewRequest(&v1pb.CreateInstanceRequest{
		InstanceId: generateRandomString("instance"),
		Instance: &v1pb.Instance{
			Title:         "test",
			Engine:        v1pb.Engine_POSTGRES,
			Environment:   new(prodEnvironment.Name),
			Activation:    true,
			SyncDatabases: &v1pb.SyncDatabases{},
			DataSources:   []*v1pb.DataSource{pgContainer.dataSource(v1pb.DataSourceType_ADMIN, "admin-ds")},
		},
	}))
	a.NoError(err)
	instance := instanceResp.Msg

	db0Name := uniqueDB("db0")
	err = ctl.createDatabaseByRollout(ctx, ctl.project, instance, testEnvironment /* environment */, db0Name)
	a.NoError(err)
	db0Resp, err := ctl.databaseServiceClient.GetDatabase(ctx, connect.NewRequest(&v1pb.GetDatabaseRequest{
		Name: fmt.Sprintf("%s/databases/%s", instance.Name, db0Name),
	}))
	a.NoError(err)
	db0 := db0Resp.Msg
	a.NotNil(db0.Environment)
	a.Equal(testEnvironment.Name, *db0.Environment)
	a.NotNil(db0.EffectiveEnvironment)
	a.Equal(testEnvironment.Name, *db0.EffectiveEnvironment)

	db1Name := uniqueDB("db1")
	err = ctl.createDatabaseByRollout(ctx, ctl.project, instance, nil /* environment */, db1Name)
	a.NoError(err)
	db1Resp, err := ctl.databaseServiceClient.GetDatabase(ctx, connect.NewRequest(&v1pb.GetDatabaseRequest{
		Name: fmt.Sprintf("%s/databases/%s", instance.Name, db1Name),
	}))
	a.NoError(err)
	db1 := db1Resp.Msg
	a.Nil(db1.Environment)
	a.NotNil(db1.EffectiveEnvironment)
	a.Equal(prodEnvironment.Name, *db1.EffectiveEnvironment)

	db2Name := uniqueDB("db2")
	err = ctl.createDatabaseByRollout(ctx, ctl.project, instance, nil /* environment */, db2Name)
	a.NoError(err)
	db2Resp, err := ctl.databaseServiceClient.GetDatabase(ctx, connect.NewRequest(&v1pb.GetDatabaseRequest{
		Name: fmt.Sprintf("%s/databases/%s", instance.Name, db2Name),
	}))
	a.NoError(err)
	db2 := db2Resp.Msg

	// Update database environment for db2.
	db2Resp, err = ctl.databaseServiceClient.UpdateDatabase(ctx, connect.NewRequest(&v1pb.UpdateDatabaseRequest{
		Database: &v1pb.Database{
			Name:        db2.Name,
			Environment: new(testEnvironment.Name),
		},
		UpdateMask: &fieldmaskpb.FieldMask{
			Paths: []string{"environment"},
		},
	}))
	a.NoError(err)
	db2 = db2Resp.Msg
	a.NotNil(db2.Environment)
	a.Equal(testEnvironment.Name, *db2.Environment)
	a.NotNil(db2.EffectiveEnvironment)
	a.Equal(testEnvironment.Name, *db2.EffectiveEnvironment)

	// Unset database environment for db2.
	db2Resp, err = ctl.databaseServiceClient.UpdateDatabase(ctx, connect.NewRequest(&v1pb.UpdateDatabaseRequest{
		Database: &v1pb.Database{
			Name:        db2.Name,
			Environment: new(""),
		},
		UpdateMask: &fieldmaskpb.FieldMask{
			Paths: []string{"environment"},
		},
	}))
	a.NoError(err)
	db2 = db2Resp.Msg
	a.Nil(db2.Environment)
	a.NotNil(db2.EffectiveEnvironment)
	a.Equal(prodEnvironment.Name, *db2.EffectiveEnvironment)
}