ProPeler
Home
Console
Upload
information
Create File
Create Folder
About
Tools
:
/
opt
/
cpanel-ccs
/
txdav
/
common
/
datastore
/
Filename :
sql_dump.pyc
back
Copy
� �t�ac @ s? d d l m Z m Z d d l m Z m Z m Z m Z m Z m Z m Z m Z m Z d d l m Z d d l m Z m Z d d l Z i d d 6d d 6d d 6Z i d d 6d d 6Z i e d d d g � d 6d d 6e d 6e d 6Z i e d d d g � d 6d d 6Z d d � Z e d d � � Z e d d � � Z d S( i����( t inlineCallbackst returnValue( t Schemat Tablet Columnt Sequencet Functiont SQLTypet ProcedureCallt Constraintt Index( t addSQLToSchema( t POSTGRES_DIALECTt ORACLE_DIALECTNt chart charactert varchars character varyingt timestamps timestamp without time zonet integert numbers timestamp(6)t timezonet UTCt CURRENT_TIMESTAMPs timezone('UTC'::text, now())s NULL::character varyingt falset trues$ CURRENT_TIMESTAMP at time zone 'UTC't nullt publicc C sH | j j t k r" t | | | � S| j j t k rD t | | | � Sd S( s! Generate the L{Schema}. N( t dbtypet dialectR t dumpSchema_postgresR t dumpSchema_oracle( t txnt titlet schemaname( ( s2 /opt/cpanel-ccs/txdav/common/datastore/sql_dump.pyt dumpSchema5 s c c s� | j � } t | � } i } | j d | f � V} x7 | D]/ } | d } t | | j � � | | j � <q< Wi } | j d | f � V} xv| D]n} | d } t | | j � � } | | | j � <| j d | | f � V} x | D]\ } } } } } t | | j � t t j | | � | � � } | j j | � | r�| j d � r�| j d � d j d � d } | | j � | _ q�| t k r�t | | _ q�y t | � | _ Wq�t k r�| | _ q�Xn | d k r� | j t j | j g � q� q� Wq� Wi } | j d | f � V} x' | D] \ } } } | | f | | <q)Wi } | j d | f � V} x' | D] \ } } } | | f | | <qpW| j d | f � V} x� | D]} \ } } } | | | d j � } | j | | d j � � } | j | | d j � � | d k r�| j � | _ q�q�W| j d | f � V} x8 | D]0 } t | | d j d | f d � j � � qPW| j d | f � V} x% | D] } | d } t | | � q�Wt | � d S( s! Generate the L{Schema}. sT select sequence_name from information_schema.sequences where sequence_schema = '%s';i sK select table_name from information_schema.tables where table_schema = '%s';s� select column_name, data_type, is_nullable, character_maximum_length, column_default from information_schema.columns where table_schema = '%s' and table_name = '%s';s nextval(t 'i t .i����t NOsx select constraint_name, table_name, column_name from information_schema.key_column_usage where constraint_schema = '%s';s select constraint_name, table_name, column_name from information_schema.constraint_column_usage where constraint_schema = '%s';s� select constraint_name, unique_constraint_name, delete_rule from information_schema.referential_constraints where constraint_schema = '%s';s NO ACTIONs8 select indexdef from pg_indexes where schemaname = '%s';s %s.t sQ select routine_name from information_schema.routines where routine_schema = '%s';N( t lowerR t execSQLR t upperR R R t DTYPE_MAP_POSTGRESt gett columnst appendt startswitht splitt defaultt DEFAULTVALUE_MAP_POSTGRESt intt ValueErrort tableConstraintR t NOT_NULLt namet columnNamedt doesReferenceNamet deleteActionR t replaceR R ( R R R! t schemat seqst rowst rowR6 t tablest tablet datatypet is_nullablet charlenR0 t columnt dnamet keyst connamet tnamet cnamet constraintst uconnamet deletet indexdef( ( s2 /opt/cpanel-ccs/txdav/common/datastore/sql_dump.pyR @ sh # - $ . c # c s� | j � } t | � } i } | j d | j � f � V} x7 | D]/ } | d } t | | j � � | | j � <qB Wi } | j d | j � f � V} x�| D]�} | d } t | | j � � } | | | j � <| j d | j � | f � V} x4| D],\ } } } } } t | | j � t t j | j � | j � � | � � } | j j | � | r�| j � } | j d � r�| j d � d j d � d } | | j � | _ q�| t k r�t | | _ q�y t | � | _ Wq�t k r�| | _ q�Xn | d k r� | j t j | j g � q� q� Wq� Wt j t � } | j d | j � f � V} x4 | D], \ } } } } | | j | | | f � qbW| j d | j � f � V} xN| D]F\ } } } } } | | d d j � | k r�| | } t | d d � �} | | d d j � } g | D] } | d j � ^ q'} g | D] } | j | � ^ qJ} | d k r}| | _ q�| d k r�| j t j | � q�| d k r�| d j | | d d j � � | j � d k r�| j � | d _ q�q�q�q�Wt j t � } | j d | j � f � V} x. | D]& \ } } } | | j | | f � q3W| j d | j � f � V} x� | D]� \ } } }! | | k r�| | } g t | | d d � �D] } | d j � ^ q�} g | D] } | j | � ^ q�} t | | j � | |! d k � }" x | D] } |" j! | � q&Wq�q�W| j d | j � f � V} x% | D] } | d } t" | | � qhWt# | � d S( s! Generate the L{Schema}. sC select sequence_name from all_sequences where sequence_owner = '%s'i s4 select table_name from all_tables where owner = '%s's� select column_name, data_type, nullable, char_length, data_default from all_tab_columns where owner = '%s' and table_name = '%s's nextval(R# i R$ i����t Nsb select constraint_name, table_name, column_name, position from all_cons_columns where owner = '%s's{ select constraint_name, constraint_type, table_name, r_constraint_name, delete_rule from all_constraints where owner = '%s't keyc S s | d S( Ni ( ( t x( ( s2 /opt/cpanel-ccs/txdav/common/datastore/sql_dump.pyt <lambda>� R& t Pt Ut Rs no actions] select index_name, column_name, column_position from all_ind_columns where index_owner = '%s'sM select index_name, table_name, uniqueness from all_indexes where owner = '%s'c S s | d S( Ni ( ( RP ( ( s2 /opt/cpanel-ccs/txdav/common/datastore/sql_dump.pyRQ � R& t UNIQUEs9 select object_name from all_procedures where owner = '%s'N($ R' R R( R) R R R R t DTYPE_MAP_ORACLER+ R, R- t stripR. R/ R0 t DEFAULTVALUE_MAP_ORACLER2 R3 R4 R R5 R6 t collectionst defaultdictt listt sortedR7 t primaryKeyRU R8 R9 R t addColumnR R (# R R R! R; R< R= R> R6 R? R@ RA RB RC R0 RD RE RJ RG RH RI t positiont conntypet r_constraint_namet delete_rulet constraintt itemt column_namest column_nameR, t idxt index_namet column_positiont table_namet uniquenesst index( ( s2 /opt/cpanel-ccs/txdav/common/datastore/sql_dump.pyR � s� # 9 $ #" # 6"! ( t twisted.internet.deferR R t twext.enterprise.dal.modelR R R R R R R R R t twext.enterprise.dal.parseschemaR t twext.enterprise.ienterpriseR R RY R* RV t Nonet Falset TrueR1 RX R" R R ( ( ( s2 /opt/cpanel-ccs/txdav/common/datastore/sql_dump.pyt <module> s0 @ P