Guest User

Untitled

a guest
Aug 31st, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. function helloworld(params) {
  2.  
  3. return new Promise(function (resolve, reject ) {
  4. // Default values set here
  5. let name = params.name || 'stranger';
  6. getGreeting(name, value => {
  7. resolve({message: value});
  8. })
  9. })
  10. };
  11.  
  12. function getGreeting(name, callback) {
  13. const format = require('string-format');
  14. const mysql = require('mysql');
  15.  
  16. // Get special greeting from database here
  17. const dbconn = mysql.createConnection({
  18. host: 'mysql',
  19. user: 'myuser',
  20. password: 'myuser',
  21. database: 'mydb'
  22. });
  23.  
  24. // Default greeting
  25. var greeting = "Hello";
  26. try {
  27. dbconn.connect((err) => {
  28. if (err) {
  29. }
  30. });
  31. } catch (error) {
  32. }
  33.  
  34. try {
  35. var qry = format('SELECT custom_greeting FROM personal_greeting WHERE first_name = "{}";', name);
  36. dbconn.query(qry, (err,rows) => {
  37. if ( rows.length > 0 ) {
  38. greeting = rows[0].custom_greeting;
  39. }
  40. return callback(format(greeting + ", {}", name));
  41. });
  42. } catch (error) {
  43. };
  44. dbconn.end;
  45. }
  46.  
  47. exports.main = helloworld;
Add Comment
Please, Sign In to add comment