Mercurial > hg > ZDBInterface

annotate ZDBInterfaceFolder.py @ 13:cf03ab908a2b

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