INSTALLATION

Requirements

Local PostgREST server

docker-compose up

Instructions

With Poetry (recommended)

poetry add postgrest

With Pip

pip install postgrest

USAGE

Getting started

importasynciofrompostgrestimportAsyncPostgrestClientasyncdefmain():asyncwithAsyncPostgrestClient("http://localhost:3000")asclient:r=awaitclient.from_("countries").select("*").execute()countries=r.dataasyncio.run(main())

Create

awaitclient.from_("countries").insert({"name":"Việt Nam","capital":"Hà Nội" }).execute()

Read

r=awaitclient.from_("countries").select("id","name").execute()countries=r.data

Update

awaitclient.from_("countries").update({"capital":"Hà Nội"}).eq("name","Việt Nam").execute()

Delete

awaitclient.from_("countries").delete().eq("name","Việt Nam").execute()

General filters

Stored procedures (RPC)

awaitclient.rpc("foobar", {"arg1":"value1","arg2":"value2"}).execute()

DEVELOPMENT

git clone https://github.com/supabase/postgrest-py.gitcd postgrest-pypoetry installpoetry run pre-commit install

Testing

poetry run pytest

CHANGELOG

SPONSORS