migration

package module

Go to main page

Versions in this module

v1

v1.3.2

Nov 4, 2022

v1.3.1

Nov 3, 2022

v1.3.0

Nov 3, 2022

v1.2.0

Oct 24, 2022

v1.1.3

Oct 21, 2022

v1.1.2

Oct 20, 2022

v1.1.1

Jun 30, 2022

v1.1.0

Jun 15, 2022

v1.0.0

Jun 3, 2022

v0

v0.4.0

Apr 13, 2023

Changes in this version

+ var ErrSqliteForeignKeyCheck = errors.New("sqlite foreign key constraint violation")

type Actions

+ CreateView func(view *View) error

+ DropView func(name string) error

+ ExecDDL func(query string, args ...any) error

type BigInt

+ func (BigInt) CanBeAutoIncr() bool

type Blob

+ func (Blob) CanBeAutoIncr() bool

type Boolean

+ func (Boolean) CanBeAutoIncr() bool

type DataType

+ CanBeAutoIncr func() bool

type Date

+ func (Date) CanBeAutoIncr() bool

type DateTime

+ func (DateTime) CanBeAutoIncr() bool

type DateTimeOffset

+ func (DateTimeOffset) CanBeAutoIncr() bool

type Double

+ func (Double) CanBeAutoIncr() bool

+ type Expression string

type Float

+ func (Float) CanBeAutoIncr() bool

+ type Index struct

+ Cols []string

+ Name string

+ On string

+ Unique bool

type Integer

+ func (Integer) CanBeAutoIncr() bool

type SmallInt

+ func (SmallInt) CanBeAutoIncr() bool

type Text

+ func (Text) CanBeAutoIncr() bool

type TinyInt

+ func (TinyInt) CanBeAutoIncr() bool

type Varchar

+ func (Varchar) CanBeAutoIncr() bool

+ type View struct

+ As string

+ ColNames []string

+ Name string

v0.3.0

Nov 22, 2022

Changes in this version

+ var ErrMissingColumnName = errors.New("missing column name")

+ var ErrMissingColumnType = errors.New("missing column type")

+ var ErrMissingConstraintCols = errors.New("missing constraint columns")

+ var ErrMissingConstraintName = errors.New("missing constraint name")

+ var ErrMissingExpression = errors.New("missing expression")

+ var ErrMissingNewColumnName = errors.New("missing new column name")

+ var ErrMissingRefCols = errors.New("missing reference columns")

+ var ErrMissingRefTable = errors.New("missing reference table")

+ var ErrNoColumns = errors.New("table has no columns")

+ var ErrNonIntegerAutoIncr = errors.New("auto-increment can only be set on integer columns")

+ var ErrSqliteAutoIncrPK = errors.New(...)

+ var ErrSqliteTableParse = errors.New("could not parse the sqlite table schema")

+ var ErrUnknownDataType = errors.New("unknown SQL data type")

+ var ErrUnknownModification = errors.New("unknown table modification type")

+ var ErrUnsupportedGoType = errors.New("unsupported Go type")

+ var ErrUnwrappedTimeValue = errors.New("time values must be formatted using TimeValue")

+ func TimeValue(value time.Time, dataType DataType) any

type Actions

+ AlterTable func(table string, modifications ...AlterStatement) error

+ type AddCheck Check

+ type AddColumn Column

+ type AddForeignKey ForeignKey

+ type AddPrimaryKey PrimaryKey

+ type AddUnique Unique

+ type AlterColumn struct

+ Default any

+ Name string

+ NewName string

+ NotNull bool

+ Type DataType

+ type AlterStatement interface

type BigInt

+ func (t BigInt) ToMysqlType() string

+ func (t BigInt) ToPostgresType() string

+ func (t BigInt) ToSqliteType() string

type Blob

+ func (t Blob) ToMysqlType() string

+ func (t Blob) ToPostgresType() string

+ func (t Blob) ToSqliteType() string

type Boolean

+ func (t Boolean) ToMysqlType() string

+ func (t Boolean) ToPostgresType() string

+ func (t Boolean) ToSqliteType() string

type Check

+ Expr string

+ Name string

type Column

+ Default any

+ NotNull bool

+ type DataType interface

+ ToMysqlType func() string

+ ToPostgresType func() string

+ ToSqliteType func() string

type Date

+ func (t Date) ToMysqlType() string

+ func (t Date) ToPostgresType() string

+ func (t Date) ToSqliteType() string

type DateTime

+ func (t DateTime) ToMysqlType() string

+ func (t DateTime) ToPostgresType() string

+ func (t DateTime) ToSqliteType() string

+ type DateTimeOffset struct

+ func (t DateTimeOffset) ToMysqlType() string

+ func (t DateTimeOffset) ToPostgresType() string

+ func (t DateTimeOffset) ToSqliteType() string

type Double

+ func (t Double) ToMysqlType() string

+ func (t Double) ToPostgresType() string

+ func (t Double) ToSqliteType() string

+ type DropColumn struct

+ Name string

+ type DropConstraint struct

+ Name string

+ type DropPrimaryKey struct

