Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function loadData() {
- var sheet = SpreadsheetApp.getActiveSheet();
- var instanceUrl = 'jdbc:mysql://' + address;
- var dbUrl = instanceUrl + '/' + db;
- var conn = Jdbc.getConnection(dbUrl, user, userPwd);
- var stmt = conn.createStatement();
- stmt.setMaxRows(10);
- var results = stmt.executeQuery('Select YEAR(dateCreated) as yearAdded,MONTH(dateCreated) as monthAdded, DAY(dateCreated) as dayAdded,sum(amount)/100 from stripeTransactions GROUP BY yearAdded ,monthAdded,dayAdded;');
- var numCols = results.getMetaData().getColumnCount();
- while (results.next()) {
- var rowArray = new Array();
- for (var col = 0; col < numCols; col++) {
- rowArray.push(results.getString(col+1));
- }
- sheet.appendRow(rowArray);
- }
- results.close();
- stmt.close();
- var stmt2 = conn.createStatement();
- stmt2.setMaxRows(10);
- var results2= stmt2.executeQuery('Select YEAR(dateAdded) as yearAdded,MONTH(dateAdded) as monthAdded, DAY(dateAdded) as dayAdded,sum(amount) from itunestransactions GROUP BY yearAdded ,monthAdded,dayAdded;');
- var numCols2 = results2.getMetaData().getColumnCount();
- while (results2.next()) {
- var rowArray2 = new Array();
- for (var cal = numCols; cal < numCols2; cal++) {
- rowArray2.push(results2.getString(cal+1));
- }
- sheet.appendRow(rowArray2);
- }
- results2.close();
- stmt2.close();
- }
Add Comment
Please, Sign In to add comment