| Server IP : 209.209.40.120 / Your IP : 216.73.217.112 Web Server : Microsoft-IIS/10.0 System : Windows NT NEWWWW 10.0 build 17763 (Windows Server 2019) i586 User : NEWWWW$ ( 0) PHP Version : 8.3.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/MySQL/MySQL Workbench 6.3 CE/modules/ |
Upload File : |
�
�"�Xc @ sr d d l m Z d d l Z d d l m Z d d l m Z d d l m Z e d d d d d
d � Z d � Z
d
� Z i Z d � Z
d � Z d � Z d � d � Z e j e j e j � d � � Z e j e j e j j � d � � Z e j e j e j j e j � d � � Z e j e j e j j � d � � Z e j e j e j j � d � � Z e j e j � d � � Z e j e j j e j j � d � � Z e j e j e j j � d � � Z e j e j e j j e j � d � � Z! e j e j e j j e j e j � d � � Z" e j e j e j j e j e j � d � � Z# e j e j e j j e j e j � d � � Z$ e j e j e j j e j e j � d � � Z% e j e j e j j e j e j � d � � Z& e j e j j' e j j e j e j e j f e j( � d! � � Z) e j e j e j j e j j* � d" � � Z+ e j e j e j j e j j, � d# � � Z- e j e j e j j e j j. � d$ � � Z/ e j e j e j j e j j. � d% � � Z0 e j e j e j j e j j. � d& � � Z1 e j e j e j j e j j. � d' � � Z2 e j e j e j j e j j, � d( � � Z3 e j e j e j j e j j, � d) � � Z4 e j e j e j j e j j, � d* � � Z5 e j e j e j j e j j, � d+ � � Z6 e j e j j7 � d, � � Z8 e j e j e j f � d- � � Z9 e j e j e j f � d. � � Z: e j e j e j j � d/ � � Z; d S(0 i����( t DefineModuleN( t db_driver( t NotConnectedError( t find_object_with_namet namet
DbSybaseREt authors Oracle Corp.t versions 1.0c C s t j � r t j � � n d S( s� Checks if the user is requesting to cancel an operation in progress.
Call this from time to time so that the actual cancel requests can be handled
N( t grtt query_statust
UserInterrupt( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt check_interruption s c C s@ d } x3 t j j j j D] } | j d k r | } Pq q W| S( Nt Sybase( t NoneR t roott wbt rdbmsMgmtt rdbmsR ( t sybase_rdbms_instanceR ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt get_sybase_rdbms_instance( s c C s5 | j t k r t | j d St d | j � � d S( Nt
connections No open connection to %s( t __id__t _connectionsR t hostIdentifier( t connection_object( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt get_connection4 s c O s< t j d d | | | f � t | � j � j | | | � S( s� Retrieves a connection and executes the given query returning a cursor to iterate over results.
The remaining positional and keyword arguments are passed with the query to the execute function
s db.sybases execute %s %s %s
( R t
log_debug3R t cursort execute( R t queryt argst kwargs( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt
execute_query; s c s � f d � } | S( s� (Decorator). Needed because a Sybase issue with DDL statements inside transactions.
More info here: http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/53037
c sM d } x- | D]% } t | t j j � r
| } Pq
q
W| sP t j d d � � St | � j � } y | j d � j � d } Wn t
k
r� d } n X| j d � | j d � | j d � | d k r� | j d | � n ~ � | | � } t | � j � } | j d � | j d
� | j d � | d k rI| j d | � n | S( Ns db.sybasesB Cannot find a connection object to apply the allow-ddl-in-tran fixs SELECT db_name()i t masters
USE masters& sp_dboption tempdb,"ddl in tran", trues CHECKPOINT tempdbs USE ?s' sp_dboption tempdb,"ddl in tran", false( R
t
isinstanceR t classest db_mgmt_Connectiont log_errorR R R t fetchonet Exception( R R t connt argR t
current_dbt res( t func( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt wrapper_functionJ s6
( ( R, R- ( ( R, sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt allow_ddl_in_tranE s c C s d S( N( R
( t _( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt <lambda>k s c c s� d } d } g } t d � t | j � D� � } x� | D]� } | | | | | | } }
| sn | | k r� | | � | r� | | d j | � f Vn | } |
g } | d 7} q8 n | j |
� q8 W| r� | | d j | � f Vn d S( s� Generator to join definition columns that are split across several rows
In Sybase, object definitions in syscomments can be split into several rows. For example,
a stored procedure can have several row entries in syscomments each having the same object
name and containing the chunks of the procedure's code in the "text" column. The order of
the rows is determined by the "colid" value (a sequence of integers: 1, 2, 3, etc.).
Arguments: name_column -- string with the name of the column that has the object name
split_column -- string with the name of the column that has the fragments
cursor -- the resultset to iterate through
callback -- an optional callable that will be called with the row corresponding
to the first row of each distinct object
Returns: idx, name, definition where idx tracks the count of different objects as they are
found, name is the name of the current object and definition is the joint definition for the
object.
Note: This functions assumes that the rows are ordered properly, i.e. sorted by name, colid.
i c s s% | ] \ } } | d | f Vq d S( i N( ( t .0t post col_description( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pys <genexpr>� s t i N( R
t dictt enumeratet descriptiont joint append( t name_columnt split_columnR t callbackt idxt current_objectt current_object_chunkst column_indext rowt object_namet object_definition( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt join_multiline_contentk s"
c C s d | S( Ns [%s]( ( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt quoteIdentifier� s c C s� | j } | rz t | t j j � rz | j r� t | j t j j � r� t | j j � d t | j � d t | j � Sn9 | r� t | t j j � r� t | j � d t | j � St | j � S( Nt .( t ownerR" R R# t db_Schemat
db_CatalogRE R ( t objRG ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt fullyQualifiedObjectName� s !5 c C s� d } | j } yn t | � } y( | j � j d � sE t d � � n Wn3 t k
r{ } t j d | j � t d � � n XWn8t k
r�} t j d | � d d l } y t
j | | � } t | _
Wnj | j k
r7} t | j � d k r8| j d d k r8d | j d
k r8t j | j d
� � q8n X| sZt j d t | � � � n i | d 6t | j <t | � t | j d <t | d � j � d } t j d | | f � n Xd
S( s� Establishes a connection to the server and stores the connection object in the connections pool.
It first looks for a connection with the given connection parameters in the connections pool to
reuse existent connections. If such connection is found it queries the server to ensure that the
connection is alive and reestablishes it if is dead. If no suitable connection is found in the
connections pool, a new one is created and stored in the pool.
Parameters:
===========
connection: an object of the class db_mgmt_Connection storing the parameters
for the connection.
password: a string with the password to use for the connection.
s SELECT 1s connection errors1 Connection to %s apparently lost, reconnecting...s Connection errors Connecting to %s...i����Ni i t 28000t 42000s (18456)i s Connection failedR R s SELECT @@versions Connected to %s, %s( s 28000s 42000( R
R R R R R' R t send_infoR t pyodbcR t connectt Truet
autocommitt Errort lenR t DBLoginErrort
send_errort strR R t getServerVersionR R& ( R t passwordt cont host_identifiert excRO t odbc_errR ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyRP � s6
; c C s | j t k r t | j =n d S( Ni ( R R ( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt
disconnect� s
c C s | j t k r d Sd S( Ni i ( R R ( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt isConnected� s c C s d S( NR ( ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getTargetDBMSName� s c C s� t j j � } t | d � j � d } y | j d d � d } Wn t k
r[ d } n Xg | j d � D] } t | � ^ ql d d g } | d \ | _ | _ | _
| _ | S( sN Returns a GrtVersion instance containing information about the server version.s SELECT @@versioni t /i i t 15RF i ( R R# t
GrtVersionR R& t splitt
IndexErrort intt majorNumbert minorNumbert
releaseNumbert buildNumber( R R t
ver_stringt partt ver_parts( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyRX � s
3"c C s* d } g t | | � D] } | d ^ q S( sl Returns a list of the available catalogs.
[NOTE] A catalog is equivalent to a databases in Sybase.
s exec sp_databasesi ( R ( R R RA ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getCatalogNames s c C s: t | d t | � � t t d � t | d � D� � � S( s; Returns a list of schemata for the given connection object.s USE %sc s s | ] } | d Vq d S( i N( ( R1 RA ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pys <genexpr> s t sp_tables( R RE t sortedt set( R t catalog_name( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getSchemaNames s c C sK t | d t | � � g t | d � D] } | d | k r' | d ^ q' S( Ns USE %ss sp_tables @table_type="'TABLE'"i i ( R RE ( R Rr t schema_nameRA ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt
getTableNames s c C sK t | d t | � � g t | d � D] } | d | k r' | d ^ q' S( Ns USE %ss sp_tables @table_type="'VIEW'"i i ( R RE ( R Rr Rt RA ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getViewNames s c C sD t | d t | � � d } g t | | | � D] } | d ^ q0 S( Ns USE %ss@ SELECT name
FROM sysobjects
WHERE type='TR' AND uid = user_id(?)i ( R RE ( R Rr Rt R RA ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getTriggerNames! s c C sD t | d t | � � d } g t | | | � D] } | d ^ q0 S( Ns USE %ss? SELECT name
FROM sysobjects
WHERE type='P' AND uid = user_id(?)i ( R RE ( R Rr Rt R RA ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getProcedureNames* s c C s g S( N( ( R Rr Rt ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getFunctionNames3 s c s} t j d d � t j j � } | | _ | j j � | j j | j j j � d | _
t j d d � t � t | | � t j d d � i � i } i } i } i } | j
d t � } | j
d t � }
| j
d
t � } | j
d t � } d }
d
} d } x>| D]6} t � | r5t t | | | � � n d � | <| r]t t | | | � � n d | | <t � | r�t t | | | � � t t | | | � � n d | | <|
r�t t | | | � � n d | | <� | | | | | | | d | | <|
| | 7}
t j | d | t | � d d | � | d
7} q
Wd } t j � t j | | d � d } x/| D]'} | j
| d � |
} t j | | | � d } t j j � } | | _ | | _ | j
| _
| j j | � � | | | d } | r�t � t j d � | | f � t j | | | � t | j j d t � � } | j d | � t | | � t j! � n | | 7} t j | d | � | | | | d } | r t � t j d | | | f � t j | | | � t" | | � t j! � n | | 7} t j | d | � | | | | d } | r�t � t j d | | | f � t j | | | d � | j# j � t$ | | � t j! � t � t j | | d | | � t% | | � t j! � n | | 7} t j | d | � | | | | d } |
rjt � t j d | | | f � t j | | | � t& | | � t j! � n | | 7} t j | d | � | | 7} t j! � quWt j! � d } | rit' � f d � | j D� � } x� | j D]� } t � d � | j | d } t j d | j � t j | | | � t | | � t j! � | | 7} t j | d | � q�Wn t j d
d! � | S(" s� Reverse engineers a Sybase ASE database.
This is the function that will be called by the Migration Wizard to reverse engineer
a Sybase database. All the other reverseEngineer* functions are not actually required
and should not be considered part of this module API even though they are currently
being exposed. This function calls the other reverseEngineer* functions to complete
the full reverse engineer process.
i s' Reverse engineering catalog informationR4 g�������?s& Reverse engineering User Data Types...g�������?s Preparing...t reverseEngineerTablest reverseEngineerTriggerst reverseEngineerViewst reverseEngineerRoutinesg�����|�=g �?s Gathered stats for %sg�������?g333333�?g s% Reverse engineering %i tables from %st _rev_eng_progress_flagss %s_tables_first_passs@ First pass of table reverse engineering for schema %s completed!s$ Reverse engineering %i views from %ss5 Reverse engineering of views for schema %s completed!s' Reverse engineering %i routines from %si s8 Reverse engineering of routines for schema %s completed!s' Reverse engineering %i triggers from %ss8 Reverse engineering of triggers for schema %s completed!g�������?c 3 s | ] } � | j Vq d S( N( R ( R1 t schema( t table_count_per_schema( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pys <genexpr>� s s8 Reverse engineering foreign keys for tables in schema %ssA Second pass of table reverse engineering for schema %s completed!s Reverse engineering completed!(( R t
send_progressR# t db_sybase_CatalogR t simpleDatatypest
remove_allt extendt driverRG t defaultCollationNameR t reverseEngineerUserDatatypest getRQ RT Ru Rv Rx Ry Rw t reset_progress_stepst begin_progress_stept db_sybase_Schemat schemataR9 RN R R t
setdefaultRq t discardRz t end_progress_stepR| t routinest reverseEngineerProcedurest reverseEngineerFunctionsR{ t sum( R Rr t
schemata_listt optionst catalogt view_count_per_schemat routine_count_per_schemat trigger_count_per_schemat total_count_per_schemat
get_tablest get_triggerst get_viewst get_routinest totalt it accumulated_progressRt t accumulated_schema_progresst schema_progress_sharet this_schema_progressR t step_progress_sharet progress_flagst total_tables( ( R� sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt reverseEngineer: s�
((>(**
c
. C s� t d^ d_ d` da db dc dd de df dg dh di dj dk dl dm dn do dp dq dr ds dt du dv dw dx dy dz d{ d| d} d~ d d� d� d� d� d� d� d� d� d� d� f, � } dY } t | dZ t | j � � t � } | j j � x� t | | � D]� \ } } } } } }
t j j � } | j
� | _ | | _ | | _ | | _
| | _ t | j | |
� } | rX| | _ n t j d[ d\ |
| f � | j j | � q� Wd] S(� Ni" t IMAGEi# t TEXTi$ s
EXTENDED TYPEi% t TIMESTAMPi& t INTNi' t VARCHARi- t BINARYi/ t CHARi0 t TINYINTi1 t DATEi2 t BITi3 t TIMEi4 t SMALLINTi7 t DECIMALi8 t INTi: t
SMALLDATETIMEi; t REALi< t MONEYi= t DATETIMEi> t FLOATi? t NUMERICiA t USMALLINTiB t UINTiC t UBIGINTiD t UINTNij t DECIMALNil t NUMERICNim t FLOATNin t MONEYNio t DATETIMNiz t
SMALLMONEYi{ t DATENi� t UNICHARi� t TIMENi� t
UNIVARCHARi� t TEXT_LOCATORi� t
IMAGE_LOCATORi� t UNITEXT_LOCATORi� t UNITEXTi� t BIGDATETIMENi� t BIGTIMENi� t BIGDATETIMEi� t BIGTIMEi� t BIGINTsY SELECT name, length, prec, scale, allownulls, type
FROM systypes
WHERE accessrule != NULLs USE %ss# Sybase reverseEngineerUserDatatypess9 Could not found base type "%s" for user defined type "%s"i ( i" s IMAGE( i# s TEXT( i$ s
EXTENDED TYPE( i% s TIMESTAMP( i& R� ( i' s VARCHAR( i- s BINARY( i/ s CHAR( i0 s TINYINT( i1 s DATE( i2 s BIT( i3 s TIME( i4 s SMALLINT( i7 s DECIMAL( i8 s INT( i: s
SMALLDATETIME( i; s REAL( i< s MONEY( i= s DATETIME( i> s FLOAT( i? s NUMERIC( iA R� ( iB R� ( iC R� ( iD R� ( ij R� ( il R� ( im R� ( in R� ( io R� ( iz s
SMALLMONEY( i{ R� ( i� s UNICHAR( i� R� ( i� s
UNIVARCHAR( i� R� ( i� R� ( i� R� ( i� s UNITEXT( i� R� ( i� R� ( i� R� ( i� R� ( i� s BIGINT( R5 R RE R R t
userDatatypesR� R R# t db_sybase_UserDatatypet uppert characterMaximumLengtht numericPrecisiont numericScalet
isNullableR R� t
actualTypet send_warningR9 (
R R� t
base_typesR R R t lengtht precisiont scalet is_nullablet base_typet datatypet simple_type( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR� � s|
( c C s� t | j j d t � � } d | j | k } | rl| j } t | d t | j � � | j j � g t
| | j | j � D] } | d f ^ q~ } t | � d } d } x� | D]� \ } } t j
| | d | j | f � t j j � }
| |
_ | j j |
� | |
_ | pd |
_ t | |
� t | |
� t | |
� | d 7} q� W| j d | j � nh d } t | j � d } xL | j D]A }
t | |
� t j
| | d | j |
j f � | d 7} q�Wd
S( NR~ s %s_tables_first_passs USE %sR4 g�����|�=g s Retrieving table %s.%s...g �?s< Reverse engineering of foreign keys in table %s.%s completedi ( R R R� Rq R RG R RE t tablesR� Ru RT R R� R# t db_sybase_TableR9 t commentt reverseEngineerTableColumnst reverseEngineerTablePKt reverseEngineerTableIndicest addt reverseEngineerTableFKs( R R R� t
is_first_passR� t
table_namet table_namesR� R� t
table_commentt table( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyRz s8
1!
$c C s� | j } | j } t | d t | j � � d } t | | | j | j � } t � } g | j D] } | j ^ q` } g | j D] } | j ^ q } g | j D] }
|
d ^ q� } x/| D]'} t d � t | | � D� � }
t
j j � } |
d p� d | _ |
d | _
|
j d d � | _ |
d p2d | _ |
d
d k rR|
d
n d | _ |
d d k ru|
d n d | _ |
j d
d � | _ |
d p�d | _ d } y | j |
d j � � } Wn� t k
r�y$ | j | j |
d j � � } Wnn t t f k
rmd } | j d � } d | _ d |
d j � | j | j | j f } t
j d | � q�Xd } | | _ n X| d k r�| j | | _ n |
d } | d k r�| j d � r�| d | _ n | j | � q� Wd S( Ns USE %ss' SELECT ISNULL(C.name, '') AS COLUMN_NAME, T.name AS DATA_TYPE,
C.length AS CHARACTER_MAXIMUM_LENGTH, C.prec AS NUMERIC_PRECISION,
C.scale AS NUMERIC_SCALE, CONVERT(BIT, (C.status & 0x08)) AS IS_NULLABLE,
CONVERT(BIT, (C.status & 0x80)) AS IS_IDENTITY_COLUMN, K.text AS COLUMN_DEFAULT
FROM syscolumns C, systypes T, sysobjects A, syscomments K
WHERE USER_NAME(A.uid) = ? AND
A.id = C.id AND C.id = OBJECT_ID(?) AND
C.usertype *= T.usertype AND
C.cdefault *= K.id
ORDER BY C.colidi c s s | ] } | Vq d S( N( ( R1 t nameval( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pys <genexpr>[ s t COLUMN_NAMER4 t IS_NULLABLEt COLLATION_NAMEt CHARACTER_MAXIMUM_LENGTHt NUMERIC_PRECISIONi����t
NUMERIC_SCALEt COLUMN_COMMENTt IS_IDENTITY_COLUMNt DATA_TYPER� i� sX Column datatype "%s" for column "%s" in table "%s.%s" reverse engineered as VARCHAR(255)s" Sybase reverseEngineerTableColumnst COLUMN_DEFAULTs DEFAULT i ( RG R RE R R R� R� R7 R5 t zipR R# t db_sybase_Columnt isNotNullR� t
collationNameR� R
R� R� R� t identityt indexR� t
ValueErrort TypeErrorR� t userTypet
simpleTypet
startswitht defaultValuet addColumn( R R� R R� R t rowsR R� t sybase_simple_datatypes_listt user_datatypes_listR3 t col_namesRA t
row_valuest columnt
user_datatypet msgt
default_value( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR� C sR
##
$ )
c C s� | j } | j } t | d | j � d } t | j � d k re t j d d | j | j f � d Sg t | | | j | j � D] } | d ^ q� } x6 | D]. } t | j | � } | r� | j | � q� q� Wd S( s6 Reverse engineers the primary key for the given table.s USE %ss� SELECT sc.name
FROM sysobjects so JOIN syskeys sk ON so.id=sk.id
JOIN syscolumns sc ON sc.id=sk.id AND sc.colid IN (sk.key1, sk.key2, sk.key3, sk.key4, sk.key5, sk.key6, sk.key7, sk.key8)
WHERE so.uid=USER_ID(?) AND sk.id=OBJECT_ID(?) AND sk.type=1i s Sybase reverseEngineerTablePKsb Reverse engineer of table's %s.%s primary key was attempted but the table has no columns attributei ( RG R R RT t columnsR RV R t addPrimaryKeyColumn( R R� R R� R RA t pk_col_namest pk_columnR ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR� � s 2
c C s� | j } | j } t | j � d k rK t j d d | j | j f � d St | d | j � d } x)t | | | j | j � D] } t j j � } | d | _ | d | _ | d | _
| d | _ | j r� d n d
| _ | d | _
| j | � g | d D] } | d k r| ^ q} xe | D]] } t | j | � }
|
r,t j j � } | j d
| | _ |
| _ | j j | � q,q,Wq� Wd S( s2 Reverse engineers the indices for the given table.i s" Sybase reverseEngineerTableIndicessT Reverse engineer of table %s.%s was attempted but the table has no columns attributei s USE %ss; SELECT INDEX_NAME = A.name,
IS_CLUSTERED = CASE
WHEN ((A.status&16) = 16 OR (A.status2&512) = 512) THEN 1
ELSE 0
END,
IS_PRIMARY = CASE
WHEN ((A.status&0x800) = 0x800) THEN 1
ELSE 0
END,
IS_UNIQUE = CASE
WHEN ((A.status&2) = 2) THEN 1
ELSE 0
END,
IGNORE_DUP = CASE
WHEN ((A.status&4) = 4) THEN 1
ELSE 0
END,
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 1),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 2),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 3),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 4),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 5),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 6),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 7),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 8),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 9),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 10),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 11),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 12),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 13),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 14),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 15),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 16),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 17),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 18),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 19),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 20),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 21),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 22),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 23),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 24),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 25),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 26),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 27),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 28),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 29),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 30),
INDEX_COL(USER_NAME(B.uid) + '.' + B.name, indid, 31)
FROM sysindexes A, sysobjects B
WHERE A.indid > 0 AND A.indid < 255 AND A.status2 & 2 != 2 AND
B.id = A.id AND B.type = 'U' AND
USER_NAME(B.uid) = ? AND B.name=? ORDER BY 1, 2, 3i i t UNIQUEt INDEXi i RF N( RG RT R R RV R R R# t db_sybase_Indext clusteredt isPrimaryt uniquet indexTypet ignoreDuplicateRowst addIndexR
R t db_sybase_IndexColumnt referencedColumnR9 ( R R� R R� R t index_rowR t colnamet index_column_namest column_nameR t index_column( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR� � s2 5"
)
c C s� | j } | j } t | d | j � d | j | j f } t | j � d k ru t j d d | j | j f � d S| j j � xt | | � D] } g | d d !D] } | r� | ^ q� } g | d D] } | r� | ^ q� } t j j
� } d | j | j d
j | � f | _ | | _ d | _ | _
d | _ t | j | d � }
|
swt j d d | j | j f � d St |
j | d � | _ | j s�t j d d
| d | j f � d Sx� t | | � D]� \ } } t | j | � }
|
st j d d | | j | j f � d St | j j | � } | s^t j d d | |
j | j j f � d S| j j |
� | j j | � q�W| j j | � q� Wd S( s7 Reverse engineers the foreign keys for the given table.s USE %ss) SELECT so.name, USER_NAME(so.uid),
COL_NAME(sk.id, key1),
COL_NAME(sk.id, key2),
COL_NAME(sk.id, key3),
COL_NAME(sk.id, key4),
COL_NAME(sk.id, key5),
COL_NAME(sk.id, key6),
COL_NAME(sk.id, key7),
COL_NAME(sk.id, key8),
COL_NAME(sk.depid, depkey1),
COL_NAME(sk.depid, depkey2),
COL_NAME(sk.depid, depkey3),
COL_NAME(sk.depid, depkey4),
COL_NAME(sk.depid, depkey5),
COL_NAME(sk.depid, depkey6),
COL_NAME(sk.depid, depkey7),
COL_NAME(sk.depid, depkey8)
FROM syskeys sk JOIN sysobjects so ON sk.depid = so.id
WHERE sk.type = 2 AND sk.id = OBJECT_ID('%s.%s')i s Sybase reverseEngineerTableFKsse Reverse engineer of foreign keys for table %s.%s was attempted but the table has no columns attributei i i
s %s_%s_%s_fkR/ t RESTRICTs* Could not find schema "%s" in catalog "%s"s3 Could not find referenced table "%s" in schema "%s"s+ Could not find column "%s" in table "%s.%s"( RG R R RT R R RV t foreignKeysR� R# t db_sybase_ForeignKeyR8 t
deleteRulet
updateRulet modelOnlyR R� R� t referencedTableR� R9 t referencedColumns( R R� R R� R RA t col_namet
fk_columnst fk_ref_columnst foreign_keyt referenced_schemaR& t referenced_column_nameR t referenced_column( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR� � sR
&#% c C s� t | d | j j � d } | j j � d t t | | j j | j � � d } t | | | j � } | r� x� t d d | � D]p \ } } } t j | | d | j | f � t j
j � } | | _ | p� d | _ | | _ | j j
| � q� Wn d S(
Ns USE %ss� SELECT so.name AS view_name, sc.text AS view_definition
FROM sysobjects so JOIN syscomments sc on so.id=sc.id
WHERE so.uid=USER_ID(?) AND so.type='V'
ORDER BY so.name, sc.colidg �?g�����|�=t view_namet view_definitions Reverse engineering view %s.%sR4 i ( R RG R t viewsR� RT Rv RD R R� R# t db_sybase_Viewt
sqlDefinitionR9 ( R R R t stepR R= R7 R8 t view( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR| = s
)"! c C s t | d | j j � d } d t t | | j j | j � � d } t | | | j � } | r� x� t d d | � D]y \ } } } t j | | d | j | f � t j j � } | | _ | p� d | _ d | _
| | _ | j j
| � qt Wn t j d d
| j � d S( Ns USE %ss� SELECT so.name AS procedure_name, sc.text as procedure_definition
FROM sysobjects so INNER JOIN syscomments sc ON so.id=sc.id
WHERE so.uid = USER_ID(?) AND so.type = 'P'
ORDER BY so.name, sc.colidg �?g�����|�=t procedure_namet procedure_definitions# Reverse engineering procedure %s.%sR4 t PROCEDUREs= Finished reverse engineering of procedures for the %s schema.i ( R RG R RT Rx RD R R� R# t db_sybase_Routinet routineTypeR; R� R9 ( R R R R< R R= R> R? t procedure( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR� T s )"! c C s t j d d | j � d S( Ng �?s< Finished reverse engineering of functions for the %s schema.i ( R R� R ( R R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR� l s c s� t | d | j j � d } d } i } x� t | | | j � D]� } | d d k r� | j | d | d d g � d c d 7<n | d d k r� | j | d | d d g � d c d 7<n | d
d k r? | j | d
| d d g � d c d 7<q? q? Wd t t | | j j | j � � d
} | rUt | | d j d � | D� � � n d } i � � f d � } | rmx� t d d | | � D]� \ } }
} t j
| | d | j |
f � t j j � } |
p�d | _ | | _
d | _ d | _ | � |
\ }
} | j d � | _ t | j |
� | _ | j rO| j j j | � q�t j d d | j � q�Wn t j
d d | j � d S( Ns USE %ss� SELECT name, deltrig, instrig, updtrig
FROM sysobjects
WHERE uid = USER_ID(?) AND type='U'
AND(deltrig != 0 OR instrig != 0 OR updtrig != 0)s� SELECT so.name AS trigger_name, sc.id AS trigger_id, sc.text AS trigger_definition
FROM syscomments sc JOIN sysobjects so ON sc.id=so.id
WHERE sc.id IN (%s)
ORDER BY so.name, sc.colidi i R4 s ;DELETEi s ;INSERTi s ;UPDATEg �?g�����|�=s , c s s | ] } t | � Vq d S( N( RW ( R1 t trig_id( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pys <genexpr>� s c s | d � | d <d S( Ni i ( ( RA ( t trigger_name2id( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt register_trigger_name� s t trigger_namet trigger_definitions! Reverse engineering trigger %s.%st AFTERt ;s Sybase reverseEngineerTriggerss' Parent table not found for trigger "%s"s; Finished reverse engineering of triggers for the %s schema.( R RG R R� RT Rw R8 R
RD R R� R# t db_sybase_TriggerR; t timingt enabledt stript eventR R� t triggersR9 R� ( R R t tables_with_triggers_queryt trigger_details_queryRP RA R< t all_triggersRF R= RG RH t triggert
trigger_tablet trigger_events( ( RE sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyR{ s s@ --1)2 ! c C s3 t j t j d � } t j j j j j | � | S( Ns /sybase_rdbms_info.xml( R t unserializet
ModuleInfot moduleDataDirectoryR R R R R9 ( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt initializeDBMSInfo� s c C se t j t j � } d d l } | j � } x4 | j � D]& \ } } | j d | | | f � q7 W| S( Ni����s
%s|%s (%s)( R t Listt STRINGRO t dataSourcest itemsR9 ( t resultRO t sourcest keyt value( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getDataSourceNames� s c C s# t j t j � } | j d � | S( Ns. 4.1|Sybase Adaptive Server Enterprise 15 (4.1)( R R[ R\ R9 ( R_ ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt getTDSProtocolVersionChoices� s
c C s g t | j d <d S( NR~ i ( R R ( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt resetProgressFlags� s (< R R R t workbenchR t workbench.exceptionsR t workbench.utilsR RX R R R R R R. RD t exportR\ RE R# t GrtNamedObjectRK R� R$ RP R^ R_ R` Rc RX t LISTRn Rs Ru Rv Rw Rx Ry RI t DICTR� R� R� R� Rz R� R� R� R� R� R| R� R� R{ t
db_mgmt_RdbmsRZ Rc Rd Re ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sybase_re_grt.pyt <module> sR
&)!$
*>$$'$
*000 0 0B�-H-)-A--X-H----3 $
$