+ Name string

type Float

+ func (t Float) ToMysqlType() string

+ func (t Float) ToPostgresType() string

+ func (t Float) ToSqliteType() string

type ForeignKey

+ Cols []string

+ Name string

+ OnDelete ReferentialAction

+ OnUpdate ReferentialAction

+ RefCols []string

+ RefTbl string

type Integer

+ func (t Integer) ToMysqlType() string

+ func (t Integer) ToPostgresType() string

+ func (t Integer) ToSqliteType() string

type PrimaryKey

+ Cols []string

+ Name string

+ type ReferentialAction uint8

+ func (i ReferentialAction) String() string

+ type RenameColumn struct

+ NewName string

+ OldName string

type SmallInt

+ func (t SmallInt) ToMysqlType() string

+ func (t SmallInt) ToPostgresType() string

+ func (t SmallInt) ToSqliteType() string

+ type Table struct

+ Checks []Check

+ Columns []Column

+ ForeignKeys []ForeignKey

+ PrimaryKey *PrimaryKey

+ Uniques []Unique

type Text

+ func (t Text) ToMysqlType() string

+ func (t Text) ToPostgresType() string

+ func (t Text) ToSqliteType() string

type TinyInt

+ func (t TinyInt) ToMysqlType() string

+ func (t TinyInt) ToPostgresType() string

+ func (t TinyInt) ToSqliteType() string

type Unique

+ Cols []string

+ Name string

type Varchar

+ func (t Varchar) ToMysqlType() string

+ func (t Varchar) ToPostgresType() string

+ func (t Varchar) ToSqliteType() string

v0.2.0

Nov 4, 2022

Changes in this version

+ const MySQL

+ var DateTime = sqlType

+ var MultiIndex = indexFn

type Actions

+ CreateIndex func(isUnique bool, table, indexName string, cols ...string) error

+ DropIndex func(isUnique bool, table, indexName string) error

+ Exec func(query string, args ...any) error

+ Query func(query string, args ...any) (*sql.Rows, error)

+ QueryRow func(query string, args ...any) *sql.Row

+ type DATETIME time.Time

type Logger

+ Alert func(msg string, args ...any)

v0.1.0

Jun 3, 2022

Changes in this version

+ const Cascade

+ const NoAction

+ const PostgreSQL

+ const Restrict

+ const SQLite

+ const SetDefault

+ const SetNull

+ var AutoIncr = &autoIncr

+ var BigInt = sqlType

+ var Binary = func(s uint64) sqlType

+ var Blob = sqlType

+ var Boolean = sqlType

+ var Check = checkFn

+ var CurrentTimestamp = &curTimestamp

+ var Date = sqlType

+ var Default = defaultFn

+ var Double = sqlType

+ var ErrUnknownDialect = errors.New("unknown SQL dialect")

+ var Float = sqlType

+ var ForeignKey = fkFn

+ var Integer = sqlType

+ var MultiPrimaryKey = pkFn

+ var MultiUnique = uniqueFn

+ var NotNull = &notNull

+ var PrimaryKey = &pk

+ var SmallInt = sqlType

+ var Text = sqlType

+ var Timestamp = sqlType

+ var Timestampz = sqlType

+ var TinyInt = sqlType

+ var Unique = &unique

+ var Varchar = func(s uint64) sqlType

+ type Actions interface

+ AddColumn func(table, column string, dataType sqlType, constraints ...Constraint) error

+ AddRow func(table string, values Values) error

+ ChangeColumnType func(table, col string, from, to sqlType) error

+ CreateTable func(name string, defs ...Definition) error

+ DropColumn func(table, name string) error

+ DropTable func(name string) error

+ FormatValue func(val any) (string, error)

+ GetDialect func() string

+ RenameColumn func(table, oldName, newName string) error

+ RenameTable func(oldName, newName string) error

+ SwapColumns func(table, col1, col2, cond string) error

+ type Column struct

+ Constraints []Constraint

+ Name string

+ Type sqlType

+ func Col(name string, typ sqlType, constraints ...Constraint) Column

+ type Constraint any

+ type DATE time.Time

+ type Definition any

+ type Engine struct

+ func NewEngine(db *sql.DB, dialect string, logger Logger, out io.Writer) (*Engine, error)

+ func (e *Engine) Downgrade(migration Migration) error

+ func (e *Engine) Upgrade(migration Migration) error

+ type Executor interface

+ Exec func(string, ...any) error

+ type Logger interface

+ Critical func(msg string, args ...any)

+ Debug func(msg string, args ...any)

+ Error func(msg string, args ...any)

+ Info func(msg string, args ...any)

+ Trace func(msg string, args ...any)

+ Warning func(msg string, args ...any)

+ type Migration []Script

+ type Querier interface

+ Query func(string, ...any) (*sql.Rows, error)

+ QueryRow func(string, ...any) *sql.Row

+ type Script struct

+ Description string

+ Down func(db Actions) error

+ Up func(db Actions) error

+ type TS time.Time

+ type TSZ time.Time

+ type TableConstraint any

+ type Values map[string]any

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL