Implement qualifiers for DBEntities

Details

Description

This is much like ObjEntities qualifier, only applied on DBEntities level. This, for instance, means that it will be inserted in needed JOINs of any select, thus allowing to use restricting qualifiers in e.g. middle table of many-to-many flattened relationship.
This issue includes core changes and modeler support

Activity

This is my implementation of the feature. The only disadvantage I see is that we cannot provide different qualifiers for different DBMS. Personally I don't think this is too important by now. So, if there aren't any objections I will add modeler support and commit next week

Andrey Razumovsky
added a comment - 05/Jun/09 07:48 This is my implementation of the feature. The only disadvantage I see is that we cannot provide different qualifiers for different DBMS. Personally I don't think this is too important by now. So, if there aren't any objections I will add modeler support and commit next week

Turns out we need some type of expressions for DBEntities, to correctly insert table prefix to a db entity qualifier, e.g.
SELECT .... from p1 .... WHERE p1.deleted=false
instead of
SELECT .... from p1 .... WHERE deleted=false

Now db entities support expression-like qualifiers. Attributes and relations can be used as always, but there's no need to add "db:" prefix since it will be inserted automatically.
This also ensures expressions will be translated correctly to different DBMS

Andrey Razumovsky
added a comment - 17/Jun/09 15:57 Now db entities support expression-like qualifiers. Attributes and relations can be used as always, but there's no need to add "db:" prefix since it will be inserted automatically.
This also ensures expressions will be translated correctly to different DBMS