
    +h~                        d Z ddlZd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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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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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lm!Z! ddlm"Z" ddlm#Z#  e$g d      Z% G d  d!e&      Z' G d" d#e'ejB                        Z( G d$ d%e'ejB                        Z) G d& d'e'ejT                        Z+ G d( d)ejX                        Z- G d* d+ej\                        Z/ G d, d-ej\                        Z0 G d. d/ej\                        Z1 G d0 d1ej\                        Z2 G d2 d3ejf                        Z4 G d4 d5ejj                        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eee+ee"e4e/ee e2dX
Z7 G dY dZejp                        Z9 G d[ d\e
jt                        Z; G d] d^ejx                        Z= G d_ d`ej|                        Z? G da dbej                        ZA G dc dde
j                        ZCy)ea  

.. dialect:: sybase
    :name: Sybase

.. note::

    The Sybase dialect within SQLAlchemy **is not currently supported**.
    It is not tested within continuous integration and is likely to have
    many issues and caveats not currently handled. Consider using the
    `external dialect <https://github.com/gordthompson/sqlalchemy-sybase>`_
    instead.

.. deprecated:: 1.4 The internal Sybase dialect is deprecated and will be
   removed in a future version. Use the external dialect.

    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                       e Zd ZdZd Zy)_SybaseUnitypeMixinz-these types appear to return a buffer object.c                     d }|S )Nc                     | t        |       S y N)str)values    R/var/www/html/venv/lib/python3.12/site-packages/sqlalchemy/dialects/sybase/base.pyprocessz5_SybaseUnitypeMixin.result_processor.<locals>.process'  s     5z!     )selfdialectcoltyper  s       r  result_processorz$_SybaseUnitypeMixin.result_processor&  s    	 r  N)__name__
__module____qualname____doc__r  r  r  r  r   r   #  s
    7r  r   c                       e Zd Zd Zy)UNICHARNr  r  r  __visit_name__r  r  r  r  r  0      Nr  r  c                       e Zd Zd Zy)
UNIVARCHARNr  r  r  r  r  r  4      !Nr  r  c                       e Zd Zd Zy)UNITEXTNr  r  r  r  r  r  8  r  r  r  c                       e Zd Zd Zy)TINYINTNr  r  r  r  r  r  <  r  r  r  c                       e Zd Zd Zy)BITNr  r  r  r  r  r  @  s    Nr  r  c                       e Zd Zd Zy)MONEYNr  r  r  r  r  r  D      Nr  r  c                       e Zd Zd Zy)
SMALLMONEYNr  r  r  r  r"  r"  H  r  r  r"  c                       e Zd Zd Zy)UNIQUEIDENTIFIERNr  r  r  r  r$  r$  L  s    'Nr  r$  c                       e Zd Zd Zy)IMAGENr  r  r  r  r&  r&  P  r   r  r&  c                   T    e Zd Zd Zd Zd Zd Zd Zd Zd Z	d Z
d	 Zd
 Zd Zd Zy)SybaseTypeCompilerc                 $    | j                  |      S r  )visit_IMAGEr  type_kws      r  visit_large_binaryz%SybaseTypeCompiler.visit_large_binaryU  s    &&r  c                 $    | j                  |      S r  )	visit_BITr+  s      r  visit_booleanz SybaseTypeCompiler.visit_booleanX  s    ~~e$$r  c                 $    | j                  |      S r  )visit_NVARCHARr+  s      r  visit_unicodez SybaseTypeCompiler.visit_unicode[  s    ""5))r  c                      d|j                   z  S )NzUNICHAR(%d)lengthr+  s      r  visit_UNICHARz SybaseTypeCompiler.visit_UNICHAR^  s    u||++r  c                      d|j                   z  S )NzUNIVARCHAR(%d)r6  r+  s      r  visit_UNIVARCHARz#SybaseTypeCompiler.visit_UNIVARCHARa  s    %,,..r  c                      y)Nr  r  r+  s      r  visit_UNITEXTz SybaseTypeCompiler.visit_UNITEXTd      r  c                      y)Nr  r  r+  s      r  visit_TINYINTz SybaseTypeCompiler.visit_TINYINTg  r=  r  c                      y)Nr&  r  r+  s      r  r*  zSybaseTypeCompiler.visit_IMAGEj      r  c                      y)Nr  r  r+  s      r  r0  zSybaseTypeCompiler.visit_BITm  s    r  c                      y)Nr  r  r+  s      r  visit_MONEYzSybaseTypeCompiler.visit_MONEYp  rA  r  c                      y)Nr"  r  r+  s      r  visit_SMALLMONEYz#SybaseTypeCompiler.visit_SMALLMONEYs  s    r  c                      y)Nr$  r  r+  s      r  visit_UNIQUEIDENTIFIERz)SybaseTypeCompiler.visit_UNIQUEIDENTIFIERv  s    !r  N)r  r  r  r.  r1  r4  r8  r:  r<  r?  r*  r0  rD  rF  rH  r  r  r  r(  r(  T  s>    '%*,/"r  r(  r)   r}   r~   r   r   zunsigned bigintzunsigned intzunsigned smallintr   rL   rK   re   rS   zdouble precisionr   
