You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Oct 10, 2024. It is now read-only.
We have a couple of constraints that should always hold.
I'm not sure if it's possible to encode these in Django, but if it is, it would help to keep our data clean and potentially speed up some queries.
Note that we might need to fix some faulty data if we integrate this.
Some constraints that I can think of at the top of my head:
Submission:
If claimed_by is not null, then claim_time is not null
If completed_by is not null, then complete_time is not null
If completed_by is not null, then claimed_by is not null
create_time <= claim_time <= complete_time
If removed_from_queue is true, then approved is false
If approved is true then removed_from_queue is false
The text was updated successfully, but these errors were encountered:
We have a couple of constraints that should always hold.
I'm not sure if it's possible to encode these in Django, but if it is, it would help to keep our data clean and potentially speed up some queries.
Note that we might need to fix some faulty data if we integrate this.
Some constraints that I can think of at the top of my head:
Submission:
claimed_by
is notnull
, thenclaim_time
is notnull
completed_by
is notnull
, thencomplete_time
is notnull
completed_by
is notnull
, thenclaimed_by
is notnull
create_time
<=claim_time
<=complete_time
removed_from_queue
istrue
, thenapproved
isfalse
approved
istrue
thenremoved_from_queue
isfalse
The text was updated successfully, but these errors were encountered: