Uploaded image for project: 'Cayenne'
  1. Cayenne
  2. CAY-800

SQLTemplate improvement - API to control the capitalization of the data row labels

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 3.0
    • 3.0M1, 3.0
    • Core Library
    • None

    Description

      "SELECT *" SQLTemplates sometimes mess up the capitalization of labels in a returned DataRow, so it can't be converted to an object properly. Most users would follow a naming convention for the table names (ALL_UPPERCASE or all_lowercase). Unfortunately such mapping will not work consistemtly across different databases and SELECT * queries. So what was suggested on the mailing list [1] to address this problem (and avoid using #result workaround) is an API to force capitalization of the result set labels.

      I did a few preliminary tests, and this solution works extremely well.

      [1] http://objectstyle.org/cayenne/lists/cayenne-user/2007/06/0044.html

      Attachments

        Activity

          People

            andrus Andrus Adamchik
            andrus Andrus Adamchik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: