Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function foo() {
- var conn = Jdbc.getConnection('jdbc:mysql://<host>:3306/<instance>', 'user', 'password');
- var stmt = conn.createStatement();
- stmt.setMaxRows(100);
- var start = new Date();
- var rs = stmt.executeQuery('select * from person');
- var doc = SpreadsheetApp.getActiveSpreadsheet();
- var cell = doc.getRange('a1');
- var row = 0;
- while (rs.next()) {
- for (var col = 0; col < rs.getMetaData().getColumnCount(); col++) {
- cell.offset(row, col).setValue(rs.getString(col + 1));
- }
- row++;
- }
- rs.close();
- stmt.close();
- conn.close();
- var end = new Date();
- Logger.log('Time elapsed: ' + (end.getTime() - start.getTime()));
- }
- select * from table_name
- into outfile '/somelocation/data.csv'
- FIELDS TERMINATED BY ','
- OPTIONALLY ENCLOSED BY '"'
- LINES TERMINATED BY 'n';
- // Replace the variables in this block with real values.
- var address = 'Your DB Address Here';
- var user = 'Enter USER';
- var userPwd = 'YOUR PASSWORD';
- var db = 'DATABASE NAME';
- var dbUrl = 'jdbc:mysql://' + address + '/' + db;
- // Read up to 1000 rows of data from the table and log them.
- function readFromTable() {
- var conn = Jdbc.getConnection(dbUrl, user, userPwd);
- var start = new Date();
- var stmt = conn.createStatement();
- // Read up to 1000 rows of data from the table and log them.
- // stmt.setMaxRows(1000);
- var results = stmt.executeQuery('SELECT * FROM YOURTABLE');
- var sheet = SpreadsheetApp.getActiveSpreadsheet();
- var cell = sheet.getRange('A1');
- var numCols = results.getMetaData().getColumnCount();
- var row =0;
- while (results.next()) {
- var rowString = '';
- for (var col = 0; col < numCols; col++) {
- rowString += results.getString(col + 1) + 't';
- cell.offset(row, col).setValue(results.getString(col +1 ));
- }
- row++
- Logger.log(rowString)
- }
- results.close();
- stmt.close();
- conn.close();
- var end = new Date();
- Logger.log('Time elapsed: %sms', end - start);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement