Edit File: base.cpython-37.pyc
B ��4]�| � � @ s d Z ddlZddlmZ ddlmZ ddlmZ ddlmZ ddl m Z ddl m Z dd l m Z dd l mZ dd lmZ dd lmZ dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm Z ddlm Z ddlm Z ddlm Z dd lm!Z! dd lm"Z" dd lm#Z# e$d d d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGdHdIdJdKdLdMdNdOdPdQdRdSdTdUdVdWdXdYdZd[d\d]d^d_d`dadbdcdddedfdgdhdidjdkdldmdndodpdqdrdsdtdudvdwdxdydzd{d|d}d~dd�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�d�g߃Z%G d�d�� d�e&�Z'G �d �d� �de'ej!�Z(G �d�d� �de'ej!�Z)G �d�d� �de'ej*�Z+G �d�d� �dej,�Z-G �d�d � �d ej.�Z/G �d �d � �d ej.�Z0G �d �d � �d ej.�Z1G �d�d� �dej.�Z2G �d�d� �dej3�Z4G �d�d� �de j5�Z6eeee e-eee eeeeeee e1e0eeee eee#e#e#e(e)eeeeeeee e+ee"e4e/e e e2�d�,Z7G �d�d� �de j8�Z9G �d�d� �de j:�Z;G �d�d� �de j<�Z=G �d�d � �d e j>�Z?G �d �d � �d e j@�ZAG �d �d � �d e jB�ZCdS (! a .. dialect:: sybase :name: Sybase .. note:: The Sybase dialect within SQLAlchemy **is not currently supported**. The dialect is not tested within continuous integration and is likely to have many issues and caveats not currently handled. � N)�exc)�schema)�types)�util)�default)� reflection)�compiler)�text)�BIGINT)�BINARY)�CHAR)�DATE)�DATETIME)�DECIMAL)�FLOAT)�INT)�INTEGER)�NCHAR)�NUMERIC)�NVARCHAR)�REAL)�SMALLINT)�TEXT)�TIME)� TIMESTAMP)�Unicode)� VARBINARY)�VARCHAR�add�allZalter�and�any�asZascZbackup�beginZbetween�bigint�binary�bitZbottom�breakZby�callZ capabilityZcascade�case�cast�charZ char_convert� character�checkZ checkpoint�close�commentZcommit�connectZ constraint�contains�continue�convert�createZcrossZcube�currentZcurrent_timestampZ current_user�cursor�dateZdbspaceZ deallocate�dec�decimalZdeclarer �deleteZdeleting�descZdistinctZdo�double�dropZdynamic�elseZelseifZ encrypted�endZendif�escape�except� exception�exec�execute�existing�existsZ externloginZfetch�first�float�for�forceZforeignZforward�from�fullZgotoZgrant�groupZhavingZholdlockZ identified�if�in�indexZ index_lparen�innerZinoutZ insensitive�insertZ inserting�installZinstead�int�integerZ integratedZ intersectZintoZiq�isZ isolation�join�keyZlateral�leftZlike�lockZlogin�long�matchZ membership�message�mode�modifyZnatural�new�noZ noholdlock�not�notify�null�numericZof�off�on�open�option�options�or�orderZothers�outZouterZoverZ passthrough� precisionZprepareZprimary�printZ privileges�procZ procedureZ publicationZ raiserrorZreadtext�real� referenceZ references�releaseZremote�remove�renameZ reorganize�resource�restoreZrestrict�returnZrevoke�rightZrollbackZrollupZsaveZ savepointZscroll�selectZ sensitiveZsession�setZsetuser�share�smallintZsomeZsqlcodeZsqlstate�start�stopZsubtransZsubtransactionZ synchronizeZ syntax_error�tableZ temporaryZthen�time� timestamp�tinyint�to�topZtranZtrigger�truncateZtsequalZ unbounded�union�unique�unknownZunsigned�updateZupdating�userZusing�validate�values� varbinary�varchar�variableZvarying�view�waitZwaitforZwhen�where�while�window�withZ with_cubeZ with_lparenZ with_rollupZwithinZworkZ writetextc @ s e Zd ZdZdd� ZdS )�_SybaseUnitypeMixinz-these types appear to return a buffer object.c C s dd� }|S )Nc S s | d k rt | �S d S d S )N)�str)�value� r� �R/opt/alt/python37/lib64/python3.7/site-packages/sqlalchemy/dialects/sybase/base.py�process" s z5_SybaseUnitypeMixin.result_processor.<locals>.processr� )�self�dialect�coltyper� r� r� r� �result_processor! s z$_SybaseUnitypeMixin.result_processorN)�__name__� __module__� __qualname__�__doc__r� r� r� r� r� r� s r� c @ s e Zd Zd ZdS )�UNICHARN)r� r� r� �__visit_name__r� r� r� r� r� + s r� c @ s e Zd Zd ZdS )� UNIVARCHARN)r� r� r� r� r� r� r� r� r� / s r� c @ s e Zd Zd ZdS )�UNITEXTN)r� r� r� r� r� r� r� r� r� 3 s r� c @ s e Zd Zd ZdS )�TINYINTN)r� r� r� r� r� r� r� r� r� 7 s r� c @ s e Zd Zd ZdS )�BITN)r� r� r� r� r� r� r� r� r� ; s r� c @ s e Zd Zd ZdS )�MONEYN)r� r� r� r� r� r� r� r� r� ? s r� c @ s e Zd Zd ZdS )� SMALLMONEYN)r� r� r� r� r� r� r� r� r� C s r� c @ s e Zd Zd ZdS )�UNIQUEIDENTIFIERN)r� r� r� r� r� r� r� r� r� G s r� c @ s e Zd Zd ZdS )�IMAGEN)r� r� r� r� r� r� r� r� r� K s r� c @ sl e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zd d � Zd d� Z dd� Z dd� Z dd� Z dd� Z dd� ZdS )�SybaseTypeCompilerc K s | � |�S )N)� visit_IMAGE)r� �type_�kwr� r� r� �visit_large_binaryP s z%SybaseTypeCompiler.visit_large_binaryc K s | � |�S )N)� visit_BIT)r� r� r� r� r� r� � visit_booleanS s z SybaseTypeCompiler.visit_booleanc K s | � |�S )N)Zvisit_NVARCHAR)r� r� r� r� r� r� � visit_unicodeV s z SybaseTypeCompiler.visit_unicodec K s d|j S )Nz UNICHAR(%d))�length)r� r� r� r� r� r� � visit_UNICHARY s z SybaseTypeCompiler.visit_UNICHARc K s d|j S )NzUNIVARCHAR(%d))r� )r� r� r� r� r� r� �visit_UNIVARCHAR\ s z#SybaseTypeCompiler.visit_UNIVARCHARc K s dS )Nr� r� )r� r� r� r� r� r� � visit_UNITEXT_ s z SybaseTypeCompiler.visit_UNITEXTc K s dS )Nr� r� )r� r� r� r� r� r� � visit_TINYINTb s z SybaseTypeCompiler.visit_TINYINTc K s dS )Nr� r� )r� r� r� r� r� r� r� e s z SybaseTypeCompiler.visit_IMAGEc K s dS )Nr� r� )r� r� r� r� r� r� r� h s z SybaseTypeCompiler.visit_BITc K s dS )Nr� r� )r� r� r� r� r� r� � visit_MONEYk s z SybaseTypeCompiler.visit_MONEYc K s dS )Nr� r� )r� r� r� r� r� r� �visit_SMALLMONEYn s z#SybaseTypeCompiler.visit_SMALLMONEYc K s dS )Nr� r� )r� r� r� r� r� r� �visit_UNIQUEIDENTIFIERq s z)SybaseTypeCompiler.visit_UNIQUEIDENTIFIERN)r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� r� O s r� ),r$ rT rU r} r� zunsigned bigintz unsigned intzunsigned smallintre r9 r8 rH r< zdouble precisionrq Z smallmoneyZmoneyZ smalldatetime�datetimer7 r� r+ r, r� zcharacter varyingz char varyingZunicharzunicode characterZncharz national charznational characterZnvarcharz nchar varyingznational char varyingznational character varyingr Zunitextr% r� Zimager& z long varcharr� Zuniqueidentifierc @ s e Zd Zdd� Zddd�ZdS )�SybaseInspectorc C s t j�| |� d S )N)r � Inspector�__init__)r� Zconnr� r� r� r� � s zSybaseInspector.__init__Nc C s | j j| j||| jd�S )z3Return the table id from `table_name` and `schema`.)� info_cache)r� � get_table_id�bindr� )r� � table_namer r� r� r� r� � s z SybaseInspector.get_table_id)N)r� r� r� r� r� r� r� r� r� r� � s r� c @ s0 e Zd ZdZdd� Zdd� Zdd� Zdd � Zd S ) �SybaseExecutionContextFc C s t � �dS )a� Must be implemented by subclasses to accommodate DDL executions. "connection" is the raw unwrapped DBAPI connection. "value" is True or False. when True, the connection should be configured such that a DDL can take place subsequently. when False, a DDL has taken place and the connection should be resumed into non-autocommit mode. N)�NotImplementedError)r� � connectionr� r� r� r� �set_ddl_autocommit� s z)SybaseExecutionContext.set_ddl_autocommitc C s� | j r\| jjj}|j}|d k }|r6|j| jd k| _nd| _| jr\| j� d| j j � |� � | j r�| jsrt�d��| jjj�d� | �| jjjd� d S )Nr FzSET IDENTITY_INSERT %s ONzGThe Sybase dialect only supports DDL in 'autocommit' mode at this time.z-AUTOCOMMIT (Assuming no Sybase 'ddl in tran')T)Zisinsert�compiled� statementr� �_autoincrement_columnrX Zcompiled_parameters�_enable_identity_insertr6 rD r� �identifier_preparer� format_table�isddlZshould_autocommitr ZInvalidRequestError�root_connectionZengine�logger�infor� r� )r� ZtblZ seq_columnZinsert_has_sequencer� r� r� �pre_exec� s& z SybaseExecutionContext.pre_execc C s> | j r| �| jd� | jr:| j�d| jj�| j j j � � d S )NFzSET IDENTITY_INSERT %s OFF) r� r� r� r� r6 rD r� r� r� r� r� r� )r� r� r� r� � post_exec� s z SybaseExecutionContext.post_execc C s* | � � }|�d� |�� d }|�� |S )Nz SELECT @@identity AS lastrowidr )Z create_cursorrD �fetchoner. )r� r6 Z lastrowidr� r� r� � get_lastrowid� s z$SybaseExecutionContext.get_lastrowidN)r� r� r� r� r� r� r� r� r� r� r� r� r� � s % r� c @ sp e Zd ZdZe�ejjdddd��Zdd� Z dd � Z d d � Z d d � Z dd� Z dd� Zdd� Zdd� Zdd� ZdS )�SybaseSQLCompilerTZ dayofyear�weekdayZ millisecond)ZdoyZdowZ millisecondsc K s< |j r dp d}|j}|r&|d|f 7 }|j}|r8td��|S )Nz DISTINCT � zTOP %s z"Sybase ASE does not support OFFSET)Z _distinct�_limit�_offsetr� )r� rz r� �s�limit�offsetr� r� r� �get_select_precolumns s z'SybaseSQLCompiler.get_select_precolumnsc C s |S )Nr� )r� r� r r� r� r� �get_from_hint_text s z$SybaseSQLCompiler.get_from_hint_textc K s dS )Nr� r� )r� rz r� r� r� r� � limit_clause s z SybaseSQLCompiler.limit_clausec K s* | j �|j|j�}d|| j|jf|�f S )NzDATEPART("%s", %s))� extract_map�get�fieldr� �expr)r� �extractr� r� r� r� r� � visit_extract s z SybaseSQLCompiler.visit_extractc K s dS )Nz GETDATE()r� )r� �fnr� r� r� r� �visit_now_func s z SybaseSQLCompiler.visit_now_funcc C s dS )Nr� r� )r� rz r� r� r� �for_update_clause s z#SybaseSQLCompiler.for_update_clausec K s: d|d< | j |jf|�}|r2| �� r*|jr2d| S dS d S )NTZ literal_bindsz ORDER BY r� )r� Z_order_by_clauseZ is_subqueryr� )r� rz r� Zorder_byr� r� r� �order_by_clause% s z!SybaseSQLCompiler.order_by_clausec C s d}|r d}|j | dd|d�S )z=If we have extra froms make sure we render any alias as hint.FT)�asfromZiscrud�ashint)�_compiler_dispatch)r� � delete_stmt� from_table� extra_fromsr� r� r� r� �delete_table_clause/ s z%SybaseSQLCompiler.delete_table_clausec s& dd� � ��fdd�|g| D �� S )z4Render the DELETE .. FROM clause specific to Sybase.zFROM z, c 3 s& | ] }|j �fd � d����V qdS )T)r� Z fromhintsN)r� )�.0�t)� from_hintsr� r� r� r� � <genexpr>= s z=SybaseSQLCompiler.delete_extra_from_clause.<locals>.<genexpr>)rW )r� r� r� r� r� r� r� )r� r� r� r� �delete_extra_from_clause8 s z*SybaseSQLCompiler.delete_extra_from_clauseN)r� r� r� Zansi_bind_rulesr Z update_copyr � SQLCompilerr� r� r� r� r� r� r� r� r� r� r� r� r� r� r� � s r� c @ s e Zd Zdd� Zdd� ZdS )�SybaseDDLCompilerc K s� | j �|�d | jjj|j|d� }|jd kr8t�d��|jj }||kr�t |j t j �oZ|j }|rx|jphd|jppd }}nd\}}||fdkr�|d7 }q�|d||f 7 }nF| �|�}|d k r�|d| 7 }|jd k r�|jr�|jr�|d 7 }n|d 7 }|S ) N� )Ztype_expressionzHThe Sybase dialect requires Table-bound columns in order to generate DDL� )r� r� z IDENTITYz IDENTITY(%s,%s)z DEFAULT z NOT NULLz NULL)�preparerZ format_columnr� � type_compilerr� �typer� r � CompileErrorr� � isinstancer � sa_schema�Sequencer~ � incrementZget_column_default_string�nullableZ primary_key) r� �column�kwargsZcolspecZseq_col�sequencer~ r r r� r� r� �get_column_specificationC s. z*SybaseDDLCompiler.get_column_specificationc C s* |j }d| j�|jj�| j|j dd�f S )Nz DROP INDEX %s.%sF)Zinclude_schema)�elementr� Zquote_identifierr� �nameZ_prepared_index_name)r� r= rP r� r� r� �visit_drop_indexo s z"SybaseDDLCompiler.visit_drop_indexN)r� r� r� r r r� r� r� r� r� B s ,r� c @ s e Zd ZeZdS )�SybaseIdentifierPreparerN)r� r� r� �RESERVED_WORDSZreserved_wordsr� r� r� r� r w s r c s� e Zd ZdZdZdZdZdZdZdZ i Z e Z e Z eZeZeZeZg Zdd� Z� fdd�Zd d d �Zejd d d ��Z d d� Z ejd!dd��Z ejd"dd��Z ejd#dd��Z ejdd� �Z!ejd$dd��Z"ejd%dd��Z#ejd&dd ��Z$d'd d �Z%� Z&S )(� SybaseDialectZsybaseFTc C s |� td�jtd��S )Nz SELECT user_name() as user_name)�username)�scalarr �columnsr )r� r� r� r� r� �_get_default_schema_name� s z&SybaseDialect._get_default_schema_namec s6 t t| ��|� | jd k r,| jdk r,d| _nd| _d S )N)� � � )�superr � initializeZserver_version_infoZmax_identifier_length)r� r� )� __class__r� r� r � s zSybaseDialect.initializeNc K sv d}|dkr| j }td�}tjrHt|t�r4|�d�}t|t�rH|�d�}|j|||d�}|�� }|dkrrt � |��|S )z�Fetch the id for schema.table_name. Several reflection methods require the table id. The idea for using this method is that it can be fetched one time and cached for subsequent calls. Nz� SELECT o.id AS id FROM sysobjects o JOIN sysusers u ON o.uid=u.uid WHERE u.name = :schema_name AND o.name = :table_name AND o.type in ('U', 'V') �ascii)� schema_namer� ) �default_schema_namer r �py2kr �unicode�encoderD r r �NoSuchTableError)r� r� r� r r� �table_idZ TABLEID_SQL�resultr� r� r� r� � s zSybaseDialect.get_table_idc K s~ | j ||||�d�d�}td�}|j||d�}g }xF|D ]>\} } } } } }}}| �| | t| �t| �| |||�}|�|� q8W |S )Nr� )r� a* SELECT col.name AS name, t.name AS type, (col.status & 8) AS nullable, (col.status & 128) AS autoincrement, com.text AS 'default', col.prec AS precision, col.scale AS scale, col.length AS length FROM systypes t, syscolumns col LEFT OUTER JOIN syscomments com ON col.cdefault = com.id WHERE col.usertype = t.usertype AND col.id = :table_id ORDER BY col.colid )r" )r� r� r rD �_get_column_info�bool�append)r� r� r� r r� r" � COLUMN_SQL�resultsr r r� r � autoincrementZdefault_rn �scaler� Zcol_infor� r� r� � get_columns� s& zSybaseDialect.get_columnsc C s� | j �|d �} i } | ttfkr(||f} n0| tkr8|f} n | ttttt t fkrT|f} nd} | rh| | | �} nt � d||f � t j} |r�|�dd��� }t�ddd� |�}nd }t|| |||d�} | S ) Nr� z*Did not recognize type '%s' of column '%s'�DEFAULTr� z^'(.*)'$c S s | � d�S )Nr� )rM )�mr� r� r� �<lambda> � z0SybaseDialect._get_column_info.<locals>.<lambda>)r r r r r) )� ischema_namesr� r r r r r r� r� r r r �warn�sqltypesZNULLTYPE�replace�strip�re�sub�dict) r� r r� r r) r rn r* r� r� r �argsZ column_infor� r� r� r$ � s2 z SybaseDialect._get_column_infoc K s� | j ||||�d�d�}i }i }g }||d�||< td�} |j| |d�} i } x | D ]} | d | | d < qRW | ||< td�} |j| |d��� }td �}�x:|D �]0}|d }||k�rF|j||d�}|�� }|�� |d d d�}|d k s�|d | jk�r|d |d < |||< |j| |d�} i }x | D ]} | d || d < �q$W |||< || }|| }g }g }xHtd |d d �D ]2}|� | |d| � |� ||d| � �qrW ||d |d ||d d�}|� |� q�W |S )Nr� )r� )r r zu SELECT c.colid AS id, c.name AS name FROM syscolumns c WHERE c.id = :table_id )r" r �ida( SELECT o.name AS name, r.reftabid AS reftable_id, r.keycnt AS 'count', r.fokey1 AS fokey1, r.fokey2 AS fokey2, r.fokey3 AS fokey3, r.fokey4 AS fokey4, r.fokey5 AS fokey5, r.fokey6 AS fokey6, r.fokey7 AS fokey7, r.fokey1 AS fokey8, r.fokey9 AS fokey9, r.fokey10 AS fokey10, r.fokey11 AS fokey11, r.fokey12 AS fokey12, r.fokey13 AS fokey13, r.fokey14 AS fokey14, r.fokey15 AS fokey15, r.fokey16 AS fokey16, r.refkey1 AS refkey1, r.refkey2 AS refkey2, r.refkey3 AS refkey3, r.refkey4 AS refkey4, r.refkey5 AS refkey5, r.refkey6 AS refkey6, r.refkey7 AS refkey7, r.refkey1 AS refkey8, r.refkey9 AS refkey9, r.refkey10 AS refkey10, r.refkey11 AS refkey11, r.refkey12 AS refkey12, r.refkey13 AS refkey13, r.refkey14 AS refkey14, r.refkey15 AS refkey15, r.refkey16 AS refkey16 FROM sysreferences r JOIN sysobjects o on r.tableid = o.id WHERE r.tableid = :table_id z� SELECT o.name AS name, u.name AS 'schema' FROM sysobjects o JOIN sysusers u ON o.uid = u.uid WHERE o.id = :table_id � reftable_idr r� �countzfokey%izrefkey%i)�constrained_columnsZreferred_schemaZreferred_table�referred_columnsr ) r� r� r rD Zfetchallr� r. r �ranger& )r� r� r� r r� r" Z table_cacheZ column_cacheZ foreign_keysr' r( r �colZREFCONSTRAINT_SQLZreferential_constraintsZ REFTABLE_SQL�rr: �cZreftableZ table_infoZreftable_columnsr< r= �iZfk_infor� r� r� �get_foreign_keys) sb z SybaseDialect.get_foreign_keysc K s� | j ||||�d�d�}td�}|j||d�}g }x^|D ]V} g } x*td| d �D ]} | �| d| f � qPW | d t| d �| d �} |�| � q8W |S ) Nr� )r� a� SELECT object_name(i.id) AS table_name, i.keycnt AS 'count', i.name AS name, (i.status & 0x2) AS 'unique', index_col(object_name(i.id), i.indid, 1) AS col_1, index_col(object_name(i.id), i.indid, 2) AS col_2, index_col(object_name(i.id), i.indid, 3) AS col_3, index_col(object_name(i.id), i.indid, 4) AS col_4, index_col(object_name(i.id), i.indid, 5) AS col_5, index_col(object_name(i.id), i.indid, 6) AS col_6, index_col(object_name(i.id), i.indid, 7) AS col_7, index_col(object_name(i.id), i.indid, 8) AS col_8, index_col(object_name(i.id), i.indid, 9) AS col_9, index_col(object_name(i.id), i.indid, 10) AS col_10, index_col(object_name(i.id), i.indid, 11) AS col_11, index_col(object_name(i.id), i.indid, 12) AS col_12, index_col(object_name(i.id), i.indid, 13) AS col_13, index_col(object_name(i.id), i.indid, 14) AS col_14, index_col(object_name(i.id), i.indid, 15) AS col_15, index_col(object_name(i.id), i.indid, 16) AS col_16 FROM sysindexes i, sysobjects o WHERE o.id = i.id AND o.id = :table_id AND (i.status & 2048) = 0 AND i.indid BETWEEN 1 AND 254 )r" r� r; zcol_%ir r� )r r� � column_names)r� r� r rD r> r& r% ) r� r� r� r r� r" Z INDEX_SQLr( �indexesr@ rD rB Z index_infor� r� r� � get_indexes� s zSybaseDialect.get_indexesc K s� | j ||||�d�d�}td�}|j||d�}|�� }|�� g } |r�x.td|d d �D ]} | �|d| f � qZW | |d d �S g d d �S d S ) Nr� )r� ay SELECT object_name(i.id) AS table_name, i.keycnt AS 'count', i.name AS name, index_col(object_name(i.id), i.indid, 1) AS pk_1, index_col(object_name(i.id), i.indid, 2) AS pk_2, index_col(object_name(i.id), i.indid, 3) AS pk_3, index_col(object_name(i.id), i.indid, 4) AS pk_4, index_col(object_name(i.id), i.indid, 5) AS pk_5, index_col(object_name(i.id), i.indid, 6) AS pk_6, index_col(object_name(i.id), i.indid, 7) AS pk_7, index_col(object_name(i.id), i.indid, 8) AS pk_8, index_col(object_name(i.id), i.indid, 9) AS pk_9, index_col(object_name(i.id), i.indid, 10) AS pk_10, index_col(object_name(i.id), i.indid, 11) AS pk_11, index_col(object_name(i.id), i.indid, 12) AS pk_12, index_col(object_name(i.id), i.indid, 13) AS pk_13, index_col(object_name(i.id), i.indid, 14) AS pk_14, index_col(object_name(i.id), i.indid, 15) AS pk_15, index_col(object_name(i.id), i.indid, 16) AS pk_16 FROM sysindexes i, sysobjects o WHERE o.id = i.id AND o.id = :table_id AND (i.status & 2048) = 2048 AND i.indid BETWEEN 1 AND 254 )r" r� r; zpk_%ir )r< r )r� r� r rD r� r. r> r& ) r� r� r� r r� r" ZPK_SQLr( Zpksr< rB r� r� r� �get_pk_constraint� s z SybaseDialect.get_pk_constraintc K s t d�}|�|�}dd� |D �S )Nz%SELECT u.name AS name FROM sysusers uc S s g | ] }|d �qS )r r� )r� r� r� r� r� � <listcomp>� s z2SybaseDialect.get_schema_names.<locals>.<listcomp>)r rD )r� r� r� Z SCHEMA_SQLZschemasr� r� r� �get_schema_names� s z SybaseDialect.get_schema_namesc K sL |d kr| j }td�}tjr0t|t�r0|�d�}|j||d�}dd� |D �S )Nz� SELECT o.name AS name FROM sysobjects o JOIN sysusers u ON o.uid = u.uid WHERE u.name = :schema_name AND o.type = 'U' r )r c S s g | ] }|d �qS )r r� )r� r� r� r� r� rH s z1SybaseDialect.get_table_names.<locals>.<listcomp>)r r r r r r r rD )r� r� r r� Z TABLE_SQLZtablesr� r� r� �get_table_names� s z SybaseDialect.get_table_namesc K sF |d kr| j }td�}tjr0t|t�r0|�d�}|j||d�}|�� S )Nz� SELECT c.text FROM syscomments c JOIN sysobjects o ON c.id = o.id WHERE o.name = :view_name AND o.type = 'V' r )� view_name) r r r r r r r rD r )r� r� rK r r� Z VIEW_DEF_SQLr� r� r� r� �get_view_definition s z!SybaseDialect.get_view_definitionc K sL |d kr| j }td�}tjr0t|t�r0|�d�}|j||d�}dd� |D �S )Nz� SELECT o.name AS name FROM sysobjects o JOIN sysusers u ON o.uid = u.uid WHERE u.name = :schema_name AND o.type = 'V' r )r c S s g | ] }|d �qS )r r� )r� �vr� r� r� rH < s z0SybaseDialect.get_view_names.<locals>.<listcomp>)r r r r r r r rD )r� r� r r� ZVIEW_SQLZviewsr� r� r� �get_view_names) s z SybaseDialect.get_view_namesc C s2 y| � |||� W n tjk r( dS X dS d S )NFT)r� r r! )r� r� r� r r� r� r� � has_table> s zSybaseDialect.has_table)N)N)N)N)N)N)N)N)N)'r� r� r� r Zsupports_unicode_statementsZsupports_sane_rowcountZ supports_sane_multi_rowcountZsupports_native_booleanZsupports_unicode_bindsZpostfetch_lastrowidZcolspecsr0 r� r� r� Zstatement_compilerr� Z ddl_compilerr r� r� Z inspectorZconstruct_argumentsr r r� r �cacher+ r$ rC rF rG rI rJ rL rN rO � __classcell__r� r� )r r� r { sF $ 23 e 2 1 r )Dr� r5 � sqlalchemyr r r r r2 r Zsqlalchemy.enginer r Zsqlalchemy.sqlr r Zsqlalchemy.typesr r r r r r r r r r r r r r r r r r r r r{ r �objectr� r� r� Z UnicodeTextr� ZIntegerr� Z TypeEnginer� r� r� r� Z LargeBinaryr� ZGenericTypeCompilerr� r0 r� r� ZDefaultExecutionContextr� r� r� Z DDLCompilerr� ZIdentifierPreparerr ZDefaultDialectr r� r� r� r� �<module> st ' HH5