Parse Archives - Desktop Liberation

cParseCom examples

January 13, 2020 Comments Off

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 […]

cParseCom implementation

January 13, 2020 Comments Off

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 […]

Some simple examples

January 13, 2020 Comments Off

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 […]

creating Parse Classes from Google Spreadsheets

January 13, 2020 Comments Off

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 […]

Query Limits on parse.com

November 13, 2019 Comments Off

The first problem we hit is the 1000 object limit on parse queries. Here’s how to get round it using jQuery promises.

<!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>

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>

google.load('visualization', '1');

google.load("jquery", '1');

</script>

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>

</html>

How it works Parse allows only 1000 results max per query, but […]

Updating ScriptDB

November 13, 2019 Comments Off

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 […]

Updating parse.com

November 13, 2019 Comments Off

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 […]

Query parse.com from GAS

May 2, 2019 Comments Off

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 […]

parse.com – noSQL database for GAS

April 13, 2019 Comments Off

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 […]

Common query code

April 5, 2019 Comments Off

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 […]

Desktop Liberation

The definitive resource for Google Apps Script and Microsoft Office automation

Parse

cParseCom examples

cParseCom implementation

Some simple examples

creating Parse Classes from Google Spreadsheets

Query Limits on parse.com

Updating ScriptDB

Updating parse.com

Query parse.com from GAS

parse.com – noSQL database for GAS

more complex parse API topics

Common query code

Data from parse.com

Color scheme explorer

parse.com – nosql database for VBA

parse.com api class for VBA

Parse.com

Accessing parse.com and scriptDB noSQL databases from Excel