YelloJello
07/27/2021, 7:25 PMsumchans
07/27/2021, 7:25 PMFlyken
07/27/2021, 7:34 PMhttps://i.imgur.com/1Gn2XF0.png▾
Flyken
07/27/2021, 7:35 PMjs
useEffect(() => {
if (user) {
(async () => {
const res = await fetchGames();
const {data: gameList, error} = await supabase.from('games').select('*')
if(res) {
res.data.map(game => {
gameList.map((Game) => {
if(Game.id == game.game_id) {
setGames(game)
}
})
})
}
})();
}
}, [user]);
console.log(games)
Flyken
07/27/2021, 7:35 PMYelloJello
07/27/2021, 7:35 PMFlyken
07/27/2021, 7:36 PMFlyken
07/27/2021, 7:36 PMFlyken
07/27/2021, 7:37 PMFlyken
07/27/2021, 7:37 PMFlyken
07/27/2021, 7:37 PMFlyken
07/27/2021, 7:38 PMFlyken
07/27/2021, 7:38 PMFlyken
07/27/2021, 7:38 PMFlyken
07/27/2021, 7:39 PMFlyken
07/27/2021, 7:39 PMFlyken
07/27/2021, 7:39 PMfrubalu
07/27/2021, 7:40 PMsetGames(game)
, which is overwriting it each time there's a matchFlyken
07/27/2021, 7:40 PMgames
table, and return in an array of games that match game_id
Flyken
07/27/2021, 7:40 PMfrubalu
07/27/2021, 7:40 PM.match()
?frubalu
07/27/2021, 7:41 PMfrubalu
07/27/2021, 7:41 PMconst { data, error } = await supabase.from('games').select().match({ id: gameId })
frubalu
07/27/2021, 7:41 PMFlyken
07/27/2021, 7:41 PMFlyken
07/27/2021, 7:43 PMjs
if(res) {
res.data.map(game => {
//console.log(game)
(async () => {
const { data, error } = await supabase.from('games').select().match({ id: game.game_id })
if(data){
console.log(data)
}
})
})
}
like this?frubalu
07/27/2021, 7:44 PMres
returns all of a specific user's games from the users_games
table, right?frubalu
07/27/2021, 7:44 PMFlyken
07/27/2021, 7:45 PMfrubalu
07/27/2021, 7:45 PM