schema

Apr 1, 2024

Changes in this version

type StringType

+ Attrs []Attr

Mar 3, 2024

Changes in this version

type Realm

+ Objects []Object

+ func (r *Realm) AddObjects(objs ...Object) *Realm

+ func (r *Realm) Object(f func(Object) bool) (Object, bool)

Feb 25, 2024

Changes in this version

type EnumType

+ func (e *EnumType) SpecName() string

+ func (e *EnumType) SpecType() string

Jan 1, 2024

Changes in this version

type InspectMode

+ const InspectTriggers

Dec 19, 2023

Changes in this version

+ var TriggerEventDelete = TriggerEvent

+ var TriggerEventInsert = TriggerEvent

+ var TriggerEventTruncate = TriggerEvent

+ var TriggerEventUpdate = TriggerEvent

+ type AddTrigger struct

+ Extra []Clause

+ T *Trigger

+ type DropTrigger struct

+ Extra []Clause

+ T *Trigger

type Func

+ Deps []Object

+ func (f *Func) AddDeps(objs ...Object) *Func

type InspectMode

+ const InspectObjects

+ type ModifyTrigger struct

+ Changes []Change

+ From *Trigger

+ To *Trigger

type Proc

+ Deps []Object

+ func (p *Proc) AddDeps(objs ...Object) *Proc

type Realm

+ func ExcludeRealm(r *Realm, patterns []string) (*Realm, error)

+ type RenameTrigger struct

+ From *Trigger

+ To *Trigger

type Schema

+ func ExcludeSchema(s *Schema, patterns []string) (*Schema, error)

type Table

+ Deps []Object

+ Triggers []*Trigger

+ func (t *Table) AddDeps(objs ...Object) *Table

+ func (t *Table) Trigger(name string) (*Trigger, bool)

+ type Trigger struct

+ ActionTime TriggerTime

+ Attrs []Attr

+ Body string

+ Deps []Object

+ Events []TriggerEvent

+ For TriggerFor

+ Name string

+ Table *Table

+ View *View

+ type TriggerEvent struct

+ Columns []*Column

+ Name string

+ func TriggerEventUpdateOf(columns ...*Column) TriggerEvent

+ type TriggerFor string

+ const TriggerForRow

+ const TriggerForStmt

+ type TriggerTime string

+ const TriggerTimeAfter

+ const TriggerTimeBefore

+ const TriggerTimeInstead

type Type

+ func UnderlyingType(t Type) Type

+ type TypeFormatter interface

+ FormatType func(Type) (string, error)

+ type TypeParseFormatter interface

+ type TypeParser interface

+ ParseType func(string) (Type, error)

type View

+ Triggers []*Trigger

+ func (v *View) Trigger(name string) (*Trigger, bool)

Oct 24, 2023

Changes in this version

+ type AddFunc struct

+ Extra []Clause

+ F *Func

+ type AddProc struct

+ Extra []Clause

+ P *Proc

+ type DropFunc struct

+ Extra []Clause

+ F *Func

+ type DropProc struct

+ Extra []Clause

+ P *Proc

+ type Func struct

+ Args []*FuncArg

+ Attrs []Attr

+ Body string

+ Lang string

+ Name string

+ Ret Type

+ Schema *Schema

+ type FuncArg struct

+ Attrs []Attr

+ Default Expr

+ Mode FuncArgMode

+ Name string

+ Type Type

+ type FuncArgMode string

+ const FuncArgModeIn

+ const FuncArgModeInOut

+ const FuncArgModeOut

+ const FuncArgModeVariadic

type InspectMode

+ const InspectFuncs

+ const InspectTypes

+ type ModifyFunc struct

+ Changes []Change

+ From *Func

+ To *Func

+ type ModifyProc struct

+ Changes []Change

+ From *Proc

+ To *Proc

+ type Proc struct

+ Args []*FuncArg

+ Attrs []Attr

+ Body string

+ Lang string

