o ٭hL@sddlmZddlZddlZddlZddlZddlZddlmZm Z m Z ddl m Z m Z ddlmZddlmZmZmZmZmZddlmZmZdd lmZmZmZmZmZmZm Z m!Z!m"Z"dd l#m$Z$m%Z%dd l&m'Z'm(Z(m)Z)m*Z*m+Z+erdd l,m-Z-m.Z.m/Z/ej0d krddlm1Z1nddl2m1Z1edZ3edddZ4GdddZ5Gddde5Z6Gddde6Z7GdddZ8Gddde6Z9Gddde6Z:Gddde6Z;Gd d!d!e6ZGd&d'd'e=Z?Gd(d)d)e6Z@Gd*d+d+ZAGd,d-d-e@e;ZBGd.d/d/e6ZCGd0d1d1eBZDGd2d3d3e@ZEGd4d5d5eEZFGd6d7d7eEZGGd8d9d9e@ZHGd:d;d;e@ZIGdd?d?e@ZKGd@dAdAe@ZLGdBdCdCeLZMGdDdEdEeLZNGdFdGdGe@ZOGdHdIdIe@ZPGdJdKdKeIZQGdLdMdMe6ZRGdNdOdOe6ZSGdPdQdQe@ZTGdRdSdSe@ZUGdTdUdUZVGdVdWdWe@ZWGdXdYdYeWZXGdZd[d[eXZYed\d]dZZGd^d_d_eYZ[Gd`dadaeYZ\Gdbdcdce6Z]GdddedeeWZ^GdfdgdgeWZ_GdhdidieWZ`Gdjdkdke6ZaGdldmdme6ZbdS)n) annotationsN)IterableIteratorSequence)datetime)Enum) TYPE_CHECKINGAnyCallableTypeVarcast)DEFAULT_SQL_CONTEXT SqlContext) ArithmeticBoolean ComparatorDatePartDialectsEquality JSONOperatorsMatchingOrder) CaseExceptionFunctionException)builderformat_alias_sql format_quotes ignore_copyresolve_is_aggregate) QueryBuilder SelectableTable) )SelfTNodeTNode)boundc@s.eZdZUdZded<d ddZdd d ZdS)r)N bool | None is_aggregatereturnIterator[NodeT]ccs |VdSNselfr0r0Z/var/www/html/stock_analysis/be/venv/lib/python3.10/site-packages/pypika_tortoise/terms.pynodes_+s z Node.nodes_type type[NodeT] list[NodeT]csfdd|DS)Ncsg|] }t|r|qSr0) isinstance).0noder5r0r3 /s  zNode.find_..)r4)r2r5r0r;r3find_.s z Node.find_r-r.)r5r6r-r7)__name__ __module__ __qualname__r,__annotations__r4r=r0r0r0r3r)(s  c@sPeZdZUdZded<ddd d Zedd dZedddZ dddZ e ddddZ e dddd Z dd$d%Zdd(d)Zdd+d,Zdd.d/Zdd3d4Zdd5d6Zdd7d8Zdd9d:Zdd;d<Zdd=d>Zdd@dAZddBdCZddDdEZddFdGZddHdIZddJdKZddMdNZddRdSZddWdXZ ddYdZZ!dd\d]Z"ddadbZ#ddcddZ$ddedfZ%ddgdhZ&ddidjZ'ddkdlZ(ddndoZ)ddqdrZ*ddsdtZ+ddudvZ,ddwdxZ-ddzd{Z.dd}d~Z/dddZ0dddZ1dddZ2dddZ3dddZ4dddZ5dddZ6dddZ7dddZ8dddZ9dddZ:dddZ;dddZs z Term.tables_ set[Field]cCst|tSr/)rQr=Fieldr1r0r0r3fields_Dz Term.fields_valr wrapper_clstype[Term] | None3NodeT | LiteralValue | Array | Tuple | ValueWrappercCsVt|tr tt|S|durtSt|trt|St|tr#t|S|p&t }||S)a, Used for wrapping raw inputs such as numbers in Criterions and Operator. For example, the expression F('abc')+1 stores the integer part in a ValueWrapper object. :param val: Any value. :param wrapper_cls: A pypika class which wraps a constant value so it can be handled as a component of the query. :return: Raw string, number, or decimal values will be returned in a ValueWrapper. Fields and other parts of the querybuilder will be returned as inputted. N) r8r)r r( NullValuelistArraytupleTuple ValueWrapper)rWrXr0r0r3 wrap_constantGs    zTerm.wrap_constant-Term | QueryBuilder | str | int | bool | Nonetype[ValueWrapper] | None5Term | QueryBuilder | NullValue | ValueWrapper | JSONcCsTddlm}t|t|fr|S|durtSt|tttfr&|p!t}||St |S)Nr)r!) queriesr!r8rCr[rLintboolr`JSON)rWrXr!r0r0r3 wrap_jsongs zTerm.wrap_json current_table Table | None new_tablecC|S)a Replaces all occurrences of the specified table with the new table. Useful when reusing fields across queries. The base implementation returns self because not all terms have a table property. :param current_table: The table to be replaced. :param new_table: The table to replace with. :return: Self. r0r2rjrlr0r0r3 replace_tablexs zTerm.replace_tableotherBasicCriterioncCs||kSr/r0r2rpr0r0r3eqzTerm.eq NullCriterioncCt|Sr/)rur1r0r0r3isnullrtz Term.isnullNotcCs |Sr/)rwnegater1r0r0r3notnulls z Term.notnullvaluerfBitwiseAndCriterioncCst|||Sr/)r|rar2r{r0r0r3 bitwiseandzTerm.bitwiseandcCs||kSr/r0rrr0r0r3gtrtzTerm.gtcCs||kSr/r0rrr0r0r3gtertzTerm.gtecCs||kSr/r0rrr0r0r3ltrtzTerm.ltcCs||kSr/r0rrr0r0r3ltertzTerm.ltecCs||kSr/r0rrr0r0r3nertzTerm.neexprcCttj|||Sr/)rqrglobrar2rr0r0r3rz Term.globcCrr/)rqrlikerarr0r0r3rrz Term.likecCrr/)rqrnot_likerarr0r0r3rrz Term.not_likecCrr/)rqrilikerarr0r0r3rrz Term.ilikecCrr/)rqr not_ilikerarr0r0r3rrzTerm.not_ilikecCrr/)rqrrlikerarr0r0r3rrz Term.rlikepatterncCrr/)rqrregexrar2rr0r0r3rrz Term.regexlowerupperBetweenCriterioncCt|||||Sr/)rrar2rrr0r0r3betweenz Term.betweenstartendPeriodCriterioncCrr/)rra)r2rrr0r0r3from_torz Term.from_tocCrr/)rqras_ofrarr0r0r3rrz Term.as_ofAllcCrvr/)rr1r0r0r3all_rtz Term.all_arglist | tuple | set | TermContainsCriterioncCs(t|tttfrt|t|St||Sr/)r8r\r^rQrr_r2rr0r0r3isins z Term.isincCs||Sr/)rryrr0r0r3notinrVz Term.notincCrr/)rqr bin_regexrarr0r0r3rrzTerm.bin_regexcCrvr/rxr1r0r0r3ryrtz Term.negatecCrvr/rr1r0r0r3 __invert__rtzTerm.__invert__cCrmr/r0r1r0r0r3__pos__z Term.__pos__NegativecCrvr/)rr1r0r0r3__neg__rtz Term.__neg__ArithmeticExpressioncCrr/rraddrarrr0r0r3__add__rz Term.__add__cCrr/rrsubrarrr0r0r3__sub__rz Term.__sub__cCrr/rrmulrarrr0r0r3__mul__rz Term.__mul__cCrr/rrdivrarrr0r0r3 __truediv__rzTerm.__truediv__PowcC t||Sr/)rrrr0r0r3__pow__rKz Term.__pow__ModcCrr/)rrrr0r0r3__mod__rKz Term.__mod__cCttj|||Sr/rrrr0r0r3__radd__rz Term.__radd__cCrr/rrrr0r0r3__rsub__rz Term.__rsub__cCrr/rrrr0r0r3__rmul__rz Term.__rmul__cCrr/rrrr0r0r3 __rtruediv__rzTerm.__rtruediv__cCrr/)rqrrsrarrr0r0r3__eq__rz Term.__eq__cCrr/)rqrrrarrr0r0r3__ne__rz Term.__ne__cCrr/)rqrrrarrr0r0r3__gt__rz Term.__gt__cCrr/)rqrrrarrr0r0r3__ge__rz Term.__ge__cCrr/)rqrrrarrr0r0r3__lt__rz Term.__lt__cCrr/)rqrrrarrr0r0r3__le__rz Term.__le__itemslicecCs"t|ts td||j|jS)Nz"Field' object is not subscriptable)r8r TypeErrorrrstop)r2rr0r0r3 __getitem__ s zTerm.__getitem__cC |tSr/get_sqlrr1r0r0r3__str__rKz Term.__str__cCstjdd}t||S)NT with_alias)rcopyhashrr2ctxr0r0r3__hash__ z Term.__hash__rrcCtr/NotImplementedErrorrr0r0r3rz Term.get_sqlr/rDrEr-rF)rDrLr-r&)r-rOr-rS)rWr rXrYr-rZ)rWrbrXrcr-rdrjrkrlrkr-r&rpr r-rq)r-ru)r-rx)r{rfr-r|)rrLr-rq)rrLr-rq)rr rr r-r)rr rr r-r)r-r)rrr-rr-r&)r-r)rpr r-r)rpr r-r)rpr r-r)rrr-rr-rL)r-rfrrr-rL)>r?r@rAr,rBrJrrMpropertyrRrU staticmethodrarirorsrwrzr~rrrrrrrrrrrrrrrrrrrryrrrrrrrrrrrrrrrrrrrrrrrr0r0r0r3rC4s|                                                    rCc @sdeZdZdZejddejddejddejddej ddiZ dZ d Z ddddZ dddZd S) Parameterz Represents a parameter in a query. The placeholder can be specified with the `placeholder` argument or will be determined based on the dialect if not provided. cCdSN?r0_r0r0r3 zParameter.cCrrr0rr0r0r3r!rcCr)Nz%sr0rr0r0r3r"rcCs d|S)N$r0idxr0r0r3r#s cCrrr0rr0r0r3r$rrN placeholderrEr int | Noner-rFcCsL|s |dur td|dur|dkrtd|r|rtd||_||_dS)Nz+Must provide either a placeholder or an idxrzidx must start at 1z,Cannot provide both a placeholder and an idx) ValueError _placeholder_idx)r2rrr0r0r3rJ)s  zParameter.__init__rrrLcs*jrjSj|jfddjS)NcsjSr/)DEFAULT_PLACEHOLDERrr1r0r3r:sz#Parameter.get_sql..)rIDX_PLACEHOLDERSgetdialectrrr0r1r3r6szParameter.get_sqlNN)rrErrr-rFr)r?r@rA__doc__rORACLEMSSQLMYSQL POSTGRESQLSQLITErrr,rJrr0r0r0r3rs       rc@s0eZdZdZddddZdd d ZdddZdS) Parameterizera Parameterizer can be used to replace values with parameters in a query: >>>>>>> 94fab2d (Replace ListParameter with Parameterizer) >>> parameterizer = Parameterizer() >>> customers = Table("customers") >>> sql = Query.from_(customers).select(customers.id) ... .where(customers.lname == "Mustermann") ... .get_sql(parameterizer=parameterizer, dialect=Dialects.SQLITE) >>> sql, parameterizer.values ('SELECT "id" FROM "customers" WHERE "lname"=?', ['Mustermann']) Parameterizer remembers the values it has seen and replaces them with parameters. The values can be accessed via the `values` attribute. Nplaceholder_factoryCallable[[int], str] | Noner-rFcCs||_g|_dSr/)rvalues)r2rr0r0r3rJN zParameterizer.__init__r{r rgcCs(t|trdSt|tr|dkrdSdS)NF*T)r8rrLr}r0r0r3should_parameterizeRs z!Parameterizer.should_parameterizercCs6|j||jrt|t|jStt|jdS)Nr)rappendrrlenr}r0r0r3 create_paramZs zParameterizer.create_paramr/)rrr-rF)r{r r-rg)r{r r-r)r?r@rArrJr r r0r0r0r3r=s   rcs6eZdZdfdd Zeddd Zdd dZZS)rtermrCr-rFcst||_dSr/superrJr r2r  __class__r0r3rJcs  zNegative.__init__r+cC|jjSr/r r,r1r0r0r3r,gzNegative.is_aggregaterrrLcCdj|j|dS)Nz-{term}r )formatr rrr0r0r3rkrzNegative.get_sql)r rCr-rFr-r+r)r?r@rArJrr,r __classcell__r0r0rr3rb  rcsHeZdZdZ ddfd d ZdddZedddZdddZZ S)r`NTr{r rDrEallow_parametrizergr-rFcst|||_||_dS)ab A wrapper for a constant value such as a string or number. :param value: The value to be wrapped. :param alias: An optional alias for the value. :param allow_parametrize: Whether the value should be replaced with a parameter in the query if parameterizer is used. N)rrJr{r)r2r{rDrrr0r3rJrs  zValueWrapper.__init__rrrLcCs||j|Sr/)get_formatted_valuer{rr0r0r3 get_value_sqlrVzValueWrapper.get_value_sqlcCs|jpd}t|tr||St|tr#t|tr|jS||j|St|tt fr2|| |St|t rD| ||d}t ||St|trOt |St|tjr]|t ||St|ttfrlt t||S|durrdSt |S)NrPnull)secondary_quote_charr8rCrrrr{rrr isoformatrLreplacerrgruuidUUIDdictr\jsondumps)clsr{r quote_charr0r0r3rs*          z ValueWrapper.get_formatted_valuecCsX|jdus|j|jr|js||}t||j|S|j|j}t|||j|Sr/) parameterizerr r{rrrrDr r)r2rsqlparamr0r0r3rs  zValueWrapper.get_sqlNT)r{r rDrErrgr-rFr)r{r rrr-rL) r?r@rAr,rJr classmethodrrrr0r0rr3r`os  r`cseZdZUdZded<d6d7fd d Zd8ddZd9ddZd:ddZe d;dd!d"Z d>d#d$Z d?d&d'Zd?d(d)Zd@d+d,Zd@d-d.Zd@d/d0ZdAd2d3ZdAd4d5ZZS)BrhNrktabler{r rDrEr-rFct|||_dSr/)rrJr{r2r{rDrr0r3rJ  z JSON.__init__kwargsrLcKs\t|tr|j|fi|St|tr|j|fi|St|tr*|j|fi|St|Sr/)r8r& _get_dict_sqlr\ _get_list_sqlrL _get_str_sql)r2r{r4r0r0r3_recursive_get_sqls   zJSON._recursive_get_sqlr&c s.fdd|D}ddd|dgS)Ncs:g|]\}}djj|fij|fidqS)z {key}:{value})keyr{)rr8)r9kvr4r2r0r3r<sz&JSON._get_dict_sql..rP{,})itemsjoinr2r{r4pairsr0r<r3r5s zJSON._get_dict_sqlr\c s*fdd|D}ddd|dgS)Ncsg|] }j|fiqSr0)r8)r9r;r<r0r3r<sz&JSON._get_list_sql..rP[r>])rArBr0r<r3r6szJSON._get_list_sql"r*cKrr/)r)r{r*r4r0r0r3r7rNzJSON._get_str_sqlrrcCs"t||j|j}t||j|Sr/)rr8r{r!rrDr2rr,r0r0r3rz JSON.get_sql key_or_index str | intrqcCrr/)rqrGET_JSON_VALUErar2rIr0r0r3get_json_value zJSON.get_json_valuecCrr/)rqrGET_TEXT_VALUErarLr0r0r3get_text_valuerNzJSON.get_text_value path_jsoncCrr/)rqrGET_PATH_JSON_VALUErir2rQr0r0r3get_path_json_valuerNzJSON.get_path_json_valuecCrr/)rqrGET_PATH_TEXT_VALUErirSr0r0r3get_path_text_valuerNzJSON.get_path_text_valuerpcCrr/)rqrHAS_KEYrirrr0r0r3has_keyrNz JSON.has_keycCrr/)rqrCONTAINSrirrr0r0r3containsrNz JSON.containscCrr/)rqr CONTAINED_BYrirrr0r0r3 contained_byrNzJSON.contained_byrcCttj|t|Sr/)rqrHAS_KEYSr]rrr0r0r3has_keysz JSON.has_keyscCr]r/)rqr HAS_ANY_KEYSr]rrr0r0r3 has_any_keys r`zJSON.has_any_keysr)r{r rDrEr-rF)r{r r4r r-rL)r{r&r4r r-rL)r{r\r4r r-rL)rF)r{rLr*rLr4r r-rLr)rIrJr-rq)rQrLr-rqr)rprr-rq)r?r@rAr0rBrJr8r5r6rr7rrMrPrTrVrXrZr\r_rbrr0r0rr3rhs$            rhc(eZdZd fdd Zd d d ZZS)Valuesfield str | Fieldr-rFcs.tdt|tst||_dS||_dSr/)rrJr8rTre)r2rerr0r3rJs "zValues.__init__rrrLcCr)NzVALUES({value})r{)rrerrr0r0r3rrzValues.get_sql)rerfr-rFrr?r@rArJrrr0r0rr3rdrdcs*eZdZd dfdd Zdd d ZZS) LiteralValueNrDrEr-rFcr1r/)rrJ_valuer2rr0r3rJr3zLiteralValue.__init__rrrLcCst|j|j|Sr/)rrkrDrr0r0r3rrzLiteralValue.get_sqlr/rrrhr0r0rr3rjrjc eZdZdd fdd ZZS) r[NrDrEr-rFctd|dS)NNULLrrJrIrr0r3rJ"r`zNullValue.__init__r/rr?r@rArJrr0r0rr3r[!r[crm) SystemTimeValueNrDrEr-rFcrn)N SYSTEM_TIMErprIrr0r3rJ'r`zSystemTimeValue.__init__r/rrqr0r0rr3rs&rrrsc@sTeZdZdddZdddZdd d ZeddddZeddddZdddZ dS) Criterionrpr r-ComplexCriterioncCttj||Sr/)rvrand_rrr0r0r3__and__,rVzCriterion.__and__cCrwr/)rvror_rrr0r0r3__or__/rVzCriterion.__or__cCrwr/)rvrxor_rrr0r0r3__xor__2rVzCriterion.__xor__r0termsIterable[Term]EmptyCriterioncCst}|D]}||O}q|Sr/rr~critr r0r0r3any5 z Criterion.any Iterable[Any]cCst}|D]}||M}q|Sr/rrr0r0r3all>rz Criterion.allrrrLcCrr/rrr0r0r3rGrzCriterion.get_sqlN)rpr r-rv)r0)r~rr-r)r~rr-rr) r?r@rAryr{r}rrrrr0r0r0r3ru+s   ruc@sPeZdZUdZded<eZded<ddd Zdd d ZdddZ dddZ dS)rNr+r,rOrRr-rScCstSr/)rQr1r0r0r3rUOrzEmptyCriterion.fields_rpr'cC|Sr/r0rrr0r0r3ryRrzEmptyCriterion.__and__cCrr/r0rrr0r0r3r{UrzEmptyCriterion.__or__cCrr/r0rrr0r0r3r}XrzEmptyCriterion.__xor__r)rpr'r-r') r?r@rAr,rBrQrRrUryr{r}r0r0r0r3rKs    rcsFeZdZ  ddfd d Zdd dZedddZdddZZS)rTNnamerLrDrEr0str | Selectable | Noner-rFcstj|d||_||_dSNrH)rrJrr0)r2rrDr0rr0r3rJ]s zField.__init__r.cc*|V|jdur|jEdHdSdSr/r0r4r1r0r0r3r4g  z Field.nodes_rjrkrlr&cCs|j|kr ||_dSdS)Q Replaces all occurrences of the specified table with the new table. Useful when reusing fields across queries. :param current_table: The table to be replaced. :param new_table: The table to replace with. :return: A copy of the field with the tables replaced. Nr0rnr0r0r3rols  zField.replace_tablerrcCsdt|j|j}|jr!|js|jjr!|j}djt||j|d}t|dd}|j r0t |||S|S)Nz{namespace}.{name}) namespacerrD) rrr*r0with_namespacerDget_table_namergetattrrr)r2r field_sql table_name field_aliasr0r0r3r}s    z Field.get_sqlr)rrLrDrEr0rr-rFr>rr r?r@rArJr4rrorrr0r0rr3rT\s  rTcs*eZdZddfdd Zdd d ZZS)IndexNrrLrDrEr-rFcr1r/rrJr)r2rrDrr0r3rJr3zIndex.__init__rrcCst|j|jSr/)rrr*rr0r0r3rrVz Index.get_sqlr/)rrLrDrEr-rFrrhr0r0rr3rrlrcs4eZdZddfdd Zdd d ZdddZZS)StarNr0rr-rFcstjd|ddS)Nrrrp)r2r0rr0r3rJrz Star.__init__r.ccrr/rr1r0r0r3r4rz Star.nodes_rrrLcCs>|jr|js |jjr|jjpt|jd}dt||jSdS)N _table_namez{}.*r)r0rrDrrrr*)r2rrr0r0r3rsz Star.get_sqlr/)r0rr-rFr>rr?r@rArJr4rrr0r0rr3rs rcsNeZdZdfdd Zddd Zdd dZedddZedddZ Z S)r_rr r-rFcs"tfdd|D_dS)Ncg|]}|qSr0rar9r{r1r0r3r<z"Tuple.__init__..)rrJrr2rrr1r3rJs zTuple.__init__r.cc&|V|jD] }|EdHqdSr/)rr4r}r0r0r3r4  z Tuple.nodes_rrrLcs.ddfdd|jD}t||jS)N({})r>c3|]}|VqdSr/rr9r rr0r3 z Tuple.get_sql..)rrArrrDrGr0rr3rs z Tuple.get_sqlr+cCtdd|jDS)NcSg|]}|jqSr0r,)r9rWr0r0r3r<z&Tuple.is_aggregate..)r rr1r0r0r3r,szTuple.is_aggregaterjrkrlr&cfdd|jD|_dS)rcg|]}|qSr0rorrjrlr0r3r<z'Tuple.replace_table..N)rrnr0rr3rozTuple.replace_tablerr r-rFr>rrr) r?r@rArJr4rrr,rrorr0r0rr3r_s   r_crc)r]rr r-rFcstj|t||_dSr/)rrJr\original_valuerrr0r3rJrzArray.__init__rrrLcsjdus j|js;dfdd|jD}d|}jtjtj fvr4t |dkr2d|nd}t ||j Sj |j}|S)Nr>c3rr/rrrr0r3rrz Array.get_sql..z[{}]rz ARRAY[{}]z'{}')r+r rrArrrrrREDSHIFTr rrDr r)r2rrr,r-r0rr3rs  z Array.get_sqlrrrhr0r0rr3r]rir]ceZdZdfdd ZZS)Bracketr r r-rFcst|dSr/rprrr0r3rJrzBracket.__init__)r r r-rFrqr0r0rr3rrcsReZdZ d!d"fdd Zd#ddZed$ddZed%ddZd&dd Z Z S)'NestedCriterionN comparatorrnested_comparatorrvleftr rightnestedrDrEr-rFcs.t|||_||_||_||_||_dSr/)rrJrrrrr)r2rrrrrrDrr0r3rJs  zNestedCriterion.__init__r.cc<|V|jEdH|jEdH|jEdHdSr/)rr4rrr1r0r0r3r4 zNestedCriterion.nodes_r+cCstdd|j|j|jfDS)NcSrr0rrr0r0r3r<rz0NestedCriterion.is_aggregate..)r rrrr1r0r0r3r,szNestedCriterion.is_aggregaterjrkrlr&cCs4|j|||_|j|||_|j|||_dSU Replaces all occurrences of the specified table with the new table. Useful when reusing fields across queries. :param current_table: The table to be replaced. :param new_table: The table to replace with. :return: A copy of the criterion with the tables replaced. N)rrorrrnr0r0r3roszNestedCriterion.replace_tablerrrLcCsNdj|j||jj|j||jj|j|d}|jr%t ||j |dS|S)Nz4{left}{comparator}{right}{nested_comparator}{nested})rrrrr)r,rDr) rrrrr{rrrrrrDrGr0r0r3rs   zNestedCriterion.get_sqlr/)rrrrvrr rr rr rDrEr-rFr>rrr r?r@rArJr4rr,rrorrr0r0rr3rs   rcsReZdZ ddfd d Zd ddZed!ddZed"ddZd#ddZ Z S)$rqNr!Comparator | JSONOperators | EnumrrCrrDrEr-rFc"t|||_||_||_dS)a A wrapper for a basic criterion such as equality or inequality. This wraps three parts, a left and right term and a comparator which defines the type of comparison. :param comparator: Type: Comparator This defines the type of comparison, such as {quote}={quote} or {quote}>{quote}. :param left: The term on the left side of the expression. :param right: The term on the right side of the expression. N)rrJrrr)r2rrrrDrr0r3rJ$s  zBasicCriterion.__init__r.cc,|V|jEdH|jEdHdSr/)rr4rr1r0r0r3r4=zBasicCriterion.nodes_r+cCsdd|j|jfD}t|S)NcSrr0rrr0r0r3r<Drz/BasicCriterion.is_aggregate..)rrr )r2aggrsr0r0r3r,BszBasicCriterion.is_aggregaterjrkrlr&cC$|j|||_|j|||_dSrrrorrnr0r0r3roGzBasicCriterion.replace_tablerrrLcCs<dj|jj|j||j|d}|jrt||j|S|S)Nz{left}{comparator}{right}rrr) rrr{rrrrrrDrGr0r0r3rXs  zBasicCriterion.get_sqlr/) rrrrCrrCrDrEr-rFr>rrrrr0r0rr3rq#s   rqcsZeZdZdZddfd d Zd ddZd ddZd ddZd ddZe d!ddZ Z S)"JSONAttributeCriteriona~ A specialized criterion for accessing JSON column attributes/paths. Generates database-specific SQL for accessing nested JSON attributes: - PostgreSQL: data->'user'->'details'->>'age' or data->'tags'->>0 - MySQL and SQLite: data->>'$.user.details.age' or data->>'$.tags[0]' - MS SQL: JSON_VALUE(data, '$.user.details.age') or JSON_VALUE(data, '$.tags[0]') N json_columnrCpathlist[str | int]rDrEr-rFcst|||_||_dS)z Initialize a JSON attribute access criterion. :param json_column: The JSON column/field to access :param path: The path to the attribute as a list of keys/indices :param alias: Optional alias for the expression N)rrJrr)r2rrrDrr0r3rJms  zJSONAttributeCriterion.__init__rrrLcCs^|jtjks |jtjkr||}n|jtjkr||}n||}|jr-t ||j |S|S)z9Generate database-specific SQL for JSON attribute access.) rrrr_get_mysql_sqlr_get_mssql_sql_get_postgres_sqlrrrDrGr0r0r3rzs    zJSONAttributeCriterion.get_sqlcCsr|j|}t|jD]+\}}|t|jdk}|rdnd}t|tr,|||7}q ||d|d7}q |S)Nrz->>z->')rr enumeraterr r8rf)r2rr,ipartis_lastoperatorr0r0r3rs   z(JSONAttributeCriterion._get_postgres_sqlcCs\g}|jD]}|t|trd|dnd|qdd|}|j|d|dS)NrDrE.rrPz->>'rrr r8rfrArrr2r path_partsrpath_strr0r0r3rs  (z%JSONAttributeCriterion._get_mysql_sqlcCs^g}|jD]}|t|trd|dnd|qdd|}d|j|d|dS) NrDrErrrPz JSON_VALUE(z, 'z')rrr0r0r3rs  (z%JSONAttributeCriterion._get_mssql_sqlrjrkrlr&cCs|j|||_dSr/)rrornr0r0r3rosz$JSONAttributeCriterion.replace_tabler/)rrCrrrDrEr-rFrr) r?r@rArrJrrrrrrorr0r0rr3rcs  rcs^eZdZdd fd d Zd!d dZed"ddZed#ddZd$ddZ ed%ddZ Z S)&rNr r containerrCrDrEr-rFcs"t|||_||_d|_dS)a A wrapper for a "IN" criterion. This wraps two parts, a term and a container. The term is the part of the expression that is checked for membership in the container. The container can either be a list or a subquery. :param term: The term to assert membership for within the container. :param container: A list or subquery. FN)rrJr r _is_negated)r2r rrDrr0r3rJs  zContainsCriterion.__init__r.ccrr/)r r4rr1r0r0r3r4rzContainsCriterion.nodes_r+cCrr/rr1r0r0r3r,rzContainsCriterion.is_aggregaterjrkrlr&cC|j|||_dSrr rornr0r0r3rozContainsCriterion.replace_tablerrrLcCsD|jdd}dj|j||j||jrdndd}t||j|S)NT)subqueryz{term} {not_}IN {container}zNOT rP)r rnot_)rrr rrrrrD)r2r container_ctxr,r0r0r3rs    zContainsCriterion.get_sqlcC d|_dSr.)rr1r0r0r3ryrNzContainsCriterion.negater/)r r rrCrDrEr-rFr>rrrr) r?r@rArJr4rr,rrorryrr0r0rr3rs     rcs8eZdZddfd d ZdddZedddZZS)RangeCriterionNr rCrr rrDrEr-rFcs"t|||_||_||_dSr/)rrJr rr)r2r rrrDrr0r3rJs  zRangeCriterion.__init__r.ccrr/)r r4rrr1r0r0r3r4rzRangeCriterion.nodes_r+cCrr/rr1r0r0r3r,rzRangeCriterion.is_aggregater/) r rCrr rr rDrEr-rFr>r)r?r@rArJr4rr,rr0r0rr3rs  rc@s$eZdZedddZdd d Zd S)rrjrkrlr-r&cCrrrrnr0r0r3rorzBetweenCriterion.replace_tablerrrLcC6dj|j||j||j|d}t||j|S)Nz {term} BETWEEN {start} AND {end}r rrrr rrrrrDrGr0r0r3rs    zBetweenCriterion.get_sqlNrr)r?r@rArrorr0r0r0r3rs rc@seZdZdddZdS) rrrr-rLcCr)Nz{term} FROM {start} TO {end}rrrGr0r0r3rs    zPeriodCriterion.get_sqlNr)r?r@rArr0r0r0r3rsrcsBeZdZddfd d Zdd dZedddZdddZZS)r|Nr rCr{r rDrEr-rFcst|||_||_dSr/)rrJr r{)r2r r{rDrr0r3rJs  zBitwiseAndCriterion.__init__r.ccrr/)r r4r{r1r0r0r3r4!rzBitwiseAndCriterion.nodes_rjrkrlr&cCrrrrnr0r0r3ro&rz!BitwiseAndCriterion.replace_tablerrrLcCs&dj|j||jd}t||j|S)Nz({term} & {value}))r r{)rr rr{rrDrGr0r0r3r6s  zBitwiseAndCriterion.get_sqlr/)r rCr{r rDrEr-rFr>rrrr0r0rr3r|s   r|csBeZdZddfdd Zdd d ZedddZdddZZS)ruNr rCrDrEr-rFcr1r/rr2r rDrr0r3rJ?r3zNullCriterion.__init__r.cc|V|jEdHdSr/r r4r1r0r0r3r4CzNullCriterion.nodes_rjrkrlr&cCrrrrnr0r0r3roGrzNullCriterion.replace_tablerrrLcC"dj|j|d}t||j|S)Nz{term} IS NULLrrr rrrDrGr0r0r3rWs zNullCriterion.get_sqlr/)r rCrDrEr-rFr>rrrr0r0rr3ru>s   ruc@s eZdZd ddZdd d Zd S)rvrrr-rLcCsb|j||jd}|j||jd}dj|jj|j||j|d}|jr/dj|dS|S)N subcriterionz{left} {comparator} {right}rz ({criterion})) criterion) rneeds_bracketsrrrrr{rr)r2rleft_ctx right_ctxr,r0r0r3r_s   zComplexCriterion.get_sqlr rCrgcCst|to |j|jk Sr/)r8rvrrr0r0r3rmrzComplexCriterion.needs_bracketsNr)r rCr-rg)r?r@rArrr0r0r0r3rv^s rvcsveZdZdZejejgZ d(d)fd d Zd*ddZ e d+ddZ e d,ddZ d-ddZd.d!d"Zd/d&d'ZZS)0rz Wrapper for an arithmetic function. Can be simple with two terms or complex with nested terms. Order of operations are also preserved. Nrrrr rrDrEr-rFcr)a Wrapper for an arithmetic expression. :param operator: Type: Arithmetic An operator for the expression such as {quote}+{quote} or {quote}/{quote} :param left: The term on the left side of the expression. :param right: The term on the right side of the expression. :param alias: (Optional) an alias for the term which can be used inside a select statement. :return: N)rrJrrr)r2rrrrDrr0r3rJys  zArithmeticExpression.__init__r.ccrr/)rr4rr1r0r0r3r4rzArithmeticExpression.nodes_r+cCst|jj|jjgSr/)r rr,rr1r0r0r3r,sz!ArithmeticExpression.is_aggregaterjrkrlr&cCr)P Replaces all occurrences of the specified table with the new table. Useful when reusing fields across queries. :param current_table: The table to be replaced. :param new_table: The table to replace with. :return: A copy of the term with the tables replaced. Nrrnr0r0r3rorz"ArithmeticExpression.replace_tablecurr_opleft_opArithmetic | NonergcCs$|durdS||jvr dS||jvS)a Returns true if the expression on the left of the current operator needs to be enclosed in parentheses. :param current_op: The current operator. :param left_op: The highest level operator of the left expression. NF) add_order)r2rrr0r0r3left_needs_parenss    z&ArithmeticExpression.left_needs_parensright_opcCs2|durdS|tjkr dS|tjkrdS||jvS)a Returns true if the expression on the right of the current operator needs to be enclosed in parentheses. :param current_op: The current operator. :param right_op: The highest level operator of the right expression. NFT)rrrr)r2rrr0r0r3right_needs_parenss    z'ArithmeticExpression.right_needs_parensrrrLcCsdd|j|jfD\}}dj|jj||j|rdnd|j|||j|r,dnd|j|d}|jrAt ||j |S|S)NcSsg|]}t|ddqS)rN)r)r9sider0r0r3r<rz0ArithmeticExpression.get_sql..z{left}{operator}{right}rz{})rrr) rrrrr{rrrrrrD)r2rrrarithmetic_sqlr0r0r3rs   zArithmeticExpression.get_sqlr/) rrrr rr rDrEr-rFr>rr)rrrrr-rg)rrrrr-rgr)r?r@rArrrrrrJr4rr,rrorrrrr0r0rr3rqs      rcsleZdZd d!fdd Zd"d d Zed#d d Zed$ddZed%ddZ ed&ddZ d'ddZ Z S)(CaseNrDrEr-rFcstj|dg|_d|_dSr)rrJ_cases_elserIrr0r3rJs z Case.__init__r.ccsV|V|jD]\}}|EdH|EdHq|jdur)|jEdHdSdSr/)rr4rr2rr r0r0r3r4s z Case.nodes_r+cCs.tdd|jD|jr|jjgSdgS)NcSsg|] \}}|jp |jqSr0rr9rr r0r0r3r<sz%Case.is_aggregate..)r rrr,r1r0r0r3r,szCase.is_aggregaterr r r&cCs|j|||fdSr/)rr rarr0r0r3whensz Case.whenrjrkrlcs<fdd|jD|_|jr|j|_dSd|_dS)rcs(g|]\}}||gqSr0rr rr0r3r<s  z&Case.replace_table..N)rrrornr0rr3ros $zCase.replace_tablecCs|||_|Sr/)rarrr0r0r3else_s z Case.else_rrrLcsv|jstd|jdddfdd|jD}|jr&d|jnd}d j||d }|jr9t||j |S|S) Nz:At least one 'when' case is required for a CASE statement.Fr c3s.|]\}}dj||dVqdS)zWHEN {when} THEN {then})r thenN)rrr when_then_else_ctxr0r3r&s zCase.get_sql..z ELSE {}rPzCASE {cases}{else_} END)casesr ) rrrrArrrrrrD)r2rrr case_sqlr0rr3r!s z Case.get_sqlr/rr>r)rr r r r-r&r)r r r-r&r) r?r@rArJr4rr,rr ror rrr0r0rr3rs     rcsPeZdZddfdd Zdd d ZdddZedddZed ddZ Z S)!rxNr r rDrEr-rFctj|d||_dSrrrrr0r3rJ6 z Not.__init__r.ccrr/rr1r0r0r3r4:rz Not.nodes_rrrLcCs.|jdd}dj|j|d}t||j|S)NTrz NOT {term}r)rrr rrrD)r2rnot_ctxr,r0r0r3r>s z Not.get_sqlrcs,t|j|ts Sd fdd }|S) z Delegate method calls to the class wrapped by Not(). Re-wrap methods on child classes of Term (e.g. isin, eg...) to retain 'NOT ' output. inner_selfr argsr4r-Not | Tcs.|g|Ri|}t|tfrt|S|Sr/)r8rCrx)rrr4result item_funcr0r3innerNs zNot.__getattr__..innerN)rr rr r4r r-r)rr inspectismethod)r2rrr0rr3 __getattr__Cs  zNot.__getattr__rjrkrlr&cCrrrrnr0r0r3roVrzNot.replace_tabler/r r rDrEr-rFr>r)rrLr-r r) r?r@rArJr4rrrrrorr0r0rr3rx5s   rxcs4eZdZddfdd Zdd d ZdddZZS)rNr r rDrEr-rFcrrrrrr0r3rJhrz All.__init__r.ccrr/rr1r0r0r3r4lrz All.nodes_rrrLcCr)Nz {term} ALLrrrGr0r0r3rprHz All.get_sqlr/rr>rrr0r0rr3rgs rc@s6eZdZdddd ZdddZdddZdddZdS)CustomFunctionNrrLparamsSequence | Noner-rFcCs||_||_dSr/)rr!)r2rr!r0r0r3rJvrzCustomFunction.__init__rr r4Functionc Os|st|j|ddS|j|s2tdj|jdddtt |j Dddd|Ddt|jg|Rd|diS) NrDrHzCFunction {name} require these arguments ({params}), ({args}) passedz, cs|]}t|VqdSr/rLr9pr0r0r3rz*CustomFunction.__call__..csr$r/r%r&r0r0r3rr()rr!r) _has_paramsr#rr_is_valid_function_callrrrAr rr!)r2rr4r0r0r3__call__zs zCustomFunction.__call__rgcCs |jduSr/)r!r1r0r0r3r)rKzCustomFunction._has_paramscGst|ttt|jkSr/)r r rr!)r2rr0r0r3r*rz&CustomFunction._is_valid_function_callr/)rrLr!r"r-rF)rr r4r r-r#)r-rg)rr r-rg)r?r@rArJr+r)r*r0r0r0r3r us    r cspeZdZd!fdd Zd"d d Zed#ddZed$ddZd%ddZ e d&ddZ d'ddZ d'dd Z ZS)(r#rrLrr r4r-rFcs<t|d|_fdd|D_|d_dS)NrDcrr0rr9r-r1r0r3r<rz%Function.__init__..schema)rrJrrrr-r2rrr4rr1r3rJszFunction.__init__r.ccrr/)rr4rr0r0r3r4rzFunction.nodes_r+cCr)aa This is a shortcut that assumes if a function has a single argument and that argument is aggregated, then this function is also aggregated. A more sophisticated approach is needed, however it is unclear how that might work. :returns: True if the function accepts one argument and that argument is aggregate. cSrr0rr9rr0r0r3r<rz)Function.is_aggregate..)r rr1r0r0r3r,szFunction.is_aggregaterjrkrlr&cr)rcrr0rr,rr0r3r<rz*Function.replace_table..Nrrnr0rr3rorzFunction.replace_tablerrcCsdSr/r0rr0r0r3get_special_params_sqlrzFunction.get_special_params_sqlrcCs(|jdd}t|dr||St|S)NFrr)rhasattrrrL)rrarg_ctxr0r0r3 get_arg_sqls zFunction.get_arg_sqlcsD}djjdfddjD|rd|dSddS)Nz{name}({args}{special})r>c3s|] }|VqdSr/)r4r/rr2r0r3rsz,Function.get_function_sql..r rP)rrspecial)r1rrrAr)r2rspecial_params_sqlr0r5r3get_function_sqls  zFunction.get_function_sqlcCsB||}|jdurdj|j||d}|jrt||j|S|S)Nz{schema}.{function})r-function)r8r-rrrrrD)r2r function_sqlr0r0r3rs   zFunction.get_sqlrrLrr r4r r-rFr>rr)rrr-r )rr rrr-rLr)r?r@rArJr4rr,rror1rr4r8rrr0r0rr3r#s       r#csHeZdZdZdfdd Zedd d ZdddZdfdd ZZ S)AggregateFunctionTr-rFcs*tj|g|Ri|g|_d|_dSNF)rrJ_filters_include_filterr.rr0r3rJs zAggregateFunction.__init__filtersr AnalyticFunctioncGd|_|j|7_dSr.)r?r>)r2r@r0r0r3filterzAggregateFunction.filterrrrLcCs&|jrt|j|}d|SdS)NzWHERE )r?rurr>r)r2r criterionsr0r0r3get_filter_sqls z AggregateFunction.get_filter_sqlcs0t|}||}|jr|dj|d7}|S)Nz FILTER({filter_sql})) filter_sql)rr8rFr?r)r2rr,rGrr0r3r8s  z"AggregateFunction.get_function_sql)r-rF)r@r r-rAr) r?r@rAr,rJrrCrFr8rr0r0rr3r<s  r<csdeZdZdZdZdfd d ZedddZed ddZd!ddZ d"ddZ d"fdd Z Z S)#rAFTrrLrr r4r-rFcs<tj|g|Ri|g|_g|_g|_d|_d|_dSr=)rrJr> _partition _orderbysr? _include_overr.rr0r3rJs  zAnalyticFunction.__init__r~r&cGrBr.)rJrHr2r~r0r0r3overrDzAnalyticFunction.overcs&d|_|jfdd|D7_dS)NTcsg|] }|dfqS)order)rrr4r0r3r< sz,AnalyticFunction.orderby..)rJrI)r2r~r4r0rNr3orderbys zAnalyticFunction.orderbyrerTorient Order | NonerrcCs(|dur ||Sdj|||jdS)Nz{field} {orient})rerP)rrr{)r2rerPrr0r0r3_orderby_field s  zAnalyticFunction._orderby_fieldcslg}jr|djdfddjDdjr1|djdfddjDdd |S) NzPARTITION BY {args}r>c3s,|]}t|dr|nt|VqdS)rN)r2rrLr&rr0r3rs z5AnalyticFunction.get_partition_sql..r0zORDER BY {orderby}c3s"|] \}}||VqdSr/)rR)r9rerPr5r0r3r#s )rOr )rHr rrArI)r2rr~r0r5r3get_partition_sqls$ z"AnalyticFunction.get_partition_sqlcs4t|}||}|}|jr|dj|d7}|S)Nz OVER({partition_sql})) partition_sql)rr8rSrJr)r2rr:rTr,rr0r3r8+s  z!AnalyticFunction.get_function_sqlr;)r~r r-r&)r~r r4r r-r&)rerTrPrQrrr-rLr) r?r@rAr, is_analyticrJrrLrOrRrSr8rr0r0rr3rAs    rAEdgeT WindowFrameAnalyticFunction.EdgecsreZdZGdddZdfd d Zd ddZe d!d"ddZe d!d"ddZd#ddZ d$fdd Z Z S)%WindowFrameAnalyticFunctionc@s"eZdZd d ddZd d d ZdS)rWNr{str | int | Noner-rFcCrGr/rgr}r0r0r3rJ;rKz)WindowFrameAnalyticFunction.Edge.__init__rLcCsdj|jpd|jdS)Nz{value} {modifier} UNBOUNDED)r{modifier)rr{r[r1r0r0r3r>sz(WindowFrameAnalyticFunction.Edge.__str__r/)r{rYr-rFr)r?r@rArJrr0r0r0r3Edge:s r\rrLrr r4r-rFcs*tj|g|Ri|d|_d|_dSr/)rrJframer*r.rr0r3rJEs z$WindowFrameAnalyticFunction.__init__r]r* str | EdgeT and_bound EdgeT | NonecCs4|js|jr t||_|r||f|_dS||_dSr/)r]r*AttributeError)r2r]r*r_r0r0r3_set_frame_and_boundsJs z1WindowFrameAnalyticFunction._set_frame_and_boundsNr&cC|d||dS)NROWSrbr2r*r_r0r0r3rowsSz WindowFrameAnalyticFunction.rowscCrc)NRANGErerfr0r0r3rangeYrhz!WindowFrameAnalyticFunction.rangecCs:t|jtsdj|j|jdS|j\}}dj|j||dS)Nz{frame} {bound})r]r*z#{frame} BETWEEN {lower} AND {upper})r]rr)r8r*r^rr]rr0r0r3 get_frame_sql_s  z)WindowFrameAnalyticFunction.get_frame_sqlrrcs.t|}|js|js|Sdj||dS)Nz{over} {frame})rLr])rrSr]r*rrk)r2rrTrr0r3rSjs  z-WindowFrameAnalyticFunction.get_partition_sqlr;)r]rLr*r^r_r`r-rFr/)r*r^r_r`r-r&rr) r?r@rAr\rJrbrrgrjrkrSrr0r0rr3rX9s    rXcs6eZdZdfdd Zedd d ZdddZZS)IgnoreNullsAnalyticFunctionrrLrr r4r-rFcs$tj|g|Ri|d|_dSr=)rrJ _ignore_nullsr.rr0r3rJts z$IgnoreNullsAnalyticFunction.__init__r&cCrr.rmr1r0r0r3 ignore_nullsxrNz(IgnoreNullsAnalyticFunction.ignore_nullsrrrEcCs|jrdSdS)Nz IGNORE NULLSrnrr0r0r3r1|sz2IgnoreNullsAnalyticFunction.get_special_params_sqlr;r)rrr-rE)r?r@rArJrror1rr0r0rr3rlsrrlc @s|eZdZejdejdejdejdejdiZ gdZ gdZ e dZ          dd ddZd!ddZd"ddZdS)#IntervalINTERVAL '{expr} {unit}'zINTERVAL '{expr}' {unit}yearsmonthsdayshoursminutesseconds microseconds)YEARMONTHDAYHOURMINUTESECOND MICROSECONDz6(^0+\.)|(\.0+$)|(^[0\-.: ]+[\-: ])|([\-:. ][0\-.: ]+$)rNrsrfrtrurvrwrxryquartersweeksrDialects | Noner-rFc  Cs| |_d|_d|_d|_|r||_dS| r| |_dSt|j|j|||||||gD]#\} } } | rLt | }t || t ||jdurI| |_|dk|_| |_q)dS)NFr) rlargestsmallest is_negativerrzipunitslabelsrfsetattrabs)r2rsrtrurvrwrxryrrrunitlabelr{ int_valuer0r0r3rJs0   zInterval.__init__rLcCrr/rr1r0r0r3rrKzInterval.__str__rrc Cs |jdkr t|d}d}nkt|drt|d}d}n^t|dr't|d}d}nQdjt|dd t|d d t|d d t|d d t|d d t|dd t|dd d}|jd|}|jr]d|}|j|jkrm|jd|j}n |jdurud}n|j}|j |j dj||dS)NrryrQUARTERrWEEKzB{years}-{months}-{days} {hours}:{minutes}:{seconds}.{microseconds}rsrrtrurvrwrxrrrP-rr|rq)rr) rrr2r trim_patternrrr templatesrr)r2rrrr0r0r3rs:                zInterval.get_sql) rrrrrrrrrN)rsrfrtrfrurfrvrfrwrfrxrfryrfrrfrrfrrr-rFrr)r?r@rArrrVERTICArrrrrrecompilerrJrrr0r0r0r3rps.   'rpc eZdZd d fd d ZZS)rNr rCexponentfloatrDrEr-rFctjd|||ddS)NPOWrHrp)r2r rrDrr0r3rJrz Pow.__init__r/)r rCrrrDrEr-rFrqr0r0rr3rrrrcr)rNr rCmodulusrrDrEr-rFcr)NMODrHrp)r2r rrDrr0r3rJrz Mod.__init__r/)r rCrrrDrEr-rFrqr0r0rr3rrrrcr)Rollupr~r r-rFcstjdg|RdS)NROLLUPrprKrr0r3rJrzRollup.__init__)r~r r-rFrqr0r0rr3rrrcs,eZdZdZd fdd Zd d d ZZS) PseudoColumnz Represents a pseudo column (a "column" which yields a value when selected but is not actually a real table column). rrLr-rFcstjdd||_dSrr)r2rrr0r3rJrzPseudoColumn.__init__rrcCs|jSr/)rrr0r0r3rrzPseudoColumn.get_sql)rrLr-rFr)r?r@rArrJrrr0r0rr3rsrcs>eZdZUdZdZded< ddfdd ZdddZZS) AtTimezonez| Generates AT TIME ZONE SQL. Examples: AT TIME ZONE 'US/Eastern' AT TIME ZONE INTERVAL '-06:00' Nr+r,FrerfzonerLintervalrgrDrEr-rFcs4t|t|tst|n||_||_||_dSr/)rrJr8rTrerr)r2rerrrDrr0r3rJs  zAtTimezone.__init__rrcCs2dj|j||jr dnd|jd}t||j|S)Nz&{name} AT TIME ZONE {interval}'{zone}'z INTERVAL rP)rrr)rrerrrrrDrGr0r0r3rs   zAtTimezone.get_sql)FN) rerfrrLrrgrDrEr-rFr) r?r@rArr,rBrJrrr0r0rr3rs  r)c __future__rrr'rsysr$collections.abcrrrdatetimerrenumrtypingr r r r r contextrrenumsrrrrrrrrr exceptionsrrutilsrrrrr rer!r"r# version_infor&typing_extensionsr'r(r)rCrrrr`rhrdrjr[rsrurrTrrr_r]rrrqrrrrrr|rurvrrrxrr r#r<rArVrXrlrprrrrrr0r0r0r3s  ,     f$% B^   2 #>@I8 # xL2H @:c