userDetailsService.js

getUserDetails: function (event, context, commonService, dbService, userModel, callback) {
            let idRetrieved = event.queryStringParameters.id ? event.queryStringParameters.id : '';
            dbService.connectDb(commonService.DB_CONFIG.CONNECTIONSTRING, {}).then(() => {
                    dbService.query(userModel, {
                        'userId': idRetrieved
                    }, {}).then(userDataArray => {
                        let userData = userDataArray[0];
                        return new Promise((resolve, reject) => {
                            if (!userData) {
                                reject('User data is missing');
                            }
                            let returndata = {
                                firstName: userData.firstName,
                                lastName: userData.lastName,
                            }
                            resolve(returndata);
                        });
                    })
                })
                .then(data => dbService.disconnectDb(data))
                .then(data => callback(data))
                .catch((error) => {
                    dbService.disconnectDb(error).then(error => {
                        console.log(error);
                        callback({}, error);
                    })
                });
        }