Nrthugu

I'm new to Javascript and I have to solve a task for my Homework.
I have to get specific data (album titles and the album IDs) from a Database in one class, return this Data to another class and format it with template literals there.

getAlbums: function (db) {

    sql = `SELECT DISTINCT Title, AlbumId FROM albums`;

    let title = , id = ;

    db.all(sql, , (err, rows) => {

        if (err) throw err;

        rows.forEach((row)=>{

            title.push(row.Title);

            id.push(row.AlbumId);

        });

    });

    return [title, id];

}

this is the function where I get the data from the database. When I put a console.log(title) inside the db.all function, the titles array is filled correctly. But it does not return this array to the other class, I get an error:

TypeError: Cannot read property 'forEach' of undefined.

If I put a console.log(title) outside the db.all function, it returns an empty array and I don't get an error. The output is just undefined.

The method call in my other class:

showAlbum: function (db) {

    let albumID = model.getAlbums(db);

    //let album = "";

    //let albId = "";



    albumID.forEach((element) => {

        //album = element.title;

        //albId = element.id;

        console.log(`Albumtitle: ${element.title} AlbumID: ${element.id}n`);

    });

}

How can I transfer the arrays correctly?

Try changing your JS code to the following.

getAlbums: function (data) {

sql = `SELECT DISTINCT Title, AlbumId FROM albums`;

let title = , id = ;

data.data.all(sql, , (err, rows) => {

    if (err) throw err;

    rows.forEach((row)=>{

        title.push(row.Title);

        id.push(row.AlbumId);

    });

});

return [title, id];

}

then

showAlbum: function (data) {

let albumID = model.getAlbums(data.data);

//let album = "";

//let albId = "";



albumID.forEach((element) => {

    //album = element.title;

    //albId = element.id;

    console.log(`Albumtitle: ${element.title} AlbumID: ${element.id}n`);

});

}