Package Exports

@zapscloud/zapsdatabase

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (@zapscloud/zapsdatabase) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

zapsdatabase

Zapscloud Database API Client

Initialize Library with config values

var zapsdb = new ZapsDB({
    url: 'https://api.zapscloud.com',
    app: 'appsample',
    tenant: ' ',
    authkey: ' ',
    authsecret: ''
})

Snippet for Collection create

var dbcollection = 'samplecoll'
// Create Collection
// createCollection(collectionname, collectionkey, description)
zapsdb.createCollection(dbcollection, 'key_id', 'Sample Collection')
.then(function (response) {
    // collection created successfully
})
.catch(function (err) {
    // collection created failed
});

Snippet for Collection remove

// Remove Collection
// removeCollection(collectionname)
zapsdb.removeCollection(dbcollection)
.then(function (response) {
    // collection removed successfully
})
.catch(function (err) {
    // collection removed failed
});

Snippet for Insert Document

// Insert a record
//  insertOne(collectionname, jsondata)
zapsdb.insertOne(dbcollection, {
     'key_id':'001',
     'key_status':'A',
     'key_value':'Same Values',
     'key_another_value':123
})
.then(function (response) {
    // insert successful
})
.catch(function (err) {
    // insert failure 
});

Snippet for Get a Document

// Get a record
// getOne(collectionname, key, lookupkeys)
// lookupkeys => helps to retrive relative collection
zapsdb.getOne(dbcollection, '001')
.then(function (response) {
    // get successful
})
.catch(function (err) {
    // get failure 
});

Snippet for Multiple Document retive

// Get multiple record
// getMany(collectionname,filterquery)
// filterquery => query to filter, sort, skip and limit

zapsdb.getMany(dbcollection, 'key_value=/00/')
.then(function (response) {
    // get successful
})
.catch(function (err) {
    // get failure 
});

Snippet for Aggrigate Documents

// Get multiple record
// getAggregation(collectionname, aggquery, filterquery)
// aggquery => mongodb style aggregation
// filterquery => query to sort, skip and limit

zapsdb.getAggregation(dbcollection, '[{"$group":{"_id" : "$key_status", "count":{"$sum":1}, "total" : {"$sum": "$key_another_value"}}}])
.then(function (response) {
    // get successful
})
.catch(function (err) {
    // get failure 
});

Snippet for Update a Document

// update a record by key
// updateOne(collectionname, key, setjsondata, unsetjsondata)
zapsdb.updateOne(dbcollection, '001', 
   {
     'key_value':'Updated Values'
    },
    {
     'key_another_value':0
    }
)
.then(function (response) {
    // set & unset data successful
})
.catch(function (err) {
    // update failure 
});

Snippet for Update Multiple Documents

// update multiple records
// updateMany(collectionname, filterquery, setjsondata, unsetjsondata)
zapsdb.updateMany(dbcollection, 'key_value=/00/&key_another_value > 100', 
    {
     'key_value':'Updated Values'
    },
    {
     'key_another_value':0
    }
)
.then(function (response) {
    // set & unset data successful
})
.catch(function (err) {
    // update failure 
});

Snippet for Delete a Document

 // Delete a record
 // deleteOne(collectionname, key)
zapsdb.deleteOne(dbcollection, '001')
.then(function (response) {
    // delete successful
})
.catch(function (err) {
    // delete failure 
});

Snippet for Delete Multiple Documents

// Delete multiple records by query
// deleteMany(collectionname, filterquery)
zapsdb.deleteMany(dbcollection, 'key_value=/00/')
.then(function (response) {
    // delete records with key_value contains '00' successful
})
.catch(function (err) {
    // delete failure 
});

Snippet for Retive Multiple Documents

// Get multiple record
// getMany(collectionname,filterquery)
// filterquery => query to filter, sort, skip and limit

Query with multiple conditions

// Example of multiple conditions
zapsdb.getMany(dbcollection, 'key_value=/00/&key_another_value>99')
.then(function (response) {
    // get successful
})
.catch(function (err) {
    // get failure 
});

Snippet for Multiple Document With Skip & Limit

Skip 2 records and Limit 10 records

// Example of multiple conditions
zapsdb.getMany(dbcollection, 'skip=2&limit=10')
.then(function (response) {
    // get successful
})
.catch(function (err) {
    // get failure 
});

Snippet for Multiple Document With Sorting

Sorting document with key_value ascending and key_another_value desending

// Example of multiple conditions
zapsdb.getMany(dbcollection, 'sort=key_value,-key_another_value')
.then(function (response) {
    // get successful
})
.catch(function (err) {
    // get failure 
});

Snippet for Multiple Document With Search, Sort and Skips

Sorting document with key_value ascending and key_another_value desending

key_value=/00/ & key_another_value>99 & sort=key_value,-key_another_value & skip=2 & limit=10

// Example of multiple conditions
zapsdb.getMany(dbcollection, 'key_value=/00/&key_another_value>99&sort=key_value,-key_another_value&skip=2&limit=10')
.then(function (response) {
    // get successful
})
.catch(function (err) {
    // get failure 
});