| 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 @ s� d d l 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 Z e d d d d d
d � Z d e f d
� � YZ
e j e j j � d � � Z e j e j e j f � 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 � 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 j( e j j 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$ � � 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 d S(' i����N( t GenericReverseEngineering( t DefineModule( t server_version_str2tuple( t NotConnectedErrort namet
DbSQLiteREt authors Oracle Corp.t versions 1.0t SQLiteReverseEngineeringc B s� e Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z e d � � Z
e d � � Z e d � � Z e d
� � Z
e d � � Z RS( c C s d S( Nt SQLite( ( t cls( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt getTargetDBMSName s c C s | j | j d S( NR ( t _connectionst __id__( R
t
connection( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt
serverVersion$ s c C s� d } yq | j | � } y( | j � j d � s? t d � � n Wn3 t k
ru } t j d | j � t d � � n XWn� t k
r} t j d | j � t j
| j d � } | s� t j d t
| � � � n d | j d d | j d <t j d
� i | d 6| j | j <n X| r�| j | d � j � d
} t j d d | j | f � t | � d } t j j � } | d \ | _ | _ | _ | _ | | j | j d <n d 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 (ignored for SQLite).
s SELECT 1s connection errors1 Connection to %s apparently lost, reconnecting...s Connection errors Connecting to %s...t dbfiles Connection failedt 't wbcopytables_connection_stringt ConnectedR s SELECT sqlite_version()i s SQLite REs Connected to %s, %si R i N( i i i i ( t Nonet get_connectiont cursort executet Exceptiont grtt send_infot hostIdentifierR t sqlite3t connectt parameterValuest
send_errort strR R
t
execute_queryt fetchonet log_infoR R t classest
GrtVersiont majorNumbert minorNumbert
releaseNumbert buildNumber( R
R t passwordt cont exct vert ver_partsR ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR ) s4
"c C s d g S( s2 Returns a list of the available catalogs.
t def( ( R
R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt getCatalogNamesT s c C s* t j j t j j | j d � � d g S( s; Returns a list of schemata for the given connection object.R i ( t ost patht splitextt basenameR ( R
R t catalog_name( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt getSchemaNamesZ s c C s- d } g | j | | � D] } | d ^ q S( NsN SELECT name
FROM sqlite_master
WHERE type='table' AND NOT name LIKE 'sqlite_%'i ( R! ( R
R R5 t schema_namet queryt row( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt
getTableNames` s c C s g S( N( ( R
R R5 R7 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt getViewNamesg s c C s g S( N( ( R
R R5 R7 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt getProcedureNamesk s c C s� d d l m } t j d d � | j � | j | | � } t j d d � | j d t � } d } | | r� t | j | | d � � n d 7} t j d d
� | rtd } x� | j
| d � D]� \ }
} } }
} t d k s� | s� | j d � r� q� n | j
d d � j
d d � } t j d d | � | j | | � | j � t j d | | d | � | d 7} q� Wn t j d d � | S( Ni����( t MysqlSqlFacadei s' Reverse engineering catalog informationg�������?s Preparing...t reverseEngineerTablesg�����|�=t s Gathered statss SELECT * FROM sqlite_mastert viewt triggert sqlite_t [t ]R s Processing this sql:
%s;s Object %s reverse engineered!i g �?s Reverse engineering completed!( s views trigger( t grt.modulesR= R t
send_progresst check_interruptiont reverseEngineerCatalogt gett Truet lenR: R! t typet
startswitht replacet log_debugt parseSqlScriptString( R
R R5 t
schemata_listt contextR= t catalogt
get_tablest totalt idxt object_typeR t tbl_namet _t sql( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt reverseEngineers s,
+("
c C s� t j j � } | | _ | j j | j j � | j | | � pF d g } | j j � xa | D]Y } t j j
� } | | _ | | _ t | d � r� | j
| | � n | j j | � q] W| S( NR? t reverseEngineerSequences( R R$ t db_mysql_CatalogR t simpleDatatypest extendt _rdbmsR6 t schematat
remove_allt db_mysql_Schemat ownert hasattrR\ t append( R
R R5 RS t schemata_namesR7 t schema( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRH � s
c C s d S( N( ( R
R t table( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt getCommentForTable� s c C s d S( N( ( R
R RS ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt reverseEngineerUserDatatypes� s ( t __name__t
__module__t classmethodR R R R0 R6 R: R; R< R[ RH Rj Rk ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR s +'c C s
t j d � S( Ns sqlite_rdbms_info.xml( R t initializeDBMSInfo( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRo � s c C s
t j � S( N( R t getDataSourceNames( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRp � s c C s
t j | � S( N( R t quoteIdentifier( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRq � s c C s
t j | � S( N( R t fullyQualifiedObjectName( t obj( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRr � s c C s t j | | � S( N( R R ( R R* ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR � s c C s
t j | � S( N( R t
disconnect( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRt � s c C s
t j | � S( N( R t isConnected( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRu � s c C s
t j � S( N( R R ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR � s c C s
t j � S( N( R t getSupportedObjectTypes( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRv � s c C s
t j | � S( N( R t getServerVersion( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRw � s c C s
t j | � S( N( R R0 ( R ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR0 � s c C s t j | | � S( N( R R6 ( R R5 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR6 � s c C s t j | | | � S( N( R R: ( R R5 R7 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR: � s c C s t j | | | � S( N( R R; ( R R5 R7 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR; � s c C s t j | | | � S( N( R t getTriggerNames( R R5 R7 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRx � s c C s t j | | | � S( N( R R< ( R R5 R7 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR< � s c C s t j | | | � S( N( R t getFunctionNames( R R5 R7 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRy � s c C s t j | | | | � S( N( R R[ ( R R5 RQ RR ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR[ s c C s t j | | � S( N( R Rk ( R RS ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRk s c C s t j | | � S( N( R RH ( R R5 ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRH s c C s t j | | � S( N( R R> ( R Rh ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR> s c C s t j | | � S( N( R t reverseEngineerViews( R Rh ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyRz s c C s t j | | � S( N( R t reverseEngineerProcedures( R Rh ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR{ s c C s t j | | � S( N( R t reverseEngineerFunctions( R Rh ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR| s c C s t j | | � S( N( R t reverseEngineerTriggers( R Rh ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyR} s (3 R t os.pathR1 t db_generic_re_grtR t wbR t workbench.utilsR t workbench.exceptionsR R t
ModuleInfoR t exportR$ t
db_mgmt_RdbmsRo t LISTt STRINGRp Rq t GrtNamedObjectRr t INTt db_mgmt_ConnectionR Rt Ru R Rv R% Rw R0 R6 R: R; Rx R< Ry t
db_Catalogt DICTR[ Rk RH t db_SchemaR> Rz R{ R| R} ( ( ( sI C:\Program Files\MySQL\MySQL Workbench 6.3 CE\modules\db_sqlite_re_grt.pyt <module> sB � $!$*$$'$*00000B------