annotate ZDBInterfaceFolder.py @ 3:d70e57193731

new executeZSQL method that returns Zope Results. new ZDBInterfaceFolder that doesn't do much yet.
author casties
date Mon, 14 Feb 2011 23:20:43 +0100
parents
children 0ade331198de
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
3
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
1 '''
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
2 Created on 14.2.2011
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
3
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
4 @author: casties
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
5 '''
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
6
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
7 from OFS.Folder import Folder
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
8 from Products.PageTemplates.PageTemplateFile import PageTemplateFile
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
9 from AccessControl import getSecurityManager, Unauthorized
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
10 import logging
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
11 import re
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
12
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
13 from DBInterface import *
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
14
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
15
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
16 class ZDBInterfaceFolder(DBInterface, Folder):
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
17 """Folder for database queries
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
18 """
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
19
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
20 meta_type="ZDBInterfaceFolder"
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
21 manage_options=Folder.manage_options+(
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
22 {'label':'Config','action':'manage_editZDBInterfaceFolderForm'},
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
23 )
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
24
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
25 # management templates
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
26 manage_editZDBInterfaceFolderForm=PageTemplateFile('zpt/editZDBInterfaceFolder',globals())
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
27
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
28
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
29 def __init__(self, id, title, connection_id=None):
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
30 """init"""
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
31 self.id = id
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
32 self.title = title
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
33 # database connection id
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
34 self.connection_id = connection_id
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
35
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
36
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
37
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
38 def manage_editZDBInterfaceFolder(self, title=None, connection_id=None,
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
39 REQUEST=None):
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
40 """Change the object"""
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
41 if title is not None:
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
42 self.title = title
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
43
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
44 if connection_id is not None:
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
45 self.connection_id = connection_id
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
46
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
47 #checkPermission=getSecurityManager().checkPermission
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
48 REQUEST.RESPONSE.redirect('manage_main')
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
49
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
50
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
51 manage_addZDBInterfaceFolderForm=PageTemplateFile('zpt/addZDBInterfaceFolder',globals())
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
52
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
53 def manage_addZDBInterfaceFolder(self, id, title='', label='', description='',
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
54 createPublic=0,
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
55 createUserF=0,
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
56 REQUEST=None):
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
57 """Add a new object with id *id*."""
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
58
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
59 ob=ZDBInterfaceFolder(str(id),title)
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
60 self._setObject(id, ob)
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
61
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
62 #checkPermission=getSecurityManager().checkPermission
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
63 REQUEST.RESPONSE.redirect('manage_main')
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
64
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
65