|
Server : Apache System : Linux cvar2.toservers.com 3.10.0-962.3.2.lve1.5.73.el7.x86_64 #1 SMP Wed Aug 24 21:31:23 UTC 2022 x86_64 User : njnconst ( 1116) PHP Version : 8.4.18 Disable Function : NONE Directory : /lib/python2.7/site-packages/south/db/ |
Upload File : |
�
m�Rc @ s� d d l m Z d d l Z d d l m Z m Z d d l m Z d d l m Z d d l
m Z d d l m
Z
d e j f d � � YZ d S(
i����( t print_functionN( t
connectiont models( t no_style( t
DatabaseError( t generic( t string_typest DatabaseOperationsc B s� e Z d Z d Z d Z d Z d Z d Z d Z e Z
e Z d � Z d � Z
d � Z d � Z e j d
� � Z d � Z e j e d � � Z d e e d
� Z d � Z e j e e d � � Z e j e j d � � � Z RS( t firebirds ALTER %(column)s TYPE %(type)ss) ALTER %(column)s SET DEFAULT %(default)s;t s ALTER TABLE %s ADD %s;s ALTER TABLE %s DROP %s;c C s� | j j | i � i | j | | <| j d | � } xW | D]O \ } } } | j | | j | t � � | j | | | j | | f � q> Wd S( Ns�
SELECT
rc.RDB$CONSTRAINT_NAME,
rc.RDB$CONSTRAINT_TYPE,
cc.RDB$TRIGGER_NAME
FROM rdb$relation_constraints rc
JOIN rdb$check_constraints cc
ON rc.rdb$constraint_name = cc.rdb$constraint_name
WHERE rc.rdb$constraint_type = 'NOT NULL'
AND rc.rdb$relation_name = '%s'
( t _constraint_cachet
setdefaultt executet sett add( t selft db_namet
table_namet rowst
constraintt kindt column( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt _fill_constraint_cache s
&c C sA d } | r d n d } | i | d 6| j � d 6| j � d 6S( Ns�
UPDATE RDB$RELATION_FIELDS SET RDB$NULL_FLAG = %(null_flag)s
WHERE RDB$FIELD_NAME = '%(column)s'
AND RDB$RELATION_NAME = '%(table_name)s'
t NULLt 1t null_flagR R ( t upper( R R t column_namet is_nullt sqlR ( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt _alter_column_set_null0 s
c C s' d } | j | | � } | r# t St S( Ns�
SELECT a.RDB$DEFAULT_VALUE
FROM RDB$RELATION_FIELDS a
WHERE a.RDB$FIELD_NAME = '%(column)s'
AND a.RDB$RELATION_NAME = '%(table_name)s'
( R t Truet False( R t paramsR t value( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt _column_has_default= s c C s9 | j | � r5 | j d | j | � f g f � n d S( sB Subcommand of alter_column that sets default values (overrideable)s ALTER COLUMN %s DROP DEFAULTN( R# t appendt
quote_name( R t fieldt nameR! t sqls( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt _alter_set_defaultsH s c C s g } d } x� | D] \ } } t | _ | j | | | � } | sI q n | j | � t | t j � r | j pw | j } t j
j | | � } q q W| j | j
i | j | � d 6d j g | D] } | r� | ^ q� � d 6� | r| j | d � | j | d � n d S( NR t tables , t columnsi i ( R t _suppress_defaultt
column_sqlR$ t
isinstanceR t AutoFieldt db_columnR R t opst autoinc_sqlR t create_table_sqlR% t join( R R t fieldsR+ R2 t
field_nameR& t col( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt create_tableR s"
.c C s d S( s�
Renames table is not supported by firebird.
This involve recreate all related objects (store procedure, views, triggers, etc)
N( ( R t old_table_nameR ( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt rename_tablem s c C sV t t | � j | d t �t j j | � } | rR y | j | � WqR qR Xn d S( s{
Deletes the table 'table_name'.
Firebird will also delete any triggers associated with the table.
t cascadeN( t superR t delete_tableR R R1 t drop_sequence_sqlR ( R R R; R ( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyR= t s c
C s� | s | j | � n t | d � r2 | j � n | j | � } y | j d | j � � } Wn t k
r| | j � } n X| r�| r� | j | j � | g } n | g } | j r� | j
d � n | j r� | j
d � n d j | � } d } t
| d t � sC| j � r�| j � }
|
d k r@t |
� rB|
� }
n t |
t � rjd |
j d d � }
nL t |
t j t j t j f � r�d |
}
n t |
t � r�t |
� }
n t |
t � r�|
j d
d � }
n | d 7} |
} q@qC| j r| j s| j � d
k rC| j r@| j � j j r@| d 7} q@qCn | j rd| j rd| d 7} n | j r�| j! r�| j" | j# | | j | j j$ j% j& | j j$ j% j' | j j( � j � � q�n t | d � rx- | j) t* � | � D] } | j" | � q�Wn | j svt | j � j+ d � rv| j, d | � } x9 | j � j+ j- | | t* � � D] } | j" | � qYWqvn | r�| | Sd Sd S( sY
Creates the SQL snippet for a column. Used by add_column and add_table.
t
south_initR s NOT NULL PRIMARY KEYt UNIQUEt R, s '%s't 's ''t %s %%s DEFAULT %sR s DEFAULT ''s NOT NULLt post_create_sqlt sql_indexes_for_fieldt FakeModelForGISCreationN( (. t set_attributes_from_namet hasattrR? t
_field_sanityt db_typet _get_connectiont TypeErrorR% R t primary_keyR$ t uniqueR4 t getattrR t has_defaultt get_defaultt Nonet callableR. R t replacet datetimet datet timet boolt intt nullt blankt empty_strings_allowedt featurest! interprets_empty_strings_as_nullst relt supports_foreign_keyst add_deferred_sqlt foreign_key_sqlt tot _metat db_tablet get_fieldR6 RD R t creationt
mock_modelRE (
R R R6 R& t
tablespacet with_namet field_preparedR t field_outputt sqlparamst defaultt stmtt model( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyR- � st
!
%
+ (c C s� | j ri | j | | g d � } xE | D]: } | j | j i | j | � d 6| j | � d 6� q( Wn t | j | | g d � � } | j r� | r� | j | | g � n& | j r� | r� | j | | g � n y | j | | � Wn t
k
r� n Xd S( Nt CHECKR* R R@ ( t has_check_constraintst _constraints_affecting_columnsR t delete_check_sqlR% t listRN t
create_uniquet
delete_uniquet delete_foreign_keyt
ValueError( R R R' R& t check_constraintsR t unique_constraint( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt _drop_constraints� s
c C st | j r# | j r t d � n d St | d � r? | j � n | j | � | s^ | j } n | | _ | s� | j | | | � n i | j | � d 6| j | � d 6| d 6} g } g } | d d k r� | j | j | g f � n | j
| | | | � | j | j | | | j � � | j | | | | � | j r�t t | � � \ } } | j d | j | � d j | � f t j | � � n^ x[ | D]S \ }
} y' | j d | j | � |
f | � Wq�t k
r�} t | � q�Xq�Wx | D] }
| j |
� q�W| sp| j rp| j rp| j | j | | j | j j j j | j j j j | j j � j � � qpn d S( s�
Alters the given column name so it will match the given field.
Note that conversion between the two by the database must be possible.
Will not automatically add _id by default; to have this behavour, pass
explicit_name=False.
@param table_name: The name of the table to add the column to
@param name: The name of the column to alter
@param field: The new field definition to use
sC - no dry run output for alter_column() due to dynamic DDL, sorryNR? R t typeR s ALTER TABLE %s %s;s , (! t dry_runt debugt printRH R? RG R R| R% t _db_type_for_alter_columnRR R$ t alter_string_set_typet _alter_add_column_modsR RZ R) t allows_combined_altersRu t zipR R4 R t flattenR R_ R` Rb Rc Rd Re Rf R6 ( R R R' R& t
explicit_namet ignore_constraintsR! R( t
sqls_extrat valuesR t e( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt alter_column sV
'
c C sI | | k r g S| j d | j | � | j | � | j | � f � d S( Ns ALTER TABLE %s ALTER %s TO %s;( R R% ( R R t oldt new( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt
rename_column_ s ( t __name__t
__module__t backend_nameR� t alter_string_set_defaultt alter_string_drop_nullt add_column_stringt delete_column_stringt rename_table_sqlR R� t has_booleansR R R# R) R t invalidate_table_constraintsR8 R: R= R R- R| R� t copy_column_constraintst delete_column_constraintsR� ( ( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyR s.
h Z( t
__future__R RU t django.dbR R t django.core.management.colorR t django.db.utilsR t south.dbR t south.utils.py3R R ( ( ( s5 /usr/lib/python2.7/site-packages/south/db/firebird.pyt <module> s