[Question]: I'm having a problem with populating data after migrating to 2.0 about supabase-kt HOT 9 CLOSED

On which method? And what do you mean with no longer working?

from supabase-kt.

builder.select(columns = Column.raw("*, profile(*)"))
Before this was returning the data with a populated profile, with 2.0 the profile is returned as an id, and I'm getting an error in serialization saying that object is expected but found string instead. So it seems like the profile is not populated.
I managed to fix this by listing all the fields: Column.raw("id, name, profile(id, first_name, age)") but I have a lot of fields, I prefer using the star it's easier to read and maintain.

from supabase-kt.

Can you show the full error? I just tried something similar and it works perfectly fine:

val result = supabase.from("products").select(Columns.raw("*, shops(*)"))
println(result.data) //the objects contain all fields

from supabase-kt.

The code:

Here's the error:

from supabase-kt.

Is primary_image actually a table? You have to specify the table and it postgres will automatically look for relationships and then fills in the data. (See https://supabase.com/docs/guides/database/joins-and-nesting)

from supabase-kt.

primary_image is the field name, but the table name is image, in 1.x I had to use the field name, I will try to change it with the table name.

from supabase-kt.

@MohamedRejeb Looking at the postgrest docs, it seems like it can be both. So the problem you have is not that the data is not there rather that there are two identical json keys. Can you try that:

Columns.raw("*, primary_image_data:primary_image(*)")

Here I'm renaming the key where you have the actual data (and not the id of the data)

from supabase-kt.

Note that the primary_image_data will contain the data and primary_image will still be the id of the primary image. You can also try the opposite to rename the primary_image id column:

Columns.raw("primary_image_id:primary_image, *, primary_image(*)")

from supabase-kt.

Closing due to inactivity. Feel free to reopen!

from supabase-kt.