Documentation ¶
Overview ¶
Package xlsx4db provides dump and restore features by using Excel (XLSX) format.
Index ¶
- func BuildInsertQuery(db *sql.DB, table string, columns []string) (string, error)
- func BuildUpsertQuery(db *sql.DB, table string, columns []string) (string, error)
- func Dump(xf *xlsx.File, db *sql.DB, tables ...string) error
- func FetchTables(db *sql.DB) ([]string, error)
- func Restore(db *sql.DB, xf *xlsx.File, refresh bool, tables ...string) error
- func Update(db *sql.DB, xf *xlsx.File, tables ...string) error
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func BuildInsertQuery ¶
BuildInsertQuery builds na insert statement with given columns.
func BuildUpsertQuery ¶
BuildUpsertQuery builds "insert or update" statement with given params.
func FetchTables ¶
FetchTables fetches all accessible tables from database.
Types ¶
This section is empty.
Click to show internal directories.
Click to hide internal directories.