sqlite-ddl-parser v0.1.0

SQlite DDL Parser

A SQLite DDL(Data definition language) parser module.

This module is built on codeschool/sqlite-parser

Install

npm install sqlite-ddl-parser

Example

const fs = require('fs');
const SQLiteDDLParser = require('sqlite-ddl-parser');

console.log(SQLiteDDLParser.parse(fs.readFileSync('./test/sql/contacts.sql'))); 
/*
{
    "tables": [{
		"name": "contacts",
		"columns": [{
			"name": "contact_id",
			"type": "integer",
			"notNull": false,
			"unique": false
		},{
			"name": "first_name",
			"type": "text",
			"notNull": true,
			"unique": false
		},{
			"name": "last_name",
			"type": "text",
			"notNull": true,
			"unique": false
		},{
			"name": "email",
			"type": "text",
			"notNull": true,
			"unique": true
		},{
			"name": "phone",
			"type": "text",
			"notNull": true,
			"unique": true
		}],
		"primaryKeys": [
			"contact_id"
		]
	}]
}
*/

Author

Liu Yue

License

GPL-3.0