[Zope] ZSQLMethodFile?

[Peter Sabaini]

This is a cryptographically signed message in MIME format.

--------------ms090809020209070107070804
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Peter Bengtsson wrote:

[snip]

>>>>
>>> IF I wrap them are class methods, will it correctly look like this:
>>>
>>> def Mysqlstuff(Aq...):
>>>     def zsql_method(self, name, age):
>>>         return SQL(..., ..., ...)(name=name, age=age)
>>>
>>> Or do I need anything else?
>>
>>
>>
>> This should about work, but it would be more efficient if you stored 
>> the ZSQL object somewhere.  Otherwise you'd have to reparse the dtml 
>> each time you call zsql_method() and won't be able to use zope caching.
>>
> 
> You're right.
> So, if I don't wrap them like that but do define them as attributes, 
> they don't have to reparse them?
> Then I can do this:
> 
> class Mysqlstuff(Aq...):
> 
>     _login = SQL('null','dummy title', dbconnection,
>                  'name:string pass:string', sqlfile.read())
>     def login(self, name, pass):
>         ...do other things such as debug...
>         return _login(name=name, pass=pass)
> 
> What do you think about that?


Should work -- I use a somewhat different pattern though:

class AllSQL(Acquisition.Implicit):
     zsql = SQL('id', 'title', 'dbconnection', 'arg:type', \
                "select foo from bar where <dtml- ...")

class ZopeObject(OFS.SimpleItem, ...):
     sql = AllSQL()

     def a_method(self):
         zsql = self.sql.zsql
         result_set = zsql(arg="spam")
         ...


So I can keep all SQL in one place and I like to separate SQL from 
Python :-)

cheers, peter.

