Re: [sqlalchemy] Re: restrict child count?

2015-05-19 Thread Mike Bayer
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

Re: [sqlalchemy] Re: restrict child count?

2015-05-19 Thread 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

[sqlalchemy] Re: restrict child count?

2015-05-19 Thread Jonathan Vanasco
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