nk)R d dl Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ G d d
e Z G d d ej ej
e Z G d
de Z dS ) N ) _StringType )exc)sql)util)sqltypesc * e Zd Zd Zed ZdS )_EnumeratedValuesc | dd | _ | j dk rwt | rhd }|D ]\}t | dk r d| _ nF||d }t | dk s|d |k s |d |k r d| _ n]d| _ | j dk r6t j d| j j z | | }|| _ t d |D dgz }||fS )
Nquotingautor unquotedr quotedz|Manually quoting %s value literals is deprecated. Supply unquoted values and use the quoting= option in cases of ambiguity.c , g | ]}t | S )len).0vs x/builddir/build/BUILD/cloudlinux-venv-1.0.10/venv/lib64/python3.11/site-packages/sqlalchemy/dialects/mysql/enumerated.py
z2_EnumeratedValues._init_values../ s ---c!ff--- )
popr
r r warn_deprecated __class____name__
_strip_values_enumerated_valuesmax)selfvalueskwqelengths r _init_valuesz _EnumeratedValues._init_values s+ vvi00 <6 ! !c&kk !A
(
(q66Q;;#-DLEY!Aq66Q;;!A$!))quzz#-DLE 0: ( <8 # # #~ 67
''//F"( --f---344v~ r c g }|D ]`}|dd dk s|dd dk r-|dd |d dz |d }| | a|S )Nr r "'r )replaceappend)clsr" strip_valuesas r r z _EnumeratedValues._strip_values2 s{ # #A1v}}!A##
adGOOAaD1Had33 " " " "r N)r
__module__ __qualname__r' classmethodr r r r r r s? @ [ r r c V e Zd ZdZd ZdZd Zed Z fdZ fdZ
d Z xZ S )ENUMzMySQL ENUM type.Tc | dd | || t j | fd| j i| dS )a~ Construct an ENUM.
E.g.::
Column('myenum', ENUM("foo", "bar", "baz"))
:param enums: The range of valid values for this ENUM. Values will be
quoted when generating the schema according to the quoting flag (see
below). This object may also be a PEP-435-compliant enumerated
type.
.. versionadded: 1.1 added support for PEP-435-compliant enumerated
types.
:param strict: This flag has no effect.
.. versionchanged:: The MySQL ENUM type as well as the base Enum
type now validates all Python data values.
: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 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.
:param quoting: Defaults to 'auto': automatically determine enum value
quoting. If all enum values are surrounded by the same quoting
character, then use 'quoted' mode. Otherwise, use 'unquoted' mode.
'quoted': values in enums are already quoted, they will be used
directly when generating the schema - this usage is deprecated.
'unquoted': values in enums are not quoted, they will be escaped and
surrounded by single quotes when generating the schema.
Previous versions of this type always required manually quoted
values to be supplied; future versions will always quote the string
literals for you. This is a transitional option.
strictNr& )r
_enum_initr __init__r& )r! enumsr# s r r9 z
ENUM.__init__D sS j x r""" T<<$+<<<<<>>syyRyyr c | || \ }}t t | ||| S N)r' superr5 _setup_for_values)r! r" objectsr# r& r s r rD zENUM._setup_for_values s> **6266T4 2267BGGGr c d |dk r|S t t | | S )N )rC r5 _object_value_for_elem)r! elemr s r rH zENUM._object_value_for_elem s1
2::Kt$$;;DAA Ar c \ t j | t t t j g S )N)
to_inspect)r generic_reprr5 r r Enum)r! s r __repr__z
ENUM.__repr__ s* dK ?
r )
r r1 r2 __doc____visit_name__ native_enumr9 r3 r@ rD rH rN
__classcell__r s @r r5 r5 = s NK7= 7= 7=r [H H H H HB B B B B
r r5 c F e Zd ZdZd Z fdZd Z fdZ fdZd Z xZ
S )SETzMySQL SET type.c | dd | _ | || \ }}t | | _ | j sd|v rt j d | j rft d t | j D | _ | j
d t | j D | d| t t | j d i | dS )
a Construct a SET.
E.g.::
Column('myset', SET("foo", "bar", "baz"))
The list of potential values is required in the case that this
set will be used to generate DDL for a table, or if the
:paramref:`.SET.retrieve_as_bitwise` flag is set to True.
:param values: The range of valid values for this SET.
:param convert_unicode: Same flag as that of
:paramref:`.String.convert_unicode`.
:param collation: same as that of :paramref:`.String.collation`
:param charset: same as that of :paramref:`.VARCHAR.charset`.
:param ascii: same as that of :paramref:`.VARCHAR.ascii`.
:param unicode: same as that of :paramref:`.VARCHAR.unicode`.
:param binary: same as that of :paramref:`.VARCHAR.binary`.
:param quoting: Defaults to 'auto': automatically determine set value
quoting. If all values are surrounded by the same quoting
character, then use 'quoted' mode. Otherwise, use 'unquoted' mode.
'quoted': values in enums are already quoted, they will be used
directly when generating the schema - this usage is deprecated.
'unquoted': values in enums are not quoted, they will be escaped and
surrounded by single quotes when generating the schema.
Previous versions of this type always required manually quoted
values to be supplied; future versions will always quote the string
literals for you. This is a transitional option.
.. versionadded:: 0.9.0
:param retrieve_as_bitwise: if True, the data for the set type will be
persisted and selected using an integer value, where a set is coerced
into a bitwise mask for persistence. MySQL allows this mode which
has the advantage of being able to store values unambiguously,
such as the blank string ``''``. The datatype will appear
as the expression ``col + 0`` in a SELECT statement, so that the
value is coerced into an integer value in result sets.
This flag is required if one wishes
to persist a set that can store the blank string ``''`` as a value.
.. warning::
When using :paramref:`.mysql.SET.retrieve_as_bitwise`, it is
essential that the list of set values is expressed in the
**exact same order** as exists on the MySQL database.
.. versionadded:: 1.0.0
retrieve_as_bitwiseFrG zNCan't use the blank value '' in a SET without setting retrieve_as_bitwise=Truec 3 * K | ]\ }}|d |z fV dS r+ Nr r idxvalues r z SET.__init__.. s@ &0c5S! r c 3 * K | ]\ }}d |z |fV dS rY r rZ s r r] z SET.__init__.. s@ &0c5c5! r r& Nr )r rW r' tupler" r
ArgumentErrordict enumerate_bitmapupdater> rC rU r9 )r! r" r# r& r s r r9 z SET.__init__ s5 ~ $&66*?#G#G **6266Fmm ' B&LL#3
# 4=dk4J4J DL
L 4=dk4J4J
h'''!c4!''B'''''r c ~ | j r5t j t j |t j dz | S |S Nr )rW r type_coercer Integer)r! colexprs r column_expressionzSET.column_expression sA # ?)9::Q>
Nr c j r fd}n.t t || fd}|S )Nc | ;t | } t t j j j | S d S rB )intsetr map_bitsrc __getitem__)r\ r! s r processz%SET.result_processor..process s8 $ JJE t}T\-Eu M MNNN 4r c t | t j r/r | } t t j d| S | | d | S )Nz[^,]+rG )
isinstancer string_typesrn refindalldiscardr\
super_converts r rq z%SET.result_processor..process sh eT%677
!$ 5 -
e 4 4 rz(E : :;;; (
b))) Lr )rW rC rU result_processor)r! dialectcoltyperq ry r s ` @r rz zSET.result_processor so # !
"#t , , = =gw O OM
!
!
!
!
! r c t t | j r fd}nfd}|S )Nc | d S t | t j t j z rr | S | S d}| D ]}|j | z }|S rf )rs r int_typesrt rc )r\ int_valuer r! ry s r rq z#SET.bind_processor..process sr = 4 t~8I'IJJ %$ % ,}U 3 33 $ !I " 5 5!T\!_4 $$r c | .process* sU $Z4>D,==. .$ HHUOOE !(=/// Lr )rC rU bind_processorrW )r! r{ rq ry r s ` @r r zSET.bind_processor sp c4((77@@
# !
%
%
%
%
%
%
%
!
!
!
!
! r c L | j |d< t j | |g| j R i |S )NrW )rW r constructor_copyr" )r! impltyper# s r adaptz SET.adapt8 s5 $($< !$T8HdkHHHRHHHr ) r r1 r2 rO rP r9 rj rz r r rR rS s @r rU rU s NO( O( O( O( O(b : DI I I I I I Ir rU )
ru typesr rG r r r r r NativeForEmulatedrM r5 rU r r r r s
) ) ) ) ) ) ) ) X[
[
[
[
[
8 %x}6G [
[
[
|_I _I _I _I _I
_I _I _I _I _Ir