+ Name string

+ Schema *Schema

+ type RenameFunc struct

+ From *Func

+ To *Func

+ type RenameProc struct

+ From *Proc

+ To *Proc

type Schema

+ Funcs []*Func

+ Procs []*Proc

+ func (s *Schema) AddFuncs(funcs ...*Func) *Schema

+ func (s *Schema) AddProcs(procs ...*Proc) *Schema

+ func (s *Schema) Func(name string) (*Func, bool)

+ func (s *Schema) Proc(name string) (*Proc, bool)

type TimeType

+ Attrs []Attr

Sep 28, 2023

Changes in this version

type Index

+ View *View

+ type Materialized struct

type ModifyView

+ Changes []Change

type Schema

+ func (s *Schema) Materialized(name string) (*View, bool)

type View

+ Indexes []*Index

+ func NewMaterializedView(name, def string) *View

+ func (v *View) AddIndexes(indexes ...*Index) *View

+ func (v *View) AsTable() *Table

+ func (v *View) Index(name string) (*Index, bool)

+ func (v *View) Materialized() bool

+ func (v *View) SetMaterialized(b bool) *View

Aug 6, 2023

Changes in this version

type Expr

+ func UnderlyingExpr(x Expr) Expr

Jul 26, 2023

Changes in this version

+ const ViewCheckOptionCascaded

+ const ViewCheckOptionLocal

+ const ViewCheckOptionNone

+ type AddObject struct

+ Extra []Clause

+ O Object

+ type AddView struct

+ Extra []Clause

+ V *View

+ type DropObject struct

+ Extra []Clause

+ O Object

+ type DropView struct

+ Extra []Clause

+ V *View

type InspectMode

+ const InspectViews

+ type ModifyObject struct

+ From Object

+ To Object

+ type ModifyView struct

+ From *View

+ To *View

+ type Object interface

+ type RenameObject struct

+ From Object

+ To Object

+ type RenameView struct

+ From *View

+ To *View

type Schema

+ Objects []Object

+ Views []*View

+ func (s *Schema) AddObjects(objs ...Object) *Schema

+ func (s *Schema) AddViews(views ...*View) *Schema

+ func (s *Schema) Object(f func(Object) bool) (Object, bool)

+ func (s *Schema) View(name string) (*View, bool)

type TimeOption

+ func TimeScale(scale int) TimeOption

type TimeType

+ Scale *int

+ type View struct

+ Attrs []Attr

+ Columns []*Column

+ Def string

+ Deps []Object

+ Name string

+ Schema *Schema

+ func NewView(name, def string) *View

+ func (v *View) AddAttrs(attrs ...Attr) *View

+ func (v *View) AddColumns(columns ...*Column) *View

+ func (v *View) AddDeps(objs ...Object) *View

+ func (v *View) Column(name string) (*Column, bool)

+ func (v *View) SetCheckOption(opt string) *View

+ func (v *View) SetComment(c string) *View

+ func (v *View) SetSchema(s *Schema) *View

+ type ViewCheckOption struct

+ V string

May 8, 2023

Changes in this version

+ type DiffOption func(*DiffOptions)

+ func DiffSkipChanges(changes ...Change) DiffOption

+ type DiffOptions struct

+ Extra any

+ SkipChanges []Change

+ func NewDiffOptions(opts ...DiffOption) *DiffOptions

+ func (o *DiffOptions) AddOrSkip(changes Changes, c Change) Changes

+ func (o *DiffOptions) Skipped(c Change) bool

Apr 4, 2023

Changes in this version

type AddIndex

+ Extra []Clause

type DropIndex

+ Extra []Clause

Mar 15, 2023

Changes in this version

type Changes

+ func (c Changes) IndexModifyColumn(name string) int

+ func (c Changes) LastIndexAddTable(name string) int

+ func (c Changes) LastIndexDropTable(name string) int

Feb 28, 2023

Changes in this version

