On 5/19/15 12:18 PM, Jonathan Vanasco wrote:
I think I might understand you...
You have a BOX, which could be a variable amount of sizes, and each
size can hold a variable amount of items.
You want to create a rule(s) that will ensure you do not have too many
things in each box.
If that is that case:
1. You could use Triggers in PostgreSQL to ensure that you are within
the correct dimensions on insert and update.
2. You might be able use events in sqlalchemy to inspect the
collection and figure out if the number of items is allowablw
from my POV this is more of a SQL/database question, not really
SQLAlchemy. Not a problem to post here but I wish there were some way
for me to know which questions are SQLAlchemy-API-specific; other folks
and/or stackoverflow can take care of general Postgresql / SQL / schema
design questions.
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.