o ޭh @sddlmZmZddlmZmZGdddeZGdddeZGdddeZGd d d eZ Gd d d eZ Gd ddej Z GdddeZ GdddeZ GdddeZGdddeZGdddeZGdddeZdS)) SqlContext functions) AggregateFunctionc@eZdZdZejZdS)TrimzO Trims whitespace off edges of text. :samp:`Trim("{FIELD_NAME}")` N)__name__ __module__ __qualname____doc__rr database_funcr r W/var/www/html/stock_analysis/be/venv/lib/python3.10/site-packages/tortoise/functions.pyr  rc@r)LengthzJ Returns length of text/blob. :samp:`Length("{FIELD_NAME}")` N)rr r r rrr r r r rrrrc@r)Coalescezk Provides a default value if field is null. :samp:`Coalesce("{FIELD_NAME}", {DEFAULT_VALUE})` N)rr r r rrr r r r rrrrc@r)LowerzI Converts text to lower case. :samp:`Lower("{FIELD_NAME}")` N)rr r r rrr r r r rr(rrc@r)UpperzI Converts text to upper case. :samp:`Upper("{FIELD_NAME}")` N)rr r r rrr r r r rr2rrc@seZdZedefddZdS)_ConcatctxcCs>t|dr||jddnt|}|jjdkr|dS|S)Nget_sqlF) with_alias postgresqlz::text)hasattrrcopystrdialectvalue)argrsqlr r r get_arg_sql=s$  z_Concat.get_arg_sqlN)rr r staticmethodrr r r r rr<src@seZdZdZeZdS)Concatz Concate field or constant text. Be care, DB like sqlite3 has no support for `CONCAT`. :samp:`Concat("{FIELD_NAME}", {ANOTHER_FIELD_NAMES or CONSTANT_TEXT}, *args)` N)rr r r rr r r r rr"Gsr"c@r)CountzV Counts the no of entries for that column. :samp:`Count("{FIELD_NAME}")` N)rr r r rr#r r r r rr#Wrr#c@eZdZdZejZdZdS)SumzR Adds up all the values for that column. :samp:`Sum("{FIELD_NAME}")` TN)rr r r rr%r populate_field_objectr r r rr%ar%c@r$)MaxzO Returns largest value in the column. :samp:`Max("{FIELD_NAME}")` TN)rr r r rr(r r&r r r rr(lr'r(c@r$)MinzP Returns smallest value in the column. :samp:`Min("{FIELD_NAME}")` TN)rr r r rr)r r&r r r rr)wr'r)c@r$)Avgz^ Returns average (mean) of all values in the column. :samp:`Avg("{FIELD_NAME}")` TN)rr r r rr*r r&r r r rr*r'r*N)pypika_tortoiserrtortoise.expressionsrrrrrrrr"rr#r%r(r)r*r r r rs