+ type AddPrimaryKey struct

+ P *Index

+ type DropPrimaryKey struct

+ P *Index

+ type ModifyPrimaryKey struct

+ Change ChangeKind

+ From *Index

+ To *Index

Jan 6, 2023

Changes in this version

+ type UUIDType struct

+ T string

Nov 13, 2022

Changes in this version

type Attr

+ func RemoveAttr(attrs []Attr) []Attr

type ChangeKind

+ func (i ChangeKind) String() string

Aug 11, 2022

Changes in this version

type EnumOption

+ func EnumSchema(s *Schema) EnumOption

type EnumType

+ Schema *Schema

type InspectOptions

+ Exclude []string

type InspectRealmOption

+ Exclude []string

type Realm

+ func (r *Realm) AddSchemas(schemas ...*Schema) *Realm

Jul 10, 2022

Changes in this version

type ChangeKind

+ const ChangeCollate

May 11, 2022

Changes in this version

+ var ErrLocked = errors.New("sql/schema: lock is held by other session")

+ func ReplaceOrAppend(attrs *[]Attr, v Attr)

type ChangeKind

+ const ChangeGenerated

+ type Changes []Change

+ func (c *Changes) RemoveIndex(indexes ...int)

+ func (c Changes) IndexAddColumn(name string) int

+ func (c Changes) IndexAddIndex(name string) int

+ func (c Changes) IndexAddTable(name string) int

+ func (c Changes) IndexDropColumn(name string) int

+ func (c Changes) IndexDropIndex(name string) int

+ func (c Changes) IndexDropTable(name string) int

type Column

+ func (c *Column) SetGeneratedExpr(x *GeneratedExpr) *Column

+ type GeneratedExpr struct

+ Expr string

+ Type string

+ type InspectMode uint

+ const InspectSchemas

+ const InspectTables

+ func (m InspectMode) Is(i InspectMode) bool

type InspectOptions

+ Mode InspectMode

type InspectRealmOption

+ Mode InspectMode

+ type Locker interface

+ Lock func(ctx context.Context, name string, timeout time.Duration) (UnlockFunc, error)

+ type RenameColumn struct

+ From *Column

+ To *Column

+ type RenameIndex struct

+ From *Index

+ To *Index

+ type RenameTable struct

+ From *Table

+ To *Table

+ type UnlockFunc func() error

Feb 24, 2022

Changes in this version

+ type Normalizer interface

+ NormalizeRealm func(context.Context, *Realm) (*Realm, error)

+ NormalizeSchema func(context.Context, *Schema) (*Schema, error)

Feb 13, 2022

Changes in this version

type DecimalOption

+ func DecimalUnsigned(unsigned bool) DecimalOption

type DecimalType

+ Unsigned bool

type FloatOption

+ func FloatUnsigned(unsigned bool) FloatOption

type FloatType

+ Unsigned bool

type Realm

+ func NewRealm(schemas ...*Schema) *Realm

+ func (r *Realm) SetCharset(v string) *Realm

+ func (r *Realm) SetCollation(v string) *Realm

+ func (r *Realm) UnsetCharset() *Realm

+ func (r *Realm) UnsetCollation() *Realm

Jan 27, 2022

Changes in this version

type IndexPart

+ Desc bool

+ func NewColumnPart(c *Column) *IndexPart

+ func NewExprPart(x Expr) *IndexPart

+ func (p *IndexPart) SetDesc(b bool) *IndexPart

+ type TimeOption func(*TimeType)

+ func TimePrecision(precision int) TimeOption

type TimeType

+ Precision int

Jan 16, 2022

Changes in this version

type Check

+ func NewCheck() *Check

+ func (c *Check) AddAttrs(attrs ...Attr) *Check

+ func (c *Check) SetExpr(expr string) *Check

+ func (c *Check) SetName(name string) *Check

type Column

+ func (c *Column) UnsetCharset() *Column

+ func (c *Column) UnsetCollation() *Column

