Guest User

Untitled

a guest
Nov 7th, 2017
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.96 KB | None | 0 0
  1. function connectToCloudSQL() {
  2.  
  3. var params = {
  4. ip: "INSERT IP",
  5. user: "INSERT USER",
  6. password: "INSERT PASSWORD",
  7. database: "INSERT DATABASE"
  8. }
  9.  
  10. var dbUrl = 'jdbc:mysql://' + params.ip + '/' + params.database;
  11. var conn = Jdbc.getConnection(dbUrl, params.user, params.password);
  12.  
  13. var stmt = conn.createStatement();
  14. var sql = "desc mytable"; //WRITE YOUR QUERY HERE
  15.  
  16. stmt.setMaxRows(100);
  17.  
  18. var results = stmt.executeQuery(sql);
  19. var mapping = {};
  20.  
  21. var doc = SpreadsheetApp.getActiveSpreadsheet();
  22. var cell = doc.getRange('a2');
  23. var row = 0;
  24. while (results.next()) {
  25. for (var col = 0; col < results.getMetaData().getColumnCount(); col++) {
  26. cell.offset(row, col).setValue(results.getString(col + 1));
  27. }
  28. row++;
  29. }
  30.  
  31.  
  32. while (results.next()) {
  33. Logger.log(results.getString(1));
  34. Logger.log(results.getString(2));
  35. Logger.log(results.getString(3));
  36.  
  37. }
  38.  
  39. results.close();
  40. stmt.close();
  41.  
  42. }
Add Comment
Please, Sign In to add comment