convert

Documentation

Index

• Variables
• func ExcelToDB(db *sql.DB, driverName, tableName, excelFileName, sheets string, ...)
• func FromExcel(c *Columns, sheet *xlsx.Sheet, db *sql.DB, dataStartRow int, ...) (err error)
• func FromJson(c *Columns, dataMap []map[string]interface{}, db *sql.DB, ...) (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 JsonToDB(db *sql.DB, driverName, tableName, jsonFileName string, titles []StringValue) (err error)
• func ParseValue(val string) (result string, processed bool)
• func Substr(str string, start int, length int) string
• type Columns
  • func (c *Columns) ParseColumns()
• type DBRow
• type OtherTable
• type StringValue
  • func (sv StringValue) String() string
• type StringValueInterface

Variables

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

Functions

func ExcelToDB

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

func FromExcel

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

func FromJson

func FromJson(c *Columns, dataMap []map[string]interface{},
	db *sql.DB, driverName, tableName string, titles []StringValue) (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 JsonToDB

func JsonToDB(db *sql.DB, driverName, tableName, jsonFileName string, titles []StringValue) (err error)

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) ParseColumns

func (c *Columns) ParseColumns()

解析Excel及数据库字段

type DBRow

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

数据库行

type OtherTable

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

附表

type StringValue

type StringValue struct {
	Value string
}

func (StringValue) String

func (sv StringValue) String() string

type StringValueInterface

type StringValueInterface interface {
	String() string
}