[Zope] ZSQLMethodFile?

[Peter Sabaini]

This is a cryptographically signed message in MIME format.

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

Peter Bengtsson wrote:
> Just like there's DTMLFile and PageTemplateFile, what about ZSQL 
> Methods? So that you can run ZSQL methods from the filesystem (for a 
> python product)
> 
> If not, I'll have to open my filesystem files and programmatically 
> create these objects.
> 


I usually just create ZSQL Methods as attributes of my (product) class:

import Acquisition
from Products.ZSQLMethods.SQL import SQL

class mySQLClass(Acquisition.Implicit):
     # We need Acquisition in order to find our db connection

     # a database connection with this id must exist!
     dbconnection = "the_db_connection"

     _sql_null = "select 1 as one"
     zsql_null = SQL('null',
                'A dumb zsql method for testing purposes',
                dbconnection,
                '',
                _sql_null,
                )



An instance of "mySQLClass" then could call self.zsql_null just like a 
standard ZSQL Method

For details, take a look at Products.ZSQLMethods.SQL or its superclass, 
Shared.DC.ZRDB.DA.DA

  - peter.


--------------ms000007000303020908070907
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
MTExMDIzMDBaMCMGCSqGSIb3DQEJBDEWBBTP/PiJxyiXDfNOQcRpf65EQDmurjBSBgkqhkiG
9w0BCQ8xRTBDMAoGCCqGSIb3DQMHMA4GCCqGSIb3DQMCAgIAgDANBggqhkiG9w0DAgIBQDAH
BgUrDgMCBzANBggqhkiG9w0DAgIBKDCBqwYJKwYBBAGCNxAEMYGdMIGaMIGSMQswCQYDVQQG
EwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBlMRIwEAYDVQQHEwlDYXBlIFRvd24xDzANBgNV
BAoTBlRoYXd0ZTEdMBsGA1UECxMUQ2VydGlmaWNhdGUgU2VydmljZXMxKDAmBgNVBAMTH1Bl
cnNvbmFsIEZyZWVtYWlsIFJTQSAyMDAwLjguMzACAwlZhTCBrQYLKoZIhvcNAQkQAgsxgZ2g
gZowgZIxCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcTCUNh
cGUgVG93bjEPMA0GA1UEChMGVGhhd3RlMR0wGwYDVQQLExRDZXJ0aWZpY2F0ZSBTZXJ2aWNl
czEoMCYGA1UEAxMfUGVyc29uYWwgRnJlZW1haWwgUlNBIDIwMDAuOC4zMAIDCVmFMA0GCSqG
SIb3DQEBAQUABIIBAD5lYJnd9lvO/Q511Imf4oOlsL+pjGdz0CvSiMhcKGWF4aEz5Kx7tg5t
8V6inRr6nQts7PgmCYeZ5RDLQpXMNhdrfo4JEG5oUb7sjq67fnM00AxB1aTrZvrJq9pmtXVi
4PZke6It2roGdOITRZUrZFr+xezaIY11ws8ZOiidE3gwOZGHklvz+yHe/tF+ViylO0rRN8Ix
5KAHiWfqaaXIvb5vtuCJtU2SyRCHYm14xAv1O8Zboe0vr/bTuxB9igpvyt4ob/f6itUaHflV
mVxTkyJASVtt4BmE6e5dOB7miiMggnQOoM6nTKmZ4A22d9EbsZ2JhKORQZtm9dOyEGJ6gvgA
AAAAAAA=
--------------ms000007000303020908070907--