관리-도구
편집 파일: json.cpython-37.pyc
B ��4]�& � @ s6 d dl mZ ddlmZ ddlmZ ddlmZ ddlmZ ddl m Z d Z e j e j Ze jd ed d d �Ze jd ed d d �Ze jded d d �Ze jded d d �Ze jded d d �Ze jded d d �Ze jded d d �ZG dd� dejj�Zeeejj< G dd� dej�Zeeej< eed< G dd� de�Zeed< dS ) � )�absolute_import� )�colspecs)� ischema_names� )�types)�util)� operators)�JSON�JSONBz->>T)� precedenceZnatural_self_precedentZeager_groupingz#>>�?z?&z?|z@>z<@c @ s e Zd Zdd� Zdd� ZdS )� JSONPathTypec s | � |�� � fdd�}|S )Nc s> t | tjj�st�dd� | D �}dd�|� } � r:� | �} | S )Nc S s g | ]}t �|��qS � )r � text_type)�.0�elemr r �V/opt/alt/python37/lib64/python3.7/site-packages/sqlalchemy/dialects/postgresql/json.py� <listcomp>M s z@JSONPathType.bind_processor.<locals>.process.<locals>.<listcomp>z{%s}z, )� isinstancer �collections_abc�Sequence�AssertionError�join)�value�tokens)� super_procr r �processK s z,JSONPathType.bind_processor.<locals>.process)Zstring_bind_processor)�self�dialectr r )r r �bind_processorH s zJSONPathType.bind_processorc s | � |�� � fdd�}|S )Nc s> t | tjj�st�dd� | D �}dd�|� } � r:� | �} | S )Nc S s g | ]}t �|��qS r )r r )r r r r r r Z s zCJSONPathType.literal_processor.<locals>.process.<locals>.<listcomp>z{%s}z, )r r r r r r )r r )r r r r X s z/JSONPathType.literal_processor.<locals>.process)Zstring_literal_processor)r r r r )r r �literal_processorU s z JSONPathType.literal_processorN)�__name__� __module__� __qualname__r r! r r r r r G s r c sB e Zd ZdZe�� Zd� fdd� ZG dd� dejj �Z e Z � Z S ) r a Represent the PostgreSQL JSON type. This type is a specialization of the Core-level :class:`.types.JSON` type. Be sure to read the documentation for :class:`.types.JSON` for important tips regarding treatment of NULL values and ORM use. .. versionchanged:: 1.1 :class:`.postgresql.JSON` is now a PostgreSQL- specific specialization of the new :class:`.types.JSON` type. The operators provided by the PostgreSQL version of :class:`.JSON` include: * Index operations (the ``->`` operator):: data_table.c.data['some key'] data_table.c.data[5] * Index operations returning text (the ``->>`` operator):: data_table.c.data['some key'].astext == 'some value' * Index operations with CAST (equivalent to ``CAST(col ->> ['some key'] AS <type>)``):: data_table.c.data['some key'].astext.cast(Integer) == 5 * Path index operations (the ``#>`` operator):: data_table.c.data[('key_1', 'key_2', 5, ..., 'key_n')] * Path index operations returning text (the ``#>>`` operator):: data_table.c.data[('key_1', 'key_2', 5, ..., 'key_n')].astext == 'some value' .. versionchanged:: 1.1 The :meth:`.ColumnElement.cast` operator on JSON objects now requires that the :attr:`.JSON.Comparator.astext` modifier be called explicitly, if the cast works only from a textual string. Index operations return an expression object whose type defaults to :class:`.JSON` by default, so that further JSON-oriented instructions may be called upon the result type. Custom serializers and deserializers are specified at the dialect level, that is using :func:`.create_engine`. The reason for this is that when using psycopg2, the DBAPI only allows serializers at the per-cursor or per-connection level. E.g.:: engine = create_engine("postgresql://scott:tiger@localhost/test", json_serializer=my_serialize_fn, json_deserializer=my_deserialize_fn ) When using the psycopg2 dialect, the json_deserializer is registered against the database using ``psycopg2.extras.register_default_json``. .. seealso:: :class:`.types.JSON` - Core level JSON type :class:`.JSONB` FNc s$ t t| �j|d� |dk r || _dS )a Construct a :class:`.JSON` type. :param none_as_null: if True, persist the value ``None`` as a SQL NULL value, not the JSON encoding of ``null``. Note that when this flag is False, the :func:`.null` construct can still be used to persist a NULL value:: from sqlalchemy import null conn.execute(table.insert(), data=null()) .. versionchanged:: 0.9.8 - Added ``none_as_null``, and :func:`.null` is now supported in order to persist a NULL value. .. seealso:: :attr:`.JSON.NULL` :param astext_type: the type to use for the :attr:`.JSON.Comparator.astext` accessor on indexed attributes. Defaults to :class:`.types.Text`. .. versionadded:: 1.1 )� none_as_nullN)�superr �__init__� astext_type)r r% r( )� __class__r r r' � s z JSON.__init__c @ s e Zd ZdZedd� �ZdS )zJSON.Comparatorz0Define comparison operations for :class:`.JSON`.c C sP t | jjjtjj�r0| jjjt | jj| jj d�S | jjjt | jj| jj d�S dS )a On an indexed expression, use the "astext" (e.g. "->>") conversion when rendered in SQL. E.g.:: select([data_table.c.data['some key'].astext]) .. seealso:: :meth:`.ColumnElement.cast` )� result_typeN) r �expr�right�type�sqltypesr r �left�operate�JSONPATH_ASTEXTr( �ASTEXT)r r r r �astext� s zJSON.Comparator.astextN)r" r# r$ �__doc__�propertyr3 r r r r � Comparator� s r6 )FN) r" r# r$ r4 r. �Textr( r' r r6 �comparator_factory� __classcell__r r )r) r r f s A r �jsonc @ s* e Zd ZdZd ZG dd� dej�ZeZdS )r a_ Represent the PostgreSQL JSONB type. The :class:`.JSONB` type stores arbitrary JSONB format data, e.g.:: data_table = Table('data_table', metadata, Column('id', Integer, primary_key=True), Column('data', JSONB) ) with engine.connect() as conn: conn.execute( data_table.insert(), data = {"key1": "value1", "key2": "value2"} ) The :class:`.JSONB` type includes all operations provided by :class:`.JSON`, including the same behaviors for indexing operations. It also adds additional operators specific to JSONB, including :meth:`.JSONB.Comparator.has_key`, :meth:`.JSONB.Comparator.has_all`, :meth:`.JSONB.Comparator.has_any`, :meth:`.JSONB.Comparator.contains`, and :meth:`.JSONB.Comparator.contained_by`. Like the :class:`.JSON` type, the :class:`.JSONB` type does not detect in-place changes when used with the ORM, unless the :mod:`sqlalchemy.ext.mutable` extension is used. Custom serializers and deserializers are shared with the :class:`.JSON` class, using the ``json_serializer`` and ``json_deserializer`` keyword arguments. These must be specified at the dialect level using :func:`.create_engine`. When using psycopg2, the serializers are associated with the jsonb type using ``psycopg2.extras.register_default_jsonb`` on a per-connection basis, in the same way that ``psycopg2.extras.register_default_json`` is used to register these handlers with the json type. .. versionadded:: 0.9.7 .. seealso:: :class:`.JSON` c @ s8 e Zd ZdZdd� Zdd� Zdd� Zdd � Zd d � Zd S ) zJSONB.Comparatorz0Define comparison operations for :class:`.JSON`.c C s | j t|tjd�S )zvBoolean expression. Test for presence of a key. Note that the key may be a SQLA expression. )r* )r0 �HAS_KEYr. �Boolean)r �otherr r r �has_key s zJSONB.Comparator.has_keyc C s | j t|tjd�S )zHBoolean expression. Test for presence of all keys in jsonb )r* )r0 �HAS_ALLr. r< )r r= r r r �has_all# s zJSONB.Comparator.has_allc C s | j t|tjd�S )zGBoolean expression. Test for presence of any key in jsonb )r* )r0 �HAS_ANYr. r< )r r= r r r �has_any( s zJSONB.Comparator.has_anyc K s | j t|tjd�S )z�Boolean expression. Test if keys (or array) are a superset of/contained the keys of the argument jsonb expression. )r* )r0 �CONTAINSr. r< )r r= �kwargsr r r �contains- s zJSONB.Comparator.containsc C s | j t|tjd�S )z|Boolean expression. Test if keys are a proper subset of the keys of the argument jsonb expression. )r* )r0 � CONTAINED_BYr. r< )r r= r r r � contained_by3 s z JSONB.Comparator.contained_byN) r" r# r$ r4 r> r@ rB rE rG r r r r r6 s r6 N)r" r# r$ r4 Z__visit_name__r r6 r8 r r r r r � s *!r ZjsonbN)� __future__r �baser r � r r. r Zsqlr �__all__Z _PRECEDENCEZjson_getitem_opZidx_precedenceZ custom_opr2 r1 r; r? rA rC rF r r r r r r r �<module> sd R