schema

package
v1.0.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: May 12, 2021 License: Apache-2.0 Imports: 4 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

This section is empty.

Types

type Builder

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

func NewBuilder

func NewBuilder(name string, conns ...string) *Builder

func (*Builder) BigIncrements

func (t *Builder) BigIncrements(name string) *ColumnDefinition

func (*Builder) BigInteger

func (t *Builder) BigInteger(name string, autoIncrement bool, unsigned bool) *ColumnDefinition

func (*Builder) Binary

func (t *Builder) Binary(name string) *ColumnDefinition

func (*Builder) Boolean

func (t *Builder) Boolean(name string) *ColumnDefinition

func (*Builder) Build

func (t *Builder) Build() []string

func (*Builder) Char

func (t *Builder) Char(name string, length int) *ColumnDefinition

func (*Builder) Charset

func (t *Builder) Charset(charset string)

func (*Builder) Collation

func (t *Builder) Collation(collation string)

func (*Builder) Create

func (t *Builder) Create() *Command

func (*Builder) CreateIfNotExists

func (t *Builder) CreateIfNotExists() *Command

func (*Builder) Date

func (t *Builder) Date(name string) *ColumnDefinition

func (*Builder) DateTime

func (t *Builder) DateTime(name string, precision int) *ColumnDefinition

func (*Builder) DateTimeTz

func (t *Builder) DateTimeTz(name string, precision int) *ColumnDefinition

func (*Builder) Decimal

func (t *Builder) Decimal(name string, total int, scale int) *ColumnDefinition

func (*Builder) Double

func (t *Builder) Double(name string, total int, scale int) *ColumnDefinition

func (*Builder) DropColumn

func (t *Builder) DropColumn(columns ...string)

func (*Builder) DropForeign

func (t *Builder) DropForeign(name string) *Command

func (*Builder) DropIndex

func (t *Builder) DropIndex(name string) *Command

func (*Builder) DropMorphs

func (t *Builder) DropMorphs(name string, indexName string)

func (*Builder) DropPrimary

func (t *Builder) DropPrimary(name string) *Command

func (*Builder) DropRememberToken

func (t *Builder) DropRememberToken()

func (*Builder) DropSpatialIndex

func (t *Builder) DropSpatialIndex(name string) *Command

func (*Builder) DropTable

func (t *Builder) DropTable() *Command

func (*Builder) DropTableIfExists

func (t *Builder) DropTableIfExists() *Command

func (*Builder) DropUnique

func (t *Builder) DropUnique(name string) *Command

func (*Builder) Enum

func (t *Builder) Enum(name string, items ...string) *ColumnDefinition

func (*Builder) Float

func (t *Builder) Float(name string, total int, scale int) *ColumnDefinition

func (*Builder) Foreign

func (t *Builder) Foreign(name string, columns ...string) *Command

func (*Builder) Geometry

func (t *Builder) Geometry(name string) *ColumnDefinition

func (*Builder) GeometryCollection

func (t *Builder) GeometryCollection(name string) *ColumnDefinition

func (*Builder) GetTableName

func (t *Builder) GetTableName() string

func (*Builder) Increments

func (t *Builder) Increments(name string) *ColumnDefinition

func (*Builder) Index

func (t *Builder) Index(name string, columns ...string) *Command

func (*Builder) Integer

func (t *Builder) Integer(name string, autoIncrement bool, unsigned bool) *ColumnDefinition

func (*Builder) IpAddress

func (t *Builder) IpAddress(name string) *ColumnDefinition

func (*Builder) Json

func (t *Builder) Json(name string) *ColumnDefinition

func (*Builder) Jsonb

func (t *Builder) Jsonb(name string) *ColumnDefinition

func (*Builder) LineString

func (t *Builder) LineString(name string) *ColumnDefinition

func (*Builder) LongText

func (t *Builder) LongText(name string) *ColumnDefinition

func (*Builder) MacAddress

func (t *Builder) MacAddress(name string) *ColumnDefinition

func (*Builder) MediumIncrements

func (t *Builder) MediumIncrements(name string) *ColumnDefinition

func (*Builder) MediumInteger

func (t *Builder) MediumInteger(name string, autoIncrement bool, unsigned bool) *ColumnDefinition

func (*Builder) MediumText

func (t *Builder) MediumText(name string) *ColumnDefinition

func (*Builder) Morphs

func (t *Builder) Morphs(name string, indexName string)

func (*Builder) MultiLineString

func (t *Builder) MultiLineString(name string) *ColumnDefinition

