Advertisement
Guest User

Untitled

a guest
Mar 26th, 2019
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. 'use strict'
  2. var mysql = require('mysql');
  3. var connection = mysql.createConnection({
  4. host: 'myrdstest.c7wi8gxlnp28.eu-central-1.rds.amazonaws.com',
  5. user: 'masterUsername',
  6. password: '123456Qwe',
  7. database: 'test'
  8. });
  9.  
  10. module.exports.maria = (event, context, callback) => {
  11.  
  12. connection.connect();
  13.  
  14. connection.query('SELECT * FROM books', function (error, results, fields) {
  15. if (error) throw error;
  16.  
  17. // TODO implement
  18. const response = {
  19. statusCode: 200,
  20. body: JSON.stringify(results),
  21. };
  22. callback(null, response);
  23. });
  24.  
  25. connection.end();
  26. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement