K:g UdZddlZddlZddlZddlmZddlmZddlm Z m Z m Z m Z m Z mZmZddlmZddlmZddlmZdd lmZdd lmZmZGd d ZGd deZGddeZGddeZGddeZGddeZ GddeZ!GddeZ"GddeZ#eee e!e"e#fDcic]}|jH|c}Z%GddeZ&deee efd e d!e&fd"Z'deee efd e d!e&fd#Z(dd$e ed e d!e&fd%Z)d&d'd(ed)e*d!efd*Z+d+e d!efd,Z,d+e d!e-fd-Z.d+e-d!e-fd.Z/d+e-d!e-fd/Z0d0e-d!e-fd1Z1ee-e2e3e*eeeejhejf Z5ee6d2<Gd3d4eZ7 d+e5d!e7fd5Z8d6e5d7e5d!e7fd8Z9d!e7fd9Z:dd+e5d:e e5d!e7fd;Z;dZd+e5d@e5d!e7fdBZ?d!e7fdCZ@dDe5d6e5dEe5d!e7fdFZAdDe5d!e7fdGZBdHe5dIe5dEe5d!e7fdJZCddDe5dKe e5d!e7fdLZDddDe5dMe e5dNe e5d!e7fdOZEdDe5d!e7fdPZFdQe5d!e7fdRZGd!e7fdSZHd+e5d!e7fdTZIdUe5d!e7fdVZJd!e7fdWZKddXe5dYe5dZe e5d!e7fd[ZLdd+e5d:e e5d!e7fd\ZMdDe5d!e7fd]ZNd^e5d!e7fd_ZOd`e5dae5dbe5d!e7fdcZPd+e5d!e7fddZQdee5d!e7fdfZRdHe5dIe5d!e7fdgZSdHe5dIe5d!e7fdhZTdHe5dIe5die5d!e7fdjZUd e5d!e7fdkZVdle5dme5d!e7fdnZWdle5d!e7fdoZXdd6e5dpe e5d!e7fdqZYdle5d!e7fdrZZd6e5d7e5d!e7fdsZ[dle5dte5due5d!e7fdvZ\d6e5d7e5d!e7fdwZ]d^e5d!e7fdxZ^d+e5dye5d!e7fdzZ_dDe5d!e7fd{Z`d!e7fd|Zad+e5d!e7fd}Zbdpe5dUe5d!e7fd~Zcd!e7fdZddle5de5d!e7fdZedle5de5d!e7fdZfdle5de5de5d!e7fdZgdle5de5de5de5d!e7f dZhdle5d6e5d!e7fdZidle5dme5d!e7fdZjd+e5de5d!e7fdZkd+e5de5d!e7fdZld+e5de5d!e7fdZmddXe5dYe5dZe e5d!e7fdZnd^e5d!e7fdZodDe5de5d!e7fdZpdDe5de5d!e7fdZqd+e5d!e7fdZrddle5de5de5de e5d!e7f dZsd6e5d7e5d!e7fdZtd`e5de5de5de5d!e7f dZud+e5d!e7fdZvde5d!e7fdZwd!e7fdZxdDe5d!e7fdZydle5d!e7fdZzd!e7fdZ{dle5d!e7fdZ|d>> Formula("{Column} = 1") Formula('{Column} = 1') >>> str(_) '{Column} = 1' valuereturnNc||_yNrselfrs P/var/www/html/lionshead/venv/lib/python3.12/site-packages/pyairtable/formulas.py__init__zFormula.__init__#s  c|jSrrrs r__str__zFormula.__str__&s zzrcN|jjd|jdS)N()) __class____name__rrs r__repr__zFormula.__repr__)s$..))*!DJJ>;;rotherc,t|t|Sr)AND to_formularr's r__and__zFormula.__and__,4E*++rc,t|t|Sr)ORr*r+s r__or__zFormula.__or__/s$ 5)**rc,t|t|Sr)XORr*r+s r__xor__zFormula.__xor__2r-rc`t|t|sy|j|jk(SNF) isinstancetyperr+s r__eq__zFormula.__eq__5s&%d,{{djj((rct|Sr)NOTrs r __invert__zFormula.__invert__:s 4yrc|S)zP Return a new formula with nested boolean statements flattened. rs rflattenzFormula.flatten=s  r Comparisonct||S)zZ Build an :class:`~pyairtable.formulas.EQ` comparison using this formula. )EQrs reqz Formula.eqC$rct||S)zZ Build an :class:`~pyairtable.formulas.NE` comparison using this formula. )NErs rnez Formula.neIrCrct||S)zY Build a :class:`~pyairtable.formulas.GT` comparison using this formula. )GTrs rgtz Formula.gtOrCrct||S)zZ Build an :class:`~pyairtable.formulas.LT` comparison using this formula. )LTrs rltz Formula.ltUrCrct||S)zZ Build a :class:`~pyairtable.formulas.GTE` comparison using this formula. )GTErs rgtez Formula.gte[4rct||S)z[ Build an :class:`~pyairtable.formulas.LTE` comparison using this formula. )LTErs rltez Formula.ltearPr)rr)r% __module__ __qualname____doc__strrr r&rr,r0r3boolr8r;r>rBrFrIrLrOrSr=rrrrs cd<#<,S,Y,+C+I+,S,Y,)C)D)                rrceZdZdZdefdZy)Fieldz" Represents a field name. rc,t|jSr) field_namerrs rr z Field.__str__ms$**%%rN)r%rTrUrVrWr r=rrrZrZhs&&rrZc^eZdZUdZdZeeed<dedefdZ dede fd Z defd Z defd Z y ) r?zG Represents a logical condition that compares two expressions. operatorlvalrvalc||js"t|jjd||_||_y)Nz.operator is not defined)r_NotImplementedErrorr$r%r`rarr`ras rrzComparison.__init__xs<}}%>>**++CD   rr'rct|tsy|j|j|jf|j|j|jfk(Sr5)r6r?r`r_rar+s rr8zComparison.__eq__sI%, 4==$))4 JJ NN JJ9   rcd|j|jfD\}}t|jtrd|dn|}t|jtrd|dn|}||j|S)Nc32K|]}t|ywrto_formula_str.0vs r z%Comparison.__str__..sH1GAnQ'1Gr"r#)r`rar6r?r_rds rr zComparison.__str__slH$))TYY1GH d(J?4&{T(J?4&{T tf--rch|jjd|jd|jdS)Nr", r#)r$r%r`rars rr&zComparison.__repr__s...))*!DII=499-qIIrN)r%rTrUrVr_rrW__annotations__rrrXr8r r&r=rrr?r?qsW!Hhsm S C D .. J#Jrr?ceZdZdZdZy)rAz. Produces an ``lval = rval`` formula. =Nr%rTrUrVr_r=rrrArAHrrAceZdZdZdZy)rEz/ Produces an ``lval != rval`` formula. z!=Nrtr=rrrErEHrrEceZdZdZdZy)rHz. Produces an ``lval > rval`` formula. >Nrtr=rrrHrHrurrHceZdZdZdZy)rNz/ Produces an ``lval >= rval`` formula. z>=Nrtr=rrrNrNrwrrNceZdZdZdZy)rKz. Produces an ``lval < rval`` formula.  *d+j)J z?a IJ J  $rr'ct|tsy|j|jf|j|jfk(Sr5)r6rr_rr+s rr8zCompound.__eq__s6%* t/ENNEDTDT3UUUrcjdjd|jD}|jd|dS)Nrpc32K|]}t|ywr)rW)rkcs rrmz#Compound.__str__..s%Foc!fornr"r#)joinrr_)rjoined_componentss rr zCompound.__str__s4 II%Fdoo%FF--"3!4A66rcR|jdt|jdddS)Nr"r#)r_reprrrs rr&zCompound.__repr__s*--$t"7""=!>a@@rmemoc|r|n t}|jt|g}|jD]}t||vr t |t |t rE|j|jk(r,|j|j|jp|j|jt |j|S)zJ Reduces the depth of nested AND, OR, and NOT statements. )r) setaddidrrr6rr_extendr>append)rr flatteneditems rr>zCompound.flattenst D#% OOD$x4*400$)dmmt}}.L  4!8!C!CD  0 $ y11rfieldsct|}t|dk(r/t|dx}drt|tr|gn t|}|r&|j d|j D|||S)Nrr__iter__c3LK|]\}}tt||ywr)rArZ)rkkrls rrmz!Compound.build..sF~VaE!Ha~s"$)rrhasattrr6rWritems)clsr_rrrfirsts rbuildzCompound.buildsgZ  u:?wa'8u*E)%5UG4;E  LLFv||~F F8U##rr)r%rTrUrVrWrqrrrrrrXr8r r&r r intr> classmethodSelfTyperr=rrrrs MW  % %W% %  %VCVDV 77A#A2xC12Z2"$S$s$c$h$$rrrrrc4tjdg|i|S)z Join one or more logical conditions into an AND compound condition. Keyword arguments will be treated as field names. >>> AND(EQ("foo", 1), EQ(Field("bar"), 2), baz=3) AND(EQ('foo', 1), EQ(Field('bar'), 2), EQ(Field('baz'), 3)) r)rrrrs rr)r)s >>% 7* 7 77rc4tjdg|i|S)z Join one or more logical conditions into an OR compound condition. Keyword arguments will be treated as field names. >>> OR(EQ("foo", 1), EQ(Field("bar"), 2), baz=3) OR(EQ('foo', 1), EQ(Field('bar'), 2), EQ(Field('baz'), 3)) r/rrs rr/r/s >>$ 6 6v 66r componentc |jDcgc]\}}tt||}}}|r|j|t |x}dk7rt d|t jd|Scc}}w)a Wrap one logical condition in a negation compound. Keyword arguments will be treated as field names. Can be called with either a formula or with a single kewyord argument, but not both. >>> NOT(EQ("foo", 1)) NOT(EQ('foo', 1)) >>> NOT(foo=1) NOT(EQ(Field('foo'), 1)) If not called with exactly one condition, will throw an exception: >>> NOT(EQ("foo", 1), EQ("bar", 2)) Traceback (most recent call last): TypeError: NOT() takes from 0 to 1 positional arguments but 2 were given >>> NOT(EQ("foo", 1), bar=2) Traceback (most recent call last): ValueError: NOT() requires exactly one condition; got 2 >>> NOT(foo=1, bar=2) Traceback (most recent call last): ValueError: NOT() requires exactly one condition; got 2 >>> NOT() Traceback (most recent call last): ValueError: NOT() requires exactly one condition; got 0 rz*NOT() requires exactly one condition; got r:)rrArZrrrrr)rrrrlrcounts rr:r:sx@;A,,.I.ABuQxO.EI YU!EeWMNN >>% '' JsA=F) match_any field_valuesrc`g}|jD]\\}}t|tr t|dk(rt|d|d}}nt }|j |t||^t|dk(r tdt|dk(r|dS|rt|St|S)a  Create one or more equality expressions for each provided value, treating keys as field names and values as values (not formula expressions). If more than one assertion is included, the expressions are grouped together into using ``AND()`` (all values must match). If ``match_any=True``, expressions are grouped with ``OR()``. >>> match({"First Name": "John", "Age": 21}) AND(EQ(Field('First Name'), 'John'), EQ(Field('Age'), 21)) >>> match({"First Name": "John", "Age": 21}, match_any=True) OR(EQ(Field('First Name'), 'John'), EQ(Field('Age'), 21)) To use comparisons other than equality, use a 2-tuple of ``(operator, value)`` as the value for a particular field. For example: >>> match({"First Name": "John", "Age": (">=", 21)}) AND(EQ(Field('First Name'), 'John'), GTE(Field('Age'), 21)) If you need more advanced matching you can build formula expressions using lower level primitives. Args: field_values: mapping of column names to values (or to 2-tuples of the format ``(operator, value)``). match_any: If ``True``, matches if *any* of the provided values match. Otherwise, all values must match. rrzBmatch() requires at least one field-value pair or keyword argument) rr6tuplerCOMPARISONS_BY_OPERATORrArrZrr/r))rr expressionskeyvalcmps rmatchrAsD"$K &&(S c5 !c#h!m.s1v6ACC3uSz3/0 ) ;1 P   ;11~;  rrct|tr|St|tr|r tSt St|t t ttfrtt|St|trtt|St|tjrtt|St|tjrtt|Sddl}t||j"j$j&rt'|j(St+|t-|)a Converts the given value into a Formula object. When given a Formula object, it returns the object as-is: >>> to_formula(EQ(F.Formula("a"), "b")) EQ(Formula('a'), 'b') When given a scalar value, it simply wraps that value's string representation in a Formula object: >>> to_formula(1) Formula('1') >>> to_formula('foo') Formula("'foo'") Boolean and date values receive custom function calls: >>> to_formula(True) TRUE() >>> to_formula(False) FALSE() >>> to_formula(datetime.date(2023, 12, 1)) DATETIME_PARSE('2023-12-01') >>> to_formula(datetime.datetime(2023, 12, 1, 12, 34, 56)) DATETIME_PARSE('2023-12-01T12:34:56.000Z') rN)r6rrXTRUEFALSErfloatrrrWquoteddatetimeDATETIME_PARSErdaterpyairtable.ormormrrZr\ TypeErrorr7)r pyairtables rr*r*ws8%! %tv+EG+%#ugx89s5z""%ve}%%%**+1%899%'oe455%..445U%%&& E4; ''rc*tt|S)a Converts the given value into a string representation that can be used in an Airtable formula expression. >>> to_formula_str(EQ(F.Formula("a"), "b")) "a='b'" >>> to_formula_str(True) 'TRUE()' >>> to_formula_str(False) 'FALSE()' >>> to_formula_str(3) '3' >>> to_formula_str(3.5) '3.5' >>> to_formula_str(Decimal("3.14159265")) '3.14159265' >>> to_formula_str(Fraction("4/19")) '4/19' >>> to_formula_str("asdf") "'asdf'" >>> to_formula_str("Jane's") "'Jane\'s'" >>> to_formula_str(datetime.date(2023, 12, 1)) "DATETIME_PARSE('2023-12-01')" >>> to_formula_str(datetime.datetime(2023, 12, 1, 12, 34, 56)) "DATETIME_PARSE('2023-12-01T12:34:56.000Z')" )rWr*rs rriris8 z% !!rch|jddjdd}dj|S)z Wrap string in quotes. This is needed when referencing a string inside a formula. Quotes are escaped. >>> quoted("John") "'John'" >>> quoted("Guest's Name") "'Guest\\'s Name'" \z\\'\'z'{}')replaceformatrs rrrs0 MM$ & . .sE :E == rcltjdtdtjdd|}|S)ao Ensure any quotes are escaped. Already escaped quotes are ignored. This function has been deprecated. Use :func:`~pyairtable.formulas.quoted` instead. Args: value: text to be escaped Usage: >>> escape_quotes(r"Player's Name") "Player\\'s Name" >>> escape_quotes(r"Player\'s Name") "Player\\'s Name" z2escape_quotes is deprecated; use quoted() instead.r)category stacklevelz(?>> field_name("First Name") '{First Name}' >>> field_name("Guest's Name") "{Guest's Name}" z{%s}}z\})r)rs rr\r\s DLLe, ,,r FunctionArgcHeZdZdZdedefdZdedefdZ defdZ defd Z y ) FunctionCalla Represents a function call in an Airtable formula, and converts all arguments to that function into Airtable formula expressions. >>> FunctionCall("WEEKDAY", datetime.date(2024, 1, 1)) WEEKDAY(datetime.date(2024, 1, 1)) >>> str(_) "WEEKDAY(DATETIME_PARSE('2024-01-01'))" pyAirtable exports shortcuts like :meth:`~pyairtable.formulas.WEEKDAY` for all formula functions known at time of publishing. rargsc ||_||_yr)rr)rrrs rrzFunctionCall.__init__s  rr'rct|tsy|j|jf|j|jfk(Sr5)r6rrrr+s rr8zFunctionCall.__eq__!s4%. 499%%**ejj)AAArcjdjd|jD}|jd|dS)Nrpc32K|]}t|ywrrhrjs rrmz'FunctionCall.__str__..'sE9aq 19rnr"r#rrr)r joined_argss rr zFunctionCall.__str__&s1iiE499EE ))Ak]!,,rcjdjd|jD}|jd|dS)Nrpc32K|]}t|ywr)rrjs rrmz(FunctionCall.__repr__..+s$@iT!Wirnr"r#r)rjoined_args_reprs rr&zFunctionCall.__repr__*s499$@dii$@@))A./q11rN) r%rTrUrVrWrrrrXr8r r&r=rrrrsH SBCBDB --2#2rrctd|S)z% Returns the absolute value. ABSrrs rrrq u %%rnumbernumbersctd|g|S)z- Returns the average of the numbers. AVERAGErrrs rrrxs  6 4G 44rctdS)z Returns a blank value. BLANKrr=rrrr   r significancec,td|gd|fDS)z Returns the nearest integer multiple of significance that is greater than or equal to the value. If no significance is provided, a significance of 1 is assumed. CEILINGc3&K|] }|| ywrr=rjs rrmzCEILING..s+W~!A~rrrs rrrs  5 X+W ~+W XXrtexttextsctd|g|S)zE Joins together the text arguments into a single text value. CONCATENATEr)rrs rrrs  t 4e 44rctd|g|S)z, Count the number of numeric items. COUNTrrs rrrs  2' 22rvaluesctd|g|S)zb Count the number of non-empty values. This function counts both numeric and text values. COUNTArrrs rrrs % 1& 11rctd|g|S)zE Count the number of all elements including text and blanks. COUNTALLrrs rrrs  E 3F 33rctdS)z? Returns the date and time a given record was created. CREATED_TIMErr=rrrrs  ''rrunitsctd|||S)z Adds specified "count" units to a datetime. (See `list of shared unit specifiers `__. For this function we recommend using the full unit specifier for your desired unit.) DATEADDr)rrrs rrrs  4 77rctd|S)z8 Formats a datetime into a string (YYYY-MM-DD). DATESTRrrs rrr  4 ((rdate1date2ctd|||S)z Returns the difference between datetimes in specified units. The difference between datetimes is determined by subtracting [date2] from [date1]. This means that if [date2] is later than [date1], the resulting value will be negative. DATETIME_DIFFr)r r rs rrrs u ==r output_formatc,td|gd|fDS)a Formats a datetime into a specified string. See an `explanation of how to use this function with date fields `__ or a list of `supported format specifiers `__. DATETIME_FORMATc3&K|] }|| ywrr=rjs rrmz"DATETIME_FORMAT..s2_oQRQ^1orr)rrs rrrs )4 `2_}o2_ ``r input_formatlocalec.td|gd||fDS)z Interprets a text string as a structured date, with optional input format and locale parameters. The output format will always be formatted 'M/D/YYYY h:mm a'. rc3&K|] }|| ywrr=rjs rrmz!DATETIME_PARSE..s1e=SWXWd!=Srr)rrrs rrrs" ($ f1elF=S1e ffrctd|S)zZ Returns the day of the month of a datetime in the form of a number between 1-31. DAYrr s rrrs t $$rcomponent_stringctd|S)z Replaces certain characters with encoded equivalents for use in constructing URLs or URIs. Does not encode the following characters: ``-_.~`` ENCODE_URL_COMPONENTr)rs rrrs .0@ AArctdS)z6 Returns a generic Error value (``#ERROR!``). ERRORrr=rrrrrrctd|S)za Returns the smallest even integer that is greater than or equal to the specified value. EVENrrs rrr  &&rpowerctd|S)zA Computes **Euler's number** (e) to the specified power. EXPr)r!s rr#r#rrctdS)zG Logical value false. False is represented numerically by a 0. rrr=rrrrrrstring_to_findwhere_to_searchstart_from_positionc.td||gd|fDS)z Finds an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition.(startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be 0. FINDc3&K|] }|| ywrr=rjs rrmzFIND..sBuNcghgt1Ncrrr%r&r's rr)r)s"  vBuObNcBu vvrc,td|gd|fDS)z Returns the nearest integer multiple of significance that is less than or equal to the value. If no significance is provided, a significance of 1 is assumed. FLOORc3&K|] }|| ywrr=rjs rrmzFLOOR..s)U^q}!^rrrs rr-r-s  V)Ul^)U VVrctd|S)R Calculates the number of days between the current date and another date. FROMNOWrr s rr1r1 r rrctd|S)zZ Returns the hour of a datetime as a number between 0 (12:00am) and 23 (11:00pm). HOURrrs rr3r3s  ))r expressionif_trueif_falsectd|||S)z Returns value1 if the logical argument is true, otherwise it returns value2. Can also be used to make `nested IF statements `__. IFr)r5r6r7s rr9r9s j'8 <r>'r rctd||S)zQ Determines if [date1] is later than [date2]. Returns 1 if yes, 0 if no. IS_AFTERrr r s rr@r@.s  E5 11rctd||S)zS Determines if [date1] is earlier than [date2]. Returns 1 if yes, 0 if no. IS_BEFORErrAs rrCrC5s  UE 22runitctd|||S)zo Compares two dates up to a unit and determines whether they are identical. Returns 1 if yes, 0 if no. IS_SAMEr)r r rDs rrFrF<s  5% 66rctdg|S)zx Returns the date and time of the most recent modification made by a user in a non-computed field in the table. LAST_MODIFIED_TIMEr)rs rrHrHCs , 6v 66rstringhow_manyctd||S)zG Extract how many characters from the beginning of the string. LEFTrrIrJs rrLrLJs  11rctd|S)z) Returns the length of a string. LENrrIs rrOrOQs v &&rbasec,td|gd|fDS)zi Computes the logarithm of the value in provided base. The base defaults to 10 if not specified. LOGc3&K|] }|| ywrr=rjs rrmzLOG..\s(LFqamFrr)rrQs rrSrSXs v M(LTF(L MMrctd|S)z# Makes a string lowercase. LOWERrrPs rrVrV_  ((rctd|g|S)z3 Returns the largest of the given numbers. MAXrrs rrYrYf v 0 00rwhere_to_startrctd|||S)zK Extract a substring of count characters starting at whereToStart. MIDr)rIr[rs rr]r]ms v~u ==rctd|g|S)z4 Returns the smallest of the given numbers. MINrrs rr_r_trZrctd|S)zJ Returns the minute of a datetime as an integer between 0 and 59. MINUTErr4s rrara{ ( ++rdivisorctd||S)zP Returns the remainder after dividing the first argument by the second. MODr)rrcs rreres ug ..rctd|S)z\ Returns the month of a datetime as a number between 1 (January) and 12 (December). MONTHrr s rrgrg  &&rctdS)zY While similar to the TODAY() function, NOW() returns the current date AND time. NOWrr=rrrjrjs  rctd|S)zp Rounds positive value up the the nearest odd number and negative value down to the nearest odd number. ODDrrs rrlrlrrctd||S)z= Computes the specified base to the specified power. POWERr)rQr!s rrnrns u --rctdS)z/ Returns the ID of the current record. RECORD_IDrr=rrrprps  $$rregexctd||S)zH Returns the first substring that matches a regular expression. REGEX_EXTRACTrrIrqs rrsrss  77rctd||S)zF Returns whether the input text matches a regular expression. REGEX_MATCHrrts rrvrvs  vu 55r replacementctd|||S)zN Substitutes all matching substrings with a replacement string value. REGEX_REPLACEr)rIrqrws rryrys  DDrstart_characternumber_of_charactersc td||||S)zi Replaces the number of characters beginning with the start character with the replacement text. REPLACEr)rIrzr{rws rr}r}s  6?`__.) ROUNDrrrs rrrs  22rctd||S)z Rounds the value to the number of decimal places given by "precision," always `rounding down `__. ROUNDDOWNrrs rrrs  UI 66rctd||S)z Rounds the value to the number of decimal places given by "precision," always `rounding up `__. ROUNDUPrrs rrrs  5) 44rc.td||gd|fDS)z Searches for an occurrence of stringToFind in whereToSearch string starting from an optional startFromPosition. (startFromPosition is 0 by default.) If no occurrence of stringToFind is found, the result will be empty. SEARCHc3&K|] }|| ywrr=rjs rrmzSEARCH..sDwPe1ijivQPerrr+s rrrs" ./ xDwQdPeDw xxrctd|S)zJ Returns the second of a datetime as an integer between 0 and 59. SECONDrr4s rrrrbrlocale_modifierctd||S)z Sets a specific locale for a datetime. **Must be used in conjunction with DATETIME_FORMAT.** A list of supported locale modifiers can be found `here `__. SET_LOCALEr)rrs rrrs  dO <`__. SET_TIMEZONEr)rrs rrrs m <.sChw!Z[ZgAwrr)rIrrrs rrrs#  fh iChPUwCh iirctd|g|S)zI Sum together the numbers. Equivalent to number1 + number2 + ... SUMrrs rrrrZrpatternresultpattern_resultsc td|||g|S)a Takes an expression, a list of possible values for that expression, and for each one, a value that the expression should take in that case. It can also take a default value if the expression input doesn't match any of the defined patterns. In many cases, SWITCH() can be used instead `of a nested IF() formula `__. SWITCHr)r5rrrs rrrs *gv P PPrctd|S)zA Returns the argument if it is text and blank otherwise. Trrs rrr#s U ##r timestampctd|S)z@ Formats a datetime into a time-only string (HH:mm:ss). TIMESTRr)rs rrr*s  9 --rctdS)z While similar to the NOW() function: TODAY() returns the current date (not the current time, if formatted, time will return 12:00am). TODAYrr=rrrr1rrctd|S)r0TONOWrr s rrr8rhrctd|S)z@ Removes whitespace at the beginning and end of string. TRIMrrPs rrr?s  ''rctdS)zR Logical value true. The value of true is represented numerically by a 1. rrr=rrrrFs  rctd|S)z! Makes string uppercase. UPPERrrPs rrrMrWrctd|S)u$ Converts the text string to a number. Some exceptions apply—if the string contains certain mathematical operators(-,%) the result may not return as expected. In these scenarios we recommend using a combination of VALUE and REGEX_REPLACE to remove non-digit values from the string: VALUEr)rs rrrTrhrstart_day_of_weekc,td|gd|fDS)z Returns the day of the week as an integer between 0 (Sunday) and 6 (Saturday). You may optionally provide a second argument (either ``"Sunday"`` or ``"Monday"``) to start weeks on that day. If omitted, weeks start on Sunday by default. WEEKDAYc3&K|] }|| ywrr=rjs rrmzWEEKDAY.._*[6IQ]16Irrrrs rrr[   4 \*[7H6I*[ \\rc,td|gd|fDS)z Returns the week number in a year. You may optionally provide a second argument (either ``"Sunday"`` or ``"Monday"``) to start weeks on that day. If omitted, weeks start on Sunday by default. WEEKNUMc3&K|] }|| ywrr=rjs rrmzWEEKNUM..frrrrs rrrbrr start_datenum_daysholidaysc.td||gd|fDS)z Returns a date that is numDays working days after startDate. Working days exclude weekends and an optional list of holidays, formatted as a comma-separated string of ISO-formatted dates. WORKDAYc3&K|] }|| ywrr=rjs rrmzWORKDAY..ms:bjTUTa1jrr)rrrs rrris   :x c:bxj:b ccrend_datec.td||gd|fDS)z Counts the number of working days between startDate and endDate. Working days exclude weekends and an optional list of holidays, formatted as a comma-separated string of ISO-formatted dates. WORKDAY_DIFFc3&K|] }|| ywrr=rjs rrmzWORKDAY_DIFF..ts?g:aYZYf:rr)rrrs rrrps   H h?gH:?g hhrrctd|g|S)zB Returns true if an **odd** number of arguments are true. r2r)r5rs rr2r2ws z 8K 88rctd|S)z4 Returns the four-digit year of a datetime. YEARrr s rrr~s  %%rr)NN)rVrrrdecimalr fractionsrtypingrrrrr r r typing_extensionsr rr pyairtable.api.typesrpyairtable.exceptionsrpyairtable.utilsrrrrZr?rArErHrNrKrRr_rrr)r/r:rXrr*rWrirrr\rrrrrqrrrrrrrrrrrrrrrrrrrr#rr)r-r1r3r9r;r>r@rCrFrHrLrOrSrVrYr]r_rarergrjrlrnrprsrvryr}rrrrrrrrrrrrrrrrrrrrrrrrrr2r)rs0rrs  FFF.''6AN N b&G&JJD**:  #  #  2-S-S-&     MM   Y 272B> B&{&,&5K5k5l5!|!Y;Yh{.CYR^Y5k5k5l53+3K3L32+2;2<24K4[4\4(l(8+8{8;8l8)+)\)>>[>>T`>a+ah{6KaZfaggH[4IgZbcnZogKg%k%%B;BlB!|!' '<'&{&,&!|!ww{wYabmYnw~JwWWH[,AWP\W)+)\)*;*l*=;== =S_=&{&,&)+)\)2K2 2<23[33L37;7{7+7\77 7 722 2<2' '<'N N8K#8N|N)+)\)1 1+1,1> >[>>T`>1 1+1,1,[, ,/{/[/ /' '<'\&{&,&. .K.|.%<%8+8k886 6K6|6E+EkE E[gE_K_+_U`_oz_CO_00k003+33L3333L37[7[7 75;5;5l5y;yy[cdo[py@Ly,[, ,=[=;=l=={=;=l=' '<'j{jkj[jYabmYnj~Jj1 1+1,1Q{Q[Q+QdoQuAQ$[$ $.{.,.!|!' '<'((L( l )+)\)' '<']+](;2G]Vb]]+](;2G]Vb]d d{dh{F[djvdi[iKi8T_K`io{i9K9+9,9&{&,&wTs:Q2