Edit File: test_sequence.cpython-37.pyc
B ��4]5 � @ s� d dl mZ d dl mZ d dlmZ d dlmZ d dlmZ d dlmZ ddl m Z dd l m Z dd l mZ dd l m Z dd l m Z dd l m Z G dd� dej�ZG dd� de jej�ZG dd� dej�ZdS )� )�config)�fixtures)�eq_)� requirements)�Column)�Table� )�Integer)�MetaData)�schema)�Sequence)�String)�testingc @ sR e Zd ZdZdZdZedd� �Zdd� Zdd � Z d d � Z e j d d � �Z dd� ZdS )� SequenceTest)� sequencesTZeachc C sX t d|tdttd�dd�tdtd��� t d|tdttddd �dd�tdtd��� d S ) N�seq_pk�idZ tab_id_seqT)Z primary_key�data�2 � seq_opt_pk)�optional)r r r r r )�cls�metadata� r �Y/opt/alt/python37/lib64/python3.7/site-packages/sqlalchemy/testing/suite/test_sequence.py� define_tables s zSequenceTest.define_tablesc C s. t jj| jj�� dd� | �| jjt j� d S )Nz some data)r )r �db�execute�tablesr �insert�_assert_round_trip)�selfr r r �test_insert_roundtrip* s z"SequenceTest.test_insert_roundtripc C s* t jj| jj�� dd�}t|jdg� d S )Nz some data)r � )r r r r r r r �inserted_primary_key)r! �rr r r �test_insert_lastrowid. s z"SequenceTest.test_insert_lastrowidc C s$ t j�| jjjjj�}t|d� d S )Nr# ) r r r r r �cr �defaultr )r! r% r r r �test_nextval_direct2 s z SequenceTest.test_nextval_directc C s* t jj| jj�� dd�}t|jdg� d S )Nz some data)r r# )r r r r r r r r$ )r! r% r r r �test_optional_seq6 s z SequenceTest.test_optional_seqc C s |� |�� ��� }t|d� d S )N)r# z some data)r �select�firstr )r! �tableZconn�rowr r r r = s z SequenceTest._assert_round_tripN)�__name__� __module__� __qualname__� __requires__� __backend__Zrun_create_tables� classmethodr r" r& r) r Zsequences_optionalr* r r r r r r s r c @ s e Zd ZdZdZdd� ZdS )�SequenceCompilerTest)r Tc C sr t dt� tdttd��tdt��}|�� jdd�}tjj j d tjj d�� td��}| j |d|f d tjj d � d S ) N�x�yZy_seq�q� )r8 )� statement�dialectz#INSERT INTO x (y, q) VALUES (%s, 5)T)Z literal_bindsr; ) r r r r r r �valuesr r r; Zstatement_compilerZvisit_sequenceZassert_compile)r! r- �stmtZ seq_nextvalr r r �!test_literal_binds_inline_compileF s z6SequenceCompilerTest.test_literal_binds_inline_compileN)r/ r0 r1 r2 r3 r> r r r r r5 B s r5 c @ sd e Zd ZdZdZdd� Zejjdd� �Z dd� Z ejjd d � �Z ejjd d � �Z ejjd d� �Z dS )�HasSequenceTest)r Tc C sP t d�}tj�t�|�� z ttjj�tjd�d� W d tj�t� |�� X d S )N� user_id_seqT) r r r r r �CreateSequencer r; � has_sequence� DropSequence)r! �s1r r r �test_has_sequence_ s z!HasSequenceTest.test_has_sequencec C s\ t dtjd�}tj�t�|�� z"ttjj j tjdtjd�d� W d tj�t� |�� X d S )Nr@ )r T) r r � test_schemar r r r rA r r; rB rC )r! rD r r r �test_has_sequence_schemaj s z(HasSequenceTest.test_has_sequence_schemac C s t tjj�tjd�d� d S )Nr@ F)r r r r; rB )r! r r r �test_has_sequence_negx s z%HasSequenceTest.test_has_sequence_negc C s" t tjjjtjdtjd�d� d S )Nr@ )r F)r r r r; rB r rF )r! r r r � test_has_sequence_schemas_neg{ s z-HasSequenceTest.test_has_sequence_schemas_negc C sV t d�}tj�t�|�� z"ttjjjtjdt j d�d� W d tj�t� |�� X d S )Nr@ )r F) r r r r r rA r r; rB r rF rC )r! rD r r r �'test_has_sequence_default_not_in_remote� s z7HasSequenceTest.test_has_sequence_default_not_in_remotec C sV t dtjd�}tj�t�|�� z ttjj � tjd�d� W d tj�t� |�� X d S )Nr@ )r F) r r rF r r r r rA r r; rB rC )r! rD r r r �'test_has_sequence_remote_not_in_default� s z7HasSequenceTest.test_has_sequence_remote_not_in_defaultN)r/ r0 r1 r2 r3 rE r �requiresZschemasrG rH rI rJ rK r r r r r? [ s r? N)� r r Z assertionsr r r r r r r r r r Z TablesTestr ZAssertsCompiledSQLZTestBaser5 r? r r r r �<module> s 3