piccolo-orm
Are there constraints
Hello, can we define constraints over the table? Similar to Django, I am requesting for:
Check constraints Unique constraints
Thank you!
Unique constraints are possible:
class MyTable(Table):
name = Varchar(unique=True)
We don't currently have unique together constraints, but it's often requested, so I'll add it soon. Likewise with check constraints.
You can add them directly to your database using SQL, and it should be OK.
@dantownsend Ye, thank you, I did that In the case of Unique constraints, I mean a lack of ability to set a conditional unique constraint, like: Unique application and status when status is pending. I used to write a lot of constraints like that, they are really helpful to prevent any corrupted data in huge complicated systems