func (*Builder) MultiPoint

func (t *Builder) MultiPoint(name string) *ColumnDefinition

func (*Builder) MultiPolygon

func (t *Builder) MultiPolygon(name string) *ColumnDefinition

func (*Builder) NullableMorphs

func (t *Builder) NullableMorphs(name string, indexName string)

func (*Builder) NullableTimestamps

func (t *Builder) NullableTimestamps()

func (*Builder) Point

func (t *Builder) Point(name string, srid int) *ColumnDefinition

func (*Builder) Polygon

func (t *Builder) Polygon(name string) *ColumnDefinition

func (*Builder) Primary

func (t *Builder) Primary(name string, columns ...string) *Command

func (*Builder) RememberToken

func (t *Builder) RememberToken() *ColumnDefinition

func (*Builder) Rename

func (t *Builder) Rename(to string) *Command

func (*Builder) RenameColumn

func (t *Builder) RenameColumn(from string, to string) *Command

RenameColumn rename a column name (only support for MySQL 8.0)

func (*Builder) Run

func (t *Builder) Run()

func (*Builder) Set

func (t *Builder) Set(name string, items ...string) *ColumnDefinition

func (*Builder) SmallIncrements

func (t *Builder) SmallIncrements(name string) *ColumnDefinition

func (*Builder) SmallInteger

func (t *Builder) SmallInteger(name string, autoIncrement bool, unsigned bool) *ColumnDefinition

func (*Builder) SoftDeletes

func (t *Builder) SoftDeletes(column string, precision int) *ColumnDefinition

func (*Builder) SoftDeletesTz

func (t *Builder) SoftDeletesTz(column string, precision int) *ColumnDefinition

func (*Builder) SpatialIndex

func (t *Builder) SpatialIndex(name string, columns ...string) *Command

func (*Builder) String

func (t *Builder) String(name string, length ...int) *ColumnDefinition

func (*Builder) Text

func (t *Builder) Text(name string) *ColumnDefinition

func (*Builder) Time

func (t *Builder) Time(name string, precision int) *ColumnDefinition

func (*Builder) TimeTz

func (t *Builder) TimeTz(name string, precision int) *ColumnDefinition

func (*Builder) Timestamp

func (t *Builder) Timestamp(name string) *ColumnDefinition

func (*Builder) TimestampTz

func (t *Builder) TimestampTz(name string, precision int) *ColumnDefinition

func (*Builder) Timestamps

func (t *Builder) Timestamps()

func (*Builder) TimestampsTz

func (t *Builder) TimestampsTz(precision int)

func (*Builder) TinyIncrements

func (t *Builder) TinyIncrements(name string) *ColumnDefinition

func (*Builder) TinyInteger

func (t *Builder) TinyInteger(name string, autoIncrement bool, unsigned bool) *ColumnDefinition

func (*Builder) Unique

func (t *Builder) Unique(name string, columns ...string) *Command

func (*Builder) UnsignedBigInteger

func (t *Builder) UnsignedBigInteger(name string, autoIncrement ...bool) *ColumnDefinition

func (*Builder) UnsignedDecimal

func (t *Builder) UnsignedDecimal(name string, total int, scale int) *ColumnDefinition

func (*Builder) UnsignedInteger

func (t *Builder) UnsignedInteger(name string, autoIncrement ...bool) *ColumnDefinition

func (*Builder) UnsignedMediumInteger

func (t *Builder) UnsignedMediumInteger(name string, autoIncrement ...bool) *ColumnDefinition

func (*Builder) UnsignedSmallInteger

func (t *Builder) UnsignedSmallInteger(name string, autoIncrement ...bool) *ColumnDefinition

func (*Builder) UnsignedTinyInteger

func (t *Builder) UnsignedTinyInteger(name string, autoIncrement ...bool) *ColumnDefinition

func (*Builder) Uuid

func (t *Builder) Uuid(name string) *ColumnDefinition

func (*Builder) Year

func (t *Builder) Year(name string) *ColumnDefinition

type ColumnDefinition

type ColumnDefinition struct {
	ColumnName          string
	ColumnType          string
	ColumnComment       string
	ColumnAutoIncrement bool
	ColumnUnsigned      bool
	ColumnNullable      bool
	ColumnDefault       interface{}
	ColumnCharset       string
	ColumnCollation     string
	ColumnUseCurrent    bool
	ColumnVirtualAs     string
	ColumnStoredAs      string
	ColumnAfter         string
	ColumnFirst         bool
	ColumnSrid          int64

	ColumnIndex        string
	ColumnPrimary      bool
	ColumnUnique       bool
	ColumnSpatialIndex bool

	ColumnChange bool
}

