You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cayenne.apache.org by "Andrey Razumovsky (JIRA)" <ji...@apache.org> on 2009/06/02 13:07:07 UTC

[jira] Created: (CAY-1235) Implement qualifiers for DBEntities

Implement qualifiers for DBEntities
-----------------------------------

                 Key: CAY-1235
                 URL: https://issues.apache.org/jira/browse/CAY-1235
             Project: Cayenne
          Issue Type: New Feature
          Components: Cayenne Core Library, CayenneModeler GUI
    Affects Versions: 3.0M6
            Reporter: Andrey Razumovsky
            Assignee: Andrey Razumovsky
             Fix For: 3.0 beta 1


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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Updated: (CAY-1235) Implement qualifiers for DBEntities

Posted by "Andrey Razumovsky (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CAY-1235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Razumovsky updated CAY-1235:
-----------------------------------

    Attachment: 1235.diff

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

> Implement qualifiers for DBEntities
> -----------------------------------
>
>                 Key: CAY-1235
>                 URL: https://issues.apache.org/jira/browse/CAY-1235
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library, CayenneModeler GUI
>    Affects Versions: 3.0M6
>            Reporter: Andrey Razumovsky
>            Assignee: Andrey Razumovsky
>             Fix For: 3.0 beta 1
>
>         Attachments: 1235.diff
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (CAY-1235) Implement qualifiers for DBEntities

Posted by "Andrey Razumovsky (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CAY-1235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Razumovsky closed CAY-1235.
----------------------------------

    Resolution: Fixed

> Implement qualifiers for DBEntities
> -----------------------------------
>
>                 Key: CAY-1235
>                 URL: https://issues.apache.org/jira/browse/CAY-1235
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library, CayenneModeler GUI
>    Affects Versions: 3.0M6
>            Reporter: Andrey Razumovsky
>            Assignee: Andrey Razumovsky
>             Fix For: 3.0 beta 1
>
>         Attachments: 1235.diff
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Reopened: (CAY-1235) Implement qualifiers for DBEntities

Posted by "Andrey Razumovsky (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CAY-1235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Razumovsky reopened CAY-1235:
------------------------------------


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 

> Implement qualifiers for DBEntities
> -----------------------------------
>
>                 Key: CAY-1235
>                 URL: https://issues.apache.org/jira/browse/CAY-1235
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library, CayenneModeler GUI
>    Affects Versions: 3.0M6
>            Reporter: Andrey Razumovsky
>            Assignee: Andrey Razumovsky
>             Fix For: 3.0 beta 1
>
>         Attachments: 1235.diff
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


[jira] Closed: (CAY-1235) Implement qualifiers for DBEntities

Posted by "Andrey Razumovsky (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/CAY-1235?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrey Razumovsky closed CAY-1235.
----------------------------------

    Resolution: Fixed

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

> Implement qualifiers for DBEntities
> -----------------------------------
>
>                 Key: CAY-1235
>                 URL: https://issues.apache.org/jira/browse/CAY-1235
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library, CayenneModeler GUI
>    Affects Versions: 3.0M6
>            Reporter: Andrey Razumovsky
>            Assignee: Andrey Razumovsky
>             Fix For: 3.0 beta 1
>
>         Attachments: 1235.diff
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.