queryoncsv
A small tool to execute sqlite3 queries on csv files
Last updated 2 years ago by saildeep .
MIT · Repository · Bugs · Original npm · Tarball · package.json
$ cnpm install queryoncsv 
SYNC missed versions from official npm registry.

queryoncsv

A small tool to run sqlite3 queries on csv files

Installation

npm install -g queryoncsv

Usage

queryoncsv -c file.csv -q query.sql -o out.csv
Options

  -v, --verbose                  Verbose Logging
  -c, --csv string[]             CSV files to load
  -q, --queries string[]         Queries to run on the data
  -o, --outfiles string[]        Paths were the data should be written to. One per query
  -d, --csvdelimiter string      Delimiter of the csv files
  -D, --outputdelimiter string   Delimiter of the output csv files
  -N, --outputnewline string     Newline of the output csv files
  -H, --noheader                 Omit writing the header to the csv files
  -e, --csvencoding string       Encoding of the loaded csv files
  --queryencoding string         Encoding of the queries
  -h, --help                     Show this help text

All tables are named with their respective csv name e.g. test.csv -> test

Current Tags

  • 1.0.8                                ...           latest (2 years ago)

9 Versions

  • 1.0.8                                ...           2 years ago
  • 1.0.7                                ...           2 years ago
  • 1.0.6                                ...           2 years ago
  • 1.0.5                                ...           2 years ago
  • 1.0.4                                ...           2 years ago
  • 1.0.3                                ...           2 years ago
  • 1.0.2                                ...           2 years ago
  • 1.0.1                                ...           2 years ago
  • 1.0.0                                ...           2 years ago
Maintainers (1)
Downloads
Today 1
This Week 1
This Month 2
Last Day 0
Last Week 1
Last Month 12
Dependencies (14)
Dev Dependencies (0)
None
Dependents (0)
None

Copyright 2014 - 2016 © taobao.org |