diagnostics

type BrowserLogEntry struct {
	Time    string `json:"time,omitempty"`
	App     string `json:"app,omitempty"`
	Level   string `json:"level,omitempty"`
	Message string `json:"message"`
	URL     string `json:"url,omitempty"`
}

type BrowserLogRequest struct {
	App   string `json:"app,omitempty"`
	Limit int    `json:"limit,omitempty"`
}

type Column struct {
	Name     string `json:"name"`
	Type     string `json:"type"`
	Nullable bool   `json:"nullable"`
	Primary  bool   `json:"primary,omitempty"`
}

type DatabaseConnection struct {
	Name     string `json:"name"`
	Driver   string `json:"driver"`
	Database string `json:"database,omitempty"`
	App      string `json:"app,omitempty"`
}

type DatabaseSchema struct {
	Connection string  `json:"connection"`
	Tables     []Table `json:"tables,omitempty"`
}

type Index struct {
	Name    string   `json:"name"`
	Columns []string `json:"columns"`
	Unique  bool     `json:"unique,omitempty"`
}

type LogEntry struct {
	Time    string         `json:"time,omitempty"`
	App     string         `json:"app,omitempty"`
	Runtime string         `json:"runtime,omitempty"`
	Level   string         `json:"level,omitempty"`
	Message string         `json:"message"`
	Fields  map[string]any `json:"fields,omitempty"`
}

type LogRequest struct {
	App   string `json:"app,omitempty"`
	Limit int    `json:"limit,omitempty"`
}

type MetricsMetadata struct {
	App      string            `json:"app,omitempty"`
	Runtime  string            `json:"runtime,omitempty"`
	Labels   map[string]string `json:"labels,omitempty"`
	Targets  []string          `json:"targets,omitempty"`
	Counters []string          `json:"counters,omitempty"`
}

type MetricsMetadataRequest struct {
	App     string `json:"app,omitempty"`
	Runtime string `json:"runtime,omitempty"`
}

type Provider interface {
	// DatabaseConnections returns safe connection metadata without secrets.
	DatabaseConnections(context.Context) ([]DatabaseConnection, error)
	// DatabaseSchema returns table, column, and index metadata for a connection.
	DatabaseSchema(context.Context, string) (DatabaseSchema, error)
	// DatabaseQuery runs a bounded read-only query.
	DatabaseQuery(context.Context, QueryRequest) (QueryResult, error)
	// LogEntries returns recent framework log entries.
	LogEntries(context.Context, LogRequest) ([]LogEntry, error)
	// LastError returns the latest error-level log entry when one is available.
	LastError(context.Context) (LogEntry, bool, error)
	// AbsoluteURL resolves an app-relative path to a local absolute URL.
	AbsoluteURL(context.Context, URLRequest) (string, error)
	// BrowserLogs returns recent browser console entries captured during local development.
	BrowserLogs(context.Context, BrowserLogRequest) ([]BrowserLogEntry, error)
	// MetricsMetadata returns app/runtime-aware metrics labels and targets.
	MetricsMetadata(context.Context, MetricsMetadataRequest) (MetricsMetadata, error)
}

type QueryRequest struct {
	Connection string `json:"connection"`
	SQL        string `json:"sql"`
	Limit      int    `json:"limit,omitempty"`
}

type QueryResult struct {
	Connection string           `json:"connection"`
	Columns    []string         `json:"columns,omitempty"`
	Rows       []map[string]any `json:"rows,omitempty"`
	Limit      int              `json:"limit,omitempty"`
}

type StaticProvider struct {
	Connections []DatabaseConnection
	Schemas     map[string]DatabaseSchema
	Queries     map[string]QueryResult
	Logs        []LogEntry
	BaseURLs    map[string]string
	Browser     []BrowserLogEntry
	Metrics     map[string]MetricsMetadata
}

type Table struct {
	Name    string   `json:"name"`
	Columns []Column `json:"columns,omitempty"`
	Indexes []Index  `json:"indexes,omitempty"`
}

type URLRequest struct {
	App  string `json:"app,omitempty"`
	Path string `json:"path,omitempty"`
}