관리-도구
편집 파일: api.cpython-37.opt-1.pyc
B �M!Vz9 � @ s� d Z ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ dd l Z d d � Z d d � Z ddd�Z dd� Z G dd� de�ZG dd� de�Zd S )zXProvide the 'autogenerate' feature which can produce migration operations automatically.� )�ops� )�render)�compare)�util� )� InspectorNc C s t | |�}|j�� S )a� Compare a database schema to that given in a :class:`~sqlalchemy.schema.MetaData` instance. The database connection is presented in the context of a :class:`.MigrationContext` object, which provides database connectivity as well as optional comparison functions to use for datatypes and server defaults - see the "autogenerate" arguments at :meth:`.EnvironmentContext.configure` for details on these. The return format is a list of "diff" directives, each representing individual differences:: from alembic.migration import MigrationContext from alembic.autogenerate import compare_metadata from sqlalchemy.schema import SchemaItem from sqlalchemy.types import TypeEngine from sqlalchemy import (create_engine, MetaData, Column, Integer, String, Table) import pprint engine = create_engine("sqlite://") engine.execute(''' create table foo ( id integer not null primary key, old_data varchar, x integer )''') engine.execute(''' create table bar ( data varchar )''') metadata = MetaData() Table('foo', metadata, Column('id', Integer, primary_key=True), Column('data', Integer), Column('x', Integer, nullable=False) ) Table('bat', metadata, Column('info', String) ) mc = MigrationContext.configure(engine.connect()) diff = compare_metadata(mc, metadata) pprint.pprint(diff, indent=2, width=20) Output:: [ ( 'add_table', Table('bat', MetaData(bind=None), Column('info', String(), table=<bat>), schema=None)), ( 'remove_table', Table(u'bar', MetaData(bind=None), Column(u'data', VARCHAR(), table=<bar>), schema=None)), ( 'add_column', None, 'foo', Column('data', Integer(), table=<foo>)), ( 'remove_column', None, 'foo', Column(u'old_data', VARCHAR(), table=None)), [ ( 'modify_nullable', None, 'foo', u'x', { 'existing_server_default': None, 'existing_type': INTEGER()}, True, False)]] :param context: a :class:`.MigrationContext` instance. :param metadata: a :class:`~sqlalchemy.schema.MetaData` instance. .. seealso:: :func:`.produce_migrations` - produces a :class:`.MigrationScript` structure based on metadata comparison. )�produce_migrations� upgrade_opsZas_diffs)�context�metadata�migration_script� r �I/opt/alt/python37/lib/python3.7/site-packages/alembic/autogenerate/api.py�compare_metadata s Z r c C s8 t | |d�}tjdt�g �t�g �d�}t�||� |S )a� Produce a :class:`.MigrationScript` structure based on schema comparison. This function does essentially what :func:`.compare_metadata` does, but then runs the resulting list of diffs to produce the full :class:`.MigrationScript` object. For an example of what this looks like, see the example in :ref:`customizing_revision`. .. versionadded:: 0.8.0 .. seealso:: :func:`.compare_metadata` - returns more fundamental "diff" data from comparing a schema. )r N)�rev_idr � downgrade_ops)�AutogenContextr �MigrationScript� UpgradeOps� DowngradeOpsr �_populate_migration_script)r r �autogen_contextr r r r r j s r �sa.�op.Fr c C s6 ||||d�}t d|d�}t|�|_t�t�| |��S )z�Render Python code given an :class:`.UpgradeOps` or :class:`.DowngradeOps` object. This is a convenience function that can be used to test the autogenerate output of a user-defined :class:`.MigrationScript` structure. )�sqlalchemy_module_prefix�alembic_module_prefix� render_item�render_as_batchN)�opts)r �set�importsr Z_indentZ_render_cmd_body)Z up_or_down_opr r r r! r r r r r r �render_python_code� s r" c C sD t | �}t�g �}t�||� tjd||�� d�}t�|||� dS )z6legacy, used by test_autogen_composition at the momentN)r r r ) r r r r Z_produce_net_changesr �reverser � _render_python_into_templatevars)r � template_argsr r r r r r �_render_migration_diffs� s r& c @ sR e Zd ZdZdZdZdZdZdZd dd�Z e j dd� �Z e jdd � �Zd d � ZdS ) r zSMaintains configuration and state that's specific to an autogenerate operation.NTc s� |r |d k r |j r t�d��|d kr*|j}|d kr>|�dd �n| | _}|d krt|d k rt|jd k rtt�d|jj ��|�dd �� |�dd �}g }� r�� fdd�}|�|� |r�|�|� || _ || _ | j d k r�| j j | _ | j j | _ t� | _|| _d| _d S ) Nz^autogenerate can't use as_sql=True as it prevents querying the database for schema informationZtarget_metadatazrCan't proceed with --autogenerate option; environment script %s does not provide a MetaData object to the context.�include_symbol�include_objectc s |dkr� || j �S dS d S )N�tableT)Zschema)�object�name�type_� reflected� compare_to)r' r r �include_symbol_filter s z6AutogenContext.__init__.<locals>.include_symbol_filterF)Zas_sqlr � CommandErrorr �getr �scriptZenv_py_location�append�_object_filters�migration_contextZbind� connection�dialectr r! � _has_batch)�selfr5 r r � autogenerater( Zobject_filtersr/ r )r' r �__init__� s: zAutogenContext.__init__c C s t �| j�S )N)r Z from_enginer6 )r9 r r r � inspector& s zAutogenContext.inspectorc c s d| _ d V d| _ d S )NTF)r8 )r9 r r r � _within_batch* s z AutogenContext._within_batchc C s, x&| j D ]}||||||�sdS qW dS dS )a4 Run the context's object filters and return True if the targets should be part of the autogenerate operation. This method should be run for every kind of object encountered within an autogenerate operation, giving the environment the chance to filter what objects should be included in the comparison. The filters here are produced directly via the :paramref:`.EnvironmentContext.configure.include_object` and :paramref:`.EnvironmentContext.configure.include_symbol` functions, if present. FTN)r4 )r9 Zobject_r+ r, r- r. �fnr r r � run_filters0 s zAutogenContext.run_filters)NNT)�__name__� __module__� __qualname__�__doc__r r6 r7 r! r5 r; r Zmemoized_propertyr< � contextlib�contextmanagerr= r? r r r r r � s 2r c @ sH e Zd ZdZdd� Zdd� Zdd� Zdd � Zd d � Zd d � Z dd� Z dS )�RevisionContextz^Maintains configuration and state that's specific to a revision file generation operation.c C s, || _ || _|| _d|i| _| �� g| _d S )N�config)rG �script_directory� command_argsr% �_default_revision�generated_revisions)r9 rG rH rI r r r r; H s zRevisionContext.__init__c C s� i }x"| j �� D ]\}}|�||� qW t|dd�rd| j}t� |_|jrV|j�|j� t� |||� | j j |j |j fd|j|j|j|j|jd�|��S )N� _needs_renderFT)Zrefresh�head�spliceZ branch_labels� version_path� depends_on)r% �items� setdefault�getattr�_last_autogen_contextr r! Z union_updater r$ rH Zgenerate_revisionr �messagerM rN � branch_labelrO rP )r9 r r% �k�vr r r r � _to_scriptT s( zRevisionContext._to_scriptc C s | � ||d� d S )NT)�_run_environment)r9 �revr5 r r r �run_autogeneratep s z RevisionContext.run_autogeneratec C s | � ||d� d S )NF)rZ )r9 r[ r5 r r r �run_no_autogenerates s z#RevisionContext.run_no_autogeneratec C s |rB| j d rt�d��t| j�|��t| j�d��krBt�d��|jd }|jd }| jd }t|dd �s�||j d _ ||j d _ d |_ n,|j�tjg |d �� |j�tjg |d �� t||d � | _}|r�t�||� |jd }|r�|||| j� x| jD ] }d |_ q�W d S )NZsqlz7Using --sql with --autogenerate does not make any senseZheadsz"Target database is not up to date.� upgrade_token�downgrade_token���rL FT)r^ )r_ )r: Zprocess_revision_directives)rI r r0 r rH Z get_revisionsr rK rS Zupgrade_ops_listr^ Zdowngrade_ops_listr_ rL Z _upgrade_opsr3 r r Z_downgrade_opsr r rT r r ) r9 r[ r5 r: r^ r_ r r �hookr r r rZ v s6 z RevisionContext._run_environmentc C s^ t j| jd pt�� | jd t �g �t �g �| jd | jd | jd | jd | jd d� }|S ) Nr rU rM rN rV rO rP ) r rU r r rM rN rV rO rP )r r rI r r r r )r9 �opr r r rJ � s z!RevisionContext._default_revisionc c s x| j D ]}| �|�V qW d S )N)rK rY )r9 Zgenerated_revisionr r r �generate_scripts� s z RevisionContext.generate_scriptsN) r@ rA rB rC r; rY r\ r] rZ rJ rc r r r r rF D s (rF )r r Fr N)rC Z operationsr � r r r Z sqlalchemy.engine.reflectionr rD r r r" r& r* r rF r r r r �<module> s" ^!