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