Ftyjtk

I am trying to save the file and details of it in the database.

Waterfall function with two calls but the second function is not waiting for the first function to finish.

Even without using waterfall eachseries doesn't work as expected. It doesn't wait for the record to be created and hence uniqueness error occurs due to same id.
What am I doing wrong here and how can I fix it?

Thanks!

       async.eachSeries(uploadedPhotos, async function (uploadedFile, callback) {



          async.waterfall([

            async function() {

              var lastUser = await TblUserFiles.find({}).sort('id DESC').limit(1);

              // fileID remains undefined if i remove async-await from the  function 

              var fileID = lastUser[0].id;

              fileID += 1;

              cbb(null, fileID, uploadedFile);

            },

            async function(file_id, uploadedFile, cbb) {

              sails.log("save file id is " + file_id);

              sails.log("savee file id is " + uploadedFile['filename']);

              var today = moment(new Date()).format('YYYY-MM-DD HH:mm:ss');

              await TblUserFiles.findOrCreate({ customer_no: req.session.userId, file_type: 'profile_image' }, {

                id: fileID,

                customer_no: req.session.userId,

                file_name: uploadedFile['filename'],

                file_type: 'profile_image',

                is_approved: 'No',

                approved_by: 0,

                approved_on: today,

                approved_from: ip,

                uploaded_date: today,

                modified_date: today

              }).exec(async (err, user, wasCreated) => {

                if (err) { return res.serverError(err); }



                if (wasCreated) {

                  // created a new user

                  sails.log("new file was uploaded...")

                  return cbb(err, "done");



                  // return res.send("sent");

                }

                else {

                  // found existing user

                  var user = await TblUserFiles.create({

                    id: fileID,

                    customer_no: req.session.userId,

                    file_name: uploadedFile["filename"],

                    file_type: "image",

                    is_approved: "No",

                    approved_by: 0,

                    approved_on: today,

                    approved_from: ip,

                    uploaded_date: today,

                    modified_date: today

                  }).intercept(err => {

                    // Return a modified error here (or a special exit signal)

                    // and .create() will throw that instead

                    err.message = "Uh oh: " + err.message;

                    return err;

                  }).fetch();

                  if (user) {

                    sails.log("found existing files..")

                    return cbb(err, "done");

                  }

                  sails.log("this should not be called");

                }

              });

            }

          ], (err, success) => {

            if (err) sails.log(err);

            return callback(err, 'done')

          });







        }, function (err) {

          // if any of the saves produced an error, err would equal that error

          if (err) {

            sails.log(err);

          } else {

            return res.json({

              message: uploadedPhotos.length + ' file(s) uploaded successfully!',

              files: uploadedPhotos

            });

          }

        });

Updated answer:

I rewrite the code.
I forgot that async.js handles promise in different way. Basically, you don't use callback(). Use return instead. If an error occurs, use throw new Error(message).
See here for more information. Read topic: Using ES2017 async functions.

async.eachSeries(uploadedPhotos, async uploadedFile => {

  var lastUser = await TblUserFiles.find({}).sort('id DESC').limit(1);

  var fileID = lastUser[0].id;

  fileID += 1;

  sails.log("save file id is " + file_id);

  sails.log("savee file id is " + uploadedFile['filename']);

  var today = moment(new Date()).format('YYYY-MM-DD HH:mm:ss');

  await TblUserFiles.findOrCreate(

    { customer_no: req.session.userId, file_type: 'profile_image' },

    {

      id: fileID,

      customer_no: req.session.userId,

      file_name: uploadedFile['filename'],

      file_type: 'profile_image',

      is_approved: 'No',

      approved_by: 0,

      approved_on: today,

      approved_from: ip,

      uploaded_date: today,

      modified_date: today

    }

  ).exec(async (err, user, wasCreated) => {

    if (err) throw new Error(err);

    if (wasCreated) {

      sails.log("new file was uploaded...");

      return;

    } else {

      await TblUserFiles.create({

        id: fileID,

        customer_no: req.session.userId,

        file_name: uploadedFile["filename"],

        file_type: "image",

        is_approved: "No",

        approved_by: 0,

        approved_on: today,

        approved_from: ip,

        uploaded_date: today,

        modified_date: today

      })

      .intercept(err => {

        throw new Error("Uh oh: " + err.message);

      }).fetch();

      if (user) {

        sails.log("found existing files..");

        return;

      } else {

        sails.log("this should not be called");

        return;

      }

    }

  });

}, err => {

  // Don't call res.serverError() or res.json() inside the async loop!

  if (err) {

    sails.log(err);

    res.serverError(err);

  }

  else {

    res.json({

      message: uploadedPhotos.length + ' file(s) uploaded successfully!',

      files: uploadedPhotos

    });

  }

});

I think the first problem here is that the you forget to give the first task a callback function(cbb in this case).

async.waterfall([

            async function(cbb) {

              var lastUser = await TblUserFiles.find({}).sort('id DESC').limit(1);

              // fileID remains undefined if i remove async-await from the  function 

              var fileID = lastUser[0].id;

              fileID += 1;

              cbb(null, fileID, uploadedFile);

            },

            async function(file_id, uploadedFile, cbb) {

...

Secondly, you shouldn't return a callback. Callback is a function not a promise. Just use them normally.

By the way, const async = require('async'); will NOT override async keyword. Compiler can tell the difference between them. This is proved by the following script example:

const async = require('async');



let runPromise = (name, timer, success = true) => {

  console.log(`${name} starts.`);

  return new Promise((resolve, reject) => {

    if (success) {

      setTimeout(function () {

        resolve(`${name} finished after ${timer / 1000} seconds(resolved).`);

      }, timer);

    } else {

      reject(`${name} failed(rejected).`);

    }

  });

};



async function asyncFunction() {

  let txt = await runPromise('A', 1000);

  console.log(txt);

}



asyncFunction();