Skip to content

Latest commit

 

History

History
74 lines (59 loc) · 1.34 KB

README.md

File metadata and controls

74 lines (59 loc) · 1.34 KB
Raw

Export table from database to a csv file

This little utility exports database table from a database to a CSV file

Install:

go install github.com/olbrichattila/gocsvexporter/cmd/csvexporter@latest

Usage: csvexporter . <tablebane> <csvfilename> <separator>

where the Separator is optional, if not set then it defaults to ,

The database connection can be set by .env.csvexporter file, or if not exists, the application tries to get it from linux environment variables what you can set: Example:

export DB_CONNECTION=sqlite
export DB_DATABASE=./data/database.sqlite

Possible .env.csvexporter settings (please see .env.* examples as well)

SqLite:

DB_CONNECTION=sqlite
DB_DATABASE=./data/database.sqlite

MySql:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=migrator
DB_USERNAME=migrator
DB_PASSWORD=H8E7kU8Y

PostgresQl:

DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
DB_DATABASE=postgres
DB_USERNAME=postgres
DB_PASSWORD=postgres
DB_SSLMODE=disable

FirebirdSQL

DB_CONNECTION=firebird
DB_HOST=127.0.0.1
DB_PORT=3050
DB_DATABASE=/firebird/data/employee.fdb
DB_USERNAME=SYSDBA
DB_PASSWORD=masterkey

Makefile targets:

  • run
  • switch-sqlite
  • switch-mysql
  • switch-pgsql
  • switch-firebird
  • lint
  • test (under development)

Coming Next

  • test
  • distributed import