to-sql
v1.0.2
Published
Create SQL tables and insert data from tabular file formats
Downloads
19
Readme
to-sql
Node.js script to read .csv
, .tsv
, and Excel spreadsheets
into a series of standard SQL CREATE TABLE
and INSERT
statements.
$ npm install -g to-sql
Example:
$ to-sql MySpreadsheet.xlsx
Creating table Sheet1
Inserting 171 rows
Creating table Sheet2
Inserting 0 rows
Uses the fabulous xlsx
library for parsing the Excel spreadsheet.
It does some simple regular expression-based type inference, automatically distinguishing between TEXT
, INTEGER
, and REAL
, as well as some formats of DATE
and TIME
.
To-do
- Support more types in the type inference part
- Infer foreign relationships if possible
License
Copyright 2016-2017 Christopher Brown. MIT Licensed