Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
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)
}