| Server IP : 192.158.238.246 / Your IP : 18.222.25.95 Web Server : LiteSpeed System : Linux uniform.iwebfusion.net 4.18.0-553.27.1.lve.1.el8.x86_64 #1 SMP Wed Nov 20 15:58:00 UTC 2024 x86_64 User : jenniferflocom ( 1321) PHP Version : 8.1.32 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /opt/alt/python37/lib/python3.7/site-packages/alembic/runtime/__pycache__/ |
Upload File : |
B
�M!Vn � @ s� d dl Z d dlZd dlmZ d dlmZmZmZmZm Z d dl
m Z d dl m
Z ddlmZmZ ddlmZmZ e �e�ZG d d
� d
e�ZG d d � d e�ZG d
d� de�ZG dd� de�Z G dd� de�Z dS )� N)�contextmanager)�MetaData�Table�Column�String�literal_column)�MockEngineStrategy)�url� )�callable� EncodedIO)�ddl�utilc @ s� e Zd ZdZd"dd�Zed#dd��Zd$dd �Zd
d � Zd d
� Z dd� Z
dd� Z dd� Z dd� Z
d%dd�Zdd� Zedd� �Zed d � �Zd d � Zd d!� ZdS )&�MigrationContexta� 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)
Nc C s� || _ || _|| _|�d�| _|�dd�}|�d�}|�dd�| _|rb| �|�| _| jd k sht�n|| _|�d�| _ || _
d|kr�t |�d�p�t j
|d �| _n|�dt j
�| _|�d d�| _|�d
d�| _|�d d � | _}|�d
d � | _}t|t� tdtd�dd�|d�| _|�d�| _tj�|�|| j| j
|| j|�| _ t � d| j j j � | j
�rdt � d� t � d| j j!�rxdnd� d S )N�script�as_sqlF�transactional_ddlZtransaction_per_migration�fnZoutput_encoding�
output_buffer� compare_type�compare_server_default�
version_tableZalembic_version�version_table_schema� version_num� )Znullable)ZschemaZ starting_revzContext impl %s.zGenerating static SQLzWill assume %s DDL.Z
transactionalznon-transactional)"�environment_context�opts�dialect�getr �_transaction_per_migration�_stdout_connection�
connection�AssertionError�_migrations_fnr r �sys�stdoutr �_user_compare_type� _user_compare_server_defaultr r r r r r �_version�_start_from_revr
Z DefaultImplZget_by_dialect�impl�log�info� __class__�__name__r ) �selfr r! r r r r r r � r0 �J/opt/alt/python37/lib/python3.7/site-packages/alembic/runtime/migration.py�__init__> sT
zMigrationContext.__init__c C sj |dkr i }|r|j }nD|r2t�|�}|�� � }n*|rPt�d| �}|�� � }n |s\td��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.
Nz%s://z-Connection, url, or dialect_name is required.)r �sqla_urlZmake_urlZ get_dialect� Exceptionr )�clsr! r Z dialect_namer r r r0 r0 r1 � configuret s
zMigrationContext.configureFc sd |� j k}|s tdd� �}|� S � jjs:tdd� �}|� S � jrVt� fdd��}|� S � j�� S d S )Nc s s
d V d S )Nr0 r0 r0 r0 r1 �
do_nothing� s z6MigrationContext.begin_transaction.<locals>.do_nothingc s s
d V d S )Nr0 r0 r0 r0 r1 r7 � s c 3 s � j �� d V � j �� d S )N)r* Z
emit_beginZ emit_commitr0 )r/ r0 r1 � begin_commit� s
z8MigrationContext.begin_transaction.<locals>.begin_commit)r r r* r r �bind�begin)r/ �_per_migrationZtransaction_nowr7 r8 r0 )r/ r1 �begin_transaction� 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 N� zQVersion table '%s' has more than one head present; please use get_current_heads())�get_current_heads�lenr � CommandErrorr )r/ �headsr0 r0 r1 �get_current_revision� s z%MigrationContext.get_current_revisionc C sr | j r6| j}|dk r(| jr(| j�|�j}tj|dd�S | jrFt�d��| �� sRdS 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.
.. versionadded:: 0.7.0
Nr0 )�defaultzECan't specify current_rev to context when using a database connectionc s s | ]}|d V qdS )r Nr0 )�.0�rowr0 r0 r1 � <genexpr>� s z5MigrationContext.get_current_heads.<locals>.<genexpr>)r r) r � get_revision�revisionr �to_tupler@ �_has_version_table�tupler! �executer( �select)r/ Zstart_from_revr0 r0 r1 r> � s z"MigrationContext.get_current_headsc C s | j j| jdd� d S )NT)Z
checkfirst)r( �creater! )r/ r0 r0 r1 �_ensure_version_table� s z&MigrationContext._ensure_version_tablec C s | j j�| j | j| j�S )N)r! r Z has_tabler r )r/ r0 r0 r1 rJ � s z#MigrationContext._has_version_tablec C sH | � � }| js|s| �� t| |�}x |�||�D ]}|�|� q2W dS )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.
.. versionadded:: 0.7.0
N)r> r rO �HeadMaintainerZ _stamp_revs�update_to_step)r/ Zscript_directoryrH rA �head_maintainer�stepr0 r0 r1 �stamp s
zMigrationContext.stampc
K s� | j �� | �� }| js$|s$| �� t| |�}x�| �|| �D ]r}| jdd��\ | jrh|jsh| j �
| j � t �
d|� | jr�| j �d|jf � |jf |� |�|� W dQ R X q<W | jr�|js�| 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.
T)r; z
Running %sz
-- Running %sN)r* Zstart_migrationsr> r rO rP r# r< rA r( rN r! r+ r, Z
static_output� short_log� migration_fnrQ Zdrop)r/ �kwrA rR rS r0 r0 r1 �run_migrations s
z MigrationContext.run_migrationsc 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)r* �_exec)r/ ZsqlZexecution_optionsr0 r0 r1 rL D s zMigrationContext.executec s � fdd�}t �� j|�S )Nc s � j �| � d S )N)r* rY )Z constructZ multiparams�params)r/ r0 r1 �dumpP s z1MigrationContext._stdout_connection.<locals>.dump)r ZMockConnectionr )r/ r! r[ r0 )r/ r1 r O 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 :ref:`sqlexpression_toplevel` 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.
)r! )r/ r0 r0 r1 r9 U s zMigrationContext.bindc C s | j r| j jS dS dS )zoReturn the :class:`.Config` used by the current environment, if any.
.. versionadded:: 0.6.6
N)r �config)r/ r0 r0 r1 r\ j s zMigrationContext.configc C sH | j dkrdS t| j �r:| � | |||j|j�}|d k r:|S | j�||�S )NF)r& r �typer* r )r/ �inspector_column�metadata_column�
user_valuer0 r0 r1 �
_compare_typev s
z MigrationContext._compare_typec C sL | j dkrdS t| j �r:| � | ||||j|�}|d k r:|S | j�||||�S )NF)r' r Zserver_defaultr* r )r/ r^ r_ Zrendered_metadata_defaultZrendered_column_defaultr` r0 r0 r1 �_compare_server_default� s"
z(MigrationContext._compare_server_default)N)NNNNNN)F)N)r. �
__module__� __qualname__�__doc__r2 � classmethodr6 r< rB r> rO rJ rT rX rL r �propertyr9 r\ ra rb r0 r0 r0 r1 r s, -
6 &
&2
r c @ s4 e Zd Zdd� Zdd� Zdd� Zdd� Zd d
� Zd S ) rP c C s || _ t|�| _d S )N)�context�setrA )r/ rh rA r0 r0 r1 r2 � s zHeadMaintainer.__init__c C sD || j kst�| j �|� | jj�| jj�� jt d| �d�� d S )Nz'%s')r )
rA r" �addrh r* rY r( �insert�valuesr )r/ �versionr0 r0 r1 �_insert_version� s
z HeadMaintainer._insert_versionc C sl | j �|� | jj�| jj�� �| jjjj t
d| �k��}| jj sh|j dkrht
�d|| jj|j f ��d S )Nz'%s'r= zOOnline migration expected to match one row when deleting '%s' in '%s'; %d found)rA �removerh r* rY r( �delete�where�cr r r �rowcountr r@ r )r/ rm �retr0 r0 r1 �_delete_version� s
z HeadMaintainer._delete_versionc C s� || j kst�| j �|� | j �|� | jj�| jj�� j t
d| �d�� | jjj j
t
d| �k��}| jjs�|jdkr�t�d||| jj|jf ��d S )Nz'%s')r r= zWOnline migration expected to match one row when updating '%s' to '%s' in '%s'; %d found)rA r" ro rj rh r* rY r( �updaterl r rq rr r r rs r r@ r )r/ �from_�to_rt r0 r0 r1 �_update_version� s
z HeadMaintainer._update_versionc C s* |� | j�r*|j}t�d|� | �|� n�|�| j�rT|j}t�d|� | �|� n�|� | j�r�|�
| j�\}}}t�d|||� x|D ]}| �|� q�W | � ||� n~|� | j�r�|�
| j�\}}}t�d|||� x|D ]}| �|� q�W | � ||� 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_branchrA �delete_version_numr+ �debugru �should_create_branch�insert_version_numrn �should_merge_branches�merge_branch_identsry �should_unmerge_branches�unmerge_branch_idents�update_version_num) r/ rS �versZ delete_revsZupdate_from_revZ
update_to_revZdelrevZ insert_revsZinsrevrw rx r0 r0 r1 rQ � s6
z HeadMaintainer.update_to_stepN)r. rc rd r2 rn ru ry rQ r0 r0 r0 r1 rP � s
rP c @ sP e Zd Zedd� �Zedd� �Zedd� �Zedd� �Zed d
� �Z d d � Z
d
S )�
MigrationStepc C s | j jS )N)rV r. )r/ r0 r0 r1 �name� s zMigrationStep.namec C s t ||d�S )NT)� RevisionStep)r5 � revision_mapr r0 r0 r1 �upgrade_from_script� s z!MigrationStep.upgrade_from_scriptc C s t ||d�S )NF)r� )r5 r� r r0 r0 r1 �downgrade_from_script s z#MigrationStep.downgrade_from_scriptc C s | j S )N)�
is_upgrade)r/ r0 r0 r1 � is_downgrade s zMigrationStep.is_downgradec C s d| j t�| j�t�| j�f S )Nz %s %s -> %s)r� r �format_as_comma�from_revisions� to_revisions)r/ r0 r0 r1 rU s
zMigrationStep.short_logc C s4 | j r*d| jt�| j�t�| j�| j f S | jS d S )Nz%s %s -> %s, %s)�docr� r r� r� r� rU )r/ r0 r0 r1 �__str__ s
zMigrationStep.__str__N) r. rc rd rg r� rf r� r� r� rU r� r0 r0 r0 r1 r� � s r� c @ s� e Zd Zdd� Zdd� Zedd� �Zedd� �Zed d
� �Zed d � �Z d
d� Z
dd� Z dd� Z dd� Z
dd� Zdd� Zdd� Zedd � �Zed d � �Zd S ) r� c C s0 || _ || _|| _|r"|jj| _n
|jj| _d S )N)r� rH r� �moduleZupgraderV Z downgrade)r/ r� rH r� r0 r0 r1 r2 s zRevisionStep.__init__c C s" t |t�o |j| jko | j|jkS )N)�
isinstancer� rH r� )r/ �otherr0 r0 r1 �__eq__& s
zRevisionStep.__eq__c C s | j jS )N)rH r� )r/ r0 r0 r1 r� + s zRevisionStep.docc C s | j r| jjS | jjfS d S )N)r� rH �_all_down_revisions)r/ r0 r0 r1 r� / s zRevisionStep.from_revisionsc C s | j r| jjfS | jjS d S )N)r� rH r� )r/ r0 r0 r1 r� 6 s
zRevisionStep.to_revisionsc C s t | jj�dkS )Nr= )r? rH r� )r/ r0 r0 r1 �_has_scalar_down_revision= s z&RevisionStep._has_scalar_down_revisionc C s� | j s
dS | jj|krdS | jj}|s*dS t|�dkr�| j�|d �}|jsPdS tdd� | jj| j� |j
�dd�D ��}t|� |�� | jjg��r�dS dS ndS d S )NFTr= r c s s | ] }|j V qd S )N)rH )rD �rr0 r0 r1 rF S s z4RevisionStep.should_delete_branch.<locals>.<genexpr>)�check)
r� rH r� r? r� rG Z_is_real_branch_pointri Z_get_descendant_nodes�
get_revisionsZ _all_nextrev� intersection�
difference)r/ rA �downrevs�downrevZ descendantsr0 r0 r1 rz A s(
z!RevisionStep.should_delete_branchc C sz t |��| j�}|rPt dd� | jj| j�|�dd�D ��}tt | j��|��}n
t| j�}t|dd� �|d | jd fS )Nc s s | ] }|j V qd S )N)rH )rD r� r0 r0 r1 rF v s z3RevisionStep.merge_branch_idents.<locals>.<genexpr>F)r� r ���)ri r� r� r� �_get_ancestor_nodesr� �listr� )r/ rA � other_heads� ancestorsr� r0 r0 r1 r� q s
z RevisionStep.merge_branch_identsc C sv t |��| jjg�}|rTt dd� | jj| j�|�dd�D ��}tt | j��|��}n| j}| jd |d |dd� fS )Nc s s | ] }|j V qd S )N)rH )rD r� r0 r0 r1 rF � s z5RevisionStep.unmerge_branch_idents.<locals>.<genexpr>F)r� r r� ) ri r� rH r� r� r� r� r� r� )r/ rA r� r� r� r0 r0 r1 r� � s
z"RevisionStep.unmerge_branch_identsc C s0 | j s
dS | jj}|sdS |�|�s(dS dS d S )NFT)r� rH r� r� )r/ rA r� r0 r0 r1 r} � s
z!RevisionStep.should_create_branchc C s8 | j s
dS | jj}t|�dkr4t|�|��dkr4dS dS )NFr= T)r� rH r� r? r� )r/ rA r� r0 r0 r1 r � s z"RevisionStep.should_merge_branchesc C s2 | j s
dS | jj}| jj|kr.t|�dkr.dS dS )NFr= T)r� rH r� r? )r/ rA r� r0 r0 r1 r� � s z$RevisionStep.should_unmerge_branchesc 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� rH r� r? r" r� r� )r/ rA r� Z
down_revisionr0 r0 r1 r� � s z RevisionStep.update_version_numc C s | j j S )N)rH )r/ r0 r0 r1 r{ � s z RevisionStep.delete_version_numc C s | j j S )N)rH )r/ r0 r0 r1 r~ � s z RevisionStep.insert_version_numN)r. rc rd r2 r� rg r� r� r� r� rz r� r� r} r r� r� r{ r~ r0 r0 r0 r1 r� s 0 r� c @ s� e Zd Zdd� ZdZdd� Zdd� Zedd � �Zed
d � �Z ed d
� �Z
edd� �Z dd� Z dd� Z
dd� Zdd� Zdd� Zdd� Zd d � ZdS ) � StampStepc C s8 t j|dd�| _t j|dd�| _|| _|| _| j| _d S )Nr0 )rC )r rI rw rx r� � branch_move�stamp_revisionrV )r/ rw rx r� r� r0 r0 r1 r2 � s
zStampStep.__init__Nc K s d S )Nr0 )r/ rW r0 r0 r1 r� � s zStampStep.stamp_revisionc C s: t |t�o8|j| jko8|j| jko8|j| jko8| j|jkS )N)r� r� r� Z revisionsr� r� r� )r/ r� r0 r0 r1 r� � s
zStampStep.__eq__c C s | j S )N)rw )r/ r0 r0 r1 r� � s zStampStep.from_revisionsc C s | j S )N)rx )r/ r0 r0 r1 r� � s zStampStep.to_revisionsc C s t | j�dkst�| jd S )Nr= r )r? rw r" )r/ r0 r0 r1 r{ � s z StampStep.delete_version_numc C s t | j�dkst�| jd S )Nr= r )r? rx r" )r/ r0 r0 r1 r~ � s z StampStep.insert_version_numc C s8 t | j�dkst�t | j�dks$t�| jd | jd fS )Nr= r )r? rw r" rx )r/ rA r0 r0 r1 r� s z StampStep.update_version_numc C s$ t | jdd� �| jd | jd fS )Nr r� )r� rw rx )r/ rA r0 r0 r1 r� s z StampStep.merge_branch_identsc C s$ | j d | jd t| jdd� �fS )Nr r� )rw rx r� )r/ rA r0 r0 r1 r� s z StampStep.unmerge_branch_identsc C s | j o
| jS )N)r� r� )r/ rA r0 r0 r1 rz s z StampStep.should_delete_branchc C s | j o
| jS )N)r� r� )r/ rA r0 r0 r1 r} s z StampStep.should_create_branchc C s t | j�dkS )Nr= )r? rw )r/ rA r0 r0 r1 r s z StampStep.should_merge_branchesc C s t | j�dkS )Nr= )r? rx )r/ rA r0 r0 r1 r� s z!StampStep.should_unmerge_branches)r. rc rd r2 r� r� r� rg r� r� r{ r~ r� r� r� rz r} r r� r0 r0 r0 r1 r� � s r� ) �loggingr$ �
contextlibr Z
sqlalchemyr r r r r Z sqlalchemy.engine.strategiesr Zsqlalchemy.enginer r3 Z util.compatr r � r
r � getLoggerr. r+ �objectr rP r� r� r� r0 r0 r0 r1 �<module> s"
S% A