smallmoneymoneysmalldatetimedatetimerH   r   r4   r6   r   zcharacter varyingzchar varyingunicharzunicode characterncharznational charznational characternvarcharznchar varyingznational char varying)
znational character varyingr
   unitextr*   r   imager+   zlong varcharr   uniqueidentifierc                       e Zd Zd ZddZy)SybaseInspectorc                 D    t         j                  j                  | |       y r  )r   	Inspector__init__)r  conns     r  rW  zSybaseInspector.__init__  s    %%dD1r  Nc                 h    | j                   j                  | j                  ||| j                        S )z3Return the table id from `table_name` and `schema`.
info_cache)r	  get_table_idbindr[  )r  
table_namer   s      r  r\  zSybaseInspector.get_table_id  s1     ||((IIz6doo ) 
 	
r  r  )r  r  r  rW  r\  r  r  r  rT  rT    s    2
r  rT  c                   (    e Zd ZdZd Zd Zd Zd Zy)SybaseExecutionContextFc                     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  s      r  set_ddl_autocommitz)SybaseExecutionContext.set_ddl_autocommit  s     "##r  c                    | j                   r| j                  j                  j                  }|j                  }|d u}|r!|j
                  | j                  d   v | _        nd| _        | j                  rA| j                  j                  d| j                  j                  j                  |      z         | j                  r| j                  st        j                   d      | j"                  j$                  j&                  j)                  d       | j+                  | j"                  j,                  j,                  d       y y )Nr   FzSET 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_insertrG   r_   r	  identifier_preparerformat_tableisddlshould_autocommitr   InvalidRequestErrorroot_connectionengineloggerinford  rc  )r  tbl
seq_columninsert_has_sequences       r  pre_execzSybaseExecutionContext.pre_exec  s   ==--))//C22J",D"8"NNd&>&>q&AA , 05,++##/ll66CCCHI
 :: ))--= 
   ''..33? ##$$//::D r  c                 ,   | j                   r| j                  | j                  d       | j                  r`| j                  j                  d| j                  j                  j                  | j                  j                  j                        z         y y )NFzSET IDENTITY_INSERT %s OFF)rn  rd  rq  rk  rG   r_   r	  rl  rm  rg  rh  r   )r  s    r  	post_execz SybaseExecutionContext.post_exec  sr    ::##D$8$8%@''KK,,,22??MM++11 (r  c                     | j                         }|j                  d       |j                         d   }|j                          |S )NzSELECT @@identity AS lastrowidr   )create_cursorr_   fetchoner9   )r  rG   	lastrowids      r  get_lastrowidz$SybaseExecutionContext.get_lastrowid  s=    ##%78OO%a(	r  N)r  r  r  rk  rd  rx  rz  r  r  r  r  r`  r`    s    #
