[BACK]Return to ZSQLExtend.pyc CVS log [TXT] [DIR] Up to [Repository] / ZSQLExtend

Annotation of ZSQLExtend/ZSQLExtend.pyc, revision 1.1

1.1     ! dwinter     1: ;ò
        !             2: ©"@c@sÂdkl&Z&&d&klZ&dklZ&dklZ&dkZdkZdk   Z  dk
        !             3: lZ&dkl
Z
&dkZd„Zdeee&fd    „ƒYZed
        !             4: eƒƒZddded
„ZdS((&sFolder(&s
        !             5: Persistent(&sImplicit(&sDTMLFileN(&slibpq(&sgetSecurityManagerc&&&Cs|SdS(&N(&sname(&sname((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysquoteStringssZSQLExtendFoldercBs&tZ&dZd&Zed„&Zd„Zd„Zd„Zdd„&Z  ed„&Z
        !             6: d „Zd
        !             7: „Zd„Z
d„Zdd
ed„Zd„Zdded„Zed„&Zed„&Zed„&Zdeeed„Zd„Zd„Zdd„&Zdd„&Zd„Zd„ZRS(sFoldersZSQLExtendFoldercCs…|i&d&djo&|i&d}n&|i&d&}|&o&d||i&dSn1&|i&|&idƒ&}||d<ti|dƒSdS( spathsHTTP_X_FORWARDED_SERVERss  HTTP_HOSTshttp://sPATH_TRANSLATEDs&/iN(sselfsREQUESTshostsurlssplitstempsstringsjoin(sselfsurlshoststemp((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
        !             8: actualPaths&&
&&&
        !             9: &c&&&Cs|i&Sd&S(srequestN(sselfsREQUEST(&sself((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
        !            10: getRequest#s&&cCsti&i|&ƒ&d&dSdS(soinly for demois.jpgN(sosspathssplitext(sselfspath((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pyslowerEnd's&&cCs-|&o&d&Sn&&|&djo&d&Sn&&dSdS(sTeste ob Treffer leeri&siN(&sfield(sselfsfield((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLisEmpty+s&&&
&&scCsd&|&}|SdS(s(return HTML Fragment with search optionssX&<select name="-op_%s">
        !            11:    <option value="bw">begins with</option>             <!-- begins with / beginnt mit, "Wort*" -->
        !            12:    <option value="ew">ends with</option>
        !            13:        <option value="ct" selected>contains</option>               <!-- contains / enthaellt, "Wort" -->
        !            14:     <option value="eq">equals</option>                 <!-- equals / ist, =Wort -->
        !            15: </select>N(s   fieldnamesret(sselfs fieldnamesret((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLsearchOptions4s&
        !            16: cKs|g}|&o&n&d&}&x<|iƒD].}|i|dtit||ƒ&ƒ&ƒ&&q$W|i
        !            17: ti|dƒdd|&ƒ&SdS(sinlinesearchs
        !            18: foundCounts&=s&,s&_s   storenameN(
sqss  storenamesargvskeyss&asappendsurllibsquotesstrsselfsparseQueryStringsstringsjoin(sselfs   storenamesargvs&asqs((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLInlineSearch?s&&&&
&,cCsg}|id&|&ƒ&SdS(sinlinesearchsvarN(sqssselfssearchsquery(sselfsquerysqs((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLInlineSearch2Os&&c&CsÂ&|i&d&}h}
xü|idƒ&D]ë}tidd|idƒ&diƒƒ}|idƒ&d}tidd|ƒ}ti|ƒ&}|d jo&ti|ƒ&}
        !            19: q#&|d
        !            20: jo&ti|ƒ&}q#&|ddjo&t|ƒ&djo &ti|ƒ&|
ti|ƒ&<q#&q#Wg}g}    xC|
iƒD]5}&|id|&dƒ&&|  iti|
|&ƒ&ƒ&&q+&Wti|d
ƒ}ti|   d
ƒ}d|
        !            21: ||f}|id|ƒ&&|i&ii|ƒ&SdS(s
Neuer EintragsQUERY_STRINGs&&sr'+'s& s&=ii&s\+s-tables-formats&-s&"s&,sINSERT INTO %s (%s) VALUES (%s)svarN(sselfsREQUESTsqssaddListssplits&qsressubslowersnamesvaluesurllibsunquotestablesformatslenskeyLists  valueListskeyss&xsappendslibpqs
PgQuoteStringsstringsjoins keyStringsvalueStringsqueryStringssearchsRESPONSEsredirect(sselfs&xsqssnamesformats   keyStringsqueryStringsvalues&qs   valueListstableskeyListsvalueStringsaddList((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLAddYs4&&
&&&(&&&&
&&
&&&&$&&
&&&&&c&Ksg}    xH|iiiƒD]4}| i|d&tit  |ii|ƒ&ƒ&ƒ&&qWt
        !            22: i|  dƒ}g}xe&|idƒ&D]T&}titidd|id&ƒ&diƒƒƒ&}
|id&ƒ&d}tidd|ƒ}ti|ƒ&}|
djo&ti|ƒ&}qy&|
d  joD&ti|ƒ&}
        !            23: |
        !            24: id&ƒ&dd&ti|
        !            25: id&ƒ&dƒ&}
        !            26: qy&|
d
        !            27: jo&ti|ƒ&}qy&|
ddjo&t|ƒ&djo/&|id|
d
titi|ƒ&ƒ&ƒ&&qy&qyWt
        !            28: i|dƒ}d|||
        !            29: f}|id|ƒ&&|iii |ƒ&SdS(sÄndern von Einträgens&=s&&sr'+'s& ii&s\+s-tables  -identifys-formats&-s&"s"=s&,sUPDATE %s SET %s WHERE %ssvarN(!sqs_tempsselfsREQUESTsformskeyss&asappendsurllibsquotesstrsstringsjoinsqss
        !            30: changeListssplits&qsunquotesressubslowersnamesvaluestablesidentifyslibpqs
PgQuoteStringsformatslenschangeStringsqueryStringssearchsRESPONSEsredirect(sselfsargvs&asvaluesqssformatschangeStringsqueryStrings&qsqs_tempsidentifystables
        !            31: changeListsname((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
        !            32: ZSQLChangevs4&&2&&1&&&&
&&
&&5&
&&&&3&&&&c&CsÇ&|i&d&}&g}xe&|&idƒ&D]T&}titi    dd|idƒ&di
        !            33: ƒƒƒ&}|idƒ&d} ti   dd|    ƒ}   ti|    ƒ&}   |d   jo&ti| ƒ&}
        !            34: q#&|d
        !            35: joD&ti|    ƒ&}|idƒ&ddti|idƒ&dƒ&}q#&|djo&ti|    ƒ&}q#&|ddjo&t|   ƒ&djo/&|id
