Ñò (ËÅPc @sßdZddklZddklZlZlZddklZddk l Z l Z l Z l Z ddklZddkZeidƒZd dd „ƒYZd dd „ƒYZd dd„ƒYZddd„ƒYZdS(s> TABLE-TREE MODULE for DB table-structure representation ************************** *** TABLE-TREE MODULE *** for *** DB table-structure *** representation ************************** $RCSfile: tablegraph.py,v $ $Revision: 1248 $ $Author: j.holetschek $ $Date: 2012-12-10 12:44:40 +0100 (Mo, 10. Dez 2012) $ Class representing a database structure in the form of a graph-tree. It knows about the tables, their relations. The function "getJoinTableList" returns a list of tables and their relation defined by a relationObject to produce dynamic joins of tables. iÿÿÿÿ(tjoin(ttreetgraphtCircleExistingError(tColNotExistingError(tCMFErrortMissingRootTableErrortTableConfigErrortTableConfigCircleError(t intersectsNspywrapper.graphtforeignKeyClasscBs2eZdZd„Zd„Zd„Zd„ZRS(sUClass to store all data about a foreign key potentially including several attributes.cCsd|_g|_dS(N(tNonettargettattrList(tself((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyt__init__"s cCs|ii|ƒdS(N(R tappend(Rt dbAttrObj((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pytaddKey&scCs*t|iƒdjo |idSdSdS(Niiÿÿÿÿ(tlenR R (R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyt getLastKey)s cCsd|it|iƒfS(Ns&(ForeignKeyObject: target=%s, attr=%s)(R tstrR (R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyt__repr__/s(t__name__t __module__t__doc__RRRR(((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyR s    ttableAliasClasscBs8eZdZd„Zdgd„Zd„Zd„ZRS(sñThis class holds all information regarding one table in a DB. self.alias = aliasname or None self.table = tablename or None self.pk = pks, list of DBAttrObjs self.fks = fks, list of foreignKeyClass objects cCs(d|_d|_g|_g|_dS(N(R taliasttabletpktfks(R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyR:s   cCs/tƒ}||_||_|ii|ƒdS(N(R R R RR(RR t DBAttrObjListtfkObj((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pytaddFK@s   cCs*t|iƒdjo |idSdSdS(Niiÿÿÿÿ(RRR (R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyt getLastFkFs cCs,d|i|it|iƒt|iƒfS(Ns6(TableAliasObject: alias=%s, table=%s, pks=%s, fks=%s)(RRRRR(R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyRLsN(RRRRR R!R"R(((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyR3s   ttableGraphClasscBsªeZdZd„Zd„Zd„Zd„Zd„Zd„Zd„Z d„Z d „Z d „Z d „Z d „Zd „Zd„Zgd„Zd„Zd„ZRS(sSThis class holds the table structure of a DB in a easy usable way to create dynamic SQL. It relies on one root table that is not defined in the table configuration, but in every CMF file. The DB structure is represented as a tree, with list of lists whereby a single table is a tuple made of 3 values: [0]=table-alias name, [1]=list of child tuples, [2]=LOP/COP object defining the relation to the parental tuple (for building joins). If the DB table structure is a closed graph, different spanning trees are possible and an error is produced, as no circle relations are allowed in the DB setup.cCsd|_h|_h|_dS(N(R Rtalias2tableObjtalias2tablename(R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyRWs  cCs dt|iƒt|iƒfS(s8return simple string output of the object and the graph.sGRAPH: %s +++ ALIAS2TABLE: %s(RRR%(R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pyR_scCsH|iiƒ}|iƒg}x"|D]}|i|i|ƒq&W|S(s2Returns a list of all table alias objects or None.(R$tkeystsortR(Rtaliasestretlistta((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pytgetTableAliasListds cCs|ii|dƒS(s9Returns the table alias object for a given alias or None.N(R$tgetR (RR((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pytgetTableAliasObjnscCs |iiƒS(s Returns all table alias objects.(R$tvalues(R((sH/srv/www/vhosts/sammlung/BioCase/lib/biocase/wrapper/graph/tablegraph.pytgetTableAliasObjectssscCs4h}x'|iiƒD]}|i||is" !Å