$#J
r  r`  c                       e Zd ZdZ ej
                  ej                  j                  dddd      Zd Z	d Z
d Zd	 Zd
 Zd Zd Zd Zy)SybaseSQLCompilerT	dayofyearweekdaymillisecond)doydowmillisecondsc                     |S r  r  )r  r   r
   s      r  get_from_hint_textz$SybaseSQLCompiler.get_from_hint_text  s    r  c                     d}|j                   #|d | j                  |j                   fi |z   z  }|j                  4|j                   |dz  }|d | j                  |j                  fi |z   z  }|S )N z ROWS LIMIT z ROWSz OFFSET )_limit_clauser  _offset_clause)r  r   r-  r
   s       r  limit_clausezSybaseSQLCompiler.limit_clause
  s    +N\T\\&2F2F%M"%MMMD  ,##+Jf.C.C!Jr!JJJDr  c                     | j                   j                  |j                  |j                        }d|d | j                  |j                  fi |dS )Nz
DATEPART("z", ))extract_mapgetfieldr  expr)r  extractr-  r  s       r  visit_extractzSybaseSQLCompiler.visit_extract  sA      $$W]]GMMB',ldll7<<.N2.NOOr  c                      y)Nz	GETDATE()r  )r  fnr-  s      r  visit_now_funcz SybaseSQLCompiler.visit_now_func  s    r  c                      y)Nr  r  )r  r   s     r  for_update_clausez#SybaseSQLCompiler.for_update_clause  s     r  c                     d|d<    | j                   |j                  fi |}|r!| j                         r|j                  rd|z   S y)NTliteral_bindsz
 ORDER BY r  )r  _order_by_clauseis_subquery_limit)r  r   r-  order_bys       r  order_by_clausez!SybaseSQLCompiler.order_by_clause   sK    "?4<< 7 7>2> T--/6==(**r  c                 8    d}|rd}|j                  | dd|      S )z=If we have extra froms make sure we render any alias as hint.FT)asfromiscrudashint_compiler_dispatch)r  delete_stmt
from_tableextra_fromsr  s        r  delete_table_clausez%SybaseSQLCompiler.delete_table_clause*  s0    F,,d6 - 
 	
r  c                 X     dd<   ddj                   fd|g|z   D              z   S )z4Render the DELETE .. FROM clause specific to Sybase.Tr  zFROM z, c              3   H   K   | ]  } |j                   fd i  yw)	fromhintsNr  ).0t
from_hintsr-  r  s     r  	<genexpr>z=SybaseSQLCompiler.delete_extra_from_clause.<locals>.<genexpr>8  s0      #
 !A  BBrB#
s   ")r   )r  r  r  r  r  r-  s   `   ``r  delete_extra_from_clausez*SybaseSQLCompiler.delete_extra_from_clause3  s:     8 #
 \K/#
 
 
 	
r  N)r  r  r  ansi_bind_rulesr   update_copyr	   SQLCompilerr  r  r  r  r  r  r  r  r  r  r  r  r  r    s[    O"$""((I}MK
P


r  r  c                       e Zd Zd Zd Zy)SybaseDDLCompilerc                    | j                   j                  |      dz   | j                  j                  j	                  |j
                  |      z   }|j                  t        j                  d      |j                  j                  }||u rvt        |j                  t        j                        xr |j                  }|r!|j                  xs d|j                  xs d}}nd\  }}||fdk(  r|dz  }|S |d|d|d	z  }|S | j!                  |      }||d
|z   z  }|j"                  $|j"                  r|j$                  r|dz  }|S |dz  }|S )N )type_expressionzHThe Sybase dialect requires Table-bound columns in order to generate DDL   )r  r  z	 IDENTITYz
 IDENTITY(,r  z	 DEFAULT z	 NOT NULLz NULL)preparerformat_columnr	  type_compilerr  typer   r   CompileErrorri  
isinstancer   	sa_schemaSequencer   	incrementget_column_default_stringnullableprimary_key)	r  columnkwargscolspecseq_colsequencer   r  r   s	            r  get_column_specificationz*SybaseDDLCompiler.get_column_specification?  st   MM''/ll((00V 1  	 <<""3  ,,44 f6>>9+=+=> #NN  #+>>#6Q8J8J8Oay#' yy!V+;&  	BB  44V<G";00*&*<*<{*G  w&Gr  c                     |j                   }d| j                  j                  |j                  j                        d| j                  |j                   d      S )Nz
DROP INDEX .F)include_schema)elementr  quote_identifierr   name_prepared_index_name)r  rT   rt   s      r  visit_drop_indexz"SybaseDDLCompiler.visit_drop_indexk  sH    MM**5;;+;+;<%%dll5%I
 	
r  N)r  r  r  r  r  r  r  r  r  r  >  s    *X
r  r  c                       e Zd ZeZy)SybaseIdentifierPreparerN)r  r  r  RESERVED_WORDSreserved_wordsr  r  r  r  r  s  s    #Nr  r  c                       e Zd ZdZdZdZdZdZdZdZ	dZ
i ZeZeZeZeZeZeZg Z fdZd Z fdZddZej:                  dd       Zd	 Zej:                  dd
       Z ej:                  dd       Z!ej:                  dd       Z"ej:                  d        Z#ej:                  dd       Z$ej:                  dd       Z%ej:                  dd       Z&ddZ' xZ(S )SybaseDialectsybaseFTc                 Z    t        j                  dd       t        t        |   |i | y )NzThe Sybase dialect is deprecated and will be removed in a future version. This dialect is superseded by the external dialect https://github.com/gordthompson/sqlalchemy-sybase.z1.4)version)r   warn_deprecatedsuperr  rW  )r  argsr  	__class__s      r  rW  zSybaseDialect.__init__  s2    I 		
 	mT+T<V<r  c                 ^    |j                  t        d      j                  t                    S )NzSELECT user_name() as user_name)username)scalarr
   columnsr   )r  rc  s     r  _get_default_schema_namez&SybaseDialect._get_default_schema_name  s,      23;;W;M
 	
