A Command Line tool reading JSON file by simplified SQL
Install Jison by run npm install -g jison
Json file should contain an array whose elements are simple object named data.json in current dir:
[
{
"name": "human",
"location": "earth",
"last_physical_contact": "2015-08-28"
},
{
"name": "Martian",
"location": "mars",
"upcoming_event": "birthday party"
}
]
Run jison sql.jison && node index.js, then you can query data in json by type in sql after prompt >
> select *;
AST:
{ type: 'select',
selection: '*',
clause: { where: null, orderBy: null } }
+---------+----------+-----------------------+----------------+
| name | location | last_physical_contact | upcoming_event |
+---------+----------+-----------------------+----------------+
| human | earth | 2015-08-28 | |
+---------+----------+-----------------------+----------------+
| Martian | mars | | birthday party |
+---------+----------+-----------------------+----------------+
>
> select * where location == 'earth' order by name desc;
AST:
{ type: 'select',
selection: '*',
clause:
{ where:
{ type: 'COMPARISON',
predicate: [ '==', [ 'COLUMN', 'location' ], 'earth' ] },
orderBy: [ [ 'name', 'desc' ] ] } }
+-------+----------+-----------------------+
| name | location | last_physical_contact |
+-------+----------+-----------------------+
| human | earth | 2015-08-28 |
+-------+----------+-----------------------+
>