|dtiti|   ƒ&ƒ&ƒ&&q#&q#Wti|dƒ}d|
        !            36: ||f}|id|ƒ&&|i&ii|ƒ&SdS(sÄndern von EinträgensQUERY_STRINGs&&sr'+'s& s&=ii&s\+s-tables   -identifys-formats&-s&"s"=s&,sUPDATE %s SET %s WHERE %ssvarN(sselfsREQUESTsqss
        !            37: changeListssplits&qsurllibsunquotesressubslowersnamesvaluestablesidentifyslibpqs
PgQuoteStringsformatslensappendsstringsjoinschangeStringsqueryStringssearchsRESPONSEsredirect(sselfsqssnamesformats
        !            38: changeListschangeStringsqueryStrings&qsidentifysvaluestable((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLChange_old˜s,&&
&&1&&&&
&&
&&5&
&&&&3&&&&soid,*c    CsÈ|&d&joN&|ido,&|id}&ti|&idƒ&dƒ}&qv&|iid}&n&ti|&idƒ&dƒ}&tidd|&ƒ}&|o&n&d}|i
        !            39: |&d  d
        !            40: |ddd
|ƒ}|SdS(sFindssQUERY_STRINGs&&s&,squerys\+s& s
        !            41: foundCounts&-sselectsstoremaxsyess   storenameN(
sqssselfsREQUESTsstringsjoinssplitsSESSIONsressubs    storenamesparseQueryStringsselectsret(sselfsqssselects   storenamesret((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLFind±s&
&&
&$cCst|&ƒ&SdS(&N(slensvar(sselfsvar((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLFoundCountLenÎs&s&*cCs'|o&n&d&}|ii|dSdS(Ns
        !            42: foundCountscount(s  storenamesselfsREQUESTsSESSION(sselfsqssselects  storename((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLFoundCountÑs&cCs'|&o&n&d&}&|ii|&dSdS(Ns
        !            43: foundCounts
        !            44: rangeStart(s    storenamesselfsREQUESTsSESSION(sselfs    storename((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLRangeStartès&cCs'|&o&n&d&}&|ii|&dSdS(Ns
        !            45: foundCounts rangeSize(s  storenamesselfsREQUESTsSESSION(sselfs    storename((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
ZSQLRangeSizeñs&cCs'|&o&n&d&}&|ii|&dSdS(Ns
        !            46: foundCountsrangeEnd(s   storenamesselfsREQUESTsSESSION(sselfs    storename((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLRangeEndús&snocCsd&}
d}g}d}d}h}d}d}|o
        !            47: &d}n&&|&i
        !            48: dƒ&}xˆ|D]€}t
idd  |i
        !            49: d
        !            50: ƒ&diƒƒ}ti|i
        !            51: d
        !            52: ƒ&dƒ&}|dd!|d
jo&|}|d}|||<qX&qXWx9|&i
        !            53: dƒ&D](}t
idd   |i
        !            54: d
        !            55: ƒ&diƒƒ}ti|i
        !            56: d
        !            57: ƒ&dƒ&}||djo
        !            58: &|}
qì&||djo
        !            59: &|}
        !            60: qì&||djo
        !            61: &|}qì&||djo &dt|ƒ&}t|ƒ&}qì&||djo &dt|ƒ&}t|ƒ&}qì&||djo&|i|ƒ&&qì&||djo&d|}qì&||djo&&|djo&||iid<q&qì&||d
