Supadantic is a small Python library that allows you to manage Supabase tables through Pydantic models. It is very convenient to use in projects based on FastAPI, Flask, and so on.
Supadantic may not have backward compatibility until version 0.1.0. This is because the library is still experimental and is being used in several of my other projects, where requirements are still being finalized.
See documentation for more details.
Install using pip install -U supadantic.
Also, you need to add SUPABASE_URL and SUPABASE_KEY to your env variables.
from supadantic.models import BaseSBModel class User(BaseSBModel): # id field already defined in BaseSBModel class name: str = 'John Doe' is_active: bool = True # By default table name is class name in snake_case # you can override it by setting `Meta.table_name` attribute class Meta: table_name = 'db_user' # Save user active_user = User(name='John Snow') active_user.save() non_active_user = User(is_active=False) non_active_user.save() # Get all users users = User.objects.all() # Count users users.count() # Get first user users.first() # Get last user users.last() # Filter users active_users = User.objects.filter(is_active=True) # Or active_users = User.objects.exclude(is_active=False) # Update all active users active_users.update(is_active=False) # Delete all non active users User.objects.exclude(is_active=True).delete() # Get one user and delete user = User.objects.get(name='John Doe') user.delete()