r  c                     t         t        |   |       | j                  | j                  dk  rd| _        y d| _        y )N)         )r  r  
initializeserver_version_infomax_identifier_length)r  rc  r  s     r  r  zSybaseDialect.initialize  s<    mT-j9$$0((50)+D&),D&r  c                 V   d}|| j                   }t        d      }t        j                  rBt	        |t
              r|j                  d      }t	        |t
              r|j                  d      }|j                  |||      }|j                         }|t        j                  |      |S )zFetch 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encoder_   r  r   NoSuchTableError)r  rc  r^  r   r-  table_idTABLEID_SQLresults           r  r\  zSybaseDialect.get_table_id  s     >--F
 99&'*w/*g.'..w7
##V
 $ 
 ==?&&z22r  c                 $   | j                  ||||j                  d            }t        d      }|j                  ||      }g }|D ]F  \  }	}
}}}}}}| j	                  |	|
t        |      t        |      ||||      }|j                  |       H |S )Nr[  rZ  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
   r_   _get_column_infoboolappend)r  rc  r^  r   r-  r  
COLUMN_SQLresultsr  r  r,  r  autoincrementdefault_r   scaler7  col_infos                     r  get_columnszSybaseDialect.get_columns  s    $$
Frvvl7K % 
 

$ $$Z($C 	% 	
,,X]#	H NN8$)	%, r  c	                    | j                   j                  |d       }	i }
|	t        t        fv r||f}n5|	t        k(  r|f}n(|	t
        t        t        t        t        t        fv r|f}nd}|	r	 |	|i |
}	n,t        j                  d|d|d       t        j                  }	|r: |j                  dd      j!                         }t#        j$                  dd |      }nd }t'        ||	|||	      }|S )
Nr  zDid not recognize type 'z' of column ''DEFAULTr  z^'(.*)'$c                 $    | j                  d      S )Nr  )rn   )ms    r  <lambda>z0SybaseDialect._get_column_info.<locals>.<lambda>"  s    1771: r  )r  r  r  r   r  )ischema_namesr  r   r   r   r   r   r  r  r   r   r   warnsqltypesNULLTYPEreplacestripresubdict)r  r  r,  r  r  r   r   r  r7  r
  r  r  column_infos                r  r  zSybaseDialect._get_column_info  s     $$((5w((u%D<DwUHMM9DDt.v.G
 II@EtL ''G%gooi4::<GffZ)=wGGG'
 r  c                 p   | j                  ||||j                  d            }i }i }g }||d||<   t        d      }	|j                  |	|      }
i }|
D ]  }|d   ||d   <    |||<   t        d      }|j                  ||      j	                         }t        d	      }|D ]  }|d
   }||vr|j                  ||      }|j                         }|j                          |d   d d}||d   | j                  k7  r|d   |d<   |||<   |j                  |	|      }
i }|
D ]  }|d   ||d   <    |||<   ||   }||   }g }g }t        d|d   dz         D ]6  }|j                  ||d|z               |j                  ||d|z               8 ||d   |d   ||d   d}|j                  |        |S )Nr[  rZ  )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  countzfokey%izrefkey%i)constrained_columnsreferred_schemareferred_tablereferred_columnsr  )
r\  r  r
   r_   fetchallr}  r9   r  ranger  )r  rc  r^  r   r-  r  table_cachecolumn_cacheforeign_keysr  r  r  colREFCONSTRAINT_SQLreferential_constraintsREFTABLE_SQLrr  creftable
table_inforeftable_columnsr  r   ifk_infos                             r  get_foreign_keyszSybaseDialect.get_foreign_keys/  sv    $$
Frvvl7K % 
 )3v FH

 $$Z($C 	-C!$VGCI	-!(X 
* #-"4"4 #5 #

(* 	  
 ) &	)AM*K+-&&|k&J::<	&.v&6$G
&)T-E-EE+3H+=Jx(+5K($,,Z+,N#% " >C25f+$SY/>,<[)";/H+K8"$!1aj1n- M#**71Y]3C+DE ''(8:>9J(KLM
 (;#+H#5"*6"2$4&	G (M&	)P r  c                 D   | j                  ||||j                  d            }t        d      }|j                  ||      }g }|D ]V  }	g }
t	        d|	d         D ]  }|
j                  |	d|fz             |	d   t        |	d	         |
d
}|j                  |       X |S )Nr[  rZ  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  zcol_%ir  r   )r  r   column_names)r\  r  r
   r_   r"  r  r   )r  rc  r^  r   r-  r  	INDEX_SQLr  indexesr*  r3  r/  
