Posts

Showing posts with the label JavaScript Closure

Build Google BigQuery "Stored Procedures" With Google Cloud SQL - Part 4

Image
______________________ Part one  described the Google Cloud SQL database the sample application uses for the BigQuery "stored procedure" technique. Part two   described important details about the BigQuery project behind the solution. Part three  gave an overview of the Google Apps Script solution engineering. Part four here will explain the JavaScript objects behind the Google Apps Script solution. Download the five Google Apps Script component files and scripts for the MySQL stored procedure and the MySQL user-defined function from the  GitHub repository . ________________ T his diagram 1. Solution file / object diagram shows how the component solution files and objects fit together. At line 177 of the Code.gs file,  the runQuery() function 2. The runQuery() function declares and initializes a getSPStringObject class 3. The getSPStringObject class object. The object ultimately returns a finished BigQuery query string...