
cParseCom examples
In parse.com – nosql database for VBA, I described how to use cParseCom to be able to use parse.com directly from VBA. You can find the implementation details here parse.com api class for VBA Here’s a few […]
In parse.com – nosql database for VBA, I described how to use cParseCom to be able to use parse.com directly from VBA. You can find the implementation details here parse.com api class for VBA Here’s a few […]
I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I compare parse.com performance with script DB. One of the things that Parse.com has going […]
Because the GAS API is so similar to parse.com – nosql database for VBA, you may want to read that too, which has similar examples. Note that virtually all methods can be chained leading to pretty […]
Just as in parse.com – nosql database for VBA, you’ll probably want to load up some test data from a Google Spreadsheet to a Parse.com class. You’ll find some test data in this workbook – it’s same data […]
The first problem we hit is the 1000 object limit on parse queries. Here’s how to get round it using jQuery promises.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 |
<!DOCTYPE HTML> <html> <head> <title></title> <link rel="stylesheet" type="text/css" href="css/colortable.css"> <script src="http://www.parsecdn.com/js/parse-1.2.2.min.js"></script> <script src="js/colortable.js"></script> <script type="text/javascript" src="http://www.google.com/jsapi"></script> <script type="text/javascript"> google.load('visualization', '1'); google.load("jquery", '1'); </script> <script type="text/javascript"> google.setOnLoadCallback(function () { //populateParse(); var scheme = ""; var parseKeys = getParseKeys(); Parse.initialize(parseKeys.appId, parseKeys.jsKey); var ColorTable = Parse.Object.extend("ColorTable"); schemePromise(ColorTable, scheme).done(function (all) { console.log("scheme " + scheme + " returned " + all.length); }) .fail(function (error) { console.log("error getting scheme " + scheme + JSON.stringify(error)); }); }); function findChunk(model, scheme, allData) { // we have to find in chunks since there is a limit on query size // will return a promise var limit = 1000; var skip = allData.length; var findPromise = $.Deferred(); var query = new Parse.Query(model); if (scheme) query.equalTo("scheme", scheme); query .limit(limit) .skip(skip) .find() .then(function (results) { findPromise.resolve(allData.concat(results), !results.length); }, function (results) { findPromise.reject(error); }); return findPromise.promise(); } function schemePromise(model, scheme, allResults, allPromise) { // find a scheme at a time var promise = allPromise || $.Deferred(); findChunk(model, scheme, allResults || []) .done(function (results, allOver) { if (allOver) { // we are done promise.resolve(results); } else { // may be more schemePromise(model, scheme, results, promise); } }) .fail(function (error) { promise.reject(error); }); return promise.promise(); } </script> </head> <body></body> </html> |
How it works Parse allows only 1000 results max per query, but […]
Writing to parse.com was fairly complex, with all the asynchronicity and limiting. Writing the workbook to scriptDB should be much easier. We’ll use exactly the same approach as for Updating parse.com , namely get the data, get the existing […]
We’ve looked at Query Limits on parse.com and Google Visualization API data to prepare for loading the color table from Playing around with GAS color into parse.com. Now to load the data Using parse.save One of the constraints of parse is that it’s […]
First up we’ll query the colortable created in Updating parse.com, using the parse REST API. We can’t use the javaScript API in dome way from GAS, because it’s not caja compliant – if it were, we […]
Google Apps Script already has a noSQL database – scriptDB. I use it a lot, and have plenty of examples on this site. When I was developing parse.com api class for VBA , part of the motivation was […]
We’ve dealt with parse.com – nosql database for VBA, cParseCom examples and shown the code at parse.com api class for VBA. Here’s a few selected topics to help you understand a lottle more about how […]
Following on from Query parse.com from GAS, and Query scriptDB from GAS here’s the common code they each need to construct and compile the queries and results. colorschemer created by GitJsonApi https://github.com/brucemcpherson/colorschemer 0 forks. 3 stars. 0 open […]
Deprecated Parse.com has now become parseplatform.org and i will be investigating it at a later stage. I am however leaving the page as if as you may still find it useful. Contact me if you […]
In this section, we’ll build an application that pulls together many concepts already covered elsewhere on this site. You can run it standalone at xliberation.com, or below, embedded in this page The target application Pulling together Playing […]
I use scriptDB a lot , both with Google Apps Script and from other sources, including VBA, and in this blog post, I compare parse.com performance with script DB. One of the things that Parse.com […]
parse.com – nosql database for VBA, describes how to use this class to be able to use parse.com directly from VBA. Here’s the details of the implementation. List of functions and properties Can be found […]
I figured it would be pretty nice to be able use one of the cloud based noSQL databases directly from VBA, so that I could share data easily between various platforms. On Excel Liberation , I […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines