관리-도구
편집 파일: migration.cpython-38.pyc
U 0?�f�� � @ s� d dl mZ d dlmZ d dlmZ d dlZd dlZd dlmZ d dlm Z d dlm Z d dlm Z d d lm Z d d lm Z d d lmZ d d lmZ d d lmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlmZ d dlm Z d dl m Z d dl m Z d dl!m"Z" d d l#m$Z$ d d l#m%Z% d d l%m&Z& d d l'm(Z( e�rd 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&l0m1Z1 d'd(l2m3Z3 d d)l4m5Z5 d d*l6m7Z7 d d+l6m8Z8 d d,l9m:Z: d d-l9m;Z; d d.l9m<Z< e�=e>�Z?G d/d0� d0�Z@G d1d2� d2�ZAG d3d4� d4�ZBG d5d6� d6�ZCG d7d8� d8�ZDG d9d:� d:eD�ZEG d;d<� d<eD�ZFdS )=� )� annotations)�contextmanager)� nullcontextN)�Any)�Callable)�cast)� Collection)�ContextManager)�Dict)�Iterable)�Iterator)�List)�Optional)�Set)�Tuple)� TYPE_CHECKING)�Union)�Column)�literal_column)�MetaData)�PrimaryKeyConstraint)�String)�Table)�Engine)�url)�MockEngineStrategy� )�ddl)�util)� sqla_compat)� EncodedIO)�Dialect)�URL)� Connection)� Transaction)�MockConnection)� Executable� )�EnvironmentContext)�Config)�Script)�ScriptDirectory)�_RevisionOrBase)�Revision)� RevisionMapc @ sl e Zd Zddd�dd�Zedd�dd ��Zdd�d d �Zdd�d d �Zd d�dd�Zddddd�dd�Z dS )�_ProxyTransaction�MigrationContext�None)�migration_context�returnc C s || _ d S �N)r2 )�selfr2 � r6 �G/opt/hc_python/lib/python3.8/site-packages/alembic/runtime/migration.py�__init__< s z_ProxyTransaction.__init__zOptional[Transaction]�r3 c C s | j jS r4 )r2 � _transaction�r5 r6 r6 r7 �_proxied_transaction? s z&_ProxyTransaction._proxied_transactionc C s& | j }|d k st�|�� d | j_d S r4 )r< �AssertionError�rollbackr2 r: �r5 �tr6 r6 r7 r> C s z_ProxyTransaction.rollbackc C s& | j }|d k st�|�� d | j_d S r4 )r< r= �commitr2 r: r? r6 r6 r7 rA I s z_ProxyTransaction.commitc C s | S r4 r6 r; r6 r6 r7 � __enter__O s z_ProxyTransaction.__enter__r )�type_�value� tracebackr3 c C s& | j d k r"| j �|||� d | j_d S r4 )r< �__exit__r2 r: )r5 rC rD rE r6 r6 r7 rF R s z_ProxyTransaction.__exit__N) �__name__� __module__� __qualname__r8 �propertyr< r> rA rB rF r6 r6 r6 r7 r/ ; s r/ c @ sJ e Zd ZdZdHdddddd�d d �ZedIdd d d dddd d�dd��Zedd�dd��ZdJddd�dd �Z d d�d d �Z d d�d d!�Z dKddd"�d#d$�Z dd�d%d&�Z d'd(dd)�d*d+�Zd,dd-�d.d/�Zdd�d0d1�ZdLd2d3dd4�d5d6�Zdd7d8�d9d:�Zedd�d;d<��Zed=d�d>d?��Zd@dAddB�dCdD�Zd@d@d d ddE�dFdG�ZdS )Mr0 a� Represent the database state made available to a migration script. :class:`.MigrationContext` is the front end to an actual database connection, or alternatively a string output stream given a particular database dialect, from an Alembic perspective. When inside the ``env.py`` script, the :class:`.MigrationContext` is available via the :meth:`.EnvironmentContext.get_context` method, which is available at ``alembic.context``:: # from within env.py script from alembic import context migration_context = context.get_context() For usage outside of an ``env.py`` script, such as for utility routines that want to check the current version in the database, the :meth:`.MigrationContext.configure` method to create new :class:`.MigrationContext` objects. For example, to get at the current revision in the database using :meth:`.MigrationContext.get_current_revision`:: # in any application, outside of an env.py script from alembic.migration import MigrationContext from sqlalchemy import create_engine engine = create_engine("postgresql://mydatabase") conn = engine.connect() context = MigrationContext.configure(conn) current_rev = context.get_current_revision() The above context can also be used to produce Alembic migration operations with an :class:`.Operations` instance:: # in any application, outside of the normal Alembic environment from alembic.operations import Operations op = Operations(context) op.alter_column("mytable", "somecolumn", nullable=True) Nr! zOptional[Connection]zDict[str, Any]z Optional[EnvironmentContext]r1 )�dialect� connection�opts�environment_contextr3 c C s� || _ || _|| _|�d�| _|�dd�}|�d�}|�dd�| _|�dd�| _d | _|r�tt d | � |��| _ | j d k s~t �d| _ n|| _ t�|�| _ |�d �| _|| _|�d d�| _d |kr�t|�d �p�tj|d �| _n|�d tj�| _|�d d�| _|�dd�| _|�dd� | _}|�dd � | _}t|t � t dt d�dd�|d�| _ |�dd��rv| j � t!dd| d�� |�d�| _"t#j$�%|�|| j | j|| j|�| _&t'�(d| j&j)j*� | j�r�t'�(d � t'�(d | j&j+�r�d nd � d S ) N�script�as_sqlF�transactional_ddlZtransaction_per_migrationZon_version_applyr6 r# �fn�purgeZoutput_encoding� output_buffer� compare_typeT�compare_server_default� version_tableZalembic_version�version_table_schema� version_num� )Znullable)ZschemaZversion_table_pkz%s_pkc)�nameZ starting_revzContext impl %s.zGenerating static SQLzWill assume %s DDL.Z transactionalznon-transactional),rN rM rK �getrO �_transaction_per_migration�on_version_apply_callbacksr: r r �_stdout_connectionrL r= �_in_external_transactionr Z _get_connection_in_transaction�_migrations_fnrP rS r �sys�stdoutrT �_user_compare_type� _user_compare_server_defaultrW rX r r r r �_versionZappend_constraintr �_start_from_revr Z DefaultImplZget_by_dialect�impl�log�info� __class__rG rQ ) r5 rK rL rM rN rP rQ rW rX r6 r6 r7 r8 � s� � ��� � � � � � �� � ��zMigrationContext.__init__zOptional[Union[str, URL]]� Optional[str]zOptional[Dialect]zOptional[Dict[str, str]]z Optional[Any])rL r � dialect_namerK rN � dialect_optsrM r3 c C s� |dkr i }|dkri }|r<t |t�r4t�d| ��|j}nL|rZt�|�}|�� f |�}n.|r|t�d| �}|�� f |�}n |s�td��|dk s�t �t ||||�S )a� Create a new :class:`.MigrationContext`. This is a factory method usually called by :meth:`.EnvironmentContext.configure`. :param connection: a :class:`~sqlalchemy.engine.Connection` to use for SQL execution in "online" mode. When present, is also used to determine the type of dialect in use. :param url: a string database url, or a :class:`sqlalchemy.engine.url.URL` object. The type of dialect to be used will be derived from this if ``connection`` is not passed. :param dialect_name: string name of a dialect, such as "postgresql", "mssql", etc. The type of dialect to be used will be derived from this if ``connection`` and ``url`` are not passed. :param opts: dictionary of options. Most other options accepted by :meth:`.EnvironmentContext.configure` are passed via this dictionary. Nzf'connection' argument to configure() is expected to be a sqlalchemy.engine.Connection instance, got %rz%s://z-Connection, url, or dialect_name is required.) � isinstancer r � CommandErrorrK �sqla_urlZmake_url� get_dialect� Exceptionr= r0 ) �clsrL r rm rK rN rn rM Zurl_objr6 r6 r7 � configure� s, �� zMigrationContext.configurezIterator[None]r9 c c s | � � }| jjr"| jr"| j�� n"|rD| jdk s4t�| j�� d| _| js�| jdk sXt�| j� � }| j}|j dd� | _| j_| j� � }nd}z dV W 5 | js�| jdk s�t�|dk r�|�� | jj |d� | | _| j_| jjr�| jr�| j� � n"|�r| jdk �s t�| j� � | _X dS )aL Enter an "autocommit" block, for databases that support AUTOCOMMIT isolation levels. This special directive is intended to support the occasional database DDL or system operation that specifically has to be run outside of any kind of transaction block. The PostgreSQL database platform is the most common target for this style of operation, as many of its DDL operations must be run outside of transaction blocks, even though the database overall supports transactional DDL. The method is used as a context manager within a migration script, by calling on :meth:`.Operations.get_context` to retrieve the :class:`.MigrationContext`, then invoking :meth:`.MigrationContext.autocommit_block` using the ``with:`` statement:: def upgrade(): with op.get_context().autocommit_block(): op.execute("ALTER TYPE mood ADD VALUE 'soso'") Above, a PostgreSQL "ALTER TYPE..ADD VALUE" directive is emitted, which must be run outside of a transaction block at the database level. The :meth:`.MigrationContext.autocommit_block` method makes use of the SQLAlchemy ``AUTOCOMMIT`` isolation level setting, which against the psycogp2 DBAPI corresponds to the ``connection.autocommit`` setting, to ensure that the database driver is not inside of a DBAPI level transaction block. .. warning:: As is necessary, **the database transaction preceding the block is unconditionally committed**. This means that the run of migrations preceding the operation will be committed, before the overall migration operation is complete. It is recommended that when an application includes migrations with "autocommit" blocks, that :paramref:`.EnvironmentContext.transaction_per_migration` be used so that the calling environment is tuned to expect short per-file migrations whether or not one of them has an autocommit block. NZ AUTOCOMMIT)Zisolation_level) �_in_connection_transactionrh rQ rP � emit_commitr: r= rA rL Zget_isolation_level�execution_options�begin� emit_begin)r5 rv Z current_levelZbase_connectionZ fake_transr6 r6 r7 �autocommit_block s< - � � z!MigrationContext.autocommit_blockF�boolz.Union[_ProxyTransaction, ContextManager[None]])�_per_migrationr3 c s� � j r t� S � jjr |� jk}n|dk}|s2t� S � jjs�|sBt�� jrNt� S � jdk }|rbt� S � jdk spt�t � � j�� _t � �S n@� jr�t � fdd��}|� S � jdk s�t�t � � j�� _t � �S dS )a� Begin a logical transaction for migration operations. This method is used within an ``env.py`` script to demarcate where the outer "transaction" for a series of migrations begins. Example:: def run_migrations_online(): connectable = create_engine(...) with connectable.connect() as connection: context.configure( connection=connection, target_metadata=target_metadata ) with context.begin_transaction(): context.run_migrations() Above, :meth:`.MigrationContext.begin_transaction` is used to demarcate where the outer logical transaction occurs around the :meth:`.MigrationContext.run_migrations` operation. A "Logical" transaction means that the operation may or may not correspond to a real database transaction. If the target database supports transactional DDL (or :paramref:`.EnvironmentContext.configure.transactional_ddl` is true), the :paramref:`.EnvironmentContext.configure.transaction_per_migration` flag is not set, and the migration is against a real database connection (as opposed to using "offline" ``--sql`` mode), a real transaction will be started. If ``--sql`` mode is in effect, the operation would instead correspond to a string such as "BEGIN" being emitted to the string output. The returned object is a Python context manager that should only be used in the context of a ``with:`` statement as indicated above. The object has no other guaranteed API features present. .. seealso:: :meth:`.MigrationContext.autocommit_block` TNc 3 s � j �� d V � j �� d S r4 )rh rz rw r6 r; r6 r7 � begin_commit� s z8MigrationContext.begin_transaction.<locals>.begin_commit) r` r rh rQ r] r= rP r: rL r Z"_safe_begin_connection_transactionr/ r )r5 r} Ztransaction_now�in_transactionr~ r6 r; r7 �begin_transactiony s: , �� �z"MigrationContext.begin_transactionc C sB | � � }t|�dkrdS t|�dkr6t�d| j ��n|d S dS )a� Return the current revision, usually that which is present in the ``alembic_version`` table in the database. This method intends to be used only for a migration stream that does not contain unmerged branches in the target database; if there are multiple branches present, an exception is raised. The :meth:`.MigrationContext.get_current_heads` should be preferred over this method going forward in order to be compatible with branch migration support. If this :class:`.MigrationContext` was configured in "offline" mode, that is with ``as_sql=True``, the ``starting_rev`` parameter is returned instead, if any. r Nr' zQVersion table '%s' has more than one head present; please use get_current_heads())�get_current_heads�lenr rp rW �r5 �headsr6 r6 r7 �get_current_revision� s ��z%MigrationContext.get_current_revision�Tuple[str, ...]c s� � j rN� j}|dkrd}n&|dk r@� jr@� fdd�t�|�D �}tj|dd�S � jr^t�d��� �� sjdS � jdk sxt �t dd � � j� � j � � �D ��S ) a� Return a tuple of the current 'head versions' that are represented in the target database. For a migration stream without branches, this will be a single value, synonymous with that of :meth:`.MigrationContext.get_current_revision`. However when multiple unmerged branches exist within the target database, the returned tuple will contain a value for each head. If this :class:`.MigrationContext` was configured in "offline" mode, that is with ``as_sql=True``, the ``starting_rev`` parameter is returned in a one-length tuple. If no version table is present, or if there are no revisions present, an empty tuple is returned. �baseNc s" g | ]}|d kr� j �|�j�qS ))Nr� )rO � get_revision�revision)�.0Zsfrr; r6 r7 � <listcomp> s �z6MigrationContext.get_current_heads.<locals>.<listcomp>r6 ��defaultzECan't specify current_rev to context when using a database connectionc s s | ]}|d V qdS )r Nr6 )r� �rowr6 r6 r7 � <genexpr> s z5MigrationContext.get_current_heads.<locals>.<genexpr>)rP rg rO r Zto_list�to_tuplerp �_has_version_tablerL r= �tuple�executerf �select)r5 Zstart_from_revr6 r; r7 r� � s& ���z"MigrationContext.get_current_heads)rS r3 c C s` t �| j��J | jd k s t�| jj| jdd� |rR| jd k s@t�| j�| j�� � W 5 Q R X d S )NT)Z checkfirst)r Z_ensure_scope_for_ddlrL r= rf �creater� �delete)r5 rS r6 r6 r7 �_ensure_version_table" s z&MigrationContext._ensure_version_tablec C s" | j d k st�t�| j | j| j�S r4 )rL r= r Z_connectable_has_tablerW rX r; r6 r6 r7 r� * s �z#MigrationContext._has_version_tabler+ �str)�script_directoryr� r3 c C sD | � � }| js|s| �� t| |�}|�||�D ]}|�|� q0dS )a\ Stamp the version table with a specific revision. This method calculates those branches to which the given revision can apply, and updates those branches as though they were migrated towards that revision (either up or down). If no current branches include the revision, it is added as a new branch head. N)r� rP r� �HeadMaintainerZ _stamp_revs�update_to_step)r5 r� r� r� �head_maintainer�stepr6 r6 r7 �stamp0 s zMigrationContext.stampr ��kwr3 c K sZ | j �� | jr2| jr t�d��| jdd� d}n,| �� }| j� dd�}| js^|s^|s^| �� t | |�}| j dk svt �| � || �D ]�}| j dd��� | jr�|js�| jdk s�t �| j�| j� t�d |� | jr�| j �d |jf � |jf |� |�|� | jD ] }|| |jt|j�|d � q�W 5 Q R X q�| j�rV|j�sV| jdk �sHt �| j�| j� dS ) a- Run the migration scripts established for this :class:`.MigrationContext`, if any. The commands in :mod:`alembic.command` will set up a function that is ultimately passed to the :class:`.MigrationContext` as the ``fn`` argument. This function represents the "work" that will be done when :meth:`.MigrationContext.run_migrations` is called, typically from within the ``env.py`` script of the migration environment. The "work function" then provides an iterable of version callables and other version information which in the case of the ``upgrade`` or ``downgrade`` commands are the list of version scripts to invoke. Other commands yield nothing, in the case that a command wants to run some other operation against the database such as the ``current`` or ``stamp`` commands. :param \**kw: keyword arguments here will be passed to each migration callable, that is the ``upgrade()`` or ``downgrade()`` method within revision scripts. z!Can't use --purge with --sql modeT)rS r6 � dont_mutateFN)r} z Running %sz -- Running %s)�ctxr� r� Zrun_args)rh Zstart_migrationsrS rP r rp r� r� rM r\ r� ra r= r� r� rL rf r� ri rj Z static_output� short_log� migration_fnr� r^ �setZdrop)r5 r� r� r� r� r� �callbackr6 r6 r7 �run_migrations@ sD � �z MigrationContext.run_migrationsc C s. z | j j}W n tk r" Y dS X |� S d S �NF)rL r �AttributeError)r5 �methr6 r6 r7 rv � s z+MigrationContext._in_connection_transactionzUnion[Executable, str]zOptional[Dict[str, Any]])�sqlrx r3 c C s | j �||� dS )a Execute a SQL construct or string statement. The underlying execution mechanics are used, that is if this is "offline mode" the SQL is written to the output buffer, otherwise the SQL is emitted on the current SQLAlchemy connection. N�rh �_exec)r5 r� rx r6 r6 r7 r� � s zMigrationContext.executer% )rL r3 c s � fdd�}t �� j|�S )Nc s � j �| � d S r4 r� )Z constructZ multiparams�paramsr; r6 r7 �dump� s z1MigrationContext._stdout_connection.<locals>.dump)r r% rK )r5 rL r� r6 r; r7 r_ � s z#MigrationContext._stdout_connectionc C s | j S )a� Return the current "bind". In online mode, this is an instance of :class:`sqlalchemy.engine.Connection`, and is suitable for ad-hoc execution of any kind of usage described in SQLAlchemy Core documentation as well as for usage with the :meth:`sqlalchemy.schema.Table.create` and :meth:`sqlalchemy.schema.MetaData.create_all` methods of :class:`~sqlalchemy.schema.Table`, :class:`~sqlalchemy.schema.MetaData`. Note that when "standard output" mode is enabled, this bind will be a "mock" connection handler that cannot return results and is only appropriate for a very limited subset of commands. )rL r; r6 r6 r7 �bind� s zMigrationContext.bindzOptional[Config]c C s | j r| j jS dS dS )zLReturn the :class:`.Config` used by the current environment, if any.N)rN �configr; r6 r6 r7 r� � s zMigrationContext.configz Column[Any]r )�inspector_column�metadata_columnr3 c C sH | j dkrdS t| j �r:| � | |||j|j�}|d k r:|S | j�||�S r� )rd �callable�typerh rU )r5 r� r� � user_valuer6 r6 r7 � _compare_type� s �z MigrationContext._compare_type)r� r� �rendered_metadata_default�rendered_column_defaultr3 c C sL | j dkrdS t| j �r:| � | ||||j|�}|d k r:|S | j�||||�S r� )re r� Zserver_defaultrh rV )r5 r� r� r� r� r� r6 r6 r7 �_compare_server_default� s& ��z(MigrationContext._compare_server_default)N)NNNNNNN)F)F)N)rG rH rI �__doc__r8 � classmethodru r r{ r� r� r� r� r� r� r� rv r� r_ rJ r� r� r� r� r6 r6 r6 r7 r0 X s@ 4 �[ � 7^ �d*H � r0 c @ s` e Zd Zdddd�dd�Zddd�d d �Zddd�d d �Zdddd �dd�Zddd�dd�ZdS )r� r0 r r1 )�contextr� r3 c C s || _ t|�| _d S r4 )r� r� r� )r5 r� r� r6 r6 r7 r8 � s zHeadMaintainer.__init__r� )�versionr3 c C sD || j kst�| j �|� | jj�| jj�� jt d| �d�� d S )N�'%s'�rY ) r� r= �addr� rh r� rf �insert�valuesr )r5 r� r6 r6 r7 �_insert_version� s ��z HeadMaintainer._insert_versionc C s~ | j �|� | jj�| jj�� �| jjjj t d| �k��}| jj sz| jj j rz|d k rz|jdkrzt�d|| jj|jf ��d S )Nr� r' zOOnline migration expected to match one row when deleting '%s' in '%s'; %d found)r� �remover� rh r� rf r� �where�crY r rP rK �supports_sane_rowcount�rowcountr rp rW )r5 r� �retr6 r6 r7 �_delete_version s* ���������z HeadMaintainer._delete_version)�from_�to_r3 c C s� || j kst�| j �|� | j �|� | jj�| jj�� j t d| �d�� | jjj j t d| �k��}| jjs�| jjjr�|d k r�|jdkr�t�d||| jj|jf ��d S )Nr� r� r' zWOnline migration expected to match one row when updating '%s' to '%s' in '%s'; %d found)r� r= r� r� r� rh r� rf �updater� r r� r� rY rP rK r� r� r rp rW )r5 r� r� r� r6 r6 r7 �_update_version s2 � ��� ������z HeadMaintainer._update_versionz Union[RevisionStep, StampStep])r� r3 c C s" |� | j�r*|j}t�d|� | �|� n�|�| j�rT|j}t�d|� | �|� n�|� | j�r�|� | j�\}}}t�d|||� |D ]}| �|� q�| � ||� nz|� | j�r�|� | j�\}}}t�d|||� |D ]}| �|� q�| � ||� n*|�| j�\} } t�d| | � | � | | � d S )Nzbranch delete %sznew branch insert %sz!merge, delete %s, update %s to %sz#unmerge, insert %s, update %s to %szupdate %s to %s)�should_delete_branchr� �delete_version_numri �debugr� �should_create_branch�insert_version_numr� �should_merge_branches�merge_branch_identsr� �should_unmerge_branches�unmerge_branch_idents�update_version_num) r5 r� �versZ delete_revsZupdate_from_revZ update_to_revZdelrevZ insert_revsZinsrevr� r� r6 r6 r7 r� 8 sR �� �� z HeadMaintainer.update_to_stepN)rG rH rI r8 r� r� r� r� r6 r6 r6 r7 r� � s r� c @ s� e Zd ZU dZded< ded< ded< ded< ded < d ed < d ddd d d d�dd�Zedd�dd��Zedd�dd��Zedd�dd��Z edd�dd��Z edd�d d ��Z edd�d d ��Z edd�d d!��Z edd�d"d#��Zd$S )%� MigrationInfoz�Exposes information about a migration step to a callback listener. The :class:`.MigrationInfo` object is available exclusively for the benefit of the :paramref:`.EnvironmentContext.on_version_apply` callback hook. r| � is_upgrade�is_stamprl �up_revision_idr� �up_revision_ids�down_revision_idsr. � revision_mapzUnion[str, Tuple[str, ...]]r1 )r� r� r� � up_revisions�down_revisionsr3 c C sP || _ || _|| _tj|dd�| _| jr6| jd | _nd | _tj|dd�| _d S )Nr6 r� r )r� r� r� r r� r� r� r� )r5 r� r� r� r� r� r6 r6 r7 r8 � s zMigrationInfo.__init__r9 c C s | j S )a True/False: indicates whether this operation is a migration. At present this is true if and only the migration is not a stamp. If other operation types are added in the future, both this attribute and :attr:`~.MigrationInfo.is_stamp` will be false. )r� r; r6 r6 r7 � is_migration� s zMigrationInfo.is_migrationc C s | j r | jS | jS )z7Active revisions before this migration step is applied.)r� r� r� r; r6 r6 r7 �source_revision_ids� s �z!MigrationInfo.source_revision_idsc C s | j r | jS | jS )z6Active revisions after this migration step is applied.)r� r� r� r; r6 r6 r7 �destination_revision_ids� s �z&MigrationInfo.destination_revision_idszOptional[Revision]c C s | j �| j�S )zUGet :attr:`~.MigrationInfo.up_revision_id` as a :class:`.Revision`. )r� r� r� r; r6 r6 r7 � up_revision� s zMigrationInfo.up_revisionz%Tuple[Optional[_RevisionOrBase], ...]c C s | j �| j�S )zLGet :attr:`~.MigrationInfo.up_revision_ids` as a :class:`.Revision`.)r� � get_revisionsr� r; r6 r6 r7 r� � s zMigrationInfo.up_revisionsc C s | j �| j�S )zcGet :attr:`~.MigrationInfo.down_revision_ids` as a tuple of :class:`Revisions <.Revision>`.)r� r� r� r; r6 r6 r7 r� � s z MigrationInfo.down_revisionsc C s | j �| j�S )zdGet :attr:`~MigrationInfo.source_revision_ids` as a tuple of :class:`Revisions <.Revision>`.)r� r� r� r; r6 r6 r7 �source_revisions� s z MigrationInfo.source_revisionsc C s | j �| j�S )ziGet :attr:`~MigrationInfo.destination_revision_ids` as a tuple of :class:`Revisions <.Revision>`.)r� r� r� r; r6 r6 r7 �destination_revisions� s z#MigrationInfo.destination_revisionsN)rG rH rI r� �__annotations__r8 rJ r� r� r� r� r� r� r� r� r6 r6 r6 r7 r� f s0 r� c @ s� e Zd ZU ded< ded< ded< ded< er@edd �d d ��Zed d �d d��Zedddd�dd��Z edddd�dd��Z edd �dd��Z ed d �dd��Z dd � Z d S ) � MigrationStepr� �from_revisions_no_deps�to_revisions_no_depsr| r� r r� rl r9 c C s d S r4 r6 r; r6 r6 r7 �doc� s zMigrationStep.docr� c C s | j jS r4 )r� rG r; r6 r6 r7 r[ � s zMigrationStep.namer. r* � RevisionStep)r� rO r3 c C s t ||d�S )NT�r� �rt r� rO r6 r6 r7 �upgrade_from_script� s z!MigrationStep.upgrade_from_scriptc C s t ||d�S r� r� r� r6 r6 r7 �downgrade_from_script� s z#MigrationStep.downgrade_from_scriptc C s | j S r4 )r� r; r6 r6 r7 � is_downgrade s zMigrationStep.is_downgradec C s d| j t�| j�t�| j�f S )Nz %s %s -> %s)r[ r �format_as_commar� r� r; r6 r6 r7 r� s �zMigrationStep.short_logc C s4 | j r*d| jt�| j�t�| j�| j f S | jS d S )Nz%s %s -> %s, %s)r� r[ r r� r� r� r� r; r6 r6 r7 �__str__ s �zMigrationStep.__str__N)rG rH rI r� r rJ r� r[ r� r� r� r� r� r� r6 r6 r6 r7 r� � s$ r� c @ sZ e Zd Zddddd�dd�Zdd � Zd dd �d d �Zedd�dd��Zedd�dd��Zedd�dd��Z edd�dd��Z edd�dd��Z edd�dd ��Z d dd �d d �Z d d!d �d"d#�Zd dd �d$d%�Zd d&d �d'd(�Zd dd �d)d*�Zd dd �d+d,�Zd dd �d-d.�Zd d/d �d0d1�Zed2d�d3d4��Zed2d�d5d6��Zed7d�d8d9��Zd:S );r� r. r* r| r1 )r� r� r� r3 c C s0 || _ || _|| _|r"|jj| _n |jj| _d S r4 )r� r� r� �module�upgrader� � downgrade)r5 r� r� r� r6 r6 r7 r8 s zRevisionStep.__init__c C s d| j j | jf S )Nz RevisionStep(%r, is_upgrade=%r))r� r� r; r6 r6 r7 �__repr__( s �zRevisionStep.__repr__�object)�otherr3 c C s" t |t�o |j| jko | j|jkS r4 )ro r� r� r� �r5 r� r6 r6 r7 �__eq__. s � �zRevisionStep.__eq__rl r9 c C s | j jS r4 )r� r� r; r6 r6 r7 r� 5 s zRevisionStep.docr� c C s | j r| jjS | jjfS d S r4 �r� r� �_normalized_down_revisionsr; r6 r6 r7 �from_revisions9 s zRevisionStep.from_revisionsc C s | j r| jjS | jjfS d S r4 �r� r� Z_versioned_down_revisionsr; r6 r6 r7 r� @ s z#RevisionStep.from_revisions_no_depsc C s | j r| jjfS | jjS d S r4 r r; r6 r6 r7 � to_revisionsI s zRevisionStep.to_revisionsc C s | j r| jjfS | jjS d S r4 r r; r6 r6 r7 r� P s z!RevisionStep.to_revisions_no_depsc C s t | jj�dkS �Nr' )r� r� r r; r6 r6 r7 �_has_scalar_down_revisionY s z&RevisionStep._has_scalar_down_revision�Set[str]�r� r3 c C s> | j s dS | jj|krdS | jj}|s*dS | �|�}| S dS )z�A delete is when we are a. in a downgrade and b. we are going to the "base" or we are going to a version that is implied as a dependency on another version that is remaining. FTN)r� r� r �_unmerge_to_revisions)r5 r� �downrevsr r6 r6 r7 r� ] s z!RevisionStep.should_delete_branchzTuple[List[str], str, str]c C sv t |��| j�}|rLdd� | jj| j�|�dd�D �}tt | j��|��}n t| j�}t|dd� �|d | jd fS )Nc S s h | ] }|j �qS r6 �r� �r� �rr6 r6 r7 � <setcomp>z s �z3RevisionStep.merge_branch_idents.<locals>.<setcomp>F��checkr ���)r� � differencer r� �_get_ancestor_nodesr� �listr )r5 r� � other_heads� ancestorsr r6 r6 r7 r� t s ��� �z RevisionStep.merge_branch_identsc sz t |��� jjg�}|rNdd� � jj� j�|�dd�D �}tt � j��|��S � fdd�� jD �}tt � j��|��S d S )Nc S s h | ] }|j �qS r6 r r r6 r6 r7 r � s �z5RevisionStep._unmerge_to_revisions.<locals>.<setcomp>Fr c s: h | ]2}� j j� j �|�d d�D ]}|j|kr |j�q qS )Fr )r� r r� r� )r� Z to_revisionr r; r6 r7 r � s � �)r� r r� r� r r� r� r )r5 r� r r r6 r; r7 r � s �� �z"RevisionStep._unmerge_to_revisionsz Tuple[str, str, Tuple[str, ...]]c C s& | � |�}| jd |d |dd� fS �Nr r )r r )r5 r� r r6 r6 r7 r� � s �z"RevisionStep.unmerge_branch_identsc C s0 | j s dS | jj}|sdS |�|�s(dS dS d S )NFT)r� r� r � intersection�r5 r� r r6 r6 r7 r� � s z!RevisionStep.should_create_branchc C s8 | j s dS | jj}t|�dkr4t|�|��dkr4dS dS �NFr' T)r� r� r r� r r r6 r6 r7 r� � s z"RevisionStep.should_merge_branchesc C s2 | j s dS | jj}| jj|kr.t|�dkr.dS dS r )r� r� r r� r r6 r6 r7 r� � s z$RevisionStep.should_unmerge_branches�Tuple[str, str]c C sd | j s6|�| jj�}t|�dks(td��t|�d }n | jjd }| jrT|| jjfS | jj|fS d S )Nr' z4Can't do an UPDATE because downrevision is ambiguousr )r r r� r r� r= r r� )r5 r� ZdownrevZ down_revisionr6 r6 r7 r� � s � �� z RevisionStep.update_version_numr� c C s | j j S r4 r r; r6 r6 r7 r� � s z RevisionStep.delete_version_numc C s | j j S r4 r r; r6 r6 r7 r� � s z RevisionStep.insert_version_numr� c C s t | j| jj| jj| jdd�S )NF�r� r� r� r� r� )r� r� r� r r� r; r6 r6 r7 rj � s �zRevisionStep.infoN)rG rH rI r8 r� r� rJ r� r r� r r� r r� r� r r� r� r� r� r� r� r� rj r6 r6 r6 r7 r� s: r� c @ s4 e Zd ZU d8ddddddd�dd�ZdZd ed < d dd �d d�Zdd� Zedd� �Z edd�dd��Z edd�dd��Z edd�dd��Z edd�d d ��Z edd�d d ��Zd d!d"�d#d$�Zd%d&d"�d'd(�Zd d)d"�d*d+�Zd dd"�d,d-�Zd d.d"�d/d0�Zd dd"�d1d2�Zd dd"�d3d4�Zed5d�d6d7��ZdS )9� StampStepNz%Optional[Union[str, Collection[str]]]r| zOptional[RevisionMap]r1 )r� r� r� � branch_mover� r3 c C s> t j|dd�| _t j|dd�| _|| _|| _| j| _|| _d S )Nr6 r� ) r r� r� r� r� r �stamp_revisionr� r� )r5 r� r� r� r r� r6 r6 r7 r8 � s zStampStep.__init__rl r� r r� c K s d S r4 r6 )r5 r� r6 r6 r7 r s zStampStep.stamp_revisionc C s: t |t�o8|j| jko8|j| jko8|j| jko8| j|jkS r4 )ro r r r r r� r� r6 r6 r7 r� s � � � �zStampStep.__eq__c C s | j S r4 �r� r; r6 r6 r7 r s zStampStep.from_revisionsr� r9 c C s | j S r4 �r� r; r6 r6 r7 r s zStampStep.to_revisionsc C s | j S r4 r r; r6 r6 r7 r� $ s z StampStep.from_revisions_no_depsc C s | j S r4 r! r; r6 r6 r7 r� * s z StampStep.to_revisions_no_depsr� c C s t | j�dkst�| jd S �Nr' r )r� r� r= r; r6 r6 r7 r� 0 s z StampStep.delete_version_numc C s t | j�dkst�| jd S r" )r� r� r= r; r6 r6 r7 r� 5 s z StampStep.insert_version_numr r r c C s8 t | j�dkst�t | j�dks$t�| jd | jd fS r" )r� r� r= r� r� r6 r6 r7 r� : s z StampStep.update_version_numzUnion[Set[str], List[str]]z=Union[Tuple[List[Any], str, str], Tuple[List[str], str, str]]c C s$ t | jdd� �| jd | jd fS r )r r� r� r� r6 r6 r7 r� ? s �z StampStep.merge_branch_identszTuple[str, str, List[str]]c C s$ | j d | jd t| jdd� �fS r )r� r� r r� r6 r6 r7 r� I s �z StampStep.unmerge_branch_identsc C s | j o | jS r4 )r� r r� r6 r6 r7 r� S s z StampStep.should_delete_branchzUnion[Set[str], bool]c C s, | j o*| js t| j��|�o*t| j��|�S r4 )r� r r� r� r r� r� r6 r6 r7 r� Y s ��z StampStep.should_create_branchc C s t | j�dkS r )r� r� r� r6 r6 r7 r� ` s z StampStep.should_merge_branchesc C s t | j�dkS r )r� r� r� r6 r6 r7 r� c s z!StampStep.should_unmerge_branchesr� c C sF | j r| j| jfn | j| jf\}}| jd k s0t�t| j||| j dd�S )NTr )r� r� r� r� r= r� )r5 �upZdownr6 r6 r7 rj f s � ��zStampStep.info)N)rG rH rI r8 r� r� r r� rJ r r r� r� r� r� r� r� r� r� r� r� r� rj r6 r6 r6 r7 r � s4 � r )G� __future__r � contextlibr r �loggingrb �typingr r r r r r r r r r r r r r Z sqlalchemyr r r r r r Zsqlalchemy.enginer r rq Z sqlalchemy.engine.strategiesr � r r r Z util.compatr r! r" Zsqlalchemy.engine.baser# r$ Zsqlalchemy.engine.mockr% Zsqlalchemy.sqlr& � environmentr( r� r) Z script.baser* r+ Zscript.revisionr, r- r. � getLoggerrG ri r/ r0 r� r� r� r� r r6 r6 r6 r7 �<module> sx $o 3 c