Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 46056 invoked from network); 10 Jun 2008 21:58:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 10 Jun 2008 21:58:41 -0000 Received: (qmail 49157 invoked by uid 500); 10 Jun 2008 21:58:42 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 49147 invoked by uid 500); 10 Jun 2008 21:58:42 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 49136 invoked by uid 99); 10 Jun 2008 21:58:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jun 2008 14:58:42 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of marcin@ish.com.au designates 59.167.240.32 as permitted sender) Received: from [59.167.240.32] (HELO fish.ish.com.au) (59.167.240.32) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Jun 2008 21:57:53 +0000 Received: from [10.29.64.41] (helo=[10.29.64.41]) by fish.ish.com.au with esmtps (TLSv1:AES128-SHA:128) (Exim 4.43) id 1K6BuP-0007tl-E9 for user@cayenne.apache.org; Wed, 11 Jun 2008 08:01:42 +1000 Message-Id: From: Marcin Skladaniec To: user@cayenne.apache.org In-Reply-To: <1E5743C9-601A-4AC9-A07C-51B3196834B9@gmail.com> Content-Type: multipart/signed; boundary=Apple-Mail-62-752167401; micalg=sha1; protocol="application/pkcs7-signature" Mime-Version: 1.0 (Apple Message framework v924) Subject: Re: NamedQuery / SQLTemplate keyPath validation Date: Wed, 11 Jun 2008 07:58:04 +1000 References: <1E5743C9-601A-4AC9-A07C-51B3196834B9@gmail.com> X-Mailer: Apple Mail (2.924) X-Spam-Score: -1.4 (-) X-Spam-Report: -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-62-752167401 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit there is no simple way, see what I did in allRecordsCount in ListController. Yo wont translate IN statement and other easily though Marcin On 10/06/2008, at 4:26 PM, Lachlan Deck wrote: > Hi there, > > (question related to ROP) > > say I've got an Expression (whether complex or otherwise) and I want > to utilise that Expression in a NamedQuery or SQLTemplate... what's > the easiest way to transform the expression to an sql equivalent > string? (i.e., such that, e.g.,, boolean values are transformed from > say true to 1 (if using an int column), dates are formatted > appropriately etc, comparison operators are transformed (e.g., != to > <>) etc. > > I see that there's a QueryAssembler and QualifierTranslator etc, but > what I'm looking for, I guess, is a something like > expression.toSQLString(baseEntity). > > Any suggestions? > > Thanks. > > with regards, > -- > > Lachlan Deck > --Apple-Mail-62-752167401 Content-Disposition: attachment; filename=smime.p7s Content-Type: application/pkcs7-signature; name=smime.p7s Content-Transfer-Encoding: base64 MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIGIzCCAtww ggJFoAMCAQICEH04uRLie7YYyXPPwOrwracwDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UEBhMCWkEx JTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQ ZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA3MTAyMDAxNDg0OVoXDTA4MTAxOTAxNDg0 OVowQzEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjEgMB4GCSqGSIb3DQEJARYRbWFy Y2luQGlzaC5jb20uYXUwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQDu7dUT0rWcPhY8 Taf7mqzfUJTad8M5+Z535eVrhnvrPRTQxP/+4xqxykUsSiID4WbD9jZrN9qXt52wbbROlUzu4Psj E0HXbSgnigGwn8ktbCg3LEH36p2YvkFwwrk9qPE8VNR6hZ+6BtBvJ1lpSkNZCYjOMnXoKwt2gFJv Iespvi9TgPTNLHJ6mHqIXDBymAJMwQY69Yi91B0pcZpTCeJV3xNoOjkf/FwBWrJJmGOVuwnYgMrJ k26wM5rRfRgUB2lRv0gTvIhWMV7pT7gkSbpVrvQQAty6HytfWyvSl0WT0K3IIZ5J7PZs5tF8YUzP XSyucmiH6ufyA9vvpBpQSUCRAgMBAAGjLjAsMBwGA1UdEQQVMBOBEW1hcmNpbkBpc2guY29tLmF1 MAwGA1UdEwEB/wQCMAAwDQYJKoZIhvcNAQEFBQADgYEABFL6WBcmfwdhx346uDsEfWnFp8UDgbT/ x/XfGOQV0/wXgk2LK0Qc5iokICdCRv51oAigBMjFEQD0DLldqxWE0y9fDa/J3HCKox+M0oZfxIQg 9wcpwPftnrf3RyWowUJGoKtTxoiAwYHiQJSHiGKRvDvmjk3e/QLmA102yZm/wtcwggM/MIICqKAD AgECAgENMA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBD YXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYD VQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUgUGVy c29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWlsQHRoYXd0 ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQGEwJaQTElMCMG A1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJAoGBAMSmPFVz VftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTlUAow1wJjWiyJFXCO3cnwK4Va qj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIACZNenprufZdHFKlSFD0gEf6e20Txh BEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgwBgEB/wIBADBDBgNVHR8EPDA6MDigNqA0 hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3RlUGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNV HQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAYBgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqG SIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2jZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCT cDz9reFhYsPZOhl+hLGZGwDFGguCdJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo0 5RAaWzVNd+NWIXiC3CEZNd4ksdMdRv9dX2VPMYIDEDCCAwwCAQEwdjBiMQswCQYDVQQGEwJaQTEl MCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBl cnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0ECEH04uRLie7YYyXPPwOrwracwCQYFKw4DAhoFAKCC AW8wGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDgwNjEwMjE1ODA1 WjAjBgkqhkiG9w0BCQQxFgQUvLUwCE5i3JU/7i36UYCxl30OfkIwgYUGCSsGAQQBgjcQBDF4MHYw YjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAq BgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhB9OLkS4nu2GMlzz8Dq 8K2nMIGHBgsqhkiG9w0BCRACCzF4oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBD b25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJ c3N1aW5nIENBAhB9OLkS4nu2GMlzz8Dq8K2nMA0GCSqGSIb3DQEBAQUABIIBAHcE65ekgpJegoHg thB0+cwfrn2gfsdSuX5ji0wZTnrdtHVkuQlsCfi97oeBp21z21GGDy1EbeKVPDcYXhNEb0HMUhhy dq4JQ5gfCNYXvSMxTuUH7/gniZzNkj9Ps72ac+SXXF6sGZwhhsueuGVawNY0yuE8IBWUCEw+PS/C w/V3YxcIK2RRRKMaZaWtLSAYQmr7ySz523SgvX7vof7C6llayWmbMAMZqRU6lx0Xm8UhXqIxyX6H +U9X3B8V0KgCoGm3XRHFoyOQ+6uEj2my7UOxs1dY0RUN+m818si6Aq33NQUyXc37bTHd+su/TfBP ADgnJntI03i51C9vSELEotEAAAAAAAA= --Apple-Mail-62-752167401--