csv-2-sql-example

Introduction👨‍💻

This program is written with GO to show how to read csv files and register them in the database

Usage

flags

-config=config.json or --config=config.json
-file=file.csv or --file.csv=file.csv

config includes db information for insert csv

{
  "username": "postgres",
  "password": "postgres",
  "host": "localhost",
  "name": "exel2sqldb",
  "ssl": "disable"
}

Examples

Windows

go run main.go -file=C:\file\path\username.csv

OR

.\build.exe -file=C:\file\path\username.csv

Linux

go run main.go -file=/file/path/username.csv

OR

wine start -file=/file/path/username.csv

Tech Stack

Database: postgresql

Lang: GO

github.com/savioxavier/termlink v1.3.0
github.com/lib/pq

Authors

• @pooulad
• @hossein1376

Demo