o  j@sddlmZmZddlZeeZddlZzddlZ Wn e y(ddl Z Ynwddl m Z ddl mZddlmZddlmZddlmZddlmZdd lmZdd lmZdd lmZdd lmZmZdd lmZddlmZddlmZz ddlm Z e j!Z!Wne e"fyddlm#Z!Ynwddl$m%Z%ddl&m'Z'm(Z(m)Z)m*Z*m+Z+m,Z,m-Z-ddl.m/Z/ddl0m1Z1ddl2m3Z3ddl4m5Z6ddl4m Z7ddl4m8Z9ddl4m:Z;ddl4mm?Z?ddl4m@Z@mAZAmBZBmCZCmDZDmEZEmFZFmGZGmHZHmIZImJZJmKZKmLZLmMZMmNZNmOZOmPZPmQZQmRZRmSZSmTZTmUZUmVZVmWZWmXZXmYZYmZZZm[Z[m\Z\m]Z]m^Z^m_Z_m`Z`maZambZbmcZcmdZdmeZemfZfmgZgmhZhddlimjZjGdd d ZkGd!d"d"ZliejWeXejeXejmeYejneYejoe^ejpe^ejZe]ejqe]ejre\ejse\ejteLejPePejuePejJeJejveJejwjxjyjveJejzeJejwjxjyj{eKejHeHej|eHejIeIej}eIeeOe%eheefiZ~eed#eed$dZedureLe~e<d`d%d&Zd'd(Z  dad)d*Z  dad+d,Zd-d.ZGd/d0d0eZd1d2Zd3d4Zd5d6Zd7d8Zd9d:Zd;d<Zd=d>Zd?d@ZdAdBZdCdDZdEdFZdGdHZdIdJZdKdLZdMdNZdOdPZdQdRZdSdTZdUdVZdbdXdYZdZd[Zd\d]Zd^d_ZdS)c)absolute_importprint_functionN)isabs)isclass)event)Column)Index)Table) ForeignKey)FLOAT)DOUBLE_PRECISION)PGUuidPGInet) relationship)mapper)association_proxy) mapperlib)_mapper_registry)PGLTree)PGXml PGObjectXml PGObjectJson PGFileJsonPGJsonBPGHtmlPGJson) PGGeometry)EnumBase) XmlModifier)xml)json)jsonb)table)msgpack)HybridFileStore)) SimpleModelEnumArrayComplexModelBaseAnyAnyDictAnyXmlAnyHtmlDateTimeDateTimeDuration ByteArrayStringUnicodeUuidBooleanPointLinePolygon MultiPoint MultiLine MultiPolygonFloatDoubleDecimalIntegerInteger8 Integer16 Integer32 Integer64UnsignedIntegerUnsignedInteger8UnsignedInteger16UnsignedInteger32UnsignedInteger64 Ipv6Address Ipv4Address IpAddressFileLtree) sanitize_argsc@ eZdZdS)_SINGLEN__name__ __module__ __qualname__rUrU\/var/www/html/LicenciasMiG/venv/lib/python3.10/site-packages/spyne/store/relational/_base.pyrP\rPc@rO)_JOINEDNrQrUrUrUrVrX_rWrXBinaryBINARYcCsd|jjdkr|jdur|durd|d<nd|_|jjdur0|dur)|jj|d<dS|jj|_dSdS)NFnullabledefault) Attributesr[ __extends__ db_defaultr\)clssubcls col_kwargscolrUrUrV_sp_attrs_to_sqla_constraintss  rdcCsf|jj}|dur |St|trtSt|tttfrtSt|t r%t ddSt|t r2t d|jj dSt|tr?t d|jj dSt|trLt d|jj dSt|trYt d|jj dSt|trft d|jj dSt|trst d |jj dSt|tr|jjtjjkrtjSt|jjSt|tr|jjtjjkrtjSt|jjSt|trtj|jd |jiSt|trtSt|trt St|t!t"fr|jj#}|durdSt$|t%rt&St$|t'rt(St)t*||d t|t+rtj,St|t-t.frtj/St|t0t1frtj2St|t3t4fr tj5St|t6t7frtj5St|t8r t9St|t:r(t;St|t2trr5boolint ValueErrorr-r/ro as_timezoner.r0dialects postgresqlbaseINTERVALr_get_sqlalchemy_typetype)r`rpsaretvalrUrUrVrs                              rc Cs|jjdus Jd|t|jj\}} t||| t|\} | \} } t| } d| vr1| d}n|}|dur=|d| }||ksEJdtd|jj| fdd|jj|f||||d }t || |fi| S) zbGets key and child type and returns a column that points to the primary key of the child. N%r has no table name.rm_zaThe column name for the foreign key must be different from the column name for the object itself.%s.%sTz %s_%s_fkey) use_alterrm deferrable initiallyondeleteonupdate) r] table_namerNsqla_column_argsrdget_pk_columnsrpopr r)parentsubnamera fk_col_namerrrrcol_argsrb pk_columnpk_key pk_spyne_type pk_sqla_typecolnamefkrUrUrV _get_col_o2o's0     rccs|jjdus Jd|t|jj\}}t|\}|\} } t| } |dur/d|jj| g}|| fgVtd|jj| f||||d} t|| | fi|} | VdS)zaGets the parent class and returns a column that points to the primary key of the parent. Nrrr)rrrr) r]rrNrrrjoinr r)r`rrrrrrrbrrrrrrcrUrUrV _get_col_o2mQs   rc  CsDt||| | ||d\} }t||||| | ||d}d|_|_||fS)zGets the parent and child classes and returns foreign keys to both tables. These columns can be used to create a relation table.rrrrT)rr primary_key)r`kchildfk_left_col_namefk_right_col_namefk_left_deferrablefk_left_initiallyfk_right_deferrablefk_right_initiallyfk_left_ondeletefk_left_onupdatefk_right_ondeletefk_right_onupdatecol_infoleft_col right_colrUrUrV _get_cols_m2mqs  rc@seZdZddZddZdS) _FakeTablecCs||_i|_g|_g|_dSN)rmccolumnsindexes)selfrmrUrUrV__init__s z_FakeTable.__init__cCs|j|||j|j<dSr)rappendrrm)rrcrUrUrV append_columns z_FakeTable.append_columnN)rRrSrTrrrUrUrUrVrs rc Cs:|jj}|jj}|r|sd}z|\}}Wnttfy-d|j||r%dndf}|}Ynw|dvr4dS|durB||ft|df}n ||ft||df}t|trY|j |dStd d |j j D} | |d} | dur{t |d i|d dS| j|ksJd | j|| j d} | |ksJd| |dS)z :param table: sqla table :param col: sqla col :param k: field name (not necessarily == k) :param v: spyne type Tz%s_%s%s_unique)FNN)unique)rpostgresql_usingcSsg|]}|j|fqSrU)rm).0idxrUrUrV sz#_gen_index_info..rzUUniqueness flag differ between existing and current values. Existing: {!r}, New: {!r}rz`Indexing methods differ between existing and current index directives. Existing: {!r}, New: {!r})r]rindex TypeErrorrrmr}ryrrrr"getrformatkwargs) r"rcrvrr index_name index_method index_argsr existing_idx existing_valrUrUrV_gen_index_infosD        rc Cs|jj}g}d}t|dd}|dur$|D]}t|dddur#|jr#|}q|dur=|jj}|dur=||kr7t}nt}tdd}|durG|jj}|durf|D]}t |d} | dure|dusaJd| }t}qM||||fS)Nr^ _type_infoz0Joined table inheritance is not yet implemented.z"There can be only one base mapper.) r]rgetattr __mixin__rPrXr| sqla_mapper_mapper_registriesr) r` cls_basesrinc inheritance base_classbbase_table_name base_mapperbmrUrUrV_check_inheritances8   rcCs8|jj}|jj}d}||jvr|j|}|St|}|Sr)r]r sqla_metadatatablesr)r`rmetadatar"rUrUrV _check_tables  rc Cst|jj\}}t|||t|jdd}d|vr|d} n|} |jjsT| |jvr0|j| } nt| |g|Ri|} | | t || |||jj sR| ||<dSdS|dur^|||<dSdS)Nmapper_propertyrm) rNr]rrdrrexc_dbrrrr exc_mapper) r`propsr"rra sqla_typerrbmprrcrUrUrV_add_simple_types$       rcCs|jj}t||||j|j|j|j|j|j|j |j |j |j \}}|j |_|j |_|jdur7d|jj|g}n|j}||jvr}|j|} | j|j d} | dusRJ| dur`|jj| jjks`J| j|j d} | durr| |n|jj| jjks|Jn t||g||fR} |jj} t|j|j|j|j|jd} |jr| durt t!|dksJt!|\\}}| j|}| "t| || j|j k|| j|j kd|j#dur|j#| d<t$|fi| ||<dS| "t| d|j#dur|j#| d<t$|fi| ||<dS) atGenerates a relational many-to-many array. :param cls: The class that owns the field :param props: SQLAlchemy Mapper properties :param subname: Field name :param arrser: Array serializer, ie the __orig__ of the class inside the Array object :param storage: The storage configuration object passed to the store_as attribute. TrN)lazybackrefcascadeorder_byback_populatesr) secondary primaryjoin secondaryjoin single_parent)r)%r]rrleftrightrrrrrrrrkeymultirrrrrr __class__rr sqla_tabler}rrrrr explicit_joinlenrupdaterr)r`rrarrserstoragercol_own col_childrel_table_namerel_tcol_own_existingcol_child_existingown_t rel_kwargs col_pk_keyrcol_pkrUrUrV_gen_array_m2msd           r cs|jj}|jj}t||j|j|j|j|jd}t |}|d\|_} |j} t |} |j dur2||jj} | durAd ||g} | |j vr|j | } | j| jjjuseJd|| j| jjjf| | jvr| | j| jjusJd| | j| jjfn=t |}t|||d| |n,t| }t|||dt |}t|||dt| |tdtjd d ||} t| ||d d d | dD}fdd}td|tfd|i}t|| t||d|<t||td|dS)aaGenerate an array of simple objects. :param cls: The class that owns this field :param props: SQLAlchemy Mapper properties :param subname: Field name :param arrser_cust: Array serializer, ie the class itself inside the Array object :param storage: The storage configuration object passed to the store_as rrNrz%s.%s: %r != %rz%r != %rrcidT)rrcss|] }|p dVqdS)rN) capitalize)rxrUrUrV sz$_gen_array_simple..cst||ddS)Nr)setattr)rargschild_right_col_namerUrV_isz_gen_array_simple.._ir)r]rrrrrrrrnextrrrrrrrrdrrr rtr?rsplitobjectrrrr)r`rr arrser_custrrr_gen_colrchild_left_col_typechild_left_col_namechild_right_col_typechild_table_namechild_tchild_left_colchild_right_colcls_namercls_rUrrV_gen_array_simpleps~              r&c Cst||j|j|j|j|jd}t|}|d\|_}|jdus#Jd|j} |j| j vrM| j |jj j } || j |jj j usFJd|| f| j |j} nt|} t ||| d| | |j| j| t|j|j|j|j| g|jd} |jdur|j| d<t|fi| ||<dS)Nrrz'left' is ignored in one-to-many relationships with complex types (because they already have a table). You probably meant to use 'right'.z9Existing column type %r disagrees with new column type %rr)rrrr foreign_keysrr)rrrrrrrr __table__rrrrdr __mapper__ add_propertyrmr}rrrrrrr) r`rrrrrrrcol_typer! new_col_typercr rUrUrV_gen_array_o2msD     r-cCs|jjdkp t|tS)Nr)r] max_occursrqr')rrUrUrV _is_arraysr/cCs|}t|tr |j\}|}|jdur|j}|jdkr&t|||||dSt|tr5t|||||dSt ||||||dS)NF) rqr'rvalues__orig__rr r%r&r-)r`rrrarrrrUrUrV_add_array_to_complexs     r2c Cs2|jdur|}n|j}t|ddrJd|jdusJdt||||j|j|j|j|jd}|j |_|j |j vrJ|j |j }| ddurId|_ n| |t|j|j|j|jd} |jdure|j| d<||jpj|ur{t|\\} } |j | g| d <t|fd|gd | } t||||| ||<|||j <dS) NrFzBStoring a single element-type using a relation table is pointless.z/'right' is ignored in a one-to-one relationshiprr[)rrrrr remote_side)uselistr')r1rrrrrrrrrmrrr[rr}rrrrrrrr) r`rr"rrarrbreal_vrcr  pk_col_name pk_col_typerelrUrUrV_add_simple_type_to_complexsL        r9cCs4t|rt|||||dSt|||||||dSr)r/r2r9r`rr"rrarrrbrUrUrV_add_complex_type_as_tableKs  r;c Csxd|vr |d}n|}||jvr|j|} nt||j|j|j} t|| fi|} | ||<||jvr:|| dSdS)Nrm)rrrroot_tagno_ns pretty_printrr) r`rr"rrarrrbrrctrUrUrV_add_complex_type_as_xmlWs     r@c Csxd|vr |d} n|} | |jvr|j| } nt||j|j|d} t| | fi|} | ||<||jvr:|| dSdS)Nrm)ignore_wrappers complex_asdbt)rrrrArBrr) r`rr"rrarrrbrCrrcr?rUrUrV_add_complex_type_as_jsonjs    rDc Cst|tr t|||||St|jdd}t|jj\}}t|||t|t r2t ||||||||St|t rBt ||||||||St|t rSt||||||||d St|trdt||||||||d St|trmtt|dursdSt|)Nrnr r!)rqrL_add_file_typerr]rNrrdryc_tabler;c_xmlr@rzrDr{ c_msgpackr|rr:rUrUrV_add_complex_type~s4           rIc Csh|jj}|jj}|}t|jj\}}t||gt|j|Ri|}|jD] \}}t |i|q&|Sr) r]rrrNsqla_table_argsr tuplerrr) r`r"rr_table table_args table_kwargsr index_kwargsrUrUrV_convert_fake_tables rPcst|\}}}}tjj\}} | dd} | dur || d<n || || d<| dd} | durJt| ts@|j| | d<n t d| | d=|durR|| d<|t ur[|f|}t g|Ri| } fdd} t d| | S) a Generate SQLAlchemy mapper from Spyne definition data. :param cls: La Class. :param props: Dict of properties for SQLAlchemt'y Mapper call. :param table: A Table instance. Not a `_FakeTable` or anything. :param cls_bases: Sequence of class bases. propertiesNpolymorphic_onz1Deleted invalid 'polymorphic_on' value %r for %r.inheritscsF|j}D]\}}||vr t|rt|trq d||<q dSr)__dict__get_flat_type_infoitemsrrqr()targetcontextdrrr`rUrVon_loadsz_gen_mapper..on_loadload)rrNr]sqla_mapper_argsrrryrrloggerwarningrPrrlisten)r`rr"rrrrr mapper_args mapper_kwargs_propspo cls_mapperr[rUrZrV _gen_mappers.         rfc Cst|jdd}t|jj\}}t|||t|trh||jvr%|j|}n1t|j s,J|j dkr9t |j |j } n|j dkrHt |j |j dd} nt |j t|| fi|}|||<||jvrf||dSdSt |)Nrnr r!)rC)rr]rNrrdryr$rrstore db_formatrrr|rr) r`rr"rrarrrbrcr?rUrUrVrEs$        rEcCsr|j}i}t|}|durt|||||n t|||||||jj}|D]\}}||s6|||q'dS)zAdd field to the given Spyne object also mapped as a SQLAlchemy object to a SQLAlchemy table :param cls: The class to add the column to. :param subname: The column name :param subcls: The column type, a ModelBase subclass. N) r(rrIrr]rrV has_propertyr*)r`rrar" mapper_propsrrrUrUrV add_columns   rkcCsXt|dkr|j|durdS|D]}t|dsq|jj}|dur)||r)dSqdS)NrFr]T)rr1hasattrr]rri)r`rrrrrUrUrV_parent_mapper_has_propertys rmrUc Cslt|}i}|}t|dkr3|djj}|dur"||}n*|jr-||}n|j}nt |jt ||ksEJ||}|D]A\}}t |||rYqNt |} | durt |jdd} | dur}t d||||| fqNt|||||qNt|||||| qNt|trt||}t||||} |jj|_| |j_|_||j_|_|S)z~Return SQLAlchemy table object corresponding to the passed Spyne object. Also maps given class to the returned table. rNrnz#Skipping %s.%s.%s: %r, store_as: %r)r ancestorsrr]rrUrVconcretersetrmrrr^debug get_namespace get_type_namerIrryrrPrfr __tablename__r)rr() r`rr"rjrn anc_mapperfieldsrrr?prerUrUrV gen_sqla_info(sD           rxcCsi}|jr d|d<|jsd|d<d|d<t|jtjr9|jjr*td d|jji|S|jj |d<t|jji|St|jtj tj frJtd i|St|jtjtj tj fr`t|jjfi|St|jtjrtt|jj|jjfi|St|jtrt|d krtd i|StSt|jtrt|d krtd i|StSt|jtvrtt|j}t|d kr|jd i|S|St|jttfr|jj}t|d kr|jd i|S|St|jtr|j}t|d kr|jjd i|S|Std |) z$Map sqlalchemy types to spyne types.TrFr[r min_occursr0 type_namerzHSpyne type was not found. Probably _sq2sp_type_map needs a new entry. %rNrU) rr[ryrrtr&convert_unicoder3enumsrmrvrur2VARCHARlengthNumericr> precisionscalerrr+rr,_sq2sp_type_map customizerrr`rFileData Exception)rcustrrUrUrV_get_spyne_typedsZ         rcCs|jj}|j}t|jj\}}t|dkr#|jD] }t|||j<qn| |d<t ||g|Ri|}|j|j_ |_ ||j_ |_dS)Nrinclude_properties)r]rrrNr]rrrrmkeysrrrtrr))r`r"rrarbrrerUrUrVgen_spyne_infos   rcCsbg}||D]\}}|jjdur$|jjdddr$|||fq t|dkr/t|SdS)z,Return primary key fields of a Spyne object.NrFr)rUrVr]rrrrrK)r`rrrrUrUrVrs r)NN)NNNN)rU) __future__rrlogging getLoggerrRr^rt simplejsonr ImportErroros.pathrinspectrrsqlalchemy.schemarrr r sqlalchemy.dialects.postgresqlr r #sqlalchemy.dialects.postgresql.baser rsqlalchemy.ormrrsqlalchemy.ext.associationproxyrrrAttributeErrorrspyne.store.relational.simplerspyne.store.relational.documentrrrrrrrspyne.store.relational.spatialrspyne.model.enumrspyne.model.complexr spyne.modelrrGrzr!r{r"rFr#rHspyne.model.binaryr$r%r&r'r(r)r*r+r,r-r.r/r0r1r2r3r4r5r6r7r8r9r:r;r<r=r>r?r@rArBrCrDrErFrGrHrIrJrKrLrM spyne.utilrNrPrXrNUMERICrBIGINTINTEGERrSMALLINTr~BOOLEAN TIMESTAMPrrrDATETIMErDATETIMErrsqlalchemy_BINARYrdrrrrrrrrrrr r&r-r/r2r9r;r@rDrIrPrfrErkrmrxrrrrUrUrUrVs                   $                *   *   2&]Y74 3 <A