version_control

README

go-mysql-version-control

This a project to manage sql files.

Documentation

Index

• Variables
• func Hash(val string) string
• func VersionLastThan(a, b string) bool
• type MySQLVersionController
  • func NewController(db *gorm.DB) *MySQLVersionController
  • func (c *MySQLVersionController) CheckSqlFiles()
  • func (c *MySQLVersionController) ExecuteSqlFiles()
  • func (c *MySQLVersionController) QueryAllVersion()
  • func (c *MySQLVersionController) QuerySqlFiles(path string) []fs.DirEntry
  • func (c *MySQLVersionController) ReadFilesInDisk(path string)
  • func (c *MySQLVersionController) Start(path string)
• type SQLVersion

Variables

var DB *gorm.DB

var FILES_EXECUTED = []SQLVersion{}

var FILES_IN_PATH = []SQLVersion{}

var FILES_NOT_EXECUTED = []SQLVersion{}

var INIT_SQL = "CREATE TABLE `sql_version`  (" +
	"`version` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL," +
	"`name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL," +
	"`hash` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL," +
	"`create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP," +
	"PRIMARY KEY (`version`) USING BTREE" +
	") ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;"

var MAX_VERSION = "0.0.0"

var TABLE_NAME = "sql_version"

Functions

func Hash

func Hash(val string) string

func VersionLastThan

func VersionLastThan(a, b string) bool

Types

type MySQLVersionController

type MySQLVersionController struct {
}

func NewController

func NewController(db *gorm.DB) *MySQLVersionController

func (*MySQLVersionController) CheckSqlFiles

func (c *MySQLVersionController) CheckSqlFiles()

func (*MySQLVersionController) ExecuteSqlFiles

func (c *MySQLVersionController) ExecuteSqlFiles()

func (*MySQLVersionController) QueryAllVersion

func (c *MySQLVersionController) QueryAllVersion()

Query all executed versions

func (*MySQLVersionController) QuerySqlFiles

func (c *MySQLVersionController) QuerySqlFiles(path string) []fs.DirEntry

Check sql files' names are legal file name must has the format x.x.x_name.sql x is number

func (*MySQLVersionController) ReadFilesInDisk

func (c *MySQLVersionController) ReadFilesInDisk(path string)

func (*MySQLVersionController) Start

func (c *MySQLVersionController) Start(path string)

Init table

type SQLVersion

type SQLVersion struct {
	Version    string `gorm:"primaryKey"`
	Name       string
	Hash       string
	CreateTime time.Time
}