jsonsql

jsonsql.js

var pages = [
    {
        "id": 1,
        "slug": "empresa",
        "page": "Empresa",
        "title": "Empresa",
        "subtitle": "Sub Empresa",
        "text": "",
        "created_at": "2013-07-12 12:15:25",
        "updated_at": "2014-02-27 10:28:20"
    },
    {
        "id": 2,
        "slug": "servicos",
        "page": "Serviços",
        "title": "Serviços",
        "subtitle": "Sub Serviços",
        "text": "",
        "created_at": "2013-07-12 12:15:25",
        "updated_at": "2014-02-27 10:28:20"
    }
]

jsonsql.query("select * from pages where (slug == 'empresa') order by title", pages);
/*
return:
[
    Object
    created_at: "2013-07-12 12:15:25"
    id: 1
    page: "Empresa"
    slug: "empresa"
    subtitle: "Sub Empresa"
    text: ""
    title: "Empresa"
    updated_at: "2014-02-27 10:28:20"
    __proto__: Object
]
*/

jsonsql.query("select * from pages order by title desc", pages);
/*
[
    Object
    created_at: "2013-07-12 12:15:25"
    id: 2
    page: "Serviços"
    slug: "servicos"
    subtitle: "Sub Serviços"
    text: ""
    title: "Serviços"
    updated_at: "2014-02-27 10:28:20"
    __proto__: Object
, 
    Object
    created_at: "2013-07-12 12:15:25"
    id: 1
    page: "Empresa"
    slug: "empresa"
    subtitle: "Sub Empresa"
    text: ""
    title: "Empresa"
    updated_at: "2014-02-27 10:28:20"
    __proto__: Object
]
*/