sqlmigrate

Jul 22, 2025

Changes in this version

+ func DirName(dirno int, suffix string) string

+ func FileNameClear(fileno int, prefix string) string

+ func FileNameDown(fileno int, prefix string) string

+ func FileNameImport(fileno int, prefix string) string

+ func FileNameTest(fileno int, prefix string) string

+ func FileNameUp(fileno int, prefix string) string

Nov 22, 2024

Changes in this version

+ const MULTI_SQL_SPLITPOINT

Sep 27, 2024

Changes in this version

+ var CHECK_FOR_UPDATES = true

Sep 26, 2024

Changes in this version

type Config

+ GetVersion func(db *sql.DB) (number int, err error)

+ UpdateVersion func(db *sql.DB, number int) error

Sep 26, 2024

Changes in this version

+ const PlaceholderSchema

+ const PlaceholderSrcSchema

+ const PlaceholderTargetSchema

+ var ImportDir = path.Relative("imports/")

+ var StructureDir = path.Relative("structure/")

+ var TestsDir = path.Relative("tests/")

+ type Config struct

+ Dir path.Local

+ From string

+ Host string

+ Password string

+ Port string

+ To string

+ User string

+ type FS interface

+ type Import struct

+ ClearSQL string

+ ImportSQL string

+ TestSQL string

+ func (m *Import) Scan(fsys FS, mt path.Relative) (err error)

+ func (m Import) Exec(db *sql.DB, sql string) error

+ func (m Import) Path(rootDir path.Relative, suffix string) path.Relative

+ func (m Import) PathClear() path.Relative

+ func (m Import) PathImport() path.Relative

+ func (m Import) PathTest() path.Relative

+ func (m Import) QueryRow(db *sql.DB, sql string) *sql.Row

+ func (m Import) ReadSQL(fsys FS, rootDir path.Relative, target *string, suffix string) error

+ func (m Import) RunClear(db *sql.DB, srcdbname, targetdbname string) error

+ func (m Import) RunImport(db *sql.DB, srcdbname, targetdbname string) error

+ func (m Import) RunTest(db *sql.DB, srcdbname, targetdbname string) error

+ type Imports []Import

+ func (m Imports) CheckForDuplicates() error

+ func (m Imports) Len() int

+ func (m Imports) Less(a, b int) bool

+ func (m Imports) Swap(a, b int)

+ type Migration struct

+ DownSQL string

+ TestSQL string

+ UpSQL string

+ func (m *Migration) Scan(fsys FS, mt path.Relative) (err error)

+ func (m Migration) Exec(db *sql.DB, sql string) error

+ func (m Migration) Path(rootDir path.Relative, suffix string) path.Relative

+ func (m Migration) PathDown() path.Relative

+ func (m Migration) PathTest() path.Relative

+ func (m Migration) PathUp() path.Relative

+ func (m Migration) QueryRow(db *sql.DB, sql string) *sql.Row

+ func (m Migration) ReadSQL(fsys FS, rootDir path.Relative, target *string, suffix string) error

+ func (m Migration) RunDown(db *sql.DB, dbname string) error

+ func (m Migration) RunTest(db *sql.DB, dbname string) error

+ func (m Migration) RunUp(db *sql.DB, dbname string) error

+ type MigrationManager struct

+ func New(db *sql.DB, conf Config) *MigrationManager

+ func NewFS(db *sql.DB, fsys FS, conf Config) *MigrationManager

+ func (mm *MigrationManager) AddImport() error

+ func (mm *MigrationManager) AddStructure() error

+ func (mm *MigrationManager) AddTest() error

+ func (mm *MigrationManager) Down(verbose bool) error

+ func (mm *MigrationManager) Import(verbose bool) error

+ func (mm *MigrationManager) InitDir(logger io.Writer) error

+ func (mm *MigrationManager) PrepareImport(verbose bool) error

+ func (mm *MigrationManager) Rebuild(verbose bool) error

+ func (mm *MigrationManager) Run(verbose bool) error

+ func (mm *MigrationManager) Test(verbose bool) error

+ func (mm *MigrationManager) Up(verbose bool) error

+ type Migrations []Migration

+ func (m Migrations) CheckForDuplicates() error

+ func (m Migrations) Len() int

+ func (m Migrations) Less(a, b int) bool

+ func (m Migrations) Swap(a, b int)

+ type Tester struct

+ SrcSQL string

+ TargetSQL string

+ func (m *Tester) Scan(fsys FS, mt path.Relative) (err error)

+ func (m Tester) Exec(db *sql.DB, sql string) error

+ func (m Tester) Path(rootDir path.Relative, suffix string) path.Relative

+ func (m Tester) PathSrc() path.Relative

+ func (m Tester) PathTarget() path.Relative

+ func (m Tester) QueryRow(db *sql.DB, sql string) *sql.Row

+ func (m Tester) ReadSQL(fsys FS, rootDir path.Relative, target *string, suffix string) error

+ func (m Tester) Run(db *sql.DB, srcDB, targetDB string) error

+ func (m Tester) RunSrc(db *sql.DB, dbname string) (string, error)

+ func (m Tester) RunTarget(db *sql.DB, dbname string) (string, error)

+ type Testers []Tester

+ func (m Testers) CheckForDuplicates() error

+ func (m Testers) Len() int

+ func (m Testers) Less(a, b int) bool

+ func (m Testers) Swap(a, b int)