sql

type Attribute interface {
	Name() string
	Value() any
}

type Column struct {
	Name          string
	Type          spec.Type
	Unique        bool
	Nullable      bool
	Sensitive     bool
	Comment       string
	Default       sql.NullString
	Charset       string
	Collation     string
	Precision     int
	Scale         int
	Primary       bool
	AutoIncrement bool
	OnUpdate      bool
	Attrs         []Attribute

	Table *Table
}

type Driver struct {
	// contains filtered or unexported fields
}

type Expression interface{}

type ForeignKey struct {
	Name       string
	Table      *Table
	Columns    []*Column
	RefTable   *Table
	RefColumns []*Column
	Inverse    bool
	OnUpdate   ReferenceOption
	OnDelete   ReferenceOption
	Attrs      []Attribute
}

type Index struct {
	Name         string
	Unique       bool
	Type         string
	Comment      string
	IndexColumns []*IndexColumn
	Primary      bool
}

type IndexColumn struct {
	SeqNo  int
	Column string
	Sub    int
	Expr   Expression
}

type Inspector interface {
	Inspect(ctx context.Context, name string) (*Schema, error)
}

type ReferenceOption string

type Schema struct {
	Name   string
	Tables []*Table
	Attrs  []Attribute
}

type Table struct {
	Name          string
	Charset       string
	Collation     string
	AutoIncrement int
	Comment       string
	Options       string
	Columns       []*Column
	Indexes       []*Index
	ForeignKeys   []*ForeignKey
	Attrs         []Attribute

	Schema *Schema
}