func (*ColumnDefinition) After

func (c *ColumnDefinition) After(name string) *ColumnDefinition

func (*ColumnDefinition) Always

func (c *ColumnDefinition) Always() *ColumnDefinition

func (*ColumnDefinition) AutoIncrement

func (c *ColumnDefinition) AutoIncrement() *ColumnDefinition

func (*ColumnDefinition) Build

func (c *ColumnDefinition) Build() string

func (*ColumnDefinition) Change

func (c *ColumnDefinition) Change() *ColumnDefinition

func (*ColumnDefinition) Charset

func (c *ColumnDefinition) Charset(charset string) *ColumnDefinition

func (*ColumnDefinition) Collation

func (c *ColumnDefinition) Collation(collation string) *ColumnDefinition

func (*ColumnDefinition) Comment

func (c *ColumnDefinition) Comment(comment string) *ColumnDefinition

func (*ColumnDefinition) Default

func (c *ColumnDefinition) Default(defaultVal interface{}) *ColumnDefinition

func (*ColumnDefinition) First

func (c *ColumnDefinition) First() *ColumnDefinition

func (*ColumnDefinition) GeneratedAs

func (c *ColumnDefinition) GeneratedAs(expression string) *ColumnDefinition

func (*ColumnDefinition) Index

func (c *ColumnDefinition) Index(name string) *ColumnDefinition

func (*ColumnDefinition) IsChange

func (c *ColumnDefinition) IsChange() bool

func (*ColumnDefinition) Nullable

func (c *ColumnDefinition) Nullable(value bool) *ColumnDefinition

func (*ColumnDefinition) Primary

func (c *ColumnDefinition) Primary() *ColumnDefinition

func (*ColumnDefinition) SpatialIndex

func (c *ColumnDefinition) SpatialIndex() *ColumnDefinition

func (*ColumnDefinition) StoredAs

func (c *ColumnDefinition) StoredAs(expression string) *ColumnDefinition

func (*ColumnDefinition) Type

func (c *ColumnDefinition) Type() string

func (*ColumnDefinition) Unique

func (c *ColumnDefinition) Unique() *ColumnDefinition

func (*ColumnDefinition) Unsigned

func (c *ColumnDefinition) Unsigned() *ColumnDefinition

func (*ColumnDefinition) UseCurrent

func (c *ColumnDefinition) UseCurrent() *ColumnDefinition

func (*ColumnDefinition) VirtualAs

func (c *ColumnDefinition) VirtualAs(expression string) *ColumnDefinition

type Command

type Command struct {
	CommandName       string
	CommandIndex      string
	CommandParameters []string
	CommandAlgorithm  string

	CommandReferences            []string
	CommandOnTable               string
	CommandOnDelete              string
	CommandOnUpdate              string
	CommandNotInitiallyImmediate bool
	// contains filtered or unexported fields
}

func NewCommand

func NewCommand(builder *Builder) *Command

func (*Command) Algorithm

func (c *Command) Algorithm(algorithm string) *Command

func (*Command) Build

func (c *Command) Build() string

func (*Command) Columns

func (c *Command) Columns(columns ...string) *Command

func (*Command) Equal

func (c *Command) Equal(name string) bool

func (*Command) Index

func (c *Command) Index(name string) *Command

func (*Command) Name

func (c *Command) Name(name string) *Command

func (*Command) NotInitiallyImmediate

func (c *Command) NotInitiallyImmediate(value bool) *Command

func (*Command) On

func (c *Command) On(table string) *Command

func (*Command) OnDelete

func (c *Command) OnDelete(action string) *Command

func (*Command) OnUpdate

func (c *Command) OnUpdate(action string) *Command

func (*Command) References

func (c *Command) References(columns ...string) *Command

type Schema

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

func NewSchema

func NewSchema(conns ...string) *Schema

NewSchema create a new Schema

func (*Schema) AlterTable

func (s *Schema) AlterTable(table string, apply func(builder *Builder))

AlterTable update a existing table

func (*Schema) CreateTable

func (s *Schema) CreateTable(table string, apply func(builder *Builder))

CreateTable creat a new table

func (*Schema) DropTable

func (s *Schema) DropTable(table string)

DropTable drop a table

func (*Schema) DropTableIfExists

func (s *Schema) DropTableIfExists(table string)

DropTable drop a table if exists

Jump to

Keyboard shortcuts

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