;ò
:g*@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 sF t Z d Z d Z d 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 d „ Z d d „ Z d „ Z d! „ Z RS(" s Folders ZSQLExtendFolders c C s0 d G| GHy | t | | ƒ SWn d Sn Xd S( s get Attribute or emptystrings objs N( s objs prefs getattrs atribute( s selfs objs atributes pref( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
getSAttribute s c C s | o | Sn d Sd S( s make none to empty strings N( s str( s selfs str( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys getS s c 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
getRequest3 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 lowerEnd7 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
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 ZSQLsearchOptionsD 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 ZSQLInlineSearchO 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 ZSQLInlineSearch2_ 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 ZSQLAddi 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
ZSQLChange† 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 sS d } d } d } g } d } d } h } d } d }
d } h } | 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 } | | | <qj qj WxC| i
d ƒ D]2} 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 <q0qþ | | d
j o
| } qþ | d | j o t | ƒ d j o|| 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 | o†d) |
| 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 <| | i i | d1 <n | GH| i* d+ | ƒ Sd2 S(3 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 rangeSizes searchFieldsN(- s lops maxs maxstrs whereLists sorts ops opfieldss skips
rangeStarts limits searchFieldss selects qss splits splitteds qs res subs lowers names urllibs unquotes values iCTs fields tables strs 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 fields maxstrs
rangeStarts lops searchFieldss 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 s5 | i i | d i ƒ GH| i i | d i ƒ Sd S( s get searchfieldLists searchFieldsN( s selfs REQUESTs SESSIONs storenames keys( s selfs storename( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys getZSQLSearchFieldsListº s c C s- d G| i i | d GH| i i | d Sd S( s get searchfields SFs searchFieldsN( s selfs REQUESTs SESSIONs storename( s selfs storename( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys getZSQLSearchFields¿ s c 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_oldF s.
( s __name__s
__module__s __doc__s meta_types
getSAttributes getSs Nones
actualPaths
getRequests lowerEnds ZSQLisEmptys ZSQLsearchOptionss ZSQLInlineSearchs ZSQLInlineSearch2s ZSQLAdds
ZSQLChanges ZSQLChange_olds ZSQLFinds ZSQLFoundCountLens ZSQLFoundCounts ZSQLRangeStarts
ZSQLRangeSizes ZSQLRangeEnds parseQueryStrings
ZSQLSearchs ZSQLints getZSQLSearchFieldsLists getZSQLSearchFieldss nextLinks prevLinks prevLink_olds nextLink_old( ( ( sP /Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys ZSQLExtendFolder s:
" Ž 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_addZSQLExtendFolderg 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
ÿ ÿ V
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