|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/ |
Upload File : |
�
���\c @ s� d d l Z d d l m Z d d l m Z d d l m Z d d l m Z d d l m
Z d d l m Z d* Z
e j e j Z e j d d
e d e d e �Z e j d d
e d e d e �Z e j d d
e d e d e �Z e j d d
e d e d e �Z e j d d
e d e d e �Z e j d d
e d e d e �Z d
e j e j e j f d � � YZ e e d <d e j f d � � YZ d e j f d � � YZ d e j f d � � YZ d e j f d � � YZ! d e j f d � � YZ" d e j f d � � YZ# d! e j f d" � � YZ$ d# e j f d$ � � YZ% e j& d% e j' � Z( e j& d& e j' � Z) d' � Z* d( � Z+ d) � Z, d S(+ i����Ni ( t ARRAY( t
ischema_namesi ( t types( t util( t functions( t operatorst HSTOREt hstores ->t
precedencet natural_self_precedentt eager_groupingt ?s ?&s ?|s @>s <@c B so e Z d Z d Z e Z e j � Z d d � Z
d e j j e j
j f d � � YZ e Z d � Z d � Z RS( st Represent the PostgreSQL HSTORE type.
The :class:`.HSTORE` type stores dictionaries containing strings, e.g.::
data_table = Table('data_table', metadata,
Column('id', Integer, primary_key=True),
Column('data', HSTORE)
)
with engine.connect() as conn:
conn.execute(
data_table.insert(),
data = {"key1": "value1", "key2": "value2"}
)
:class:`.HSTORE` provides for a wide range of operations, including:
* Index operations::
data_table.c.data['some key'] == 'some value'
* Containment operations::
data_table.c.data.has_key('some key')
data_table.c.data.has_all(['one', 'two', 'three'])
* Concatenation::
data_table.c.data + {"k1": "v1"}
For a full list of special methods see
:class:`.HSTORE.comparator_factory`.
For usage with the SQLAlchemy ORM, it may be desirable to combine
the usage of :class:`.HSTORE` with :class:`.MutableDict` dictionary
now part of the :mod:`sqlalchemy.ext.mutable`
extension. This extension will allow "in-place" changes to the
dictionary, e.g. addition of new keys or replacement/removal of existing
keys to/from the current dictionary, to produce events which will be
detected by the unit of work::
from sqlalchemy.ext.mutable import MutableDict
class MyClass(Base):
__tablename__ = 'data_table'
id = Column(Integer, primary_key=True)
data = Column(MutableDict.as_mutable(HSTORE))
my_object = session.query(MyClass).one()
# in-place mutation, requires Mutable extension
# in order for the ORM to detect
my_object.data['some_key'] = 'some value'
session.commit()
When the :mod:`sqlalchemy.ext.mutable` extension is not used, the ORM
will not be alerted to any changes to the contents of an existing
dictionary, unless that dictionary value is re-assigned to the
HSTORE-attribute itself, thus generating a change event.
.. seealso::
:class:`.hstore` - render the PostgreSQL ``hstore()`` function.
R c C s | d k r | | _ n d S( s� Construct a new :class:`.HSTORE`.
:param text_type: the type that should be used for indexed values.
Defaults to :class:`.types.Text`.
.. versionadded:: 1.1.0
N( t Nonet text_type( t selfR
( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt __init__� s t
Comparatorc B s� e Z d Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z d � Z
d � Z d
� Z d � Z
d � Z d
� Z RS( s2 Define comparison operations for :class:`.HSTORE`.c C s | j t | d t j �S( sv Boolean expression. Test for presence of a key. Note that the
key may be a SQLA expression.
t result_type( t operatet HAS_KEYt sqltypest Boolean( R t other( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt has_key� s c C s | j t | d t j �S( sH Boolean expression. Test for presence of all keys in jsonb
R ( R t HAS_ALLR R ( R R ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt has_all� s c C s | j t | d t j �S( sG Boolean expression. Test for presence of any key in jsonb
R ( R t HAS_ANYR R ( R R ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt has_any� s c K s | j t | d t j �S( s� Boolean expression. Test if keys (or array) are a superset
of/contained the keys of the argument jsonb expression.
R ( R t CONTAINSR R ( R R t kwargs( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt contains� s c C s | j t | d t j �S( s| Boolean expression. Test if keys are a proper subset of the
keys of the argument jsonb expression.
R ( R t CONTAINED_BYR R ( R R ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt contained_by� s c C s t | | j j f S( N( t GETITEMt typeR
( R t index( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt _setup_getitem� s c C s t | j | � S( s� Boolean expression. Test for presence of a non-NULL value for
the key. Note that the key may be a SQLA expression.
( t _HStoreDefinedFunctiont expr( R t key( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt defined� s c C s. t | t � r t | � } n t | j | � S( s� HStore expression. Returns the contents of this hstore with the
given key deleted. Note that the key may be a SQLA expression.
( t
isinstancet dictt _serialize_hstoret _HStoreDeleteFunctionR& ( R R' ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt delete� s c C s t | j | � S( sd HStore expression. Returns a subset of an hstore defined by
array of keys.
( t _HStoreSliceFunctionR& ( R t array( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt slice� s c C s
t | j � S( s. Text array expression. Returns array of keys.( t _HStoreKeysFunctionR& ( R ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt keys� s c C s
t | j � S( s0 Text array expression. Returns array of values.( t _HStoreValsFunctionR& ( R ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt vals� s c C s
t | j � S( s^ Text array expression. Returns array of alternating keys and
values.
( t _HStoreArrayFunctionR& ( R ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR/ � s c C s
t | j � S( s< Text array expression. Returns array of [key, value] pairs.( t _HStoreMatrixFunctionR& ( R ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt matrix� s ( t __name__t
__module__t __doc__R R R R R R$ R( R- R0 R2 R4 R/ R7 ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR � s c s1 t j r$ | j � � f d � } n d � } | S( Nc s* t | t � r" t | � j � � S| Sd S( N( R) R* R+ t encode( t value( t encoding( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt process� s c S s! t | t � r t | � S| Sd S( N( R) R* R+ ( R< ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR> � s
( R t py2kR= ( R t dialectR> ( ( R= sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt bind_processor� s
c s1 t j r$ | j � � f d � } n d � } | S( Nc s' | d k r t | j � � � S| Sd S( N( R t
_parse_hstoret decode( R< ( R= ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR> � s c S s | d k r t | � S| Sd S( N( R RB ( R< ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR> s
( R R? R= ( R R@ t coltypeR> ( ( R= sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt result_processor� s
N( R8 R9 R: t __visit_name__t Falset hashableR t TextR
R R t IndexableR t Concatenablet comparator_factoryRA RE ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR A s E "K c B s e Z d Z e Z d Z RS( s_ Construct an hstore value within a SQL expression using the
PostgreSQL ``hstore()`` function.
The :class:`.hstore` function accepts one or two arguments as described
in the PostgreSQL documentation.
E.g.::
from sqlalchemy.dialects.postgresql import array, hstore
select([hstore('key1', 'value1')])
select([
hstore(
array(['key1', 'key2', 'key3']),
array(['value1', 'value2', 'value3'])
)
])
.. seealso::
:class:`.HSTORE` - the PostgreSQL ``HSTORE`` datatype.
R ( R8 R9 R: R R" t name( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR s R% c B s e Z e j Z d Z RS( R( ( R8 R9 R R R" RM ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR% 0 s R, c B s e Z e Z d Z RS( R- ( R8 R9 R R" RM ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR, 5 s R. c B s e Z e Z d Z RS( R0 ( R8 R9 R R" RM ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR. : s R1 c B s e Z e e j � Z d Z RS( t akeys( R8 R9 R R RI R" RM ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR1 ? s R3 c B s e Z e e j � Z d Z RS( t avals( R8 R9 R R RI R" RM ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR3 D s R5 c B s e Z e e j � Z d Z RS( t hstore_to_array( R8 R9 R R RI R" RM ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR5 I s R6 c B s e Z e e j � Z d Z RS( t hstore_to_matrix( R8 R9 R R RI R" RM ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR6 N s s�
(
"(?P<key> (\\ . | [^"])* )" # Quoted key
)
[ ]* => [ ]* # Pair operator, optional adjoining whitespace
(
(?P<value_null> NULL ) # NULL value
| "(?P<value> (\\ . | [^"])* )" # Quoted value
)
s
[ ]* , [ ]*
c C s� d } t | � } | t | | d d � t | | � !} | t | | � t | | d | � !} t | � | k r� d | d } n t | � | k r� | d d } n d | | | f S( s format an unmarshalling error.i i i s [...]i����s5 After %r, could not parse residual at position %d: %r( t lent maxt min( t
hstore_strt post ctxt hslent parsed_tailt residual( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt _parse_errorq s ''c C s! i } d } t j | � } x� | d k r� | j d � j d d � j d d � } | j d � ri d } n' | j d � j d d � j d d � } | | | <| | j � 7} t j | | � } | d k r� | | j � 7} n t j | | � } q W| t | � k r t t | | � � � n | S(
s� Parse an hstore from its literal string representation.
Attempts to approximate PG's hstore input parsing rules as closely as
possible. Although currently this is not strictly necessary, since the
current implementation of hstore's output syntax is stricter than what it
accepts as input, the documentation makes no guarantees that will always
be the case.
i R' s \"t "s \\s \t
value_nullR< N(
t HSTORE_PAIR_REt matchR t groupt replacet endt HSTORE_DELIMITER_RERR t
ValueErrorR[ ( RU t resultRV t
pair_matchR' R< t delim_match( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyRB � s& '
c s, d � � d j � f d � | j � D� � S( sx Serialize a dictionary into an hstore literal. Keys and values must
both be strings (except None for values).
c S sh | d k r | d k r d St | t j � rN d | j d d � j d d � St d | | f � � d S( NR< t NULLs "%s"s \s \\R\ s \"s" %r in %s position is not a string.( R R) R t string_typesRa Rd ( t st position( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt esc� s s , c 3 s7 | ]- \ } } d � | d � � | d � f Vq d S( s %s=>%sR' R< N( ( t .0t kt v( Rl ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pys <genexpr>� s ( t joint items( t val( ( Rl sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyR+ � s
( s HSTOREs hstore(- t reR/ R t baseR t R R R t sqlR t sqlfuncR t __all__t _PRECEDENCEt json_getitem_opt idx_precedencet custom_opt TrueR! R R R R R RJ RK t
TypeEngineR t GenericFunctionR R% R, R. R1 R3 R5 R6 t compilet VERBOSER^ Rc R[ RB R+ ( ( ( sK /usr/lib64/python2.7/site-packages/sqlalchemy/dialects/postgresql/hstore.pyt <module> sr %�
*