type Index

+ func (i *Index) SetComment(v string) *Index

type Schema

+ func (s *Schema) UnsetCharset() *Schema

+ func (s *Schema) UnsetCollation() *Schema

type Table

+ func (t *Table) UnsetCharset() *Table

+ func (t *Table) UnsetCollation() *Table

Jan 6, 2022

Changes in this version

+ type AddCheck struct

+ C *Check

+ type AddSchema struct

+ Extra []Clause

+ S *Schema

+ type BinaryOption func(*BinaryType)

+ func BinarySize(size int) BinaryOption

+ type Check struct

+ Attrs []Attr

+ Expr string

+ Name string

+ type Clause interface

type Column

+ func NewBinaryColumn(name, typ string, opts ...BinaryOption) *Column

+ func NewBoolColumn(name, typ string) *Column

+ func NewColumn(name string) *Column

+ func NewDecimalColumn(name, typ string, opts ...DecimalOption) *Column

+ func NewEnumColumn(name string, opts ...EnumOption) *Column

+ func NewFloatColumn(name, typ string, opts ...FloatOption) *Column

+ func NewIntColumn(name, typ string) *Column

+ func NewJSONColumn(name, typ string) *Column

+ func NewNullBinaryColumn(name, typ string, opts ...BinaryOption) *Column

+ func NewNullBoolColumn(name, typ string) *Column

+ func NewNullColumn(name string) *Column

+ func NewNullDecimalColumn(name, typ string, opts ...DecimalOption) *Column

+ func NewNullEnumColumn(name string, opts ...EnumOption) *Column

+ func NewNullFloatColumn(name, typ string, opts ...FloatOption) *Column

+ func NewNullIntColumn(name, typ string) *Column

+ func NewNullJSONColumn(name, typ string) *Column

+ func NewNullSpatialColumn(name, typ string) *Column

+ func NewNullStringColumn(name, typ string, opts ...StringOption) *Column

+ func NewNullTimeColumn(name, typ string) *Column

+ func NewNullUintColumn(name, typ string) *Column

+ func NewSpatialColumn(name, typ string) *Column

+ func NewStringColumn(name, typ string, opts ...StringOption) *Column

+ func NewTimeColumn(name, typ string) *Column

+ func NewUintColumn(name, typ string) *Column

+ func (c *Column) AddAttrs(attrs ...Attr) *Column

+ func (c *Column) SetCharset(v string) *Column

+ func (c *Column) SetCollation(v string) *Column

+ func (c *Column) SetComment(v string) *Column

+ func (c *Column) SetDefault(x Expr) *Column

+ func (c *Column) SetNull(b bool) *Column

+ func (c *Column) SetType(t Type) *Column

+ type DecimalOption func(*DecimalType)

+ func DecimalPrecision(precision int) DecimalOption

+ func DecimalScale(scale int) DecimalOption

type Differ

+ RealmDiff func(from, to *Realm) ([]Change, error)

+ type DropCheck struct

+ C *Check

+ type DropSchema struct

+ Extra []Clause

+ S *Schema

+ type EnumOption func(*EnumType)

+ func EnumName(name string) EnumOption

+ func EnumValues(values ...string) EnumOption

+ type FloatOption func(*FloatType)

+ func FloatPrecision(precision int) FloatOption

type ForeignKey

+ func NewForeignKey(symbol string) *ForeignKey

+ func (f *ForeignKey) AddColumns(columns ...*Column) *ForeignKey

+ func (f *ForeignKey) AddRefColumns(columns ...*Column) *ForeignKey

+ func (f *ForeignKey) SetOnDelete(o ReferenceOption) *ForeignKey

+ func (f *ForeignKey) SetOnUpdate(o ReferenceOption) *ForeignKey

+ func (f *ForeignKey) SetRefTable(t *Table) *ForeignKey

+ func (f *ForeignKey) SetTable(t *Table) *ForeignKey

+ type IfExists struct

