Not able to configure for Promises with Tables import from csv.

[jyotirmay123]

I was trying to import data from csv file and dump it onto mysql database. That is working correctly. Now I want to resolve a promise when the execution is done for data dump.
I am using below code to do so, I tried different stuff to get into end point and placing the resolve call there, but did not work out.
Please help me how to return a promise with data dum complete.

var csvToMysql = {
    import_: function (filePath, table) {
        return new Promise((resolve, reject) => {
           let tbl = new Tables({
                input: filePath,
                inputType: "csv",
                db: "mysql://" + mysql.user + ":" + mysql.password + "@" + mysql.host + ":" + mysql.port + 
                        "/" + mysql.database,
                tableName: table,
                errorHandler: reject,
                successHandler : resolve  // Is there any such option or if any other way??
            });
       }
}

[jyotirmay123]

Please have a look into the issue ASAP. My project work has been delayed due to not proper documentation of this module!! @shawnbot @zzolo @mike-hearn @thepapaya @noslouch

[zzolo]

Hey @jyotirmay123, it's pretty bad form to call a bunch of random people out in this manner. Especially for an open source project. Please avoid this in the future here and basically any other project.

Yes, it doesn't look like there is anyway to hook into the non-error end of the Tables process. Will update the name of this issue.

I think it's possible if you want to override the .done function of Tables to handle it. Maybe something like:

Tables.prototype.done = function(error, message) {
  // Your code
}

let tbl = new Tables({});

[jyotirmay123]

Thanks a lot. It works. We tried this but by providing successHandler() as there is one for errorHandler(). And providing successhandler = resolve, errorHandler = reject in options.

But anyway.. Thank you very much... You saved us from using shitty timeout function that we were using as a alternate for this. :) Good luck with your project.

[jyotirmay123]

Sorry, It's not working.

[jyotirmay123]

Sorry, It's not working.

[jyotirmay123]

Issue is with csv file with few hundreds of rows. I think, done function does not wait until end, it is resolving promise just after sending last batch of data dump into database and does not wait it to be complete and hence with small dataset, it resolves before anything gets inserted.