txt-to-sql

Tools for convert text data to SQL sentences

language: also available in:

Install

$ npm install -g txt-to-sql

Usage (command-line)

# Generate file.yaml with detected options 
$ txt-to-sql --prepare file.txt
 
# Process file.txt 
$ txt-to-sql file.txt
 
# Process file.txt using streams 
$ txt-to-sql --fast file.txt
 
# Exportr defaults to working directory 
$ txt-to-sql --export-default

Usage (code)

var txtToSql = require('txt-to-sql');
var fs = require('fs-promise');
 
txtToSql.generateScripts('./path/to/file.txt').then(function(generated){
    return fs.writeFile("file.sql", generated.rawSql);
}).then(function() {
    console.log("Done!");
});
 

License

MIT