jo
        !            62: &|}qì&|d|jo&t|ƒ&djor&&|iƒ}|i|ƒ&o&||}n&d}d|d}|djo*&|i|dt i!d|dƒ&ƒ&&nô&|d jo"&|i|d!t i!|ƒ&ƒ&&nÅ&|d"jo"&|i|d#t i!|ƒ&ƒ&&n–&|d$jo"&|i|d
        !            63: t i!|ƒ&ƒ&&ng&|djo&&|i|dt i!|dƒ&ƒ&&n4&|d%jo&&|i|dt i!d|ƒ&ƒ&&n&&d}qì&qìWt|ƒ&djo"&d&t"i#|d    |
d  ƒ}n&d}d'||
        !            64: ||||f} |djo&||iid(<n&&|or&&d)|
        !            65: |f}|iii|ƒ&o&h|ii|<n&&|ii|id*ƒ&o_&|ii|d*|jo?&||ii|d*<|i(d+|ƒ&di)|ii|d,<q‡&n<&||ii|d*<|i(d+|ƒ&di)|ii|d,<||ii|d-<|d.jo&&|ii|d,|ii|d/<n%&t*|ƒ&t*|ƒ&|ii|d/<||ii|d0<n&&|i(d+|    ƒ&Sd1S(2sanalysieren den QueryStringsANDsALLssbwisoid,*s&,sr'+'s& s&=i&isopislopstablesselectsmaxsLIMIT sskipsOFFSET sjoinssorts  ORDER BY stokensyessctsLOWER(s&)s LIKE s&%sgts&>slts&<seqsewsWHERE sSELECT %s FROM %s %s %s %s %ssqssSELECT count(*) FROM %s %ssqueryString2svarscounts
        !            66: rangeStartsallsrangeEnds    rangeSizeN(+slopsmaxs whereListssortsopsopfieldssskips
        !            67: rangeStartsselectsqsssplitssplitteds&qsressubslowersnamesurllibsunquotesvaluesiCTsfieldstablesstrslimitsappendsnostoresselfsREQUESTsSESSIONslenshas_keyslibpqs
PgQuoteStringsstringsjoinswheresquerys storenamesquery2ssearchscountsint(sselfsqssiCTsstoremaxsselectsnostores  storenamesskipsopfieldssquerystables
        !            68: rangeStartsfieldslopssorts  whereListsmaxsquery2snamesvalues&qslimitssplittedswheresop((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysparseQueryString&s¬&&&&&&&&&
        !            69: (&&&
        !            70: &(&&
        !            71: &&
        !            72: &&
        !            73: &&&&&&&&&&&&&&
        !            74: &&&&&
&*&
&"&
&"&
&"&
&&&
&&&&"&&&&&/&'&
&&$&c&Cs»|i&d&}|idƒ&}&xP|&D]H}|idƒ&}y)|diƒdjo&|d}n&&Wq#&&&q#Xq#Wt    i
        !            75: |i&d&idƒ&dƒ|i&id<|i&ii
ti|ƒ&ƒ&Sd   S(
        !            76: s
        !            77: To be donesQUERY_STRINGs&&s&=is-formati&s&,squeryN(sselfsREQUESTsrqssplitsqueryss   querytempsqueryslowers
        !            78: formatfilesstringsjoinsSESSIONsRESPONSEsredirectsurllibsunquote(sselfsqueryssrqs
        !            79: formatfilesquerys   querytemp((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys
        !            80: ZSQLSearch‰&s&&
&&&&&&&,&cCs yt|&ƒ&SWn&&&d&Sn&XdS(Ni(sintsstring(sselfsstring((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLint›&s&&&s
        !            81: foundCountcCs¹&y<|i&i|d&}t|i&i|dƒ&t|ƒ&}
        !            82: Wn&&&d}d}
        !            83: n&X|
        !            84: |i&i|djo&|i&i|dd}
        !            85: n&&|i&ddjo&&|i&id}ti  |d   ƒ}n &|i&d}ti    |d
        !            86: ƒ}g}d}  xn|D]f}|ddjo&d|d<n&&|i   d
