convert

Documentation

Index

• Variables
• func ConverExcelToDB(db *sql.DB, driverName, tableName, excelFileName, sheets string, ...)
• func Convert(c *Columns, sheet *xlsx.Sheet, db *sql.DB, dataStartRow int, ...) (err error)
• func GetTableColumns(db *sql.DB, driverName, tableName string) (tableColumnMap map[int]string, err error)
• func GetUpdateSql(driverName, tableName string, fieldNames []string, values []string, ...) (sql string, updateSetSql string, whereSql string)
• func ParseValue(val string) (result string, processed bool)
• func Substr(str string, start int, length int) string
• type Columns
  • func (c *Columns) ParaseColumns()
• type OtherTable
• type Row

Variables

var (
	NeedNotUpdateFieldSet *set.StringSet
	NeedGenerateFieldSet  *set.StringSet
)

Functions

func ConverExcelToDB

func ConverExcelToDB(db *sql.DB, driverName, tableName, excelFileName, sheets string, dataStartRow int)

func Convert

func Convert(c *Columns, sheet *xlsx.Sheet, db *sql.DB, dataStartRow int, driverName, tableName string) (err error)

func GetTableColumns

func GetTableColumns(db *sql.DB, driverName, tableName string) (tableColumnMap map[int]string, err error)

func GetUpdateSql

func GetUpdateSql(driverName, tableName string, fieldNames []string, values []string, needConflictOnFields string,
	updatedFieldSet *set.StringSet, distinctExcludedFieldSet *set.StringSet) (sql string, updateSetSql string, whereSql string)

func ParseValue

func ParseValue(val string) (result string, processed bool)

解析内容

func Substr

func Substr(str string, start int, length int) string

按长度截取字符串

Types

type Columns

type Columns struct {
	// contains filtered or unexported fields
}

列

func (*Columns) ParaseColumns

func (c *Columns) ParaseColumns()

解析Excel及数据库字段

type OtherTable

type OtherTable struct {
	// contains filtered or unexported fields
}

附表

type Row

type Row struct {
	// contains filtered or unexported fields
}

行