Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function helloworld(params) {
- return new Promise(function (resolve, reject ) {
- // Default values set here
- let name = params.name || 'stranger';
- getGreeting(name, value => {
- resolve({message: value});
- })
- })
- };
- function getGreeting(name, callback) {
- const format = require('string-format');
- const mysql = require('mysql');
- // Get special greeting from database here
- const dbconn = mysql.createConnection({
- host: 'mysql',
- user: 'myuser',
- password: 'myuser',
- database: 'mydb'
- });
- // Default greeting
- var greeting = "Hello";
- try {
- dbconn.connect((err) => {
- if (err) {
- }
- });
- } catch (error) {
- }
- try {
- var qry = format('SELECT custom_greeting FROM personal_greeting WHERE first_name = "{}";', name);
- dbconn.query(qry, (err,rows) => {
- if ( rows.length > 0 ) {
- greeting = rows[0].custom_greeting;
- }
- return callback(format(greeting + ", {}", name));
- });
- } catch (error) {
- };
- dbconn.end;
- }
- exports.main = helloworld;
Add Comment
Please, Sign In to add comment