ƒ&diƒdjo&d} d|
        !            87: }n&&|i|ƒ&&qõW|    djo&d|
        !            88: }|i|ƒ&&n&&ti|d
        !            89: ƒ}d|iƒd||&fSdS(snextLinks rangeSizes
        !            90: rangeStartiscounti
        !            91: sQUERY_STRINGssquerys&,s&&s&_s&-s&=s-skipi&s-skip=%is<a href='%s'>%s</a>s&?N(sselfsREQUESTsSESSIONs    storenameslimitsints
newRangeStartsqssstringssplitsqueriessnewquerys  skipFoundsqueryslowersappendsjoinsnewquerystrings
        !            92: actualPathshtml(sselfshtmls storenamesqssnewquerystringslimitsnewquerysqueriessquerys    skipFounds
newRangeStart((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysnextLink¢&s:&&&&(&&&
        !            93: &&
& &&&
&
        !            94: &cCs™&y<|i&i|d&}t|i&i|dƒ&t|ƒ&}
        !            95: Wn&&&d}d}
        !            96: n&X|
        !            97: djo
        !            98: &d}
        !            99: n&&|i&ddjo&&|i&id}ti  |dƒ}n &|i&d}ti  |dƒ}g}d} xn|D]f}|dd  jo&d
        !           100: |d<n&&|i   dƒ&diƒdjo&d
|
        !           101: }d}  n&&|i|ƒ&&qÕW| djo&d
|
        !           102: }|i|ƒ&&n&&ti|dƒ}d|iƒd||&fSdS(s prev links   rangeSizes
        !           103: rangeStartisQUERY_STRINGssquerys&,s&&s&_s&-s&=s-skips-skip=%ii&s<a href='%s'>%s</a>s&?N(sselfsREQUESTsSESSIONs storenameslimitsints
newRangeStartsqssstringssplitsqueriessnewquerys  skipFoundsqueryslowersappendsjoinsnewquerystrings
        !           104: actualPathshtml(sselfshtmls storenamesqssnewquerystringslimitsnewquerysqueriessquerys    skipFounds
newRangeStart((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysprevLinkÓ&s:&&&&(&&&
        !           105: 
&
        !           106: &
& 
        !           107: &
        !           108: &
&
        !           109: &c
        !           110: Csb&|i&d&djo&|i&id}n&|i&d&}tid|iƒƒ}tid|iƒƒ}|o
        !           111: &d}n(&t
        !           112: |ƒ&|}|djo
        !           113: &d}n&&ti|dƒ}g} |ob&x‚|D]S}|idƒ&diƒd    jo&d
        !           114: |}n&&|  i|ƒ&&ti|  dƒ}qÄWn$&|id
        !           115: |ƒ&&ti|dƒ}d|iƒd
