postgrest_client_sync_async_basic_select_query.py

1import asyncio
2from postgrest import SyncPostgrestClient, PostgrestClient
3
4# Example using the Synchronous client
5def sync_example():
6    url = "https://your-postgrest-endpoint.com"
7    headers = {"Authorization": "Bearer YOUR_JWT_TOKEN"}
8    
9    with SyncPostgrestClient(url, headers=headers) as client:
10        # Perform a basic SELECT query on the 'todos' table
11        response = client.from_("todos").select("*").execute()
12        print(response.data)
13
14# Example using the Asynchronous client
15async def async_example():
16    url = "https://your-postgrest-endpoint.com"
17    headers = {"Authorization": "Bearer YOUR_JWT_TOKEN"}
18    
19    async with PostgrestClient(url, headers=headers) as client:
20        # Perform a basic SELECT query on the 'todos' table
21        response = await client.from_("todos").select("*").execute()
22        print(response.data)
23
24if __name__ == "__main__":
25    # To run the sync version:
26    sync_example()
27    
28    # To run the async version:
29    # asyncio.run(async_example())