U
|
¸ý°dÇa ã @ sr d dl Z ddlmZ ddlmZ ddlmZ G dd dZG dd d eejZG d
|
d d eej Z
|
G d d d ej Z G dd dejej ZG dd deejZG dd deejZG dd deejZG dd deejZG dd deejZG dd de
|
ejZG d d d e
|
ejZG d d d e
|
ZG d d! d!e
|
ZG d"d# d#e
|
ejZG d$d% d%ejZG d&d' d'ejZG d(d) d)ej Z G d*d+ d+ej Z G d,d- d-ejZ G d.d/ d/e ej Z G d0d1 d1e Z G d2d3 d3e Z!G d4d5 d5e Z"G d6d7 d7e ej#Z#G d8d9 d9e ej$Z$G d:d; d;e ej%Z%G d<d= d=e ej&Z&G d>d? d?ej'Z(G d@dA dAej'Z)G dBdC dCej'Z*dS )Dé Né )Úexc)Úutil)Úsqltypesc s* e Zd ZdZd fdd Zdd Z ZS )Ú _NumericTypezvBase for MySQL numeric types.
|
|
This is the base both for NUMERIC as well as INTEGER, hence
|
it's a mixin.
|
|
Fc s || _ || _t jf | d S ©N)ÚunsignedÚzerofillÚsuperÚ__init__)Úselfr r Úkw©Ú __class__© úVd:\z\workplace\vscode\pyvenv\venv\Lib\site-packages\sqlalchemy/dialects/mysql/types.pyr s z_NumericType.__init__c C s t j| ttjgdS ©N)Z
|
to_inspect)r Ú generic_reprr r ZNumeric©r r r r Ú__repr__ s ÿz_NumericType.__repr__)FF©Ú__name__Ú
|
__module__Ú __qualname__Ú__doc__r r Ú __classcell__r r r r r s r c s& e Zd Zd fdd Zdd Z ZS )Ú
|
_FloatTypeNTc sZ t | ttfr8|d kr |d k s.|d k r8|d kr8t d¡t jf ||d| || _d S )NzBYou must specify both precision and scale or omit both altogether.)Ú precisionÚ asdecimal)Ú
|
isinstanceÚREALÚDOUBLEr Ú ArgumentErrorr
|
r Úscale©r r r# r r r r r r % s ÿÿþþÿz_FloatType.__init__c C s t j| tttjgdS r )r r r r r ÚFloatr r r r r 1 s
|
ÿz_FloatType.__repr__)NNT©r r r r r r r r r r r $ s r c s& e Zd Zd fdd Zdd Z ZS )Ú _IntegerTypeNc s || _ t jf | d S r )Ú display_widthr
|
r ©r r( r r r r r 8 s z_IntegerType.__init__c C s t j| tttjgdS r )r r r' r r ÚIntegerr r r r r < s
|
ÿz_IntegerType.__repr__)Nr& r r r r r' 7 s r' c s* e Zd ZdZd fdd Zdd Z ZS ) Ú _StringTypez Base for MySQL string types.NFc sD || _ | d| d|¡¡ || _|| _|| _|| _t jf | d S )NÚ collationZcollate) ÚcharsetÚ
|
setdefaultÚpopÚasciiÚunicodeÚbinaryÚnationalr
|
r )r r- r, r0 r2 r1 r3 r r r r r E s
|
z_StringType.__init__c C s t j| ttjgdS r )r r r+ r ÚStringr r r r r Z s ÿz_StringType.__repr__)NNFFFFr r r r r r+ B s ùr+ c @ s e Zd Zdd ZdS )Ú
|
_MatchTypec K s t j | ¡ t j | ¡ d S r )r r% r Ú MatchType)r r r r r r a s z_MatchType.__init__N)r r r r r r r r r5 ` s r5 c s& e Zd ZdZd Zd fdd Z ZS )ÚNUMERICzMySQL NUMERIC type.NTc s t jf |||d| dS )a# Construct a NUMERIC.
|
|
:param precision: Total digits in this number. If scale and precision
|
are both None, values are stored to limits allowed by the server.
|
|
:param scale: The number of digits after the decimal point.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
©r r# r N©r
|
r r$ r r r r l s ÿÿzNUMERIC.__init__)NNT©r r r r Ú__visit_name__r r r r r r r7 g s r7 c s& e Zd ZdZd Zd fdd Z ZS )ÚDECIMALzMySQL DECIMAL type.NTc s t jf |||d| dS )a# Construct a DECIMAL.
|
|
:param precision: Total digits in this number. If scale and precision
|
are both None, values are stored to limits allowed by the server.
|
|
:param scale: The number of digits after the decimal point.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r8 Nr9 r$ r r r r s ÿÿzDECIMAL.__init__)NNTr: r r r r r< s r< c s& e Zd ZdZd Zd fdd Z ZS )r! zMySQL DOUBLE type.NTc s t jf |||d| dS )a Construct a DOUBLE.
|
|
.. note::
|
|
The :class:`.DOUBLE` type by default converts from float
|
to Decimal, using a truncation that defaults to 10 digits.
|
Specify either ``scale=n`` or ``decimal_return_scale=n`` in order
|
to change this scale, or ``asdecimal=False`` to return values
|
directly as Python floating points.
|
|
:param precision: Total digits in this number. If scale and precision
|
are both None, values are stored to limits allowed by the server.
|
|
:param scale: The number of digits after the decimal point.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r8 Nr9 r$ r r r r s ÿÿzDOUBLE.__init__)NNTr: r r r r r! s r! c s& e Zd ZdZd Zd fdd Z ZS )r zMySQL REAL type.NTc s t jf |||d| dS )a Construct a REAL.
|
|
.. note::
|
|
The :class:`.REAL` type by default converts from float
|
to Decimal, using a truncation that defaults to 10 digits.
|
Specify either ``scale=n`` or ``decimal_return_scale=n`` in order
|
to change this scale, or ``asdecimal=False`` to return values
|
directly as Python floating points.
|
|
:param precision: Total digits in this number. If scale and precision
|
are both None, values are stored to limits allowed by the server.
|
|
:param scale: The number of digits after the decimal point.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r8 Nr9 r$ r r r r  s ÿÿz REAL.__init__)NNTr: r r r r r ½ s r c s. e Zd ZdZd Zd fdd Zdd Z ZS ) ÚFLOATzMySQL FLOAT type.NFc s t jf |||d| dS )a! Construct a FLOAT.
|
|
:param precision: Total digits in this number. If scale and precision
|
are both None, values are stored to limits allowed by the server.
|
|
:param scale: The number of digits after the decimal point.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r8 Nr9 r$ r r r r ä s ÿÿzFLOAT.__init__c C s d S r r )r Údialectr r r Úbind_processorø s zFLOAT.bind_processor)NNF)r r r r r; r r? r r r r r r= ß s r= c s& e Zd ZdZd Zd fdd Z ZS )ÚINTEGERzMySQL INTEGER type.Nc s t jf d|i| dS )a Construct an INTEGER.
|
|
:param display_width: Optional, maximum display width for this number.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r( Nr9 r) r r r r s zINTEGER.__init__)Nr: r r r r r@ ü s r@ c s& e Zd ZdZd Zd fdd Z ZS )ÚBIGINTzMySQL BIGINTEGER type.Nc s t jf d|i| dS )a Construct a BIGINTEGER.
|
|
:param display_width: Optional, maximum display width for this number.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r( Nr9 r) r r r r s zBIGINT.__init__)Nr: r r r r rA s rA c s& e Zd ZdZd Zd fdd Z ZS )Ú MEDIUMINTzMySQL MEDIUMINTEGER type.Nc s t jf d|i| dS )a Construct a MEDIUMINTEGER
|
|
:param display_width: Optional, maximum display width for this number.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r( Nr9 r) r r r r + s zMEDIUMINT.__init__)Nr: r r r r rB & s rB c s& e Zd ZdZd Zd fdd Z ZS )ÚTINYINTzMySQL TINYINT type.Nc s t jf d|i| dS )a Construct a TINYINT.
|
|
:param display_width: Optional, maximum display width for this number.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r( Nr9 r) r r r r @ s zTINYINT.__init__)Nr: r r r r rC ; s rC c s& e Zd ZdZd Zd fdd Z ZS )ÚSMALLINTzMySQL SMALLINTEGER type.Nc s t jf d|i| dS )a Construct a SMALLINTEGER.
|
|
:param display_width: Optional, maximum display width for this number.
|
|
:param unsigned: a boolean, optional.
|
|
:param zerofill: Optional. If true, values will be stored as strings
|
left-padded with zeros. Note that this does not effect the values
|
returned by the underlying database API, which continue to be
|
numeric.
|
|
r( Nr9 r) r r r r U s zSMALLINT.__init__)Nr: r r r r rD P s rD c @ s& e Zd ZdZd ZdddZdd ZdS )ÚBITzÀMySQL BIT type.
|
|
This type is for MySQL 5.0.3 or greater for MyISAM, and 5.0.5 or greater
|
for MyISAM, MEMORY, InnoDB and BDB. For older versions, use a
|
MSTinyInteger() type.
|
|
Nc C s
|
|| _ dS )zLConstruct a BIT.
|
|
:param length: Optional, number of bits.
|
|
N©Úlength)r rG r r r r p s z BIT.__init__c C s dd }|S )zãConvert a MySQL's 64 bit, variable length binary string to a long.
|
|
TODO: this is MySQL-db, pyodbc specific. OurSQL and mysqlconnector
|
already do this, so this logic should be moved to those dialects.
|
|
c S s< | d k r8d}| D ]"}t |ts&t|}|d> |B }q|S | S )Nr é )r ÚintÚord)ÚvalueÚvÚir r r Úprocess s
|
z%BIT.result_processor.<locals>.processr ©r r> ZcoltyperN r r r Úresult_processorx s
|
zBIT.result_processor)N)r r r r r; r rP r r r r rE e s
|
rE c s. e Zd ZdZd Zd fdd Zdd Z ZS ) ÚTIMEzMySQL TIME type.FNc s t j|d || _dS )aË Construct a MySQL TIME type.
|
|
:param timezone: not used by the MySQL dialect.
|
:param fsp: fractional seconds precision value.
|
MySQL 5.6 supports storage of fractional seconds;
|
this parameter will be used when emitting DDL
|
for the TIME type.
|
|
.. note::
|
|
DBAPI driver support for fractional seconds may
|
be limited; current support includes
|
MySQL Connector/Python.
|
|
©ÚtimezoneN©r
|
r Úfsp©r rS rU r r r r s z TIME.__init__c s t j fdd}|S )Nc sD | d k r<| j }| j}|d } |d |d ||d |dS d S d S )Né< )Ú microsecond)Ú microsecondsÚseconds)rK rY rZ Úminutes©Útimer r rN ¨ s
|
üz&TIME.result_processor.<locals>.process)Údatetimer] rO r r\ r rP ¥ s zTIME.result_processor)FN)r r r r r; r rP r r r r r rQ s rQ c s& e Zd ZdZd Zd fdd Z ZS )Ú TIMESTAMPzMySQL TIMESTAMP type.FNc s t j|d || _dS )a× Construct a MySQL TIMESTAMP type.
|
|
:param timezone: not used by the MySQL dialect.
|
:param fsp: fractional seconds precision value.
|
MySQL 5.6.4 supports storage of fractional seconds;
|
this parameter will be used when emitting DDL
|
for the TIMESTAMP type.
|
|
.. note::
|
|
DBAPI driver support for fractional seconds may
|
be limited; current support includes
|
MySQL Connector/Python.
|
|
rR NrT rV r r r r ¿ s zTIMESTAMP.__init__)FNr: r r r r r_ º s r_ c s& e Zd ZdZd Zd fdd Z ZS )ÚDATETIMEzMySQL DATETIME type.FNc s t j|d || _dS )aÕ Construct a MySQL DATETIME type.
|
|
:param timezone: not used by the MySQL dialect.
|
:param fsp: fractional seconds precision value.
|
MySQL 5.6.4 supports storage of fractional seconds;
|
this parameter will be used when emitting DDL
|
for the DATETIME type.
|
|
.. note::
|
|
DBAPI driver support for fractional seconds may
|
be limited; current support includes
|
MySQL Connector/Python.
|
|
rR NrT rV r r r r Ø s zDATETIME.__init__)FNr: r r r r r` Ó s r` c @ s e Zd ZdZd ZdddZdS )ÚYEARz<MySQL YEAR type, for single byte storage of years 1901-2155.Nc C s
|
|| _ d S r )r( )r r( r r r r ñ s z YEAR.__init__)N)r r r r r; r r r r r ra ì s ra c s& e Zd ZdZd Zd fdd Z ZS )ÚTEXTz0MySQL TEXT type, for text up to 2^16 characters.Nc s t jf d|i| dS )ac Construct a TEXT.
|
|
:param length: Optional, if provided the server may optimize storage
|
by substituting the smallest TEXT type sufficient to store
|
``length`` characters.
|
|
:param charset: Optional, a column-level character set for this string
|
value. Takes precedence to 'ascii' or 'unicode' short-hand.
|
|
:param collation: Optional, a column-level collation for this string
|
value. Takes precedence to 'binary' short-hand.
|
|
:param ascii: Defaults to False: short-hand for the ``latin1``
|
character set, generates ASCII in schema.
|
|
:param unicode: Defaults to False: short-hand for the ``ucs2``
|
character set, generates UNICODE in schema.
|
|
:param national: Optional. If true, use the server's configured
|
national character set.
|
|
:param binary: Defaults to False: short-hand, pick the binary
|
collation type that matches the column's character set. Generates
|
BINARY in schema. This does not affect the type of data stored,
|
only the collation of character data.
|
|
rG Nr9 )r rG r r r r r ú s z TEXT.__init__)Nr: r r r r rb õ s rb c s$ e Zd ZdZd Z fddZ ZS )ÚTINYTEXTz3MySQL TINYTEXT type, for text up to 2^8 characters.c s t jf | dS )a³ Construct a TINYTEXT.
|
|
:param charset: Optional, a column-level character set for this string
|
value. Takes precedence to 'ascii' or 'unicode' short-hand.
|
|
:param collation: Optional, a column-level collation for this string
|
value. Takes precedence to 'binary' short-hand.
|
|
:param ascii: Defaults to False: short-hand for the ``latin1``
|
character set, generates ASCII in schema.
|
|
:param unicode: Defaults to False: short-hand for the ``ucs2``
|
character set, generates UNICODE in schema.
|
|
:param national: Optional. If true, use the server's configured
|
national character set.
|
|
:param binary: Defaults to False: short-hand, pick the binary
|
collation type that matches the column's character set. Generates
|
BINARY in schema. This does not affect the type of data stored,
|
only the collation of character data.
|
|
Nr9 ©r Úkwargsr r r r s zTINYTEXT.__init__r: r r r r rc s rc c s$ e Zd ZdZd Z fddZ ZS )Ú
|
MEDIUMTEXTz6MySQL MEDIUMTEXT type, for text up to 2^24 characters.c s t jf | dS )aµ Construct a MEDIUMTEXT.
|
|
:param charset: Optional, a column-level character set for this string
|
value. Takes precedence to 'ascii' or 'unicode' short-hand.
|
|
:param collation: Optional, a column-level collation for this string
|
value. Takes precedence to 'binary' short-hand.
|
|
:param ascii: Defaults to False: short-hand for the ``latin1``
|
character set, generates ASCII in schema.
|
|
:param unicode: Defaults to False: short-hand for the ``ucs2``
|
character set, generates UNICODE in schema.
|
|
:param national: Optional. If true, use the server's configured
|
national character set.
|
|
:param binary: Defaults to False: short-hand, pick the binary
|
collation type that matches the column's character set. Generates
|
BINARY in schema. This does not affect the type of data stored,
|
only the collation of character data.
|
|
Nr9 rd r r r r > s zMEDIUMTEXT.__init__r: r r r r rf 9 s rf c s$ e Zd ZdZd Z fddZ ZS )ÚLONGTEXTz4MySQL LONGTEXT type, for text up to 2^32 characters.c s t jf | dS )a³ Construct a LONGTEXT.
|
|
:param charset: Optional, a column-level character set for this string
|
value. Takes precedence to 'ascii' or 'unicode' short-hand.
|
|
:param collation: Optional, a column-level collation for this string
|
value. Takes precedence to 'binary' short-hand.
|
|
:param ascii: Defaults to False: short-hand for the ``latin1``
|
character set, generates ASCII in schema.
|
|
:param unicode: Defaults to False: short-hand for the ``ucs2``
|
character set, generates UNICODE in schema.
|
|
:param national: Optional. If true, use the server's configured
|
national character set.
|
|
:param binary: Defaults to False: short-hand, pick the binary
|
collation type that matches the column's character set. Generates
|
BINARY in schema. This does not affect the type of data stored,
|
only the collation of character data.
|
|
Nr9 rd r r r r ^ s zLONGTEXT.__init__r: r r r r rg Y s rg c s& e Zd ZdZd Zd fdd Z ZS )ÚVARCHARz7MySQL VARCHAR type, for variable-length character data.Nc s t jf d|i| dS )a² Construct a VARCHAR.
|
|
:param charset: Optional, a column-level character set for this string
|
value. Takes precedence to 'ascii' or 'unicode' short-hand.
|
|
:param collation: Optional, a column-level collation for this string
|
value. Takes precedence to 'binary' short-hand.
|
|
:param ascii: Defaults to False: short-hand for the ``latin1``
|
character set, generates ASCII in schema.
|
|
:param unicode: Defaults to False: short-hand for the ``ucs2``
|
character set, generates UNICODE in schema.
|
|
:param national: Optional. If true, use the server's configured
|
national character set.
|
|
:param binary: Defaults to False: short-hand, pick the binary
|
collation type that matches the column's character set. Generates
|
BINARY in schema. This does not affect the type of data stored,
|
only the collation of character data.
|
|
rG Nr9 ©r rG re r r r r ~ s zVARCHAR.__init__)Nr: r r r r rh y s rh c s2 e Zd ZdZd Zd fdd Zedd Z ZS )ÚCHARz1MySQL CHAR type, for fixed-length character data.Nc s t jf d|i| dS )a¤ Construct a CHAR.
|
|
:param length: Maximum data length, in characters.
|
|
:param binary: Optional, use the default binary collation for the
|
national character set. This does not affect the type of data
|
stored, use a BINARY type for binary data.
|
|
:param collation: Optional, request a particular collation. Must be
|
compatible with the national character set.
|
|
rG Nr9 ri r r r r s z CHAR.__init__c C sV t |¡}t|t jr|S t|trFt|j|j|j|j|j |j
|
ddS t|jdS d S )NF)rG r- r, r0 r2 r1 r3 rF ) r Z to_instancer rj r+ rG r- r, r0 r2 r1 )r Útype_r r r Ú_adapt_string_for_cast s
|
|
ù
|
zCHAR._adapt_string_for_cast)N) r r r r r; r Ú classmethodrl r r r r r rj s
|
rj c s& e Zd ZdZd Zd fdd Z ZS )ÚNVARCHARzxMySQL NVARCHAR type.
|
|
For variable-length character data in the server's configured national
|
character set.
|
Nc s" d|d< t jf d|i| dS )a© Construct an NVARCHAR.
|
|
:param length: Maximum data length, in characters.
|
|
:param binary: Optional, use the default binary collation for the
|
national character set. This does not affect the type of data
|
stored, use a BINARY type for binary data.
|
|
:param collation: Optional, request a particular collation. Must be
|
compatible with the national character set.
|
|
Tr3 rG Nr9 ri r r r r Ë s zNVARCHAR.__init__)Nr: r r r r rn  s rn c s& e Zd ZdZd Zd fdd Z ZS )ÚNCHARzrMySQL NCHAR type.
|
|
For fixed-length character data in the server's configured national
|
character set.
|
Nc s" d|d< t jf d|i| dS )a¦ Construct an NCHAR.
|
|
:param length: Maximum data length, in characters.
|
|
:param binary: Optional, use the default binary collation for the
|
national character set. This does not affect the type of data
|
stored, use a BINARY type for binary data.
|
|
:param collation: Optional, request a particular collation. Must be
|
compatible with the national character set.
|
|
Tr3 rG Nr9 ri r r r r å s zNCHAR.__init__)Nr: r r r r ro Ü s ro c @ s e Zd ZdZd ZdS )ÚTINYBLOBz5MySQL TINYBLOB type, for binary data up to 2^8 bytes.N©r r r r r; r r r r rp ö s rp c @ s e Zd ZdZd ZdS )Ú
|
MEDIUMBLOBz8MySQL MEDIUMBLOB type, for binary data up to 2^24 bytes.Nrq r r r r rr ü s rr c @ s e Zd ZdZd ZdS )ÚLONGBLOBz6MySQL LONGBLOB type, for binary data up to 2^32 bytes.Nrq r r r r rs s rs )+r^ Ú r r Zsqlr r r% r r* r' r4 r+ r6 r5 r7 r< r! r r= r@ rA rB rC rD Z
|
TypeEnginerE rQ r_ r` ra rb rc rf rg rh rj rn ro Z_Binaryrp rr rs r r r r Ú<module>
|
sD "" (- $ )
|
