Generating types in python format

[dhruvmalik007]

Is your feature request related to a problem? Please describe.

I was following the tutorial for generating the database types for supabase here , so I thought normally this command can be adapted for the python in order to generate the corresponding types in python objects

Describe the solution you'd like

to include the command

npx supabase gen types python --project-id "$PROJECT_REF" --schema public > types.py should generate the types in the python.

Describe alternatives you've considered
converting the types generated in ts into py ;) .
Additional context
N.A

[sweatybridge]

Type generation is handled mostly in https://github.com/supabase/postgres-meta/tree/master/src/server/templates where you can see a list of supported type templates.

If you would like to contribute a new language, we will be more than happy to review your PR.

[Mohmn]

Could you please assign this issue to me? I find it very interesting t. Also, could you guide me on anything I need to know to get started? Any specific instructions or resources would be greatly appreciated

[dhruvmalik007]

thanks @Mohmn for the response . my bad for late response but yeah I understood we will have to define the generator types and the wrapped call functions in order to pythonic format.

but yeah right now I have my plate full in terms of time dedication , so if you want to contribute please feel free to do that.

[TopIvanAbramov]

Generating types in Python will be really helpfull

[faroukcharkas]

python types would actually be incredible, having a built in almost-ORM? with supabase would be wild

[urieltfk]

Please, this would be amazing.

[antopiahk]

Please, this would be beyond amazing.

[nikita-olechko]

Wrote a small implementation for Python here:

https://github.com/nikita-olechko/Supabase-Table-Type-Definitions-In-Python/blob/main/README.md

Far from comprehensive, but works.

[ryanpeach]

Here is my suggestion for the output format #808

I don't think it will be hard to modify the go file to do this for python.

[tresorama]

Any updates on this ?

As of today which is the recommended path to convert TS types (generated with supabase cli) into python types ?
Recommended Libraries to use ?

[ryanpeach]

If it could get testing guidance on my PR I'd continue my work.

[tresorama]

If it could get testing guidance on my PR I'd continue my work.

You pr would add a new command to supabase cli ?

[ryanpeach]

No it just adds Python type generation.

[tresorama]

No it just adds Python type generation.

So it's a standalone script .py ?