Versions in this module Expand all Collapse all v0 v0.2.8 Sep 6, 2021 Changes in this version + const AppURL + const Version + func CheckSchemaDiff(cfg *Config) + func Float2Str(f float32) string + func Float322Str(f float32) string + func Float642Str(f float64) string + func Int2Str(number int) string + func Int642Str(number int64) string + func Str2Float(s string) (f float32, err error) + func Str2Float64(s string) (f float64, err error) + func Str2Int(str string) (int, error) + func Str2Int64(str string) (int64, error) + func SyncTableData(cfg *Config) + type AlterIgnoreTable struct + Column []string + ForeignKey []string + Index []string + type Config struct + AlterIgnore map[string]*AlterIgnoreTable + ConfigPath string + DestDSN string + Drop bool + Email *EmailStruct + SourceDSN string + Sync bool + SyncData bool + SyncDataTables []string + SyncDataTruncate bool + Tables []string + TablesIGNORE []string + func LoadConfig(confPath string) *Config + func (cfg *Config) Check() + func (cfg *Config) CheckMatchIgnoreTables(name string) bool + func (cfg *Config) CheckMatchSyncTables(name string) bool + func (cfg *Config) CheckMatchTables(name string) bool + func (cfg *Config) IsIgnoreField(table string, name string) bool + func (cfg *Config) IsIgnoreForeignKey(table string, name string) bool + func (cfg *Config) IsIgnoreIndex(table string, name string) bool + func (cfg *Config) SendMailFail(errStr string) + func (cfg *Config) String() string + type DbIndex struct + IndexType indexType + Name string + RelationTables []string + SQL string + func (idx *DbIndex) String() string + type EmailStruct struct + From string + Password string + SMTPHost string + SendMailAble bool + To string + func (m *EmailStruct) SendMail(title string, body string) + type MyDb struct + Db *sql.DB + func NewMyDb(dsn string, dbType string) *MyDb + func (mydb *MyDb) GetTableNames() []string + func (mydb *MyDb) GetTableSchema(name string) (schema string) + func (mydb *MyDb) Query(query string, args ...interface{}) (*sql.Rows, error) + func (mydb *MyDb) QueryAll(sql string) []map[string]interface{} + type MySchema struct + Fields map[string]string + ForeignAll map[string]*DbIndex + IndexAll map[string]*DbIndex + SchemaRaw string + func ParseSchema(schema string) *MySchema + func (mys *MySchema) GetFieldNames() []string + func (mys *MySchema) RelationTables() []string + func (mys *MySchema) String() string + type SchemaDiff struct + Dest *MySchema + Source *MySchema + Table string + func (sdiff *SchemaDiff) RelationTables() []string + type SchemaSync struct + Config *Config + DestDb *MyDb + SourceDb *MyDb + func NewSchemaSync(config *Config) *SchemaSync + func (sc *SchemaSync) GetNewTableNames() []string + func (sc *SchemaSync) SyncSQL4Dest(sqlStr string, sqls []string) error + type TableAlterData struct + SQL string + SchemaDiff *SchemaDiff + Table string + Type alterType + func (ta *TableAlterData) String() string