jsonsql
Advanced tools
Comparing version 0.2.1 to 0.2.2
{ | ||
"name": "jsonsql", | ||
"version": "0.2.1", | ||
"version": "0.2.2", | ||
"description" : "A SQL-like query language for JSON objects.", | ||
@@ -5,0 +5,0 @@ "main": "index.js", |
@@ -172,1 +172,49 @@ # jsonSQL | ||
``` | ||
##### Date string comparison: | ||
###### Data Source: | ||
```javascript | ||
var dataSource = [ | ||
{ | ||
"Version": "120", | ||
"CreateDate": "2013-05-25T06:50:25.584Z", | ||
"Desc": "abcdef" | ||
}, | ||
{ | ||
"Version": "121", | ||
"CreateDate": "2014-05-23T06:50:25.584Z", | ||
"Desc": "dfdsf" | ||
}, | ||
{ | ||
"Version": "122", | ||
"CreateDate": "2015-05-26T06:50:25.584Z", | ||
"Desc": "qewert" | ||
}, | ||
{ | ||
"Version": "123", | ||
"CreateDate": "2016-05-24T06:50:25.584Z", | ||
"Desc": "xfsstd" | ||
} | ||
]; | ||
``` | ||
##### query: | ||
```javascript | ||
var Query = require('../index'); | ||
var res = Query(dataSource, '* where age<=30'); | ||
console.log('======RESULT 1\n',res); | ||
``` | ||
##### RESULT OUTPUT: | ||
```bash | ||
======RESULT 1 | ||
[ { Version: '121', | ||
CreateDate: '2014-05-23T06:50:25.584Z', | ||
Desc: 'dfdsf' }, | ||
{ Version: '122', | ||
CreateDate: '2015-05-26T06:50:25.584Z', | ||
Desc: 'qewert' }, | ||
{ Version: '123', | ||
CreateDate: '2016-05-24T06:50:25.584Z', | ||
Desc: 'xfsstd' } ] | ||
``` |
22246
219