csvload

Documentation

Index

• Constants
• Variables
• type Column
  • func CreateTable(ctx context.Context, db *sql.DB, tbl string, rows <-chan dbcsv.Row, ...) ([]Column, error)
  • func (c Column) FromString(ss []string) (interface{}, error)
• type Config
  • func (cfg Config) Close() error
  • func (cfg Config) Load(ctx context.Context, db *sql.DB, tbl, src string, fields []string) error
  • func (cfg Config) Open(ctx context.Context, db *sql.DB, fn string) (err error)
• type Type
  • func (t Type) String() string

Constants

const (
	Unknown = Type(0)
	String  = Type(1)
	Int     = Type(2)
	Float   = Type(3)
	Date    = Type(4)
)

const DefaultChunkSize = 1024

Variables

var (
	DateFormat = "2006-01-02 15:04:05"

	ErrTooManyFields = errors.New("too many fields")
)

Types

type Column

type Column struct {
	Name             string
	DataType         string
	Length           int
	Precision, Scale int
	Type             Type
	Nullable         bool
}

func CreateTable

func CreateTable(ctx context.Context, db *sql.DB, tbl string, rows <-chan dbcsv.Row, truncate bool, tablespace, copyTable string, forceString bool, logger *slog.Logger) ([]Column, error)

func (Column) FromString

func (c Column) FromString(ss []string) (interface{}, error)

type Config

type Config struct {
	Tablespace, Copy string
	*dbcsv.Config
	JustPrint              io.Writer
	Logger                 *slog.Logger
	Concurrency, ChunkSize int
	ForceString, Truncate  bool
	LobSource              bool
}

func (Config) Close

func (cfg Config) Close() error

func (Config) Load

func (cfg Config) Load(ctx context.Context, db *sql.DB, tbl, src string, fields []string) error

func (Config) Open

func (cfg Config) Open(ctx context.Context, db *sql.DB, fn string) (err error)

type Type

type Type uint8

func (Type) String

func (t Type) String() string