Postgres query is not executed on Node.js

Viewed 164

I've got into an issue. Postgres code(query) is not executed at all. I have to mention that the connection with the DB is correctly done.

I've tried to debug the code but I don't really know what's the problem

'use strict';

const config = require('../config');
const emailService = require('./email-service');
const pg = require('pg');
pg.defaults.ssl = true;


 module.exports = function(phone_number, user_name, previous_job, years_of_experience, job_vacancy){
    console.log('sending email');
    let emailContent = 'A new job inquiry from ' + user_name + ' for the job: ' + job_vacancy +
        '.<br> Previous job position: ' + previous_job + '.' +
        '.<br> Years of experience: ' + years_of_experience + '.' +
        '.<br> Phone number: ' + phone_number + '.';

    emailService.sendEmail('New job application', emailContent);
    try{
    var pool = new pg.Pool(config.PG_CONFIG);
    pool.connect(function(err, client, done) {
        if (err) {
            return console.error('Error acquiring client', err.stack);
        }
        client
            .query(
                'INSERT into job_applications ' +
                '(phone_number, user_name, previous_job, years_of_experience, job_vacancy) ' +
                'VALUES($1, $2, $3, $4, $5) RETURNING id',
                [phone_number, user_name, previous_job, years_of_experience, job_vacancy],
                function(err, result) {
                    if (err) {
                        console.log(err);
                    } else {
                        console.log('row inserted with id: ' + result.rows[0].id);
                    }

                });
    });
}
catch(e){
    console.log(e, 'error[][][]')
}
    pool.end();
} ```
0 Answers
Related