database

Documentation

Index

• func CreateCsvFromXlsx(xlsxFileName string) (*os.File, error)
• func GetMssqlRowsFromCsv(databaseName, targetTable, targetConn string, file *os.File) error
• func GetRowsFromCsv(targetConn, targetTable, targetDriver string, file *os.File) error
• func InsertRowsIntoCsv(rows *sql.Rows, writer *csv.Writer) error
• func PingConnection(conn, driver string) error
• func PingConnections(sourceConn, sourceDriver, targetConn, targetDriver string) error
• func SelectMssqlRows(sourceDb, sourceConn, sourceDriver, sourceTable string) (rows *sql.Rows, err error)
• func SelectQueryRows(query, sourceConn, sourceDb string) (rows *sql.Rows, err error)
• func SelectRows(sourceConn, sourceDb, sourceTable string) (rows *sql.Rows, err error)
• func SwitchDbDriver(driver, conn string) (*sql.DB, error)

Functions

func CreateCsvFromXlsx

func CreateCsvFromXlsx(xlsxFileName string) (*os.File, error)

func GetMssqlRowsFromCsv

func GetMssqlRowsFromCsv(databaseName, targetTable, targetConn string, file *os.File) error

func GetRowsFromCsv

func GetRowsFromCsv(targetConn, targetTable, targetDriver string, file *os.File) error

func InsertRowsIntoCsv

func InsertRowsIntoCsv(rows *sql.Rows, writer *csv.Writer) error

func PingConnection

func PingConnection(conn, driver string) error

func PingConnections

func PingConnections(sourceConn, sourceDriver, targetConn, targetDriver string) error

func SelectMssqlRows

func SelectMssqlRows(sourceDb, sourceConn, sourceDriver, sourceTable string) (rows *sql.Rows, err error)

func SelectQueryRows

func SelectQueryRows(query, sourceConn, sourceDb string) (rows *sql.Rows, err error)

func SelectRows

func SelectRows(sourceConn, sourceDb, sourceTable string) (rows *sql.Rows, err error)

func SwitchDbDriver

func SwitchDbDriver(driver, conn string) (*sql.DB, error)