mysql

package
v0.6.1 Latest Latest
Warning

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

Go to latest
Published: Jul 13, 2024 License: MIT Imports: 13 Imported by: 0

README

db.go

数据库维护函数

函数说明
package mysql

type Column struct {
	Name      string `json:"name"`   // 字段名
	Rename    string `json:"rename"` // 修改前的字段名
	Type      string `json:"type"`
	Length    string `json:"length,omitempty"`
	Default   string `json:"default"`
	Null      bool   `json:"null"`
	Signed    bool   `json:"signed"`
	Increment bool   `json:"increment"`
	Position  string `json:"position"` // 指定新增到什么位置,如 AFTER `updated_at`;
}

type Index struct {
	Name   string   `json:"name"`
	Type   string   `json:"type"`
	Fields []string `json:"fields"`
}

type Schema struct {
	TableName string             `json:"tablename"`
	Charset   string             `json:"charset"`
	Engine    string             `json:"engine"`
	Increment string             `json:"increment"`
	Fields    map[string]*Column `json:"fields"`
	Indexes   map[string]*Index  `json:"indexes"`
}

type TableFixSqlOpt struct {
	Table1           *Schema // 需要修复的数据表结构
	Table2           *Schema // 基准数据表结构
	Strict           bool    // 使用严格模式, 严格模式将会把表2完全变成表1的结构, 否则将只处理表2种大于表1的内容(多出的字段和索引)
	CompareTableName bool    // 是否比较数据表名称,如果名称不一致,将会根据基准表创建一张新的表
	TablePre         string  // 生成sql语句中的表前缀
	TablePreOld      string  // 原结构的表前缀
}

type CDDiffs struct {
	Charset   bool `json:"charset"`
	TableName bool `json:"tablename"`
	Engine    bool `json:"engine"`
}

type CDFields struct {
	Less    []string `json:"less"`
	Diff    []string `json:"diff"`
	Greater []string `json:"greater"`
}

type CDIndexes struct {
	Less    []string `json:"less"`
	Diff    []string `json:"diff"`
	Greater []string `json:"greater"`
}

type CompareDiffs struct {
	Diffs   *CDDiffs   `json:"diffs"`
	Fields  *CDFields  `json:"fields"`
	Indexes *CDIndexes `json:"indexes"`
}

type TableCreateSqlOpt struct {
	Table       *Schema
	TablePre    string // 生成sql语句中的表前缀
	TablePreOld string // 原结构的表前缀
}

// TableSchema 获得指定表的结构
func TableSchema(tableName string) (*Schema, error)

// TableFixSql 根据基准表生成修复差异的sql
func TableFixSql(opt TableFixSqlOpt) (sqlItems []string)

// SchemaCompare 比较两张表的结构差异
// table1 表结构
// table2 表结构 基准表
func SchemaCompare(table1 *Schema, table2 *Schema) *CompareDiffs

// TableCreateSql 根据数据表结构生成建表语句
func TableCreateSql(opt TableCreateSqlOpt) (sql string)

// TableSchemas 生成清空表内数据的sql语句
func TableSchemas(tableName string) (dump string)

// MakeInsertSql 获取某个表的insert语句
func MakeInsertSql(tableName string, start int, size int) (data string, result []map[string]interface{})

// BuildIndexSql 为数据表创建索引
func BuildIndexSql(index *Index) string

// BuildFieldSql 创建一个完整字段
func BuildFieldSql(field *Column) string

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func BuildFieldSql

func BuildFieldSql(field *Column) string

BuildFieldSql 创建一个完整字段

func BuildIndexSql

func BuildIndexSql(index *Index) string

BuildIndexSql 为数据表创建索引

func MakeInsertSql

func MakeInsertSql(c Instance, tableName string, start int, size int) (data string, result []map[string]interface{})

MakeInsertSql 获取某个表的insert语句

func TableCreateSql

func TableCreateSql(opt TableCreateSqlOpt) (sql string)

TableCreateSql 根据数据表结构生成建表语句

func TableFixSql

func TableFixSql(opt TableFixSqlOpt) (sqlItems []string)

