mЄ /с╕Ec@sdZdZddd!ZdkZdklZlZlZedZ dk lZlZl Z lZlZd klZlZlZd fdДГYZhdd

age >=

age <= This example illustrates how groups can be nested to control boolean evaluation order. It also illustrates that the grouping facility can also be used with other DTML tags like 'if' tags. The 'sqlgroup' tag checks to see if text to be inserted contains other than whitespace characters. If it does, then it is inserted with the appropriate boolean operator, as indicated by use of an 'and' or 'or' tag, otherwise, no text is inserted. s8$Id: sqltest.py 40218 2005-11-18 14:39:19Z andreasjung $s$Revision: 1.5 $ii■ N(s ParseErrorsparse_paramss name_paramtstr(sfindssplitsjoinsatoisatof(sListTypes TupleTypes StringTypetSQLTestcBs0tZdZdZZdДZdДZeZRS(NtsqltestcCs╖t|ddddddddddddd dГ}t|d dГ\}}|djo |}n |i}|||_|_||_|i dГp t dВn|d|_}t |Гpt d |dfВn|i dГo|d|_n|i dГo|d|_n|i dГo|d|_n6|idjod}t |dfВn |i|_d}|i d Гo |d }ti||Г}n||_dS(Ntnamettexprttypetcolumntmultipleitoptionaltoptsqlvarsthe type attribute is requiredRsinvalid type, %ss: the column attribute is required if an expression is usedt=(sthe type attribute is requiredR(tparse_paramstargstNonet name_paramRRtevaltselft__name__thas_keyt ParseErrorRttt valid_typeR RRterrR tcomparison_operatorstget(RRRRRRR ((t5/data/zmath/zope/lib/python/Shared/DC/ZRDB/sqltest.pyt__init__Qs8 c CsЧ|i}|i}|i}y@|i}t|ГtdГjo||}n ||Г}WnCt j o7|i dГo|dodSntd|ВnXt|Гtt fjo3t|Гdjo|iotd|ВqЎn |g}g}xЯ|D]Ч}|o't|Гtjo|djoqn|djo}yVt|Гtjo-|dd jo|d }nt|Гntt|ГГ}WqНtj otd |ВqНXn╠|djoА|ot|Гtjoqny7t|Гtjot|Гntt|ГГ}WqНtj otd|ВqНXn?t|ttfГpt|Г}n|id dГ|Г}|i|ГqW|oG|djo:|i dГo|dodSqэd|}t|Вn|p#|iodSntd|Вnt|ГdjoRttt|ГdГ}|idjod|i |fSq|d|i |fSnd|i |i|dfS(NRR s#Missing input variable, %sis/multiple values are not allowed for %ststringtinti tLs%Invalid integer value for %stfloats,Invalid floating-point value for %stsql_quote__itnbs*Invalid empty string value for %ss%No input was provided for %ss, s<>s%s not in (%s)s %s in (%s)s%s %s %s(!RRRRRRRtmdtvtKeyErrorRt ValueErrortListTypet TupleTypetlenRtvst StringTypetatoiRRtatofR t isinstancetunicodetgetitemtappendRR tjointmapR R( RR#R*RRRRRR$((Rtrenderust ( ( Rt __module__RRR RRR4t__call__(((RRMs $ MRiR RR"teqRtnes<>tltttges>=tgte(t__doc__t __rcs_id__t__version__tsystDocumentTemplate.DT_UtilRR Rt__builtins__RRtfindtsplitR2R,R-ttypesR'R(R+RRRR(RR+R(R2RGRRRDRBR,RHRR'RCR-RR R((Rt?9s %w-