sqlmodel

Documentation

Index

• Constants
• func MigrationGet(db *sql.Connection, p *MigrationGetParam) (mList []*model.Migration, count int, err error)
• func MigrationGetByCodeAndVersion(db *sql.Connection, code string, version int) (m *model.Migration, err error)
• func MigrationGetLatest(db *sql.Connection, code string) (m *model.Migration, err error)
• func MigrationInsert(db *sql.Connection, ip *MigrationInsertParam) (id int, err error)
• func MigrationUpdate(db *sql.Connection, id int, up *MigrationUpdateParam) (err error)
• type MigrationGetParam
• type MigrationInsertParam
• type MigrationUpdateParam

Constants

const (
	MigrationTableName     = "skyrin_migration"
	MigrationDefaultSortBy = "skyrin_migration_id"

	ECode000301 = e.Code0003 + "01"
	ECode000302 = e.Code0003 + "02"
	ECode000303 = e.Code0003 + "03"
	ECode000304 = e.Code0003 + "04"
	ECode000305 = e.Code0003 + "05"
	ECode000306 = e.Code0003 + "06"
	ECode000307 = e.Code0003 + "07"
	ECode000308 = e.Code0003 + "08"
	ECode000309 = e.Code0003 + "09"
	ECode00030A = e.Code0003 + "0A"
	ECode00030B = e.Code0003 + "0B"
)

Functions

func MigrationGet

func MigrationGet(db *sql.Connection,
	p *MigrationGetParam) (mList []*model.Migration, count int, err error)

MigrationGet performs select

func MigrationGetByCodeAndVersion

func MigrationGetByCodeAndVersion(db *sql.Connection, code string,
	version int) (m *model.Migration, err error)

MigrationGetByCodeAndVersion returns the migration by code and version

func MigrationGetLatest

func MigrationGetLatest(db *sql.Connection, code string) (m *model.Migration, err error)

MigrationGetLatest retrieves the latest migration

func MigrationInsert

func MigrationInsert(db *sql.Connection, ip *MigrationInsertParam) (id int, err error)

MigrationInsert performs insert

func MigrationUpdate

func MigrationUpdate(db *sql.Connection, id int, up *MigrationUpdateParam) (err error)

MigrationUpdate performs update

Types

type MigrationGetParam

type MigrationGetParam struct {
	Limit          uint64
	Offset         uint64
	ID             *int
	Version        *int
	Code           *string
	Status         *string
	FlagCount      bool
	OrderByID      string
	OrderByVersion string
}

MigrationGetParam get params

type MigrationInsertParam

type MigrationInsertParam struct {
	Code    string
	Version int
	Status  string
	SQL     string
	Err     string
}

MigrationInsertParam insert params

type MigrationUpdateParam

type MigrationUpdateParam struct {
	Version *string
	Status  *string
	SQL     *string
	Err     *string
}

MigrationUpdateParam update params