TableFixSql 根据基准表生成修复差异的sql

func TableSchemas

func TableSchemas(c Instance, tableName string) (dump string)

TableSchemas 生成清空表内数据的sql语句

Types

type AllTableName

type AllTableName struct {
	TableName string `gorm:"table_name"`
}

type CDDiffs

type CDDiffs struct {
	Charset   bool `json:"charset"`
	TableName bool `json:"tablename"`
	Engine    bool `json:"engine"`
}

type CDFields

type CDFields struct {
	Less    []string `json:"less"`
	Diff    []string `json:"diff"`
	Greater []string `json:"greater"`
}

type CDIndexes

type CDIndexes struct {
	Less    []string `json:"less"`
	Diff    []string `json:"diff"`
	Greater []string `json:"greater"`
}

type Column

type Column struct {
	Name      string `json:"name"`   // 字段名
	Rename    string `json:"rename"` // 修改前的字段名
	Type      string `json:"type"`
	Length    string `json:"length,omitempty"`
	Default   string `json:"default"`
	Null      bool   `json:"null"`
	Signed    bool   `json:"signed"`
	Increment bool   `json:"increment"`
	Position  string `json:"position"` // 指定新增到什么位置,如 AFTER `updated_at`;
}

type CompareDiffs

type CompareDiffs struct {
	Diffs   *CDDiffs   `json:"diffs"`
	Fields  *CDFields  `json:"fields"`
	Indexes *CDIndexes `json:"indexes"`
}

func SchemaCompare

func SchemaCompare(table1 *Schema, table2 *Schema) *CompareDiffs

SchemaCompare 比较两张表的结构差异

type Context added in v0.3.1

type Context = Instance

type Index

type Index struct {
	Name   string   `json:"name"`
	Type   string   `json:"type"`
	Fields []string `json:"fields"`
}

type Instance added in v0.6.1

type Instance struct {
	Dsn    string
	Conf   jcbaseGo.DbStruct
	Db     *gorm.DB
	Errors []error
}

func New added in v0.3.1

func New(dbConfig jcbaseGo.DbStruct) *Instance

New 获取新的数据库连接

func (*Instance) AddError added in v0.6.1

func (c *Instance) AddError(err error)

func (*Instance) Error added in v0.6.1

func (c *Instance) Error() []error

func (*Instance) GetAllTableName added in v0.6.1

func (c *Instance) GetAllTableName() (tableNames []AllTableName, err error)

GetAllTableName 获取所有表名

func (*Instance) GetDb added in v0.6.1

func (c *Instance) GetDb() *gorm.DB

GetDb 获取db

func (*Instance) TableName added in v0.6.1

func (c *Instance) TableName(tableName *string, quotes ...bool) *Instance

TableName 获取表名, param tableName string 表名 param quotes bool 是否加上反单引号

type Schema

type Schema struct {
	TableName string             `json:"tablename"`
	Charset   string             `json:"charset"`
	Engine    string             `json:"engine"`
	Increment string             `json:"increment"`
	Fields    map[string]*Column `json:"fields"`
	Indexes   map[string]*Index  `json:"indexes"`
}

func TableSchema

func TableSchema(c Instance, tableName string) (*Schema, error)

TableSchema 获得指定数据表的结构

type TableCreateSqlOpt

type TableCreateSqlOpt struct {
	Table       *Schema
	TablePre    string // 生成sql语句中的表前缀
	TablePreOld string // 原结构的表前缀
}

type TableFixSqlOpt

type TableFixSqlOpt struct {
	Table1           *Schema // 需要修复的数据表结构
	Table2           *Schema // 基准数据表结构
	Strict           bool    // 使用严格模式, 严格模式将会把表2完全变成表1的结构, 否则将只处理表2种大于表1的内容(多出的字段和索引)
	CompareTableName bool    // 是否比较数据表名称,如果名称不一致,将会根据基准表创建一张新的表
	TablePre         string  // 生成sql语句中的表前缀
	TablePreOld      string  // 原结构的表前缀
}

Jump to

Keyboard shortcuts

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