U
|
¸ý°dP ã @ s d dl mZ d dlZd dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d dl
|
m Z d d
|
l mZ d d l mZ d d lmZ d ZdZdZG dd dej ej ZG dd dejZG dd deje ZeZ G dd deje Z e Z G dd deje Z e Z G dd deje Z!e!Z"G d d d eje Z#G d d d eje$ Z%G d d! d!eje Z&G d"d# d#eje Z'G d$d% d%eje Z(G d&d' d'ej)Z)G d(d) d)ej*Z*G d*d+ d+ej+ej,Z-e-Z.G d,d- d-eje$ Z/e/Z0G d.d/ d/eje Z1G d0d1 d1ej2Z3dS )2é )Ú annotationsN)ÚAny)ÚOptional)Úoverload)ÚType)Ú TYPE_CHECKING)ÚUUIDé )Úsqltypes)Útype_api)ÚLiteral)iÏ i¤ )i¼ i½ iý iþ )é é é é ií iï iø c @ sZ e Zd ZdZdZerVedddddddZedd d
|
ddd dZdd dd ddZdS )ÚPGUuidT.zPGUuid[_python_UUID]z Literal[True]ÚNone)ÚselfÚas_uuidÚreturnc C s d S ©N© ©r r r r ú[d:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/dialects/postgresql/types.pyÚ__init__ s zPGUuid.__init__z PGUuid[str]zLiteral[False]c C s d S r r r r r r r % s Úbool)r r c C s d S r r r r r r r ) s N).).)T)Ú__name__Ú
|
__module__Ú __qualname__Zrender_bind_castZrender_literal_castr r r r r r r r s ÿr c @ s e Zd Zd ZdS )ÚBYTEAN©r r r Ú__visit_name__r r r r r - s r c @ s e Zd Zd ZdS )ÚINETNr r r r r r" 1 s r" c @ s e Zd Zd ZdS )ÚCIDRNr r r r r r# 8 s r# c @ s e Zd Zd ZdS )ÚMACADDRNr r r r r r$ ? s r$ c @ s e Zd Zd ZdS )ÚMACADDR8Nr r r r r r% F s r% c @ s e Zd ZdZd ZdS )ÚMONEYa0 Provide the PostgreSQL MONEY type.
|
|
Depending on driver, result rows using this type may return a
|
string value which includes currency symbols.
|
|
For this reason, it may be preferable to provide conversion to a
|
numerically-based currency datatype using :class:`_types.TypeDecorator`::
|
|
import re
|
import decimal
|
from sqlalchemy import Dialect
|
from sqlalchemy import TypeDecorator
|
|
class NumericMoney(TypeDecorator):
|
impl = MONEY
|
|
def process_result_value(
|
self, value: Any, dialect: Dialect
|
) -> None:
|
if value is not None:
|
# adjust this for the currency and numeric
|
m = re.match(r"\$([\d.]+)", value)
|
if m:
|
value = decimal.Decimal(m.group(1))
|
return value
|
|
Alternatively, the conversion may be applied as a CAST using
|
the :meth:`_types.TypeDecorator.column_expression` method as follows::
|
|
import decimal
|
from sqlalchemy import cast
|
from sqlalchemy import TypeDecorator
|
|
class NumericMoney(TypeDecorator):
|
impl = MONEY
|
|
def column_expression(self, column: Any):
|
return cast(column, Numeric())
|
|
.. versionadded:: 1.2
|
|
N©r r r Ú__doc__r! r r r r r& M s +r& c @ s e Zd ZdZd ZdS )ÚOIDz Provide the PostgreSQL OID type.Nr' r r r r r) | s r) c @ s e Zd ZdZd ZdS )Ú REGCONFIGzLProvide the PostgreSQL REGCONFIG type.
|
|
.. versionadded:: 2.0.0rc1
|
|
Nr' r r r r r* s r* c @ s e Zd ZdZd ZdS )ÚTSQUERYzJProvide the PostgreSQL TSQUERY type.
|
|
.. versionadded:: 2.0.0rc1
|
|
Nr' r r r r r+ s r+ c @ s e Zd ZdZd ZdS )ÚREGCLASSzHProvide the PostgreSQL REGCLASS type.
|
|
.. versionadded:: 1.2.7
|
|
Nr' r r r r r, s r, c s0 e Zd ZdZd Zd
|
dddd fdd Z ZS ) Ú TIMESTAMPz&Provide the PostgreSQL TIMESTAMP type.FNr ú Optional[int]r ©ÚtimezoneÚ precisionr c s t j|d || _dS )zÆConstruct a TIMESTAMP.
|
|
:param timezone: boolean value if timezone present, default False
|
:param precision: optional integer precision value
|
|
.. versionadded:: 1.4
|
|
©r0 N©Úsuperr r1 ©r r0 r1 ©Ú __class__r r r ª s zTIMESTAMP.__init__)FN©r r r r( r! r Ú __classcell__r r r6 r r- ¤ s
|
ÿr- c s0 e Zd ZdZd Zd
|
dddd fdd Z ZS ) ÚTIMEzPostgreSQL TIME type.FNr r. r r/ c s t j|d || _dS )zÁConstruct a TIME.
|
|
:param timezone: boolean value if timezone present, default False
|
:param precision: optional integer precision value
|
|
.. versionadded:: 1.4
|
|
r2 Nr3 r5 r6 r r r ¿ s z TIME.__init__)FNr8 r r r6 r r: ¹ s
|
ÿr: c @ sx e Zd ZdZd ZdZddddddd Zed
|
d d d d dZe ddddZ
|
d dd
|
dddZ e ddddZ dS ) ÚINTERVALzPostgreSQL INTERVAL type.TNr. z Optional[str]r )r1 Úfieldsr c C s || _ || _dS )a Construct an INTERVAL.
|
|
:param precision: optional integer precision value
|
:param fields: string fields specifier. allows storage of fields
|
to be limited, such as ``"YEAR"``, ``"MONTH"``, ``"DAY TO HOUR"``,
|
etc.
|
|
.. versionadded:: 1.2
|
|
N)r1 r< )r r1 r< r r r r Õ s zINTERVAL.__init__zsqltypes.Intervalr )ÚintervalÚkwr c K s t |jdS )N)r1 )r; Úsecond_precision)Úclsr= r> r r r Úadapt_emulated_to_nativeå s z!INTERVAL.adapt_emulated_to_nativezType[sqltypes.Interval])r c C s t jS r )r
|
ÚInterval©r r r r Ú_type_affinityë s zINTERVAL._type_affinityFr )Úallow_nulltyper c C s t jd| jdS )NT)Únativer? )r
|
rB r1 )r rE r r r Ú
|
as_genericï s zINTERVAL.as_genericzType[dt.timedelta]c C s t jS r )ÚdtÚ timedeltarC r r r Ú python_typeò s zINTERVAL.python_type)NN)F) r r r r( r! rF r Ú classmethodrA ÚpropertyrD rG rJ r r r r r; Î s ÿr; c @ s$ e Zd Zd Zd ddddddZdS )
|
ÚBITNFr. r r )ÚlengthÚvaryingr c C s |r || _ n
|
|pd| _ || _d S )Né )rN rO )r rN rO r r r r ý s
|
z BIT.__init__)NF)r r r r! r r r r r rM ú s ÿrM c @ s e Zd ZdZd ZdS )ÚTSVECTORzçThe :class:`_postgresql.TSVECTOR` type implements the PostgreSQL
|
text search type TSVECTOR.
|
|
It can be used to do full text queries on natural language
|
documents.
|
|
.. seealso::
|
|
:ref:`postgresql_match`
|
|
Nr' r r r r rQ s rQ c @ s e Zd ZdZd ZdS )ÚCITEXTzFProvide the PostgreSQL CITEXT type.
|
|
.. versionadded:: 2.0.7
|
|
Nr' r r r r rR s rR )4Ú
|
__future__r ÚdatetimerH Útypingr r r r r Úuuidr Z _python_UUIDZsqlr
|
r Z util.typingr Z_DECIMAL_TYPESZ _FLOAT_TYPESZ
|
_INT_TYPESZ _UUID_RETURNr Z LargeBinaryr Z
|
TypeEngineÚstrr" ZPGInetr# ZPGCidrr$ Z PGMacAddrr% Z
|
PGMacAddr8r& Úintr) r* r+ r, r- r: ZNativeForEmulatedZ_AbstractIntervalr; Z
|
PGIntervalrM ZPGBitrQ ZTEXTrR r r r r Ú<module> sH / )
|