index_infos                r  get_indexeszSybaseDialect.get_indexes  s    $$
Frvvl7K % 
 
	< $$Y$B 		'AL1aj) 8##Ah!o$678 &	q{+ ,J
 NN:&		' r  c                 F   | j                  ||||j                  d            }t        d      }|j                  ||      }|j	                         }|j                          g }	|r7t        d|d   dz         D ]  }
|	j                  |d|
fz             |	|d   d	S g d d	S )
Nr[  rZ  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  zpk_%ir  )r  r  )r\  r  r
   r_   r}  r9   r"  r  )r  rc  r^  r   r-  r  PK_SQLr  pksr  r/  s              r  get_pk_constraintzSybaseDialect.get_pk_constraint  s    $$
Frvvl7K % 
 
: $$Vh$?  1c'lQ./ @#**3w!~+>?@ (;F 
 ,.t<<r  c                 j    t        d      }|j                  |      }|D cg c]  }|d   	 c}S c c}w )Nz%SELECT u.name AS name FROM sysusers ur  )r
   r_   )r  rc  r-  
SCHEMA_SQLschemasss         r  get_schema_nameszSybaseDialect.get_schema_names  s7     AB
$$Z0#*+a&	+++s   0c                     || j                   }t        d      }t        j                  r!t	        |t
              r|j                  d      }|j                  ||      }|D cg c]  }|d   	 c}S c c}w )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  r  r  r
   r   r  r  r  r  r_   )r  rc  r   r-  	TABLE_SQLtablesr  s          r  get_table_nameszSybaseDialect.get_table_names  so    >--F
	 99&'*w/##I6#B#)*a&	***   "A1c                     || j                   }t        d      }t        j                  r!t	        |t
              r|j                  d      }|j                  ||      }|j                         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  r_   r  )r  rc  rI  r   r-  VIEW_DEF_SQLr   s          r  get_view_definitionz!SybaseDialect.get_view_definition  se    >--F
 99)W-%,,W5	!!,)!D{{}r  c                     || j                   }t        d      }t        j                  r!t	        |t
              r|j                  d      }|j                  ||      }|D cg c]  }|d   	 c}S c c}w )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  rB  r  rC  )r  rc  r   r-  VIEW_SQLviewsvs          r  get_view_nameszSybaseDialect.get_view_names/  so    >--F
 99&'*w/""8"@#()a&	)))rG  c                     | j                  |       	 | j                  |||       y# t        j                  $ r Y yw xY w)NTF)_ensure_has_table_connectionr\  r   r  )r  rc  r^  r   s       r  	has_tablezSybaseDialect.has_tableD  sF    ))*5	j*f=  ## 		s   ' ==r  ))r  r  r  r  supports_unicode_statementssupports_sane_rowcountsupports_sane_multi_rowcountsupports_statement_cachesupports_native_booleansupports_unicode_bindspostfetch_lastrowidcolspecsr  r(  r  r  statement_compilerr  ddl_compilerr  r  rT  	inspectorconstruct_argumentsrW  r  r  r\  r   cacher  r  r1  r7  r;  r@  rF  rK  rP  rS  __classcell__)r  s   @r  r  r  w  sR   D"'"#( ##"H!M&M*$L'HI=

-"H 0 0d1f c cJ 0 0d /= /=b , , + +*  * * *(r  r  )Dr  r  
sqlalchemyr   r   r  r   r  r   sqlalchemy.enginer   r   sqlalchemy.sqlr	   r
   sqlalchemy.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  UnicodeTextr  Integerr  
TypeEnginer  r  r"  r$  LargeBinaryr&  GenericTypeCompilerr(  r  rV  rT  DefaultExecutionContextr`  r  r  DDLCompilerr  IdentifierPreparerr  DefaultDialectr  r  r  r  <module>rp     s}  $ 
  * (  % ( #  # # ! ! % $ "   $ " $ % ! % ! ! & $ & $ `bJ
& 
!8#3#3 "$h&6&6 "!8#7#7 h (

 H "$$ "(x** (H   #"55 #"L.f.	7. w. 	.
 w. v. G. . w. w. 
7. U. g. . D.  *!." U#.$ X%.& '.( D).* D+., D-.. /.0 w1.2 3.4 G5.6 w7.8 9.: U;.< U=.> %?.@ A.B XC.D XE.F #+([.b	
j** 	
EW<< EP<
,, <
~2
,, 2
j$x:: $UG** Ur  