--------------ms090809020209070107070804
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIJcjCC
AxcwggKAoAMCAQICAwlZhTANBgkqhkiG9w0BAQQFADCBkjELMAkGA1UEBhMCWkExFTATBgNV
BAgTDFdlc3Rlcm4gQ2FwZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUx
HTAbBgNVBAsTFENlcnRpZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVl
bWFpbCBSU0EgMjAwMC44LjMwMB4XDTAzMDIyMTEzMTY0NloXDTA0MDIyMTEzMTY0NlowWzEQ
MA4GA1UEBBMHU2FiYWluaTEOMAwGA1UEKhMFUGV0ZXIxFjAUBgNVBAMTDVBldGVyIFNhYmFp
bmkxHzAdBgkqhkiG9w0BCQEWEHNhYmFpbmlAaW5vZGUuYXQwggEiMA0GCSqGSIb3DQEBAQUA
A4IBDwAwggEKAoIBAQC1XhEfxugiGePyj2dxvgshFABfJw+Zcfar1FrGEdmCiMdEQO8kOpfZ
6NgSFe3nxMi4wsDR6LlnW1gEKYe0FVOf8T41naNlgAoz507xmm9X0QFo+lUiz00lZyiETHLS
pniVk2Ds9NnZeOwbkYLekXj1QXy2MChGfzavpXzI+Zl+XYojMtnEJEDYUiL/gwEDxMSE/KnA
yMx3R0vVeXCNKA3dM3il50QjNyE0XAVrCd1yayJ5Nto2wNb7HHS6lXMo75Mse9pblm2kkLUO
E+G3o1fuLJ6jWKAUcCwy7yfQTAGFT5Rt8f7/Qn3fBAFUAY8ScA7OXuHupkC0QqCxohLTuewD
AgMBAAGjLTArMBsGA1UdEQQUMBKBEHNhYmFpbmlAaW5vZGUuYXQwDAYDVR0TAQH/BAIwADAN
BgkqhkiG9w0BAQQFAAOBgQCOSrsA13Mj2nKj8xDp+gVRnz2wGPlXwgSUCDib6rk/gSL/go1C
Xq0X2+H1TSzg5cd6Iad39PzNxUQqBxD3k4X5tqgnikwcNOjaufFO6gxG42kEiEentqFCm8yw
8k6BFa+WFaGSRgAyJ/HXn0SvIEb5lf850aScgo/GsmDMPvPuBjCCAxcwggKAoAMCAQICAwlZ
hTANBgkqhkiG9w0BAQQFADCBkjELMAkGA1UEBhMCWkExFTATBgNVBAgTDFdlc3Rlcm4gQ2Fw
ZTESMBAGA1UEBxMJQ2FwZSBUb3duMQ8wDQYDVQQKEwZUaGF3dGUxHTAbBgNVBAsTFENlcnRp
ZmljYXRlIFNlcnZpY2VzMSgwJgYDVQQDEx9QZXJzb25hbCBGcmVlbWFpbCBSU0EgMjAwMC44
LjMwMB4XDTAzMDIyMTEzMTY0NloXDTA0MDIyMTEzMTY0NlowWzEQMA4GA1UEBBMHU2FiYWlu
aTEOMAwGA1UEKhMFUGV0ZXIxFjAUBgNVBAMTDVBldGVyIFNhYmFpbmkxHzAdBgkqhkiG9w0B
CQEWEHNhYmFpbmlAaW5vZGUuYXQwggEiMA0GCSqGSIb3DQEBAQUAA4IBDwAwggEKAoIBAQC1
XhEfxugiGePyj2dxvgshFABfJw+Zcfar1FrGEdmCiMdEQO8kOpfZ6NgSFe3nxMi4wsDR6Lln
W1gEKYe0FVOf8T41naNlgAoz507xmm9X0QFo+lUiz00lZyiETHLSpniVk2Ds9NnZeOwbkYLe
kXj1QXy2MChGfzavpXzI+Zl+XYojMtnEJEDYUiL/gwEDxMSE/KnAyMx3R0vVeXCNKA3dM3il
50QjNyE0XAVrCd1yayJ5Nto2wNb7HHS6lXMo75Mse9pblm2kkLUOE+G3o1fuLJ6jWKAUcCwy
7yfQTAGFT5Rt8f7/Qn3fBAFUAY8ScA7OXuHupkC0QqCxohLTuewDAgMBAAGjLTArMBsGA1Ud
EQQUMBKBEHNhYmFpbmlAaW5vZGUuYXQwDAYDVR0TAQH/BAIwADANBgkqhkiG9w0BAQQFAAOB
gQCOSrsA13Mj2nKj8xDp+gVRnz2wGPlXwgSUCDib6rk/gSL/go1CXq0X2+H1TSzg5cd6Iad3
9PzNxUQqBxD3k4X5tqgnikwcNOjaufFO6gxG42kEiEentqFCm8yw8k6BFa+WFaGSRgAyJ/HX
n0SvIEb5lf850aScgo/GsmDMPvPuBjCCAzgwggKhoAMCAQICEGZFcrfMdPXPY3ZFhNAukQEw
DQYJKoZIhvcNAQEEBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUx
EjAQBgNVBAcTCUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNV
BAsTH0NlcnRpZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQ
ZXJzb25hbCBGcmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxA
dGhhd3RlLmNvbTAeFw0wMDA4MzAwMDAwMDBaFw0wNDA4MjcyMzU5NTlaMIGSMQswCQYDVQQG
EwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xDzANBgNV
BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl
cnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjguMzAwgZ8wDQYJKoZIhvcNAQEBBQADgY0AMIGJ
AoGBAN4zMqZjxwklRT7SbngnZ4HF2ogZgpcO40QpimM1Km1wPPrcrvfudG8wvDOQf/k0caCj
bZjxw0+iZdsN+kvx1t1hpfmFzVWaNRqdknWoJ67Ycvm6AvbXsJHeHOmr4BgDqHxDQlBRh4M8
8Dm0m1SKE4f/s5udSWYALQmJ7JRr6aFpAgMBAAGjTjBMMCkGA1UdEQQiMCCkHjAcMRowGAYD
VQQDExFQcml2YXRlTGFiZWwxLTI5NzASBgNVHRMBAf8ECDAGAQH/AgEAMAsGA1UdDwQEAwIB
BjANBgkqhkiG9w0BAQQFAAOBgQAxsUtHXfkBceX1U2xdedY9mMAmE2KBIqcS+CKV6BtJtyd7
BDm6/ObyJOuR+r3sDSo491BVqGz3Da1MG7wD9LXrokefbKIMWI0xQgkRbLAaadErErJAXWr5
edDqLiXdiuT82w0fnQLzWtvKPPZE6iZph39Ins6ln+eE2MliYq0FxjGCA9UwggPRAgEBMIGa
MIGSMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBl
IFRvd24xDzANBgNVBAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMx
KDAmBgNVBAMTH1BlcnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjguMzACAwlZhTAJBgUrDgMC
GgUAoIICDzAYBgkqhkiG9w0BCQMxCwYJKoZIhvcNAQcBMBwGCSqGSIb3DQEJBTEPFw0wMzA2
MTIwNjUwMDRaMCMGCSqGSIb3DQEJBDEWBBTOWYCpIJwrRPkxEsfTLjn3zUNyiTBSBgkqhkiG
9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0DAgIBQDAH
BgUrDgMCBzANBggqhkiG9w0DAgIBKDCBqwYJKwYBBAGCNxAEMYGdMIGaMIGSMQswCQYDVQQG
EwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xDzANBgNV
BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl
cnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjguMzACAwlZhTCBrQYLKoZIhvcNAQkQAgsxgZ2g
gZowgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNh
cGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNl
czEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDCVmFMA0GCSqG
SIb3DQEBAQUABIIBACCKkF5ttFqhOEkeoIYLT1aOYiELqwfbLdS23l3qmXhXd3kcxGVZR0yL
sFiNIXhkKDm/bg8dswiE/+VMoDFWBrGrclPc0VknFxxKf5DuDyfrlYNXHNiGyBOjZLRihZpu
vNRI4UqG9vJtcY/G3TOJtMtWIz+kCH3UxsDORlqcHBmGPXh5ignGk3pz37UyLx0FNGJeoh0Z
1s1eCi/XcID4GFc32JRwxDfyki2NH3vSnXqHGzVDe4hOHD/3d4vU2W+MzgI6MKdw3RSEvnAB
DYAsoa37Aehv2Y24eYP3uB7SG5oANlCJM46qNxIoY8JOlB9BJptC1Bn3reuHF4Y802MLrLoA
AAAAAAA=
--------------ms090809020209070107070804--