doc/images/main_template.svg
author Sylvain Thénault <sylvain.thenault@logilab.fr>
Thu, 24 Sep 2015 11:26:11 +0200
changeset 10921 977def81780a
parent 10491 c67bcee93248
permissions -rw-r--r--
[migration] don't handle data deletion anymore on schema changes In most cases when we want to drop some entity/relation type, we don't care whether hooks are called on their deletion. There is even low chances that some hooks still exists, based on an old version of the schema. Last but not least, this is horribly inefficient. So this should be clearly documented and handled by application's programmer if desired. This patch removes unnecessary deletion (because table or column will be later dropped) and reimplements the case of partial deletion (only one relation definition among several, hence the database structure isn't modified) using sql. Only one test regarding deletion of inlined relation def is added as other cases seem to be covered by existing tests. Closes #7023315

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!-- Created with Inkscape (http://www.inkscape.org/) -->
<svg
   xmlns:dc="http://purl.org/dc/elements/1.1/"
   xmlns:cc="http://creativecommons.org/ns#"
   xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
   xmlns:svg="http://www.w3.org/2000/svg"
   xmlns="http://www.w3.org/2000/svg"
   xmlns:sodipodi="http://sodipodi.sourceforge.net/DTD/sodipodi-0.dtd"
   xmlns:inkscape="http://www.inkscape.org/namespaces/inkscape"
   width="1036.6421"
   height="845.07812"
   id="svg2"
   sodipodi:version="0.32"
   inkscape:version="0.46"
   sodipodi:docname="main_template.svg"
   inkscape:output_extension="org.inkscape.output.svg.inkscape"
   version="1.0"
   inkscape:export-filename="/home/auc/cw/doc/book/en/images/main_template.png"
   inkscape:export-xdpi="60.659016"
   inkscape:export-ydpi="60.659016">
  <defs
     id="defs4">
    <inkscape:perspective
       sodipodi:type="inkscape:persp3d"
       inkscape:vp_x="0 : 526.18109 : 1"
       inkscape:vp_y="0 : 1000 : 0"
       inkscape:vp_z="744.09448 : 526.18109 : 1"
       inkscape:persp3d-origin="372.04724 : 350.78739 : 1"
       id="perspective10" />
  </defs>
  <sodipodi:namedview
     id="base"
     pagecolor="#ffffff"
     bordercolor="#666666"
     borderopacity="1.0"
     inkscape:pageopacity="0.0"
     inkscape:pageshadow="2"
     inkscape:zoom="0.80355603"
     inkscape:cx="510.91495"
     inkscape:cy="422.53906"
     inkscape:document-units="px"
     inkscape:current-layer="layer1"
     showgrid="false"
     inkscape:window-width="925"
     inkscape:window-height="1168"
     inkscape:window-x="0"
     inkscape:window-y="0"
     inkscape:snap-bbox="true" />
  <metadata
     id="metadata7">
    <rdf:RDF>
      <cc:Work
         rdf:about="">
        <dc:format>image/svg+xml</dc:format>
        <dc:type
           rdf:resource="http://purl.org/dc/dcmitype/StillImage" />
      </cc:Work>
    </rdf:RDF>
  </metadata>
  <g
     inkscape:label="Calque 1"
     inkscape:groupmode="layer"
     id="layer1"
     transform="translate(162.2968,90.697922)">
    <rect
       style="fill:#ffffff;fill-rule:evenodd;stroke:#000000;stroke-width:1.775;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="rect2439"
       width="854.37006"
       height="698.2019"
       x="20.307629"
       y="-20.575344" />
    <rect
       style="fill:#ffffff;fill-rule:evenodd;stroke:#000000;stroke-width:1.775;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="rect3301"
       width="816.3457"
       height="508.15628"
       x="31.751091"
       y="96.33345" />
    <g
       id="g3220"
       transform="matrix(1.0035394,0,0,1,0.5745006,0)">
      <rect
         y="-89.447922"
         x="-161.0468"
         height="55.714287"
         width="1031.1713"
         id="rect3240"
         style="fill:#dfdfdf;fill-opacity:1;fill-rule:evenodd;stroke:#000000;stroke-width:2.50000024;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1" />
      <text
         id="text3264"
         y="-51.771908"
         x="757.85767"
         style="font-size:23.38711166px;font-style:normal;font-weight:normal;fill:#000000;fill-opacity:1;stroke:none;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;font-family:Bitstream Vera Sans"
         xml:space="preserve"><tspan
           id="tspan3266"
           y="-51.771908"
           x="757.85767"
           sodipodi:role="line">header</tspan></text>
    </g>
    <rect
       style="fill:#dfdfdf;fill-opacity:1;fill-rule:evenodd;stroke:#000000;stroke-width:1.775;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
       id="rect3270"
       width="167.87744"
       height="707.71222"
       x="-160.02441"
       y="-24.671618" />
    <g
       id="g2434"
       transform="matrix(0.975467,0,0,1,0.6942419,-3.6587365)">
      <rect
         y="35.365849"
         x="29.548275"
         height="55.714287"
         width="842.59979"
         id="rect3279"
         style="fill:#dfdfdf;fill-opacity:1;fill-rule:evenodd;stroke:#000000;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1" />
      <text
         id="text3281"
         y="72.885193"
         x="681.65283"
         style="font-size:23.38711166px;font-style:normal;font-weight:normal;fill:#000000;fill-opacity:1;stroke:none;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;font-family:Bitstream Vera Sans"
         xml:space="preserve"><tspan
           id="tspan3283"
           y="72.885193"
           x="681.65283"
           sodipodi:role="line">contentheader</tspan></text>
    </g>
    <g
       id="g3170"
       transform="matrix(1.0023324,0,0,1,-2.0421673,-10.976211)">
      <rect
         y="698.6355"
         x="-158.28485"
         height="55.714287"
         width="1032.5997"
         id="rect3285"
         style="fill:#dfdfdf;fill-opacity:1;fill-rule:evenodd;stroke:#000000;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1" />
      <text
         id="text3287"
         y="736.52045"
         x="770.28204"
         style="font-size:23.38711166px;font-style:normal;font-weight:normal;fill:#000000;fill-opacity:1;stroke:none;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;font-family:Bitstream Vera Sans"
         xml:space="preserve"><tspan
           id="tspan3289"
           y="736.52045"
           x="770.28204"
           sodipodi:role="line">footer</tspan></text>
    </g>
    <g
       id="g3211" />
    <g
       id="g3215"
       transform="matrix(0.9712065,0,0,1,0.7659296,-17.074106)">
      <rect
         style="fill:#dfdfdf;fill-opacity:1;fill-rule:evenodd;stroke:#000000;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1"
         id="rect3291"
         width="844.62012"
         height="55.714287"
         x="27.850754"
         y="629.88562" />
      <text
         id="text3293"
         y="666.60339"
         x="692.85773"
         style="font-size:23.38711166px;font-style:normal;font-weight:normal;fill:#000000;fill-opacity:1;stroke:none;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;font-family:Bitstream Vera Sans"
         xml:space="preserve"><tspan
           id="tspan3295"
           y="666.60339"
           x="692.85773"
           sodipodi:role="line">contentfooter</tspan></text>
    </g>
    <text
       xml:space="preserve"
       style="font-size:23.38711166px;font-style:normal;font-variant:normal;font-weight:normal;font-stretch:normal;text-align:start;line-height:125%;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;font-family:Bitstream Vera Sans;-inkscape-font-specification:Bitstream Vera Sans"
       x="-143.67273"
       y="20.58094"
       id="text3297"
       sodipodi:linespacing="125%"><tspan
         sodipodi:role="line"
         id="tspan2432"
         x="-143.67273"
         y="20.58094">left column</tspan></text>
    <text
       transform="scale(0.9876573,1.0124969)"
       id="text3175"
       y="12.071429"
       x="721.0575"
       style="font-size:23.09845161px;font-style:normal;font-weight:normal;fill:#000000;fill-opacity:1;stroke:none;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;font-family:Bitstream Vera Sans"
       xml:space="preserve"><tspan
         id="tspan3177"
         y="12.071429"
         x="721.0575"
         sodipodi:role="line">contentcol</tspan></text>
    <text
       transform="scale(0.9876573,1.0124969)"
       id="text3179"
       y="126.27104"
       x="701.45959"
       style="font-size:23.09845161px;font-style:normal;font-weight:normal;fill:#000000;fill-opacity:1;stroke:none;stroke-width:2.5;stroke-linecap:butt;stroke-linejoin:miter;stroke-miterlimit:4;stroke-dasharray:none;stroke-opacity:1;font-family:Bitstream Vera Sans"
       xml:space="preserve"><tspan
         id="tspan3181"
         y="126.27104"
         x="701.45959"
         sodipodi:role="line">contentmain</tspan></text>
  </g>
</svg>