[CAY-800] SQLTemplate improvement - API to control the capitalization of the data row labels

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0M1, 3.0
• Component/s: Core Library
• Assignee: Andrus Adamchik
• Reporter: Andrus Adamchik
• Created: 08/Jun/07 19:27
• Updated: 08/May/10 15:41
• Resolved: 08/Jun/07 20:54

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