csvq

command module
v0.6.1 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Aug 16, 2017 License: MIT Imports: 7 Imported by: 0

README

csvq

SQL-like query language for csv

Build Status codecov

csvq is a command line tool to operate CSV files. You can read, update, delete CSV records with SQL-like query.

You can also execute multiple operations sequentially in managed transactions by passing a procedure as a command argument or a source file. In the procedure, you can use variables, cursors, temporary tables, and other functions.

Install

Install executable binary
  1. Download an archive file from release page.
  2. Extract the downloaded archive and add a binary file in it to your path.
Build from source
Requirements

Go tools (ref. Getting Started - The Go Programming Language)

Build with either of the following two ways
Use go get
  1. $ go get -u github.com/mithrandie/csvq
Build with strict dependencies
  1. Install GNU Make
  2. $ go get -d github.com/mithrandie/csvq
  3. Change directory to $GOPATH/github.com/mithrandie/csvq
  4. $ make deps
  5. $ make install

Usage

# Simple query
csvq "select id, name from `user.csv`"
csvq "select id, name from user"

# Specify data delimiter as tab character
csvq -d "\t" "select count(*) from `user.csv`"

# Load from another directory
csvq "select id, name from `/path/to/user.csv`"
csvq -r /path/to "select user.id, user.name, country.name from `user.csv` natural join `country.csv`"

# Load no-header-csv
csvq --no-header "select c1, c2 from user"

# Load from standard input
csvq "select * from stdin" < user.csv
csvq "select *" < user.csv
cat user.csv | csvq "select *"

# Output in JSON format
csvq write -f json "select integer(id) as id, name from user"

# Output to a file
csvq write -o new_user.csv "select id, name from user"

# Show help
csvq -h

More details >> https://mithrandie.github.io/csvq

Documentation

The Go Gopher

There is no documentation for this package.

Directories

Path Synopsis
lib
cmd
csv

Jump to

Keyboard shortcuts

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