Skip to content

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

1.8 KB
Raw Blame
package tests

import (
	"context"
	"fmt"
	"time"

	"connectrpc.com/connect"

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

func (ctl *controller) adminQuery(ctx context.Context, database *v1pb.Database, query string) ([]*v1pb.QueryResult, error) {
	stream := ctl.sqlServiceClient.AdminExecute(ctx)
	if err := stream.Send(&v1pb.AdminExecuteRequest{
		Name:      database.Name,
		Statement: query,
	}); err != nil {
		return nil, err
	}
	resp, err := stream.Receive()
	if err != nil {
		return nil, err
	}
	if err := stream.CloseRequest(); err != nil {
		return nil, err
	}
	return resp.Results, nil
}

// GetSQLReviewResult will wait for next task SQL review task check to finish and return the task check result.
func (ctl *controller) GetSQLReviewResult(ctx context.Context, plan *v1pb.Plan) (*v1pb.PlanCheckRun, error) {
	ticker := time.NewTicker(100 * time.Millisecond)
	defer ticker.Stop()

	for range ticker.C {
		resp, err := ctl.planServiceClient.GetPlanCheckRun(ctx, connect.NewRequest(&v1pb.GetPlanCheckRunRequest{
			Name: fmt.Sprintf("%s/planCheckRun", plan.Name),
		}))
		if err != nil {
			return nil, err
		}
		check := resp.Msg
		hasStatementAdvise := false
		for _, result := range check.Results {
			if result.Type == v1pb.PlanCheckRun_Result_STATEMENT_ADVISE {
				hasStatementAdvise = true
				break
			}
		}
		if hasStatementAdvise {
			if check.Status == v1pb.PlanCheckRun_DONE || check.Status == v1pb.PlanCheckRun_FAILED {
				return check, nil
			}
		}
	}
	return nil, nil
}

// getSchemaDiff gets the schema diff.
func (ctl *controller) getSchemaDiff(ctx context.Context, schemaDiff *v1pb.DiffSchemaRequest) (string, error) {
	resp, err := ctl.databaseServiceClient.DiffSchema(ctx, connect.NewRequest(schemaDiff))
	if err != nil {
		return "", err
	}
	return resp.Msg.Diff, nil
}