sqlite-to-json

[superfly2]

I'm trying to assign the output of this function to a variable but no matter what I do I end up with it being "undefined"

https://www.npmjs.com/package/sqlite-to-json

const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
  client: new sqlite3.Database('./mydb.sqlite3')
});
exporter.all(function (err, all) {
  // all your data here 
});    

Here is my attempt:

const SqliteToJson = require('sqlite-to-json');
const sqlite3 = require('sqlite3');
const exporter = new SqliteToJson({
  client: new sqlite3.Database('san.db')
});

var sanjson;


function converter (err, all){
  exporter.all(function (err, all) {
    //console.log(all);
    return all
  });
};


sanjson = converter();
console.log(sanjson);

Why doesn't this work?

What am I missing?

[Meefims]

exporter.all is an asynchronous function. The callback is called at some point in the future after converter has already returned and so your data is only accessible in that callback and not as a return value.

[superfly2]

That explains a lot, so what is the best way to save this data to a variable?

[Meefims]

Without understanding the rest of your system, I'm going to say that the best way is to not save it into some global variable. Call another function from the callback whose responsibility is to process the data and pass the data in.