dbcontext

type Column struct {
	Name     string
	Type     string
	Nullable bool
}

type Connection struct {
	Name           string
	Driver         string
	Vendor         string
	Host           string
	ConnectionName string
	Port           int
	Database       string
	Username       string
	Password       string
	PasswordEnv    string
	Path           string
	DSN            string
	DSNEnv         string
	Description    string
	SSLMode        string
	PoolMode       string
	QueryExecMode  string
	Params         map[string]string
}

type Inspection struct {
	Connection      Connection
	PingMillis      int64
	Version         string
	CurrentDatabase string
	SchemaCount     int
	TableCount      int
	ViewCount       int
	TotalSizeBytes  int64
	TopSchemas      []SchemaSummary
	LargestTables   []TableSummary
	Objects         []Object
}

type Object struct {
	Schema  string
	Name    string
	Type    string
	Columns []Column
}

type QueryResult struct {
	Connection Connection
	Query      string
	Columns    []string
	Rows       []map[string]string
	Truncated  bool
}

type SchemaSummary struct {
	Schema     string
	TableCount int
	ViewCount  int
}

type TableSummary struct {
	Schema      string
	Name        string
	Type        string
	SizeBytes   int64
	RowEstimate int64
}