❤
npm
Sign UpSign In

jsonql-totaljs

1.3.0 • Public • Published

jsonql-totaljs

NPM

npm version Build Status Coverage Status JavaScript Style Guide Known Vulnerabilities dependencies Status License NPM download/month NPM download total
JsonQL NoSQL Embedded for Total.js Framework.

This will make you easier to use NoSQL Embedded in Total.js Framework.

Get Started

Install using NPM

$ npm install jsonql-totaljs

Usage

  • Basic Query
const JsonQL = require('jsonql-totaljs');
// create new object jsonql
const jsonql = new JsonQL();
 
// build query
var q = [
    {
        select: {
            fields:['user_id','name'],
            from:'user',
            where:[
                ['name','==','budi']
            ]
        }
    }
];
 
// with callback
jsonql.query(q).exec(function(err,data) {
    console.log(data);        
});
 
// on top promise
jsonql.query(q).promise().then((data) => {
    console.log(data);        
});
  • Multiple Query in Single Execution
var q = [
    {
        select: {
            from:'user',
            where:[
                ['name','==','wawan']
            ]
        }
    },
    {
        select: {
            from:'profile',
            where:[
                ['address','==','jakarta']
            ]
        }
    }
];
    
jsonql.query(q).exec(function(err,data) {
    console.log(data);
});
  • Join Query
var q = [
   {
       select: {
           from:'user',
           where:[
               ['name','==','budi']
           ],
           join:[
               {
                   name:'profile',
                   from:'user_profile',
                   on:['id','id'],
                   first:true
               }
           ]
       }
   }
];
 
jsonql.query(q).exec(function(err,data) {
   console.log(data);        
});
  • Join Nested
var q = [
    {
        select: {
            from:'user',
            where:[
                ['name','==','budi']
            ],
            join:[
                {
                    name:'profile',
                    from:'user_profile',
                    on:['id','id'],
                    first:true,
                    join:[
                        {
                            name:'additional',
                            from:'user_other',
                            on:['id','id'],
                            first:false
                        }
                    ]
                }
            ]
        }
    }
];
 
jsonql.query(q).exec(function(err,data) {
    console.log(data);        
});
  • Join Nested Manually
var q = [
    {
        select: {
            from:'user',
            where:[
                ['name','==','budi']
            ],
            join:[
                {
                    name:'profile',
                    from:'user_profile',
                    on:['id','id'],
                    first:true
                },
                {
                    name:'additional',
                    from:'user_other',
                    on:['id','id'],
                    first:false
                }
            ],
            nested:['profile','additional']
        }
    }
];
 
jsonql.query(q).exec(function(err,data) {
    console.log(data);        
});
  • Insert Single
var q = [
    {
        insert: {
            into:'data_crud',
            values:[
                {
                    id:'1',
                    name:'aziz'
                }
            ]
        }
    }
];
    
jsonql.query(q).exec(function(err,data) {
    console.log(data);
});
  • Insert Multiple
var q = [
    {
        insert: {
            into:'data_crud',
            values:[
                {
                    id:'1',
                    name:'aziz'
                },
                {
                    id:'2',
                    name:'tika'
                }
            ]
        }
    }
];
    
jsonql.query(q).exec(function(err,data) {
    console.log(data);
});
  • Update
var q = [
    {
        update: {
            from:'data_crud',
            where:[
                ['name','==','aziz']
            ],
            set:{
                id:'1',
                name:'aziz alfian'
            }
        }
    }
];
    
jsonql.query(q).exec(function(err,data) {
    console.log(data);
});
  • Modify
var q = [
    {
        modify: {
            from:'data_crud',
            where:[
                ['name','==','aziz']
            ],
            set:{
                name:'M ABD AZIZ ALFIAN'
            }
        }
    }
];
    
jsonql.query(q).exec(function(err,data) {
    console.log(data);
});
  • Delete
var q = [
    {
        delete: {
            from:'data_crud',
            where:[
                ['name','==','aziz']
            ]
        }
    }
];
    
jsonql.query(q).exec(function(err,data) {
    console.log(data);
});

Documentation

For more detail in usage, please see the documentation in our Wiki.

Unit Test

All features has been tested, you also can learn how to use all features from unit test.

$ npm test

Readme

Keywords

Package Sidebar

Install

npm i jsonql-totaljs

Repository

github.com/aalfiann/jsonql-totaljs

Homepage

github.com/aalfiann/jsonql-totaljs#readme

Weekly Downloads

2

Version

1.3.0

License

MIT

Unpacked Size

60.7 kB

Total Files

11

Last publish

Collaborators

  • aalfiann
Try on RunKit
Report malware