Skip to content

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

1.7 KB
Raw Blame
package tests

import (
	"context"
	"testing"

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

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

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

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

	databaseName := uniqueDB("admin_execute_audit")
	a.NoError(ctl.createDatabase(ctx, ctl.project, instanceResp.Msg, nil, databaseName, ""))
	databaseResp, err := ctl.databaseServiceClient.GetDatabase(ctx, connect.NewRequest(&v1pb.GetDatabaseRequest{
		Name: instanceResp.Msg.Name + "/databases/" + databaseName,
	}))
	a.NoError(err)

	results, err := ctl.adminQuery(ctx, databaseResp.Msg, "SELECT 1")
	a.NoError(err)
	a.NotEmpty(results)

	logs, err := ctl.auditLogServiceClient.SearchAuditLogs(ctx, connect.NewRequest(&v1pb.SearchAuditLogsRequest{
		Parent:  ctl.project.Name,
		Filter:  `method == "/bytebase.v1.SQLService/AdminExecute"`,
		OrderBy: "create_time desc",
	}))
	a.NoError(err)
	a.NotEmpty(logs.Msg.AuditLogs, "AdminExecute must produce an audit entry")
	entry := logs.Msg.AuditLogs[0]
	a.Equal("/bytebase.v1.SQLService/AdminExecute", entry.Method)
	a.Equal(databaseResp.Msg.Name, entry.Resource)
}