supabase / wrappers

Postgres Foreign Data Wrapper development framework in Rust.
http://fdw.dev
Apache License 2.0
562 stars 56 forks source link

Add "status" column in subscriptions stripe to where filter "status" works outside of attrs #317

Open wallacedevsantos opened 3 months ago

wallacedevsantos commented 3 months ago

I can't search for signatures with status all in the stripe wrapper's foreign table, by default the api only returns signatures with status "active", so we need to have the option to filter by status "all", the code says we can filter by id, costumer and status, but status is inside attrs and doesn't work in reality.

If we do a search on Supabase, it does not return subscriptions with a status other than "active":

select * from stripe.subscriptions where status = 'all';

returns the error: ERROR: 42703: column "status" does not exist LINE 1: select * from stripe.subscriptions where status = 'all' limit 100; ^ HINT: Perhaps you meant to reference the column "subscriptions.attrs".

wallacedevsantos commented 3 months ago

If I try to search for the status within attrs it will not return any results, only if I pass an id or client along