||&fSdS(s  prev linksQUERY_STRINGssquerysmax\=(.*)\,soffset\=(.*)\,is&,s&=soffsets
        !           116: -offset=%is&&s<a href='%s'>%s</a>s&?N(sselfsREQUESTsSESSIONsqssressearchslowersmaxsoffsets    offsetnewsintsstringssplitsqueriessnewquerysquerysappendsjoinsnewquerystrings
        !           117: actualPathshtml(
        !           118: sselfshtmlsqssnewquerystrings   offsetnewsmaxsqueriessoffsetsquerysnewquery((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysprevLink_olds.&&&
&&&&
        !           119: &
&
        !           120: &&&&& &&
&&&c
        !           121: Csh&|i&d&djo&|i&id}n&|i&d&}tid|iƒƒ}tid|iƒƒ}|o
        !           122: &d}n.&t
        !           123: |ƒ&t
        !           124: |ƒ&}|djo
        !           125: &d}n&&ti|dƒ}g} |ob&x‚|D]S}|id    ƒ&diƒd
        !           126: jo&d|}n&&|    i|ƒ&&ti|  dƒ}qÊWn$&|id|ƒ&&ti|dƒ}d
|iƒd||&fSdS(s prev linksQUERY_STRINGssquerysmax\=(.*)\,soffset\=(.*)\,i&is&,s&=s-offsets
        !           127: -offset=%is&&s<a href='%s'>%s</a>s&?N(sselfsREQUESTsSESSIONsqssressearchslowersmaxsoffsets    offsetnewsintsstringssplitsqueriessnewquerysquerysappendsjoinsnewquerystrings
        !           128: actualPathshtml(
        !           129: sselfshtmlsqssnewquerystrings   offsetnewsmaxsqueriessoffsetsquerysnewquery((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysnextLink_old#s.&&&
&&&
        !           130: &
&
        !           131: &&&& &&
&&(s__name__s
        !           132: __module__s__doc__s meta_typesNones
        !           133: actualPaths
        !           134: getRequestslowerEndsZSQLisEmptysZSQLsearchOptionssZSQLInlineSearchsZSQLInlineSearch2sZSQLAdds
        !           135: ZSQLChangesZSQLChange_oldsZSQLFindsZSQLFoundCountLensZSQLFoundCountsZSQLRangeStarts
ZSQLRangeSizesZSQLRangeEndsparseQueryStrings
        !           136: ZSQLSearchsZSQLintsnextLinksprevLinksprevLink_oldsnextLink_old(((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysZSQLExtendFolders2&&                  
        !           137:       "              †     15   sZSQLExtendFolderAddsicCsðtƒ}t|&ƒ&|_||_|i|&|ƒ&|i|&ƒ&}tƒi    }|o,&|d&|ƒo
&td‚n&&|iƒ&n&&|o?&|d|ƒo
&td‚n&&|ididddd ƒ&n&&|tj    o&|i||d
        !           138: dƒ&Sn&&dS(
sÜAdd a new Folder object with id *id*.
        !           139: 
        !           140:     If the 'createPublic' and 'createUserF' parameters are set to any true
        !           141:     value, an 'index_html' and a 'UserFolder' objects are created respectively
        !           142:     in the new folder.
        !           143:     sAdd User Folderss+You are not authorized to add User Folders.sAdd Page Templatess-You are not authorized to add Page Templates.s
PageTemplatessids
        !           144: index_htmlstitlessupdate_menui&N(sZSQLExtendFoldersobsstrsidstitlesselfs
        !           145: _setObjects_getObsgetSecurityManagerscheckPermissionscreateUserFsUnauthorizedsmanage_addUserFolderscreatePublicsmanage_addProductsmanage_addPageTemplatesREQUESTsNonesmanage_main(sselfsidstitlescreatePublicscreateUserFsREQUESTsobscheckPermission((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pysmanage_addZSQLExtendFolderDs"      && &&&&
&&
!
&(s
        !           146: OFS.FoldersFoldersGlobalss
        !           147: PersistentsAcquisitionsImplicitsDTMLFilesurllibsresstringspyPgSQLslibpqs
AccessControlsgetSecurityManagersos.pathsossquoteStringsZSQLExtendFoldersglobalssmanage_addZSQLExtendFolderFormsNonesmanage_addZSQLExtendFolder(sZSQLExtendFoldersmanage_addZSQLExtendFoldersstringsmanage_addZSQLExtendFolderFormslibpqsquoteStrings
        !           148: PersistentsurllibsDTMLFilesresgetSecurityManagersFoldersossImplicit((sP/Users/dwinter/install/CVSZOPE/Zope/lib/python/Products/ZSQLExtend/ZSQLExtend.pys&?&s
&
&
&
&   &   &   &
&
&      ÿÿ3
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>