schema

type Column struct {
	Name            gds.String           `db:"name"`
	TableName       gds.String           `db:"table_name"`
	Type            Type                 `db:"-"`
	TypeRaw         gds.String           `db:"type_raw"`
	CharacterLength int16                `db:"character_length"`
	Nullable        bool                 `db:"nullable"`
	PrimaryKey      *PrimaryKey          `db:"-"`
	UniqueKey       *UniqueKey           `db:"-"`
	ForeignKey      *ForeignKey          `db:"-"`
	Comment         gds.String           `db:"comment"`
	DefaultRaw      sql.NullString       `db:"default_value"`
	Default         *ColumnDefault       `db:"-"`
	UsingSequences  map[string]*Sequence `db:"-"`
	Enum            *Enum                `db:"-"`

	IsAutoincrement bool `db:"-"`
}

type ColumnDefault struct {
	Type  ColumnDefaultType
	Value interface{}
}

type ColumnDefaultType int

type Database struct {
	Driver DatabaseDriver    `yaml:"driver"`
	DSN    specw.Env[string] `yaml:"dsn"`
	Schema string            `yaml:"schema"`
}

type DatabaseDriver string

type Enum struct {
	Name   *gds.String
	Values []string
	Used   int

	// List of names of tables, which using this enum.
	UsingInTables []string
}

type ForeignKey struct {
	Name          gds.String
	Table         gds.String
	ColumnsNames  *gds.Strings
	ForeignTable  gds.String
	ForeignColumn gds.String

	IsDeferrable        bool
	IsInitiallyDeferred bool
}

type PrimaryKey struct {
	Name         gds.String
	ColumnsNames *gds.Strings
}

type Schema struct {
	Tables    *TableMap
	Sequences map[string]*Sequence
	Enums     map[string]*Enum

	Driver DatabaseDriver
}

type Sequence struct {
	Name        string `db:"name"`
	DataType    Type   `db:"-"`
	DataTypeRaw string `db:"data_type_raw"`
	Used        int    `db:"-"`
}

type Table struct {
	Name    gds.String `db:"Name"`
	Columns []*Column  `db:"-"`

	PrimaryKey  *PrimaryKey            `db:"-"`
	ForeignKeys map[string]*ForeignKey `db:"-"`
	UniqueKeys  map[string]*UniqueKey  `db:"-"`

	UsingSequences map[string]*Sequence `db:"-"`
	UsingEnums     map[string]*Enum     `db:"-"`

	Comment string
	// contains filtered or unexported fields
}

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

type Type struct {
	Name string

	Length string

	IsNumeric    bool
	IsInteger    bool
	IsFloat      bool
	IsUUID       bool
	IsStringable bool
	IsDatetime   bool
	IsDate       bool
	IsBoolean    bool
	IsBinary     bool
	IsJSON       bool
	IsInterval   bool
}

type UniqueKey struct {
	Name         gds.String
	ColumnsNames *gds.Strings
}