[
https://issues.apache.org/jira/browse/CAY-2478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16625089#comment-16625089
]
Bob Schellink commented on CAY-2478:
------------------------------------
This will be a great addition. I know Cayenne frowns on using the DB primary
key directly, but from a practical point of view it will make things much
easier.
> cgen: Generate properties for PK
> --------------------------------
>
> Key: CAY-2478
> URL: https://issues.apache.org/jira/browse/CAY-2478
> Project: Cayenne
> Issue Type: Improvement
> Components: Modeler, Non-GUI Tools
> Reporter: Nikita Timofeev
> Priority: Major
> Fix For: 4.1.M3
>
>
> To use PK in query (in where or order by clause) you need to write custom
> expressions and that is most likely ugly (something like
> {{ExpressionFactory.matchDbExp("db:" + Artist.ARTIST_ID_PK_COLUMN, 1)}})
> So we may just use Cayenne Property API and generate these properties in cgen
> tools. This will lead to much cleaner code: {{Artist.ARTIST_ID_COLUMN.eq(1)}}
> A few things to keep in mind:
> * PK can be compound, in that case there should be several properties
> * PK can be already mapped on ObjAttribute, in that case we shouldn't
> generate anything
> * PK property naming shouldn't clash with other properties
> * this feature should be optional (or not?)
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
