Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.03 KB | None | 0 0
  1. function foo() {
  2. var conn = Jdbc.getConnection('jdbc:mysql://<host>:3306/<instance>', 'user', 'password');
  3. var stmt = conn.createStatement();
  4. stmt.setMaxRows(100);
  5. var start = new Date();
  6. var rs = stmt.executeQuery('select * from person');
  7.  
  8. var doc = SpreadsheetApp.getActiveSpreadsheet();
  9. var cell = doc.getRange('a1');
  10. var row = 0;
  11. while (rs.next()) {
  12. for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
  13. cell.offset(row, col).setValue(rs.getString(col + 1));
  14. }
  15. row++;
  16. }
  17. rs.close();
  18. stmt.close();
  19. conn.close();
  20. var end = new Date();
  21. Logger.log('Time elapsed: ' + (end.getTime() - start.getTime()));
  22. }
  23.  
  24. select * from table_name
  25. into outfile '/somelocation/data.csv'
  26. FIELDS TERMINATED BY ','
  27. OPTIONALLY ENCLOSED BY '"'
  28. LINES TERMINATED BY 'n';
  29.  
  30. // Replace the variables in this block with real values.
  31. var address = 'Your DB Address Here';
  32. var user = 'Enter USER';
  33. var userPwd = 'YOUR PASSWORD';
  34. var db = 'DATABASE NAME';
  35.  
  36. var dbUrl = 'jdbc:mysql://' + address + '/' + db;
  37.  
  38. // Read up to 1000 rows of data from the table and log them.
  39. function readFromTable() {
  40. var conn = Jdbc.getConnection(dbUrl, user, userPwd);
  41.  
  42. var start = new Date();
  43. var stmt = conn.createStatement();
  44. // Read up to 1000 rows of data from the table and log them.
  45. // stmt.setMaxRows(1000);
  46. var results = stmt.executeQuery('SELECT * FROM YOURTABLE');
  47.  
  48. var sheet = SpreadsheetApp.getActiveSpreadsheet();
  49. var cell = sheet.getRange('A1');
  50. var numCols = results.getMetaData().getColumnCount();
  51. var row =0;
  52.  
  53. while (results.next()) {
  54. var rowString = '';
  55. for (var col = 0; col < numCols; col++) {
  56. rowString += results.getString(col + 1) + 't';
  57. cell.offset(row, col).setValue(results.getString(col +1 ));
  58. }
  59. row++
  60. Logger.log(rowString)
  61. }
  62.  
  63. results.close();
  64. stmt.close();
  65. conn.close();
  66.  
  67. var end = new Date();
  68. Logger.log('Time elapsed: %sms', end - start);
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement