Mercurial > hg > ZDBInterface

annotate ZDBInterfaceFolder.py @ 7:917e28a08c58

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
search case insensitive. max and skip options.
author casties
date Tue, 15 Feb 2011 21:14:03 +0100
parents ca30cf0e810d
children 17b19345d011
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
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
37 def getSQLQuery(self, table, argv):
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
38 """returns dict with SQL query string and args"""
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
39 logging.debug("getSQLquery table=%s argv=%s"%(table,argv))
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
40 args = []
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
41 select = "*"
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
42 order = None
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
43 wheres = []
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
44 whereOp = "AND"
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
45 done = {}
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
46 limit = None
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
47 offset = None
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
48
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
49 def doOp(op, param, val):
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
50 # handles comparison operations in WHERE clause
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
51 logging.debug("doop op=%s param=%s val=%s"%(op,param,val))
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
52 if isinstance(val, list):
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
53 # join multiple parameters with spaces (makes sense with checkbox and -op=all)
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
54 val = " ".join(val)
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
55
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
56 # string comparisons are case-insensitive
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
57 if isinstance(val, basestring):
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
58 param = "LOWER(%s)"%param
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
59 val = val.lower()
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
60
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
61 if op == "eq":
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
62 wheres.append(param + " = %s")
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
63 args.append(val)
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
64 elif op == "lt":
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
65 wheres.append(param + " < %s")
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
66 args.append(val)
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
67 elif op == "gt":
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
68 wheres.append(param + " > %s")
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
69 args.append(val)
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
70 elif op == "bw":
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
71 wheres.append(param + " ILIKE %s")
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
72 args.append("%" + val)
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
73 elif op == "ew":
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
74 wheres.append(param + " ILIKE %s")
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
75 args.append(val + "%")
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
76 elif op == "ct":
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
77 wheres.append(param + " ILIKE %s")
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
78 args.append("%" + val + "%")
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
79 elif op == "all":
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
80 words = []
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
81 for word in val.split(" "):
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
82 words.append(param + " ILIKE %s")
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
83 args.append("%" + word + "%")
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
84 wheres.append("(" + " AND ".join(words) + ")")
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
85 elif op == "one":
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
86 words = []
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
87 for word in val.split(" "):
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
88 words.append(param + " ILIKE %s")
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
89 args.append("%" + word + "%")
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
90 wheres.append("(" + " OR ".join(words) + ")")
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
91 else:
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
92 logging.error("getSQLquery: unknown op=%s!"%op)
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
93
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
94 return
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
95
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
96 # evaluate argv
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
97 for (key, val) in argv.items():
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
98 if key in done:
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
99 # parameter has been processed
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
100 continue
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
101
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
102 # beginning of a command should always be "_"
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
103 if key[0] == "-":
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
104 key = "_" + key[1:]
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
105
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
106 if key == "_select":
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
107 # SELECT expression
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
108 select = sqlName(val, more="*,")
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
109 elif key == "_sort":
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
110 # sort i.e. ORDER BY expression
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
111 order = sqlName(val, more=",")
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
112 elif key == "_lop":
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
113 # logical operation joining WHERE clauses
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
114 whereOp = sqlName(val)
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
115 elif key == "max":
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
116 # number of results
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
117 limit = sqlName(val)
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
118 elif key == "skip":
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
119 # start at result number
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
120 offset = sqlName(val)
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
121 elif key[:3] == "_op":
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
122 # operation parameters _op_param=option
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
123 param = sqlName(key[4:])
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
124 logging.debug("param=%s key=%s val=%s"%(param,key,val))
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
125 if param in argv:
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
126 doOp(val, param, argv[param])
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
127 done[param] = True
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
128 else:
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
129 # no corresponding parameter
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
130 logging.error("getSQLquery: param=%s for op not found!"%param)
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
131
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
132 # process remaining parameters (without _op)
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
133 for (key, val) in argv.items():
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
134 if key not in done and key[0] not in ("_", "-"):
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
135 param = sqlName(key)
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
136 # default is begins-with
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
137 doOp("bw", param, val)
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
138
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
139 # join it all
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
140 query = "SELECT %s FROM %s"%(select, table)
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
141 if wheres:
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
142 query += " WHERE " + (" " + whereOp + " ").join(wheres)
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
143
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
144 if order:
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
145 query += " ORDER BY " + order
7
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
146
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
147 if limit:
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
148 query += " LIMIT " + limit
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
149
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
150 if offset:
917e28a08c58 search case insensitive. max and skip options.
casties
parents: 5
diff changeset
151 query += " OFFSET " + offset
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
152
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
153 return {'query' : query, 'args' : args}
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
154
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
155 def ZDBInlineSearch(self, _table=None, **argv):
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
156 """returns result set from search"""
5
ca30cf0e810d fix bugs in ZDBInlineSearch.
root@xserve09.mpiwg-berlin.mpg.de
parents: 4
diff changeset
157 query = self.getSQLQuery(_table, argv)
4
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
158 result = self.executeZSQL(query['query'], query['args'])
0ade331198de first version of ZDBInlineSearch
casties
parents: 3
diff changeset
159 return result
3
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
160
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
161 def manage_editZDBInterfaceFolder(self, title=None, connection_id=None,
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
162 REQUEST=None):
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
163 """Change the object"""
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
164 if title is not None:
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
165 self.title = title
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
166
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
167 if connection_id is not None:
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
168 self.connection_id = connection_id
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
169
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
170 #checkPermission=getSecurityManager().checkPermission
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
171 REQUEST.RESPONSE.redirect('manage_main')
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
172
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
173
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
174 manage_addZDBInterfaceFolderForm=PageTemplateFile('zpt/addZDBInterfaceFolder',globals())
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
175
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
176 def manage_addZDBInterfaceFolder(self, id, title='', label='', description='',
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
177 createPublic=0,
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
178 createUserF=0,
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
179 REQUEST=None):
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
180 """Add a new object with id *id*."""
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
181
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
182 ob=ZDBInterfaceFolder(str(id),title)
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
183 self._setObject(id, ob)
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
184
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
185 #checkPermission=getSecurityManager().checkPermission
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
186 REQUEST.RESPONSE.redirect('manage_main')
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
187
d70e57193731 new executeZSQL method that returns Zope Results.
casties
parents:
diff changeset
188