+ type IfNotExists struct

type Index

+ func NewIndex(name string) *Index

+ func NewPrimaryKey(columns ...*Column) *Index

+ func NewUniqueIndex(name string) *Index

+ func (i *Index) AddAttrs(attrs ...Attr) *Index

+ func (i *Index) AddColumns(columns ...*Column) *Index

+ func (i *Index) AddExprs(exprs ...Expr) *Index

+ func (i *Index) AddParts(parts ...*IndexPart) *Index

+ func (i *Index) SetName(name string) *Index

+ func (i *Index) SetTable(t *Table) *Index

+ func (i *Index) SetUnique(b bool) *Index

type IndexPart

+ func NewIndexPart(seqno int) *IndexPart

+ func (p *IndexPart) AddAttrs(attrs ...Attr) *IndexPart

+ func (p *IndexPart) SetColumn(c *Column) *IndexPart

+ func (p *IndexPart) SetExpr(x Expr) *IndexPart

type Inspector

+ InspectRealm func(ctx context.Context, opts *InspectRealmOption) (*Realm, error)

+ InspectTable func(ctx context.Context, name string, opts *InspectTableOptions) (*Table, error)

+ type ModifyCheck struct

+ Change ChangeKind

+ From *Check

+ To *Check

+ type ModifySchema struct

+ Changes []Change

+ S *Schema

type Realm

+ func (r *Realm) Schema(name string) (*Schema, bool)

type Schema

+ func New(name string) *Schema

+ func (s *Schema) AddAttrs(attrs ...Attr) *Schema

+ func (s *Schema) AddTables(tables ...*Table) *Schema

+ func (s *Schema) SetCharset(v string) *Schema

+ func (s *Schema) SetCollation(v string) *Schema

+ func (s *Schema) SetComment(v string) *Schema

+ func (s *Schema) SetRealm(r *Realm) *Schema

+ type StringOption func(*StringType)

+ func StringSize(size int) StringOption

type Table

+ func NewTable(name string) *Table

+ func (t *Table) AddAttrs(attrs ...Attr) *Table

+ func (t *Table) AddChecks(checks ...*Check) *Table

+ func (t *Table) AddColumns(columns ...*Column) *Table

+ func (t *Table) AddForeignKeys(fks ...*ForeignKey) *Table

+ func (t *Table) AddIndexes(indexes ...*Index) *Table

+ func (t *Table) SetCharset(v string) *Table

+ func (t *Table) SetCollation(v string) *Table

+ func (t *Table) SetComment(v string) *Table

+ func (t *Table) SetPrimaryKey(pk *Index) *Table

+ func (t *Table) SetSchema(s *Schema) *Table

Nov 21, 2021

Changes in this version

+ func IsNotExistError(err error) bool

+ type AddAttr struct

+ A Attr

+ type AddColumn struct

+ C *Column

+ type AddForeignKey struct

+ F *ForeignKey

+ type AddIndex struct

+ I *Index

+ type AddTable struct

+ Extra []Expr

+ T *Table

+ type Attr interface

+ type BinaryType struct

+ Size int

+ T string

+ type BoolType struct

+ T string

+ type Change interface

+ type ChangeKind uint

+ const ChangeAttr

+ const ChangeCharset

+ const ChangeCollation

+ const ChangeColumn

+ const ChangeComment

+ const ChangeDefault

+ const ChangeDeleteAction

+ const ChangeNull

+ const ChangeParts

+ const ChangeRefColumn

+ const ChangeRefTable

+ const ChangeType

+ const ChangeUnique

+ const ChangeUpdateAction

+ const NoChange

+ func (k ChangeKind) Is(c ChangeKind) bool

+ type Charset struct

+ V string

+ type Collation struct

+ V string

+ type Column struct

+ Attrs []Attr

+ Default Expr

+ ForeignKeys []*ForeignKey

+ Indexes []*Index

+ Name string

+ Type *ColumnType

