;ò
©"@c @ s d k l Z d k l Z d k l Z d k l Z d k Z d k Z d k Z d k
l Z d k l
Z
d k Z d „ Z d e e e f d „ ƒ YZ e d
e ƒ ƒ Z d d d e d
„ Z d S( ( s Folder( s
Persistent( s Implicit( s DTMLFileN( s libpq( s getSecurityManagerc C s | Sd S( N( s name( s name( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys quoteString s s ZSQLExtendFolderc B s t Z d Z d Z e d „ Z d „ Z d „ Z d „ Z d d „ Z e d „ Z
d „ Z d
„ Z d „ Z
d „ Z d d
e d „ Z d „ Z d d e d „ Z e d „ Z e d „ Z e d „ Z d e e e d „ Z d „ Z d „ Z d d „ Z d d „ Z d „ Z d „ Z RS( s Folders ZSQLExtendFolderc C s… | i d d j o | i d } n | i d } | o d | | i d Sn1 | i | i d ƒ } | | d <t i | d ƒ Sd S( s paths HTTP_X_FORWARDED_SERVERs s HTTP_HOSTs http://s PATH_TRANSLATEDs /i N( s selfs REQUESTs hosts urls splits temps strings join( s selfs urls hosts temp( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
actualPath s
c C s | i Sd S( s requestN( s selfs REQUEST( s self( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
getRequest# s c C s t i i | ƒ d d Sd S( s oinly for demoi s .jpgN( s oss paths splitext( s selfs path( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys lowerEnd' s c C s- | o d Sn | d j o d Sn d Sd S( s Teste ob Treffer leeri s i N( s field( s selfs field( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLisEmpty+ s
s c C s d | } | Sd S( s( return HTML Fragment with search optionssX <select name="-op_%s">
<option value="bw">begins with</option> <!-- begins with / beginnt mit, "Wort*" -->
<option value="ew">ends with</option>
<option value="ct" selected>contains</option> <!-- contains / enthaellt, "Wort" -->
<option value="eq">equals</option> <!-- equals / ist, =Wort -->
</select>N( s fieldnames ret( s selfs fieldnames ret( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLsearchOptions4 s
c K s| g } | o n d } x< | i ƒ D]. } | i | d t i t | | ƒ ƒ ƒ q$ W| i
t i | d ƒ d d | ƒSd S( s inlinesearchs
foundCounts =s ,s _s storenameN(
s qss storenames argvs keyss as appends urllibs quotes strs selfs parseQueryStrings strings join( s selfs storenames argvs as qs( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLInlineSearch? s
,c C s g } | i d | ƒ Sd S( s inlinesearchs varN( s qss selfs searchs query( s selfs querys qs( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLInlineSearch2O s c C s | i d } h }
xü | i d ƒ D]ë } t i d d | i d ƒ d i ƒ ƒ } | i d ƒ d } t i d d | ƒ } t i | ƒ } | d j o t i | ƒ }
q# | d
j o t i | ƒ } q# | d d j o t | ƒ d j o t i | ƒ |
t i | ƒ <q# q# Wg } g } xC |
i ƒ D]5 } | i d | d ƒ | i t i |
| ƒ ƒ q+Wt i | d
ƒ } t i | d
ƒ } d |
| | f } | i d | ƒ | i i i | ƒ Sd S( s
Neuer Eintrags QUERY_STRINGs &s r'+'s s =i i s \+s -tables -formats -s "s ,s INSERT INTO %s (%s) VALUES (%s)s varN( s selfs REQUESTs qss addLists splits qs res subs lowers names values urllibs unquotes tables formats lens keyLists valueLists keyss xs appends libpqs
PgQuoteStrings strings joins keyStrings valueStrings queryStrings searchs RESPONSEs redirect( s selfs xs qss names formats keyStrings queryStrings values qs valueLists tables keyLists valueStrings addList( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLAddY s4
(
&$
c K s g } xH | i i i ƒ D]4 } | i | d t i t | i i | ƒ ƒ ƒ q Wt
i | d ƒ } g } xe| i d ƒ D]T} t i t i d d | i d ƒ d i ƒ ƒ ƒ }
| i d ƒ d } t i d d | ƒ } t i | ƒ } |
d j o t i | ƒ } qy |
d j oD t i | ƒ }
|
i d ƒ d d t i |
i d ƒ d ƒ }
qy |
d
j o t i | ƒ } qy |
d d j o t | ƒ d j o/ | i d |
d
t i t i | ƒ ƒ ƒ qy qy Wt
i | d ƒ } d | | |
f } | i d | ƒ | i i i | ƒ Sd S( s Ändern von Einträgens =s &s r'+'s i i s \+s -tables -identifys -formats -s "s "=s ,s UPDATE %s SET %s WHERE %ss varN(! s qs_temps selfs REQUESTs forms keyss as appends urllibs quotes strs strings joins qss
changeLists splits qs unquotes res subs lowers names values tables identifys libpqs
PgQuoteStrings formats lens changeStrings queryStrings searchs RESPONSEs redirect( s selfs argvs as values qss formats changeStrings queryStrings qs qs_temps identifys tables
changeLists name( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
ZSQLChangev s4 2 1
5
&3c C sÇ | i d } g } xe| i d ƒ D]T} t i t i d d | i d ƒ d i
ƒ ƒ ƒ } | i d ƒ d } t i d d | ƒ } t i | ƒ } | d j o t i | ƒ }
q# | d
j oD t i | ƒ } | i d ƒ d d t i | i d ƒ d ƒ } q# | d j o t i | ƒ } q# | d d j o t | ƒ d j o/ | i d
| d t i t i | ƒ ƒ ƒ q# q# Wt i | d ƒ } d |
| | f } | i d | ƒ | i i i | ƒ Sd S( s Ändern von Einträgens QUERY_STRINGs &s r'+'s s =i i s \+s -tables -identifys -formats -s "s "=s ,s UPDATE %s SET %s WHERE %ss varN( s selfs REQUESTs qss
changeLists splits qs urllibs unquotes res subs lowers names values tables identifys libpqs
PgQuoteStrings formats lens appends strings joins changeStrings queryStrings searchs RESPONSEs redirect( s selfs qss names formats
changeLists changeStrings queryStrings qs identifys values table( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLChange_old˜ s,
1
5
&3s oid,*c C sÈ | d j oN | i d o, | i d } t i | i d ƒ d ƒ } qv | i i d } n t i | i d ƒ d ƒ } t i d d | ƒ } | o n d } | i
| d d
| d d d
| ƒ} | Sd S( s Finds s QUERY_STRINGs &s ,s querys \+s s
foundCounts -s selects storemaxs yess storenameN(
s qss selfs REQUESTs strings joins splits SESSIONs res subs storenames parseQueryStrings selects ret( s selfs qss selects storenames ret( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLFind± s
$c C s t | ƒ Sd S( N( s lens var( s selfs var( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLFoundCountLenÎ s s *c C s' | o n d } | i i | d Sd S( Ns
foundCounts count( s storenames selfs REQUESTs SESSION( s selfs qss selects storename( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLFoundCountÑ s c C s' | o n d } | i i | d Sd S( Ns
foundCounts
rangeStart( s storenames selfs REQUESTs SESSION( s selfs storename( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLRangeStartè s c C s' | o n d } | i i | d Sd S( Ns
foundCounts rangeSize( s storenames selfs REQUESTs SESSION( s selfs storename( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
ZSQLRangeSizeñ s c C s' | o n d } | i i | d Sd S( Ns
foundCounts rangeEnd( s storenames selfs REQUESTs SESSION( s selfs storename( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLRangeEndú s s noc C s d }
d } g } d } d } h } d } d } | o
d } n | i
d ƒ } xˆ | D]€ } t
i d d | i
d
ƒ d i ƒ ƒ } t i | i
d
ƒ d ƒ } | d d !| d
j o | } | d } | | | <qX qX Wx9| i
d ƒ D](} t
i d d | i
d
ƒ d i ƒ ƒ } t i | i
d
ƒ d ƒ } | | d j o
| }
qì | | d j o
| }
qì | | d j o
| } qì | | d j o d t | ƒ } t | ƒ } qì | | d j o d t | ƒ } t | ƒ } qì | | d j o | i | ƒ qì | | d j o d | } qì | | d j o& | d j o | | i i d <qqì | | d
j o
| } qì | d | j o t | ƒ d j or| i ƒ } | i | ƒ o | | } n d } d | d } | d j o* | i | d t i! d | d ƒ ƒ nô | d j o" | i | d! t i! | ƒ ƒ nÅ | d" j o" | i | d# t i! | ƒ ƒ n– | d$ j o" | i | d
t i! | ƒ ƒ ng | d j o& | i | d t i! | d ƒ ƒ n4 | d% j o& | i | d t i! d | ƒ ƒ n d } qì qì Wt | ƒ d j o" d& t" i# | d |
d ƒ } n d } d' | |
| | | | f } | d j o | | i i d( <n | ord) |
| f } | i i i | ƒ o h | i i | <n | i i | i d* ƒ o_ | i i | d* | j o? | | i i | d* <| i( d+ | ƒ d i) | i i | d, <q‡n< | | i i | d* <| i( d+ | ƒ d i) | i i | d, <| | i i | d- <| d. j o& | i i | d, | i i | d/ <n% t* | ƒ t* | ƒ | i i | d/ <| | i i | d0 <n | i( d+ | ƒ Sd1 S(2 s analysieren den QueryStrings ANDs ALLs s bwi s oid,*s ,s r'+'s s =i i s opi s lops tables selects maxs LIMIT s skips OFFSET s joins sorts ORDER BY s tokens yess cts LOWER(s )s LIKE s %s gts >s lts <s eqs ews WHERE s SELECT %s FROM %s %s %s %s %ss qss SELECT count(*) FROM %s %ss queryString2s vars counts
rangeStarts alls rangeEnds rangeSizeN(+ s lops maxs whereLists sorts ops opfieldss skips
rangeStarts selects qss splits splitteds qs res subs lowers names urllibs unquotes values iCTs fields tables strs limits appends nostores selfs REQUESTs SESSIONs lens has_keys libpqs
PgQuoteStrings strings joins wheres querys storenames query2s searchs counts int( s selfs qss iCTs storemaxs selects nostores storenames skips opfieldss querys tables
rangeStarts fields lops sorts whereLists maxs query2s names values qs limits splitteds wheres op( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys parseQueryString s¬
(
(
&
*
"
"
"
&
&" /'
&$c C s» | i d } | i d ƒ } xP | D]H } | i d ƒ } y) | d i ƒ d j o | d } n Wq# q# Xq# Wt i
| i d i d ƒ d ƒ | i i d <| i i i
t i | ƒ ƒ Sd S(
s
To be dones QUERY_STRINGs &s =i s -formati s ,s queryN( s selfs REQUESTs rqs splits queryss querytemps querys lowers
formatfiles strings joins SESSIONs RESPONSEs redirects urllibs unquote( s selfs queryss rqs
formatfiles querys querytemp( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
ZSQLSearch‰ s
,c C s y t | ƒ SWn d Sn Xd S( Ni ( s ints string( s selfs string( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLint› s s
foundCountc C s¹ y< | i i | d } t | i i | d ƒ t | ƒ }
Wn d } d }
n X|
| i i | d j o | i i | d d }
n | i d d j o& | i i d } t i | d ƒ } n | i d } t i | d
ƒ } g } d } xn | D]f } | d d j o d | d <n | i d
ƒ d i ƒ d j o d } d |
} n | i | ƒ qõ W| d j o d |
} | i | ƒ n t i | d
ƒ } d | i ƒ d | | f Sd S( s nextLinks rangeSizes
rangeStarti s counti
s QUERY_STRINGs s querys ,s &s _s -s =s -skipi s -skip=%is <a href='%s'>%s</a>s ?N( s selfs REQUESTs SESSIONs storenames limits ints
newRangeStarts qss strings splits queriess newquerys skipFounds querys lowers appends joins newquerystrings
actualPaths html( s selfs htmls storenames qss newquerystrings limits newquerys queriess querys skipFounds
newRangeStart( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys nextLink¢ s: (
c C s™ y< | i i | d } t | i i | d ƒ t | ƒ }
Wn d } d }
n X|
d j o
d }
n | i d d j o& | i i d } t i | d ƒ } n | i d } t i | d ƒ } g } d } xn | D]f } | d d j o d
| d <n | i d ƒ d i ƒ d j o d
|
} d } n | i | ƒ qÕ W| d j o d
|
} | i | ƒ n t i | d ƒ } d | i ƒ d | | f Sd S( s prev links rangeSizes
rangeStarti s QUERY_STRINGs s querys ,s &s _s -s =s -skips -skip=%ii s <a href='%s'>%s</a>s ?N( s selfs REQUESTs SESSIONs storenames limits ints
newRangeStarts qss strings splits queriess newquerys skipFounds querys lowers appends joins newquerystrings
actualPaths html( s selfs htmls storenames qss newquerystrings limits newquerys queriess querys skipFounds
newRangeStart( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys prevLinkÓ s: (
c
C sb | i d d j o | i i d } n | i d } t i d | i ƒ ƒ } t i d | i ƒ ƒ } | o
d } n( t
| ƒ | } | d j o
d } n t i | d ƒ } g } | ob x‚ | D]S } | i d ƒ d i ƒ d j o d
| } n | i | ƒ t i | d ƒ } qÄ Wn$ | i d
| ƒ t i | d ƒ } d | i ƒ d
| | f Sd S( s prev links QUERY_STRINGs s querys max\=(.*)\,s offset\=(.*)\,i s ,s =s offsets
-offset=%is &s <a href='%s'>%s</a>s ?N( s selfs REQUESTs SESSIONs qss res searchs lowers maxs offsets offsetnews ints strings splits queriess newquerys querys appends joins newquerystrings
actualPaths html(
s selfs htmls qss newquerystrings offsetnews maxs queriess offsets querys newquery( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys prevLink_old s.
c
C sh | i d d j o | i i d } n | i d } t i d | i ƒ ƒ } t i d | i ƒ ƒ } | o
d } n. t
| ƒ t
| ƒ } | d j o
d } n t i | d ƒ } g } | ob x‚ | D]S } | i d ƒ d i ƒ d
j o d | } n | i | ƒ t i | d ƒ } qÊ Wn$ | i d | ƒ t i | d ƒ } d
| i ƒ d | | f Sd S( s prev links QUERY_STRINGs s querys max\=(.*)\,s offset\=(.*)\,i i s ,s =s -offsets
-offset=%is &s <a href='%s'>%s</a>s ?N( s selfs REQUESTs SESSIONs qss res searchs lowers maxs offsets offsetnews ints strings splits queriess newquerys querys appends joins newquerystrings
actualPaths html(
s selfs htmls qss newquerystrings offsetnews maxs queriess offsets querys newquery( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys nextLink_old# s.
( s __name__s
__module__s __doc__s meta_types Nones
actualPaths
getRequests lowerEnds ZSQLisEmptys ZSQLsearchOptionss ZSQLInlineSearchs ZSQLInlineSearch2s ZSQLAdds
ZSQLChanges ZSQLChange_olds ZSQLFinds ZSQLFoundCountLens ZSQLFoundCounts ZSQLRangeStarts
ZSQLRangeSizes ZSQLRangeEnds parseQueryStrings
ZSQLSearchs ZSQLints nextLinks prevLinks prevLink_olds nextLink_old( ( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLExtendFolder s2
" † 1 5 s ZSQLExtendFolderAdds i c C sð t ƒ } t | ƒ | _ | | _ | i | | ƒ | i | ƒ } t ƒ i } | o, | d | ƒ o
t d ‚ n | i ƒ n | o? | d | ƒ o
t d ‚ n | i d i d d d d ƒ n | t j o | i | | d
d ƒSn d S(
sÜ Add a new Folder object with id *id*.
If the 'createPublic' and 'createUserF' parameters are set to any true
value, an 'index_html' and a 'UserFolder' objects are created respectively
in the new folder.
s Add User Folderss+ You are not authorized to add User Folders.s Add Page Templatess- You are not authorized to add Page Templates.s
PageTemplatess ids
index_htmls titles s update_menui N( s ZSQLExtendFolders obs strs ids titles selfs
_setObjects _getObs getSecurityManagers checkPermissions createUserFs Unauthorizeds manage_addUserFolders createPublics manage_addProducts manage_addPageTemplates REQUESTs Nones manage_main( s selfs ids titles createPublics createUserFs REQUESTs obs checkPermission( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys manage_addZSQLExtendFolderD s"
!
( s
OFS.Folders Folders Globalss
Persistents Acquisitions Implicits DTMLFiles urllibs res strings pyPgSQLs libpqs
AccessControls getSecurityManagers os.paths oss quoteStrings ZSQLExtendFolders globalss manage_addZSQLExtendFolderForms Nones manage_addZSQLExtendFolder( s ZSQLExtendFolders manage_addZSQLExtendFolders strings manage_addZSQLExtendFolderForms libpqs quoteStrings
Persistents urllibs DTMLFiles res getSecurityManagers Folders oss Implicit( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ? s
ÿ ÿ 3
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>
![[BACK]](/cvs/cvsweb/icons/back.gif){kind=icon}
Return to ZSQLExtend.pyc CVS log ![[TXT]](/cvs/cvsweb/icons/text.gif){kind=icon}
![[DIR]](/cvs/cvsweb/icons/dir.gif){kind=icon}
Up to [Repository] / ZSQLExtend