database

type ColumnDef struct {
	Name        string `json:"name"`
	Type        string `json:"type"`
	Nullable    bool   `json:"nullable"`
	DefaultVal  string `json:"defaultVal"`
	DefaultType string `json:"defaultType"` // "none" | "null" | "value" | "auto"
	Comment     string `json:"comment"`
	Collation   string `json:"collation"`
	OnUpdate    bool   `json:"onUpdate"`
}

type ColumnInfo struct {
	Name        string `json:"name"`
	Type        string `json:"type"`
	Nullable    bool   `json:"nullable"`
	DefaultVal  string `json:"defaultVal"`
	DefaultType string `json:"defaultType"` // "none" | "null" | "value" | "auto"
	IsPrimary   bool   `json:"isPrimary"`
	Comment     string `json:"comment"`
	Collation   string `json:"collation"`
	OnUpdate    bool   `json:"onUpdate"`
}

type DBCapabilities map[string]any

type ExecResult struct {
	Affected     int64 `json:"affected"`
	LastInsertID int64 `json:"lastInsertId"`
}

type IndexDef struct {
	Name      string   `json:"name"`
	Columns   []string `json:"columns"`
	Unique    bool     `json:"unique"`
	IsPrimary bool     `json:"isPrimary"`
}

type IndexInfo struct {
	Name      string   `json:"name"`
	Columns   []string `json:"columns"`
	Unique    bool     `json:"unique"`
	IsPrimary bool     `json:"isPrimary"`
}

type Provider interface {
	// DSN generates a driver-specific connection string from connection fields.
	DSN(host string, port int, user, password, dbName string, extraParams map[string]string) string

	// DriverName returns the Go SQL driver name to use for sql.Open.
	DriverName() string

	// Quote returns an identifier quoted for this database.
	Quote(name string) string

	// Schema discovery
	GetDatabases(db *sql.DB) ([]string, error)
	GetTables(db *sql.DB, dbName string) ([]TableInfo, error)
	GetTableSchema(db *sql.DB, dbName, tableName string) (*SchemaResult, error)

	// DefaultTableQuery returns the default SELECT statement used when opening a table.
	DefaultTableQuery(dbName, tableName string, limit int) string

	// Row-level CRUD helpers for the result-grid inline actions.
	InsertRow(db *sql.DB, dbName, tableName string, values map[string]any) error
	UpdateRow(db *sql.DB, dbName, tableName string, set, where map[string]any) error
	DeleteRow(db *sql.DB, dbName, tableName string, where map[string]any) error

	// DDL: Database
	CreateDatabase(db *sql.DB, dbName string) error
	DropDatabase(db *sql.DB, dbName string) error

	// DDL: Table
	CreateTable(db *sql.DB, dbName, tableName string) error
	DropTable(db *sql.DB, dbName, tableName string) error
	DropView(db *sql.DB, dbName, viewName string) error
	TruncateTable(db *sql.DB, dbName, tableName string) error

	// DDL: Column
	AddColumn(db *sql.DB, dbName, tableName string, col ColumnDef) error
	ModifyColumn(db *sql.DB, dbName, tableName string, col ColumnDef) error
	DropColumn(db *sql.DB, dbName, tableName string, colName string) error

	// DDL: Index
	AddIndex(db *sql.DB, dbName, tableName string, idx IndexDef) error
	DropIndex(db *sql.DB, dbName, tableName string, idxName string, isPrimary bool, autoIncCols []string) error

	// Capabilities
	GetCapabilities() DBCapabilities

	// PrepareExec executes any per-database setup before running user SQL.
	PrepareExec(db execer, dbName string) error
}

type QueryResult struct {
	Columns []QueryResultColumn `json:"columns"`
	Rows    []map[string]any    `json:"rows"`
}

type QueryResultColumn struct {
	Name string `json:"name"`
	Type string `json:"type"`
}

type SchemaResult struct {
	Columns []ColumnInfo `json:"columns"`
	Indexes []IndexInfo  `json:"indexes"`
}

type TableInfo struct {
	Name string `json:"name"`
	Type string `json:"type"` // "table" or "view"
}