sql-createtableobject v0.0.10

sql-createtableobject

Returns SQL Query of Create Table using an Object.

var createtable = require('sql-createtableobject');
// createtable(<table>, <column types>, <keys>);

createtable('speech', {'person': 'text', 'speech': 'text'}, ['person']);
// {"query": "CREATE TABLE IF NOT EXISTS "speech" ("person" text,"speech" text,PRIMARY KEY("person"));"}

createtable('speech', {'person': 'text', 'speech': 'text'}, 'person');
// {"query": "CREATE TABLE IF NOT EXISTS "speech" ("person" text,"speech" text,PRIMARY KEY("person"));"}

createtable('speech', {'person': 'text primary key', 'speech': 'text'});
// {"query": "CREATE TABLE IF NOT EXISTS "speech" ("person" text primary key,"speech" text);"}