models

package

v0.0.0-...-dc3aed1 Latest Latest Go to latest Published: May 19, 2020 License: GPL-3.0 Imports: 8 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

github.com/antoniny/go_csv_nw

Links

Open Source Insights

Documentation ¶

Index ¶

Variables
func BuscaStatusTable(db *sql.DB) (int64, int64, int64)
func Init() (db *sql.DB)
func InsertLineFileCSV(db *sql.DB, data FileLayout) int
func LerArquivos(patchFile string) int32
func UpdateFiledsNullable(db *sql.DB) int64
type FileLayout

Constants ¶

This section is empty.

Variables ¶

View Source

var AllRecords []FileLayout

Functions ¶

func BuscaStatusTable ¶

func BuscaStatusTable(db *sql.DB) (int64, int64, int64)

Busca status resumo da tabela

func Init ¶

func Init() (db *sql.DB)

Inicializa conexão com a base de dados

func InsertLineFileCSV ¶

func InsertLineFileCSV(db *sql.DB, data FileLayout) int

Insere as linhas do arquivo na base. Ref.:FileLayout

func LerArquivos ¶

func LerArquivos(patchFile string) int32

func UpdateFiledsNullable ¶

func UpdateFiledsNullable(db *sql.DB) int64

Corrige as colunas base sem valor para null

Types ¶

type FileLayout ¶

type FileLayout struct {
	Cpf              string
	Private          string
	Incomplete       string
	LastPurchase     string
	TicketAvgAmount  string
	TicketLastAmount string
	CnpjMaxFrequency string
	CnpjLastPurchase string
	CpfOK            string
	CnpjOK           string
}

"Layout do arquivo text/csv"

var OneRecord FileLayout

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL