Recently, I've been delving into the world of Express and experimenting with a program that allows users to create events and invite others. While I know about using join tables to retrieve data, I'm curious if there's a way to organize the data in nested form using POSTGRESQL, showcasing events where the user is hosting, attending, or invited based on event IDs.
Here's my current progress:
app.get('/api/users', function(req, res) {
var list = [];
User.findAll().then(function(users) {
for( var i in users) {
var item = {
id: users[i].dataValues['id'],
firstName: users[i].dataValues['firstname'],
lastName: users[i].dataValues['lastname'],
email: users[i].dataValues['email'],
phone: users[i].dataValues['phone'],
image: users[i].dataValues['image'],
confirmed: users[i].dataValues['confirmed'],
events: []
}
Event.findAll({ where: { hosting_id: user.id }}).then(function(events) {
for( var i in events) {
item.events.push({
hosting: event[i].dataValues['id'],
attending: event[i].dataValues['id'],
invites: event[i].dataValues['id']
})
}
})
list.push(item)
}
res.json(list)
})
});
I've managed to loop through and find all associated events by user ID, but I'm struggling to connect them in a way that displays the event IDs as shown in this example:
{
"id": "4",
"firstName": "Jon",
"lastName": "Doe",
"email": "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="6b010f040e2b1f0e181f45080406">[email protected]</a>",
"phone": "1234567890",
"image": "",
"events": {
"hosting": [
"1"],
"attending": [],
"invites": [
"3", "4"]
},
"confirmed": true
}
In addition to displaying the information, I'm pondering whether the nesting needs to be done within a POSTGRES database or if utilizing a join table would suffice without requiring another API call.
Any assistance will be highly valued! Thank you in advance!