plugin

type Browser interface {
	Connect(ctx context.Context, dsn string) error
	Disconnect(ctx context.Context) error
	List(ctx context.Context, ids []string) ([]BrowserItem, error)
	Show(ctx context.Context, ids []string) (string, error)
	Query(ctx context.Context, sql string) (BrowserQueryResult, error)
	ParseExplain(data BrowserQueryResult) (BrowserExplainResult, error)
}

type BrowserExplainLine struct {
	Text      string
	Highlight bool
}

type BrowserExplainNode struct {
	Name     string
	Lines    []BrowserExplainLine
	Children []BrowserExplainNode
}

type BrowserExplainResult struct {
	Root         BrowserExplainNode
	SummaryLines []BrowserExplainLine
	Tables       []BrowserExplainTable
}

type BrowserExplainRow struct {
	Cells     []string
	Highlight bool
}

type BrowserExplainTable struct {
	Title   string
	Headers []string
	Rows    []BrowserExplainRow
}

type BrowserItem struct {
	ID          string
	Name        string
	HasChildren bool
}

type BrowserQueryResult struct {
	Headers     []string
	Rows        [][]string
	ColumnTypes []string
}

type Driver interface {
	Connect(ctx context.Context, config config.DriverConfig) (DriverConnection, error)
	Disconnect(ctx context.Context, conn DriverConnection) error
}

type DriverAuditColumn struct {
	PrimaryKey bool
	Name       string
	Type       int
	Nullable   bool
}

type DriverAuditLock struct {
	ID       string
	LockedAt time.Time
	LockedBy string
	Data     map[string]any
}

type DriverAuditLog struct {
	ID        int64
	AppliedAt time.Time
	Event     string
	Data      map[string]any
	Metadata  map[string]any
}

type DriverConnection interface {
	UpsertAuditLogTable(ctx context.Context, execCtx DriverExecutionContext) error
	UpsertAuditLockTable(ctx context.Context, execCtx DriverExecutionContext) error
	LockAuditLog(ctx context.Context, execCtx DriverExecutionContext, lock DriverAuditLock) error
	UnlockAuditLog(ctx context.Context, execCtx DriverExecutionContext, lock DriverAuditLock) error
	AppendAuditLog(ctx context.Context, execCtx DriverExecutionContext, log DriverAuditLog) error
	ReadAuditLogs(ctx context.Context, execCtx DriverExecutionContext) ([]DriverAuditLog, error)
	Query(execCtx DriverExecutionContext) DriverQuery
}

type DriverExecutionContext struct {
	Schema string
	Prefix string
}

type DriverInstance struct {
	Driver Driver
	Config *config.Driver
}

type DriverQuery interface {
	Begin(ctx context.Context) (DriverQuery, error)
	Commit(ctx context.Context) error
	Rollback(ctx context.Context) error
	Exec(ctx context.Context, query string, args ...any) error
	Query(ctx context.Context, query string, args ...any) (*DriverQueryResult, error)
}

type DriverQueryResult struct {
	AffectedRows int64
	Rows         [][]any
}