csv_to_gorm

README

csv_to_gorm

A utility to read a csv file into a gorm managed database or, more generally, into a slice of structs.

usage

Acknowledgements

This module was developed as part of a section of work undertaken for Emerald Operating Partners LLC, who have kindly agreed to its release as open source under the MIT licence.

Documentation

Index

• func CsvToSlice(file *os.File, colSep rune, model interface{}, colMap map[string]int) interface{}
• func ExcelColIdToColNo(colID string) (int, error)
• func ExcelColNoToColId(colNo int) (string, error)
• func GetDbFields(model interface{}) ([]string, error)
• func GetHeadings(file *os.File, colSep rune) ([]string, error)
• func GuessSeparator(file *os.File) (rune, error)
• func StringToType(input string, outType reflect.Type) reflect.Value

Functions

func CsvToSlice

func CsvToSlice(file *os.File, colSep rune, model interface{}, colMap map[string]int) interface{}

converts the content of a CSV file to a slice of 'models' colMap maps the feldnames of the model to the column numbers (beginning at 1) of the CSV file the result is an interface, which will need to be typecast by the caller

func ExcelColIdToColNo

func ExcelColIdToColNo(colID string) (int, error)

func ExcelColNoToColId

func ExcelColNoToColId(colNo int) (string, error)

func GetDbFields

func GetDbFields(model interface{}) ([]string, error)

func GetHeadings

func GetHeadings(file *os.File, colSep rune) ([]string, error)

func GuessSeparator

func GuessSeparator(file *os.File) (rune, error)

inputReader would normally be the file or stream to read

func StringToType

func StringToType(input string, outType reflect.Type) reflect.Value

takes the text string of a CSV field and converts it to a reflect.Value of a given type (supplied as a reflect.Type) used internally, but exposed as it may have uses elsewhere