csv2sqlite

package module

v0.0.0-...-09ec2d6 Latest Latest Go to latest Published: Dec 16, 2021 License: MIT Imports: 7 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

CLI tool to convert csv to sqlite with type info

Run with options (single table)

$ csv2sqlite -c ./foo.csv -t foo_tb -d ./dump.db
foo.csv -> dump.db (incl. foo_tb)

Run with options (multiple tables)

$ csv2sqlite -c ./foo.csv -t foo_tb -c ./bar.csv -t bar_tb -d ./dump.db
(foo.csv, bar.csv) -> dump.db (incl. foo_tb, bar_tb)

Run with no options (only single table)

$ csv2sqlite ./foo.csv
foo.csv -> foo.db (incl. foo)

Useful in combination with drag-and-drop or shortcuts

$ go install github.com/dono/csv2sqlite/cmd/csv2sqlite@latest

MIT

This section is empty.

This section is empty.

func GenTableQParams(scheme string) string

func GenTableScheme(header []string, sampleRow []string) string

TODO: escape "(", ")", ",", and so on.

type DB struct {
	*sql.DB
}

func NewDB(dbName string) (*DB, error)

func (db *DB) CreateTable(name string, scheme string) (Table, error)

type Table struct {
	*DB
	Name    string
	Scheme  string
	QParams string
}

func (table Table) InsertRows(rows [][]string) error

Path	Synopsis
cmd
csv2sqlite