+ type ColumnType struct

+ Null bool

+ Raw string

+ Type Type

+ type Comment struct

+ Text string

+ type DecimalType struct

+ Precision int

+ Scale int

+ T string

+ type Differ interface

+ SchemaDiff func(from, to *Schema) ([]Change, error)

+ TableDiff func(from, to *Table) ([]Change, error)

+ type DropAttr struct

+ A Attr

+ type DropColumn struct

+ C *Column

+ type DropForeignKey struct

+ F *ForeignKey

+ type DropIndex struct

+ I *Index

+ type DropTable struct

+ Extra []Expr

+ T *Table

+ type EnumType struct

+ T string

+ Values []string

+ type ExecQuerier interface

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ Query func(query string, args ...interface{}) (*sql.Rows, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRow func(query string, args ...interface{}) *sql.Row

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ type Execer interface

+ Exec func(ctx context.Context, changes []Change) error

+ type Expr interface

+ type FloatType struct

+ Precision int

+ T string

+ type ForeignKey struct

+ Columns []*Column

+ OnDelete ReferenceOption

+ OnUpdate ReferenceOption

+ RefColumns []*Column

+ RefTable *Table

+ Symbol string

+ Table *Table

+ func (f *ForeignKey) Column(name string) (*Column, bool)

+ func (f *ForeignKey) RefColumn(name string) (*Column, bool)

+ type Index struct

+ Attrs []Attr

+ Name string

+ Parts []*IndexPart

+ Table *Table

+ Unique bool

+ type IndexPart struct

+ Attrs []Attr

+ C *Column

+ SeqNo int

+ X Expr

+ type InspectOptions struct

+ Tables []string

+ type InspectRealmOption struct

+ Schemas []string

+ type InspectTableOptions struct

+ Schema string

+ type Inspector interface

+ InspectSchema func(ctx context.Context, name string, opts *InspectOptions) (*Schema, error)

+ type IntegerType struct

+ Attrs []Attr

+ T string

+ Unsigned bool

+ type JSONType struct

+ T string

+ type Literal struct

+ V string

+ type ModifyAttr struct

+ From Attr

+ To Attr

+ type ModifyColumn struct

+ Change ChangeKind

+ From *Column

+ To *Column

+ type ModifyForeignKey struct

+ Change ChangeKind

+ From *ForeignKey

+ To *ForeignKey

+ type ModifyIndex struct

+ Change ChangeKind

+ From *Index

+ To *Index

+ type ModifyTable struct

+ Changes []Change

+ T *Table

+ type NotExistError struct

+ Err error

+ func (e NotExistError) Error() string

+ type RawExpr struct

+ X string

+ type Realm struct

+ Attrs []Attr

+ Schemas []*Schema

+ type RealmInspector interface

+ InspectRealm func(ctx context.Context, opts *InspectRealmOption) (*Realm, error)

+ type ReferenceOption string

+ const Cascade

+ const NoAction

+ const Restrict

+ const SetDefault

+ const SetNull

+ type Schema struct

+ Attrs []Attr

+ Name string

+ Realm *Realm

+ Tables []*Table

+ func (s *Schema) Table(name string) (*Table, bool)

+ type SpatialType struct

+ T string

+ type StringType struct

+ Size int

+ T string

+ type Table struct

+ Attrs []Attr

+ Columns []*Column

+ ForeignKeys []*ForeignKey

+ Indexes []*Index

+ Name string

+ PrimaryKey *Index

+ Schema *Schema

+ func (t *Table) Column(name string) (*Column, bool)

+ func (t *Table) ForeignKey(symbol string) (*ForeignKey, bool)

+ func (t *Table) Index(name string) (*Index, bool)

+ type TableInspector interface

+ InspectTable func(ctx context.Context, name string, opts *InspectTableOptions) (*Table, error)

+ type TimeType struct

+ T string

+ type Type interface

+ type UnsupportedType struct

+ T string