Re: [sqlalchemy] Re: restrict child count?

[Richard Gerd Kuesters]

i know, i'm sorry for that. i first posted it here since my whole 
application is managed by sqlalchemy, so that's why i asked for 
something. i mentioned postgresql because it's the database that i use 
and there's a lot of database specific solutions bundled with sa. but, 
even if no rdbms agnostic solution can be provided to such situation 
using sqlalchemy, i'll sure dive into a trigger :)

best regards,
richard.
On 05/19/2015 02:10 PM, Mike Bayer wrote:

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 
<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.
<<attachment: richard.vcf>>