Can some help me how to implement query like this ...
# off-topicr
rayyanmaq1
08/05/2021, 7:45 AMCan some help me how to implement query like this one?
rayyanmaq1
08/05/2021, 7:47 AM2nd from is of user_from user uid of user and 3rd row is user_to uid of user who he is following
s
silentworks
08/05/2021, 7:58 AMIs the user uuid always the same one or is it a parameter that you pass in?
silentworks
08/05/2021, 7:59 AMSame question for privacy too
u
unrealg
08/05/2021, 7:59 AM^
r
rayyanmaq1
08/05/2021, 9:54 AMYeah that i written here would be the current user uid
rayyanmaq1
08/05/2021, 9:55 AMMean it is the query to get posts of whom a current user is following
s
silentworks
08/05/2021, 9:55 AMSo this uuid would be dynamic and not static right?
r
rayyanmaq1
08/05/2021, 9:55 AMPrivacy will also be the same
rayyanmaq1
08/05/2021, 9:56 AMYeah dynamic
rayyanmaq1
08/05/2021, 9:56 AMI have written static to check is the query works
s
silentworks
08/05/2021, 9:57 AMThe best way to do this is to create a database function and call it via the
.rpcsilentworks
08/05/2021, 9:58 AMI can’t give an example right now as I’m on my mobile, but if you check the Supabase GitHub discussion board you will find examples I’ve given in the past. Just search for .rpc and you should get some results
r
rayyanmaq1
08/05/2021, 9:58 AMOk i will check 😊
k
Kosh
08/05/2021, 3:27 PMyou could simply do this:
Copy code
final response = await _supabase.client
.from('posts')
.select(
"*, user:user_id(id, username, profile_picture)"
)
.eq('user_id', uid)
.execute();Kosh
08/05/2021, 3:29 PMfor friends table, my table is designed in a way like this
friends_table -> follower , following, created_at, both follower and following are primary keys.
then simply to get followers from supabase
Copy code
final response = await _supabase.client
.from(FRIENDS_DB)
.select(
"*, following_user:follower(id, username, profile_picture), "
"follower_user:following(id, username, profile_picture)",
)
.eq('following', uid)
.execute(); Copy code
final response = await _supabase.client
.from(FRIENDS_DB)
.select(
"*, follower_user:follower(id, username, profile_picture), "
"following_user:following(id, username, profile_picture)",
)
.eq('follower', uid)
.execute();r
rayyanmaq1
08/06/2021, 7:03 AMHey I made rpc method but having issue in return type can you help me out
s
silentworks
08/06/2021, 7:03 AMOpen an Discussion on https://github.com/supabase/supabase/discussions and I will assist you there
silentworks
08/06/2021, 7:24 AM@User I've replied to your discussion topic I'll paste the link here for anyone wanting to get involved or having the same question https://github.com/supabase/supabase/discussions/2741
silentworks
08/06/2021, 7:26 AM@User can you modify the title to How do I get query data from a database function?
r
rayyanmaq1
08/06/2021, 8:51 AMSure and thanks alot sir😊
s
silentworks
08/06/2021, 8:58 AMYou're welcome, I'm sure this will be useful to someone else in the future too. At some point I will try and work out how to do this with the actual function UI in the dashboard.
r
rayyanmaq1
08/06/2021, 9:13 AMsure it would be very helpful