�
��4]c�@shdZd
dl
Z
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dl	m
Z

d
dl	mZ
d
d	lm
Z

d
d
lmZ
d
dlmZ
d
dlmZ
d
d
lmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlmZ
d
dlm Z 
d
dlm!Z!
d
dlm"Z"
d
dlm#Z#
e$dd 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%d�e&f
d���YZ'd
e'ej!fd

��YZ(d
e'ej!fd
��YZ)d
e'ej*fd
��YZ+d
ej,f
d
��YZ-d
ej.f
d	
��YZ/d

ej.f
d
��YZ0d
ej.f
d

��YZ1d
ej.f
d
��YZ2d
ej3f
d
��YZ4d
e
j5f
d
��YZ6i,ed)6ed~6ed6ed�6e-d�6ed
6ed
6ed
6ed�6edL6edK6edf6edT6ed
6ed�6e1d
6e0d
6ed
6ed
6edH6ed�6ed46ed66e#d�6e#d
6e#d
6e(d
6e)d
6ed 
6ed!
6ed"
6ed#
6ed$
6ed%
6ed&
6ed'
6e+d(
6ed*6e"d�6e4d)
6e/d+6ed*
6e d�6e2d+
6Z7d,
ej8f
d-
��YZ9d.
e
j:f
d/
��YZ;d0
e
j<f
d1
��YZ=d2
e
j>f
d3
��YZ?d4
e
j@f
d5
��YZAd6
e
jBf
d7
��YZCdS(8
s


.. 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.

i����N(
texc(
tschema(
ttypes(
tutil(
tdefault(
t
reflection(
tcompiler(
ttext(
tBIGINT(
tBINARY(
tCHAR(
tDATE(
tDATETIME(
tDECIMAL(
tFLOAT(
tINT(
tINTEGER(
tNCHAR(
tNUMERIC(
tNVARCHAR(
tREAL(
tSMALLINT(
tTEXT(
tTIME(
t	TIMESTAMP(
tUnicode(
t	VARBINARY(
tVARCHARtaddtalltaltertandtanytastasctbackuptbegintbetweentbiginttbinarytbittbottomtbreaktbytcallt
capabilitytcascadetcasetcasttchartchar_convertt	charactertcheckt
checkpointtclosetcommenttcommittconnectt
constrainttcontainstcontinuetconverttcreatetcrosstcubetcurrenttcurrent_timestamptcurrent_usertcursortdatetdbspacet
deallocatetdectdecimaltdeclareRtdeletetdeletingtdesctdistincttdotdoubletdroptdynamictelsetelseift	encryptedtendtendiftescapetexceptt	exceptiontexectexecutetexistingtexiststexternlogintfetchtfirsttfloattfortforcetforeigntforwardtfromtfulltgototgranttgroupthavingtholdlockt
identifiedtiftintindextindex_lparentinnertinouttinsensitivetinsertt	insertingtinstalltinsteadtinttintegert
integratedt	intersecttintotiqtist	isolationtjointkeytlateraltlefttliketlocktlogintlongtmatcht
membershiptmessagetmodetmodifytnaturaltnewtnot
noholdlocktnottnotifytnulltnumerictoftofftontopentoptiontoptionstortordertotherstouttoutertovertpassthrought	precisiontpreparetprimarytprintt
privilegestproct	proceduretpublicationt	raiserrortreadtexttrealt	referencet
referencestreleasetremotetremovetrenamet
reorganizetresourcetrestoretrestricttreturntrevoketrighttrollbacktrolluptsavet	savepointtscrolltselectt	sensitivetsessiontsettsetusertsharetsmallinttsometsqlcodetsqlstatetstarttstoptsubtranstsubtransactiontsynchronizetsyntax_errorttablet	temporarytthenttimet	timestampttinyintttottopttranttriggerttruncatettsequalt	unboundedtuniontuniquetunknowntunsignedtupdatetupdatingtusertusingtvalidatetvaluest	varbinarytvarchartvariabletvaryingtviewtwaittwaitfortwhentwheretwhiletwindowtwitht	with_cubetwith_lparentwith_rolluptwithintworkt	writetextt_SybaseUnitypeMixinc
BseZ
dZd
�ZRS(s-these types appear to return a buffer object.c
Cs
d
�}|S(Nc

Ss|dk	rt
|�
SdSdS(
N(tNonetstr(
tvalue((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytprocess"
s


((tselftdialecttcoltypeR�((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytresult_processor!
s
	(t__name__t
__module__t__doc__R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR�
s
tUNICHARc
BseZ
dZRS(
R
(R
R
t__visit_name__(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
+
s
t
UNIVARCHARc
BseZ
dZRS(
R
(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
/
s
tUNITEXTc
BseZ
dZRS(
R	
(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR	
3
s
tTINYINTc
BseZ
dZRS(
R

(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR

7
s
tBITc
BseZ
dZRS(
R
(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
;
s
tMONEYc
BseZ
dZRS(
R
(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
?
s
t
SMALLMONEYc
BseZ
dZRS(
R

(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR

C
s
tUNIQUEIDENTIFIERc
BseZ
dZRS(
R
(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
G
s
tIMAGEc
BseZ
dZRS(
R
(R
R
R
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
K
s
tSybaseTypeCompilerc
BsteZ
d�Zd
�Zd�Zd�Zd�Zd�Zd�Zd�Z	d�Z
d	�Zd
�Zd�Z
RS(cKs
|j|
�
S(
N(
tvisit_IMAGE(R�ttype_tkw((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytvisit_large_binaryP
s
cKs
|j|
�
S(
N(
t	visit_BIT(R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt
visit_booleanS
s
cKs
|j|
�
S(
N(
tvisit_NVARCHAR(R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt
visit_unicodeV
s
cKsd
|
jS(NsUNICHAR(%d)(
tlength(R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt
visit_UNICHARY
s
cKsd
|
jS(NsUNIVARCHAR(%d)(
R
(R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytvisit_UNIVARCHAR\
s
c
Ksd
S(NR	
((R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt
visit_UNITEXT_
s
c
Ksd
S(NR

((R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt
visit_TINYINTb
s
c
Ksd
S(NR
((R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
e
s
c
Ksd
S(NR
((R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
h
s
c
Ksd
S(NR
((R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytvisit_MONEYk
s
c
Ksd
S(NR

((R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytvisit_SMALLMONEYn
s
c
Ksd
S(NR
((R�R
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytvisit_UNIQUEIDENTIFIERq
s
(R
R
R
R
R
R
R
R
R
R
R
R
R
R 
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR
O
s
											sunsigned bigintsunsigned intsunsigned smallintsdouble precisiont
smallmoneytmoneyt
smalldatetimetdatetimescharacter varyingschar varyingtunicharsunicode charactertnchars
national charsnational charactertnvarchars
nchar varyingsnational char varyingsnational character varyingRtunitexttimageslong varchartuniqueidentifiertSybaseInspectorcBseZ
d�Zdd
�
ZRS(cCstj
j||
�
dS(
N(Rt	Inspectort__init__(R�tconn((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR-
�
s
cCs"|jj
|j|
|d
|j�
S(s3Return the table id from `table_name` and `schema`.t
info_cache(R
tget_table_idtbindR/
(R�t
table_nameR
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR0
�
s	
N(R
R
R-
R�R0
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR+
�
s
	tSybaseExecutionContextc
Bs2eZ
eZd�Zd
�Zd�Zd�ZRS(c
Cs
t��
d
S(s�
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(
tNotImplementedError(R�t
connectionR�((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytset_ddl_autocommit�
s
c
Cs�|jr�|j
jj}
|
j}|dk	}|rO|j|jd
k|_n	t	|_|jr�|j
jd|jj
j|
�
�

q�n|jr�|js�tjd�
�
n|jjjjd�

|j|jjjt�
ndS(NisSET IDENTITY_INSERT %s ONsGThe Sybase dialect only supports DDL in 'autocommit' mode at this time.s-AUTOCOMMIT (Assuming no Sybase 'ddl in tran')(tisinserttcompiledt	statementR�t_autoincrement_columnR�R�tcompiled_parameterst_enable_identity_inserttFalseRDR\R
tidentifier_preparertformat_tabletisddltshould_autocommitRtInvalidRequestErrortroot_connectiontenginetloggertinfoR6
R5
tTrue(R�ttblt
seq_columntinsert_has_sequence((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytpre_exec�
s&
	

	
		
	

		



c

Cs[|jr|j
|jt�
n|jrW|jjd
|jjj	|j
jj�
�

ndS(NsSET IDENTITY_INSERT %s OFF(
R@
R6
RC
R=
R<
RDR\R
R>
R?
R8
R9
R�(
R�((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt	post_exec�
s
	
	
	


c
Cs7|j�}
|
j
d
�

|
j�d}|
j�
|S(NsSELECT @@identity AS lastrowidi(t
create_cursorR\tfetchoneR6(R�RDt	lastrowid((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt
get_lastrowid�
s







(R
R
R=
R<
R6
RK
RL
RP
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR3
�
s

		%	tSybaseSQLCompilercBs�eZ
eZejejjidd
6dd6dd6�Zd�Z	d�Z
d�Zd	�Zd
�Z
d�Zd�Zd
�Zd�ZRS(t	dayofyeartdoytweekdaytdowtmillisecondtmillisecondscKsZ|
jrd
pd}|
j
}|r8|d|f
7}n|
j}|rVtd�
�
n|S(Ns	DISTINCT tsTOP %s s"Sybase ASE does not support OFFSET(t	_distinctt_limitt_offsetR4
(R�R�R
t
stlimittoffset((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_select_precolumnss
	

	


c
Cs|S(
N((R�R�R((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_from_hint_texts
c
Ksd
S(NRX
((R�R�R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytlimit_clausescKs8|jj
|
j|
j�}d
||j|
j|�
fS(NsDATEPART("%s", %s)(textract_maptgettfieldR�texpr(R�textractR
Rd
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt
visit_extracts

c
Ksd
S(Ns	GETDATE()((R�tfnR
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytvisit_now_funcs
c
Csd
S(NRX
((R�R�((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytfor_update_clause scKsKt|d
<|j
|
j|�
}|rC|j�s;|
jrCd|SdSdS(Nt
literal_bindss
 ORDER BY RX
(RG
R�t_order_by_clausetis_subqueryRZ
(R�R�R
torder_by((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytorder_by_clause%s




cCs4t}|rt
}n|j|d
t
dt
d|�
S(s=If we have extra froms make sure we render any alias as hint.tasfromtiscrudtashint(R=
RG
t_compiler_dispatch(R�tdelete_stmtt
from_tabletextra_fromsRr
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytdelete_table_clause/s


	

cs.d
dj��
�fd�|g
|D�
�
S(s4Render the DELETE .. FROM clause specific to Sybase.sFROM s, c
3s-|]#}
|
j�dt
d
��
�
V
qdS(Rp
t	fromhintsN(Rs
RG
(t.0t
t(t
from_hintsR
R�(sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pys	<genexpr>=s
(
R�(R�Rt
Ru
Rv
R{
R
((R{
R
R�sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytdelete_extra_from_clause8s	

(R
R
RG
tansi_bind_rulesRtupdate_copyRtSQLCompilerRb
R_
R`
Ra
Rg
Ri
Rj
Ro
Rw
R|
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyRQ
�
s

	
							
		tSybaseDDLCompilerc
BseZ
d�Zd
�ZRS(c	Ks_
|jj
|
�
d
|jjj|
jd|
�

}|
jdkrStj	d�
�
n|
jj
}||
kr�t|
jt
j�o�|
j}|r�|jp�d|jp�d}}nd
\}}||fdkr�|d7}q[
|d||f7}nh|j|
�
}|dk	r
|d|7}n|
jdk	r[
|
jsA
|
jrN
|d7}q[
|d	7}n|S(Nt
 ttype_expressionsHThe Sybase dialect requires Table-bound columns in order to generate DDLi
s	 IDENTITYs IDENTITY(%s,%s)s	 DEFAULT s	 NOT NULLs NULL(i
i
(i
i
(tpreparert
format_columnR
t
type_compilerR�ttypeR�R�RtCompileErrorR:
t
isinstanceRt	sa_schematSequenceR�t	incrementtget_column_default_stringtnullabletprimary_key(	R�tcolumntkwargstcolspectseq_coltsequenceR�R�
R((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_column_specificationCs.



	
"








cCs;|
j}d
|j
j|jj�
|j|
jdt�

fS(Ns
DROP INDEX %s.%stinclude_schema(telementR�
tquote_identifierR�tnamet_prepared_index_nameR=
(R�RQRq((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytvisit_drop_indexos
	


(R
R
R�
R�
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR�
Bs
	,tSybaseIdentifierPreparerc
BseZ
eZRS((R
R
tRESERVED_WORDStreserved_words(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR�
ws
t
SybaseDialectcBs:
eZ
dZeZeZeZeZeZe	Z
iZeZe
ZeZeZeZeZgZd
�Zd�Zdd�
Zejdd�
�
Zd�Zejdd�
�
Z ejdd�
�
Z!ejdd�
�
Z"ejd	��
Z#ejdd
�
�
Z$ejdd�
�
Z%ejdd�
�
Z&dd
�
Z'RS(tsybasecCs|
jt
d
�
jdt�
�
S(NsSELECT user_name() as user_nametusername(tscalarRtcolumnsR(R�R5
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt_get_default_schema_name�s

cCsMtt
|�j|
�

|jdk	r@|jdkr@d|_n	d|_dS(Niii�(
i(tsuperR�
t
initializetserver_version_infoR�tmax_identifier_length(R�R5
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR�
�s


cKs�d}|dkr|j
}ntd
�
}tjrxt|t�rT|jd�
}nt|t�rx|jd�
}qxn|
j|d|d|�
}|j	�}|dkr�t
j|�
�
n|S(s�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.

        s�
          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')
        tasciitschema_nameR2
N(R�tdefault_schema_nameRRtpy2kR�
tunicodetencodeR\R�
RtNoSuchTableError(R�R5
R2
R
R
ttable_idtTABLEID_SQLtresult((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR0
�s 	

		








c
Ks�|j|
||d
|j
d
�
�
}td�
}|
j|d|�

}g}xc|D][\}	}
}}}
}}}|j|	|
t|�
t|�
|
|||�}|j|�

qRW|S(NR/
s*
          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�
(R0
Rc
RR\t_get_column_infotbooltappend(R�R5
R2
R
R
R�
t
COLUMN_SQLtresultsR�
R�
R
R�
t
autoincrementtdefault_R�tscaleR
tcol_info((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_columns�s&
	
	"



	
	



	c	
Cs&
|jj
|d�}	i}
|	ttfkr<||f}nH|	tkrT|f
}n0|	tttt	t
tfkr~|f
}nd}|	r�|	||
�}	n tj
d
||
f�

tj}	|r�|jdd�j�}tjdd�|�}nd}td|
d|	d|d	|d
|�}|S(Ns*Did not recognize type '%s' of column '%s'tDEFAULTRX
s^'(.*)'$c

Ss
|jd
�
S(Ni
(
Rk(
t
m((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt<lambda>RX
R�
R�
R�
RR�
((t
ischema_namesRc
R�RR
RR
RR
R
RRRtwarntsqltypestNULLTYPEtreplacetstriptretsubtdict(
R�R�
R
R�
R�
RR�R�
R
R

R�
targstcolumn_info((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR�
�s2






	






	cKs~|j|
||d
|j
d
�
�
}i}i}g}i|d6|d6||<td�
}	|
j|	d|�

}
i}x |
D]}|d||d<q|W|||<td�
}
|
j|
d|�

j�}td�
}x�
|D]�
}|d	}||kr�
|
j|d|�

}|j�}|j�
i|dd6dd6}|dk	sZ
|d|jkrk
|d|d<n|||<|
j|	d|�

}
i}x |
D]}|d||d<q�
W|||<n||}||}g}g}xQt	d
|dd
�D]8}|j
||d|�

|j
||d
|�

q�
Wi|d6|dd6|dd6|d6|dd6}|j
|�

q�W|S(NR/
R�
R
su
          SELECT c.colid AS id, c.name AS name
          FROM syscolumns c
          WHERE c.id = :table_id
        R�
tids(
          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
        s�
          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
        treftable_idi
tcountsfokey%isrefkey%itconstrained_columnstreferred_schematreferred_tabletreferred_columns(R0
Rc
RR\tfetchallRN
R6R�R�
trangeR�
(R�R5
R2
R
R
R�
ttable_cachetcolumn_cachetforeign_keysR�
R�
R�
tcoltREFCONSTRAINT_SQLtreferential_constraintstREFTABLE_SQLt
rR�
t
ctreftablet
table_infotreftable_columnsR�
R�
t
itfk_info((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_foreign_keys)sd


	





	
	




























c
Ks�|j|
||d
|j
d
�
�
}td�
}|
j|d|�

}g}x�|D]x}	g}
x3td|	d�D]}|
j|	d|f
�

qrWi|	dd6t|	d�
d6|
d	6}|j|�

qRW|S(
NR/
s�
          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�
i
R�
scol_%iR�
R�tcolumn_names(R0
Rc
RR\R�
R�
R�
(
R�R5
R2
R
R
R�
t	INDEX_SQLR�
tindexesR�
R�
R�
t
index_info((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_indexes�s 
	










cKs�|j|
||d
|j
d
�
�
}td�
}|
j|d|�

}|j�}|j�
g}	|r�x7td|dd�D]}
|	j|d|
f
�

qWi|	d6|dd6Sigd6dd6SdS(	NR/
sy
          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�
i
R�
spk_%iR�
R�
(	R0
Rc
RR\RN
R6R�
R�
R�(R�R5
R2
R
R
R�
tPK_SQLR�
tpksR�
R�
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_pk_constraint�s
	








cKs6td
�
}|
j
|�
}g|D]}|d^q"S(Ns%SELECT u.name AS name FROM sysusers uR�
(RR\(R�R5
R
t
SCHEMA_SQLtschemasR\
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_schema_names�scKs�|dkr|j
}ntd
�
}tjrQt|t�rQ|jd�
}qQn|
j|d|�

}g|D]}|d^qmS(Ns�
          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�
RRR�
R�
R�
R�
R\(R�R5
R
R
t	TABLE_SQLttablesRz
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_table_names�s
		

cKsp|dkr|j
}ntd
�
}tjrQt|t�rQ|jd�
}qQn|
j|d|�

}|j	�S(Ns�
          SELECT c.text
          FROM syscomments c JOIN sysobjects o ON c.id = o.id
          WHERE o.name = :view_name
            AND o.type = 'V'
        R�
t	view_name(
R�R�
RRR�
R�
R�
R�
R\R�
(R�R5
R�
R
R
tVIEW_DEF_SQLR�((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_view_definitions
		

cKs�|dkr|j
}ntd
�
}tjrQt|t�rQ|jd�
}qQn|
j|d|�

}g|D]}|d^qmS(Ns�
          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�
R�
(	R�R�
RRR�
R�
R�
R�
R\(R�R5
R
R
tVIEW_SQLtviewst
v((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pytget_view_names)s
		


cCs7y|j|
||�
Wnt
jk
r.


tSXtSdS(
N(R0
RR�
R=
RG
(R�R5
R2
R
((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt	has_table>s




N((R
R
R�
R=
tsupports_unicode_statementstsupports_sane_rowcounttsupports_sane_multi_rowcounttsupports_native_booleantsupports_unicode_bindsRG
tpostfetch_lastrowidtcolspecsR�
R
R�
RQ
tstatement_compilerR�
tddl_compilerR�
R�
R+
t	inspectortconstruct_argumentsR�
R�
R�R0
RtcacheR�
R�
R�
R�
R�
R�
R�
R�
R�
R�
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyR�
{sF










		
$
2	3
e
2
1	


(DR
R�
t
sqlalchemyRR
R�
RR�
Rtsqlalchemy.engineRRtsqlalchemy.sqlRRtsqlalchemy.typesRR	R
RRR
RRRRRRRRRRRRRRR�R�
tobjectR�R
R
tUnicodeTextR	
tIntegerR

t
TypeEngineR
R
R

R
tLargeBinaryR
tGenericTypeCompilerR
R�
R,
R+
tDefaultExecutionContextR3
R
RQ
tDDLCompilerR�
tIdentifierPreparerR�
tDefaultDialectR�
(((sR/opt/alt/python27/lib64/python2.7/site-packages/sqlalchemy/dialects/sybase/base.pyt<module>sv

























































































































































































































































&











































HH5