Dashboard
PHP:
8.2.30
OS:
Linux
User:
dh_nv8b2m
/
/
usr
/
local
/
lib
/
python3.10
/
dist-packages
/
sqlalchemy
/
dialects
/
sybase
/
__pycache__
📤 Upload
📝 New File
📁 New Folder
Close
Editing: base.cpython-310.pyc
o [�h�| � @ s� d Z ddlZddlmZ ddlmZ ddlmZ ddlmZ ddl m Z ddl mZ dd lm Z dd lmZ ddlmZ ddlmZ dd lmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlmZ ddlm Z ddlm!Z! ddlm"Z" ddlm#Z# e$g d��Z%G d d!� d!e&�Z'G d"d#� d#e'ej!�Z(G d$d%� d%e'ej!�Z)G d&d'� d'e'ej*�Z+G d(d)� d)ej,�Z-G d*d+� d+ej.�Z/G d,d-� d-ej.�Z0G d.d/� d/ej.�Z1G d0d1� d1ej.�Z2G d2d3� d3ej3�Z4G d4d5� d5e j5�Z6i d6e�d7e�d8e�d9e�d:e-�d;e�d<e�d=e�d>e�d?e�d@e�dAe�dBe�dCe�dDe�dEe1�dFe0�i dGe�dHe�dIe�dJe�dKe�dLe�dMe#�dNe#�dOe#�dPe(�dQe)�dRe�dSe�dTe�dUe�dVe�dWe��eee+ee"e4e/ee e2dX� �Z7G dYdZ� dZej8�Z9G d[d\� d\e j:�Z;G d]d^� d^e j<�Z=G d_d`� d`e j>�Z?G dadb� dbe j@�ZAG dcdd� dde jB�ZCdS )ea .. 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�all�alter�and�any�as�asc�backup�begin�between�bigint�binary�bit�bottom�break�by�call� capability�cascade�case�cast�char�char_convert� character�check� checkpoint�close�comment�commit�connect� constraint�contains�continue�convert�create�cross�cube�current�current_timestamp�current_user�cursor�date�dbspace� deallocate�dec�decimal�declarer �delete�deleting�desc�distinct�do�double�drop�dynamic�else�elseif� encrypted�end�endif�escape�except� exception�exec�execute�existing�exists�externlogin�fetch�first�float�for�force�foreign�forward�from�full�goto�grant�group�having�holdlock� identified�if�in�index�index_lparen�inner�inout�insensitive�insert� inserting�install�instead�int�integer� integrated� intersect�into�iq�is� isolation�join�key�lateral�left�like�lock�login�long�match� membership�message�mode�modify�natural�new�no� noholdlock�not�notify�null�numeric�of�off�on�open�option�options�or�order�others�out�outer�over�passthrough� precision�prepare�primary�print� privileges�proc� procedure�publication� raiserror�readtext�real� reference� references�release�remote�remove�rename� reorganize�resource�restore�restrict�return�revoke�right�rollback�rollup�save� savepoint�scroll�select� sensitive�session�set�setuser�share�smallint�some�sqlcode�sqlstate�start�stop�subtrans�subtransaction�synchronize�syntax_error�table� temporary�then�time� timestamp�tinyint�to�top�tran�trigger�truncate�tsequal� unbounded�union�unique�unknown�unsigned�update�updating�user�using�validate�values� varbinary�varchar�variable�varying�view�wait�waitfor�when�where�while�window�with� with_cube�with_lparen�with_rollup�within�work� writetextc @ s e Zd ZdZdd� ZdS )�_SybaseUnitypeMixinz-these types appear to return a buffer object.c C s dd� }|S )Nc S s | d urt | �S d S �N)�str)�value� r �J/usr/local/lib/python3.10/dist-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 @ � e Zd Zd ZdS )�UNICHARN�r r r �__visit_name__r r r r r + � r c @ r )� UNIVARCHARNr r r r r r / r r c @ r )�UNITEXTNr r r r r r 3 r r c @ r )�TINYINTNr r r r r r 7 r r c @ r )�BITNr r r r r r ; r r c @ r )�MONEYNr r r r r r ? r r c @ r )� SMALLMONEYNr r r r r r C r r c @ r )�UNIQUEIDENTIFIERNr r r r r r G r r c @ r )�IMAGENr r r r r r K r r c @ sl e Zd Zdd� Zdd� Zdd� Zdd� Zd d � Zdd� Zd d� Z dd� Z dd� Zdd� Zdd� Z dd� ZdS )�SybaseTypeCompilerc K � | � |�S r� )�visit_IMAGE�r �type_�kwr r r �visit_large_binaryP � z%SybaseTypeCompiler.visit_large_binaryc K r r� )� visit_BITr r r r � visit_booleanS r z SybaseTypeCompiler.visit_booleanc K r r� )�visit_NVARCHARr r r r � visit_unicodeV r z SybaseTypeCompiler.visit_unicodec K � d|j S )NzUNICHAR(%d)��lengthr r r r � visit_UNICHARY r z SybaseTypeCompiler.visit_UNICHARc K r$ )NzUNIVARCHAR(%d)r% r r r r �visit_UNIVARCHAR\ r z#SybaseTypeCompiler.visit_UNIVARCHARc K � dS )Nr r r r r r � visit_UNITEXT_ � z SybaseTypeCompiler.visit_UNITEXTc K r) )Nr r r r r r � visit_TINYINTb r+ z SybaseTypeCompiler.visit_TINYINTc K r) )Nr r r r r r r e r+ zSybaseTypeCompiler.visit_IMAGEc K r) )Nr r r r r r r h r+ zSybaseTypeCompiler.visit_BITc K r) )Nr r r r r r �visit_MONEYk r+ zSybaseTypeCompiler.visit_MONEYc K r) )Nr r r r r r �visit_SMALLMONEYn r+ z#SybaseTypeCompiler.visit_SMALLMONEYc K r) )Nr r r r r r �visit_UNIQUEIDENTIFIERq r+ 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( r| r} r� r� zunsigned bigintzunsigned intzunsigned smallintr� rK rJ rd rR zdouble precisionr� � smallmoney�money� smalldatetime�datetimerG r� r3 r5 r� zcharacter varyingzchar varying�unicharzunicode character�ncharz national charznational character�nvarcharz nchar varyingznational char varying) znational character varyingr �unitextr) r� �imager* zlong varcharr� �uniqueidentifierc @ s e Zd Zdd� Zddd�ZdS )�SybaseInspectorc C s t j�| |� d S r� )r � Inspector�__init__)r �connr 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 �zSybaseInspector.get_table_idr� )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 � �)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. )�NotImplementedError)r � connectionr� r r r �set_ddl_autocommit� s z)SybaseExecutionContext.set_ddl_autocommitc C s� | j r.| jjj}|j}|d u}|r|j| jd v | _nd| _| jr.| j� d| j j�|� � | j rL| js9t�d��| jjj�d� | �| jjjd� d S 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)�isinsert�compiled� statementr� �_autoincrement_columnr� �compiled_parameters�_enable_identity_insertrF r^ r �identifier_preparer�format_table�isddl�should_autocommitr �InvalidRequestError�root_connection�engine�logger�inforF rE )r �tbl� seq_column�insert_has_sequencer r r �pre_exec� s4 ���� � ��zSybaseExecutionContext.pre_execc C sB | j r | �| jd� | jr| j�d| jj�| j j j� � d S d S )NFzSET IDENTITY_INSERT %s OFF)rO rF rR rL rF r^ r rM rN rH rI r� )r r r r � post_exec� s ����z SybaseExecutionContext.post_execc C s* | � � }|�d� |�� d }|�� |S )NzSELECT @@identity AS lastrowidr )� create_cursorr^ �fetchoner8 )r rF � lastrowidr r r � get_lastrowid� s z$SybaseExecutionContext.get_lastrowidN)r r r rL rF rY rZ r^ r r r r rC � s %rC c @ sp e Zd ZdZe�ejjdddd��Zdd� Z dd � Z d d� Zdd � Zdd� Z dd� Zdd� Zdd� Zdd� ZdS )�SybaseSQLCompilerT� dayofyear�weekday�millisecond)�doy�dow�millisecondsc K s<