[jira] Created: (CAY-1122) Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class

[Cayenne - Dev mailing list]

Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class
--------------------------------------------------------------------------------------------

                 Key: CAY-1122
                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
             Project: Cayenne
          Issue Type: New Feature
          Components: Cayenne Core Library
    Affects Versions: 3.0
            Reporter: Artyom Sokolov
            Assignee: Andrus Adamchik


Currently to achieve the same functionality we need to write next code:

                        SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
                        query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
                        List<Uri> uris = dataContext.performQuery(query);

It could be much better to write just this:

                        NamedQuery query = new NamedQuery("GetUris");
                        query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
                        List<Uri> uris = dataContext.performQuery(query);

Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

    [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13159#action_13159 ]

Andrus Adamchik commented on CAY-1122:
--------------------------------------

Hi Artem,

NamedQuery main intent is to accessed shared queries mapped in the Modeler where you can set column name capitalization using "Row Label Case" dropdown. Will this work for you?

Thanks,
Andrus

> Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class
> --------------------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

    [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13160#action_13160 ]

Artyom Sokolov commented on CAY-1122:
-------------------------------------

Hi Andrus,

Unfortunately "<property name="cayenne.SQLTemplate.columnNameCapitalization" value="upper"/>" seems not to work for me in 3.0M4. It looks like Cayenne simple ignores this construction at all. This is the reason why I use explicit capitalization in code :)

Thanks,
Artyom

> Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class
> --------------------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

    [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13162#action_13162 ]

Andrus Adamchik commented on CAY-1122:
--------------------------------------

then it is a different kind of bug. Let me look into that.

> Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class
> --------------------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

     [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Loiko Dima updated CAY-1122:
----------------------------

    Attachment: caseTest.txt

> Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class
> --------------------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>         Attachments: caseTest.txt
>
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

     [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Loiko Dima updated CAY-1122:
----------------------------

    Attachment: caseTest_1.txt

> Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class
> --------------------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>         Attachments: caseTest.txt, caseTest_1.txt
>
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

     [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik closed CAY-1122.
--------------------------------

       Resolution: Fixed
    Fix Version/s: 3.0

> columnNamesCapitalization property is ignored for the queries mapped via Modeler
> --------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>             Fix For: 3.0
>
>         Attachments: caseTest.txt, caseTest_1.txt
>
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

     [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik updated CAY-1122:
---------------------------------

    Summary: columnNamesCapitalization property is ignored for the queries mapped via Modeler  (was: Add setColumnNamesCapitalization(String columnNameCapitalization) method to NamedQuery class)

renaming the issue to reflect the actual problem

> columnNamesCapitalization property is ignored for the queries mapped via Modeler
> --------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: New Feature
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>             Fix For: 3.0
>
>         Attachments: caseTest.txt, caseTest_1.txt
>
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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

[Cayenne - Dev mailing list]

     [ https://issues.apache.org/cayenne/browse/CAY-1122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Andrus Adamchik updated CAY-1122:
---------------------------------

    Issue Type: Bug  (was: New Feature)

> columnNamesCapitalization property is ignored for the queries mapped via Modeler
> --------------------------------------------------------------------------------
>
>                 Key: CAY-1122
>                 URL: https://issues.apache.org/cayenne/browse/CAY-1122
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Cayenne Core Library
>    Affects Versions: 3.0
>            Reporter: Artyom Sokolov
>            Assignee: Andrus Adamchik
>             Fix For: 3.0
>
>         Attachments: caseTest.txt, caseTest_1.txt
>
>
> Currently to achieve the same functionality we need to write next code:
> SQLTemplate query = (SQLTemplate) dataContext.getEntityResolver().lookupQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> It could be much better to write just this:
> NamedQuery query = new NamedQuery("GetUris");
> query.setColumnNamesCapitalization(SQLTemplate.UPPERCASE_COLUMN_NAMES);
> List<Uri> uris = dataContext.performQuery(query);
> Code without casts looks more pretty and clean... doesn't it? :)

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