source: cats/ISOcat/trunk/mod-ISOcat-access-data/access/dc_scope_update.acc @ 2686

<accessor debug="false">
        <name>ISOcat.access.data.dc.scope.update</name>
        <descr>Update the scope of a DC.</descr>
        <param mandatory="true">
                <name>dc</name>
                <descr>the DC key</descr>
                <type canonical="true">string</type>
        </param>
        <param mandatory="true">
                <name>scope</name>
                <descr>the DC scope</descr>
        </param>
        <idoc>
                <seq>
                        <accessor-debug>
                                <instr>
                                        <type>ISOcat.access.data.dc.scope</type>
                                        <dc>var:dc</dc>
                                        <target>ffcpl:/trace/dc_scope_update.old.xml</target>
                                </instr>
                        </accessor-debug>
                        
                        <!-- create the SQL -->
                        <instr>
                                <type>xslt2</type>
                                <operand>var:scope</operand>
                                <operator>
                                        <xsl:stylesheet
                                                version="2.0"
                                                xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                                                >
                                                <xsl:param name="dc"/>
                                                
                                                <xsl:template match="text()"/>
                                                
                                                <xsl:template match="/scope">
                                                        <batch>
                                                                <!-- delete the old scope -->
                                                                <sql>
                                                                        DELETE FROM
                                                                                link_dc_access
                                                                        WHERE
                                                                                dc = <xsl:value-of select="$dc"/>
                                                                        ;
                                                                </sql>
                                                                <!-- insert the new scope -->
                                                                <xsl:for-each select="db/entry">
                                                                        <sql>
                                                                                INSERT INTO
                                                                                        link_dc_access
                                                                                (
                                                                                        dc,
                                                                                        account,
                                                                                        rights
                                                                                )
                                                                                VALUES
                                                                                (
                                                                                        <xsl:value-of select="$dc"/>,
                                                                                        <xsl:value-of select="@acc"/>,
                                                                                        '<xsl:value-of select="@rights"/>'
                                                                                )
                                                                                ;
                                                                        </sql>
                                                                </xsl:for-each>
                                                                <sql>
                                                                        UPDATE
                                                                                core_data_category
                                                                        SET
                                                                                private = <xsl:value-of select="if (public/@rights='r') then ('false') else ('true')"/> 
                                                                        WHERE
                                                                                id = <xsl:value-of select="$dc"/>
                                                                        ;
                                                                </sql>
                                                        </batch>
                                                </xsl:template>
                                        </xsl:stylesheet>
                                </operator>
                                <dc>var:dc</dc>
                                <target>var:sql</target>
                        </instr>
                        <accessor-debug>
                                <instr>
                                        <type>copy</type>
                                        <operand>var:sql</operand>
                                        <target>ffcpl:/trace/dc_scope_update.sql.xml</target>
                                </instr>
                        </accessor-debug>
                        <instr>
                                <type>isocat.sqlBatch</type>
                                <operand>var:sql</operand>
                                <target>var:result</target>
                        </instr>
                        <accessor-debug>
                                <instr>
                                        <type>copy</type>
                                        <operand>var:result</operand>
                                        <target>ffcpl:/trace/dc_scope_update.result.xml</target>
                                </instr>
                        </accessor-debug>

                        <!-- touch the updated DC -->
                        <instr>
                                <type>ISOcat.access.data.dc.touch</type>
                                <dc>var:dc</dc>
                                <target>var:void</target>
                        </instr>
                        
                        <!-- return the updated DC scope -->
                        <instr>
                                <type>ISOcat.access.data.dc.scope</type>
                                <dc>var:dc</dc>
                                <target>this:response</target>
                        </instr>
                        
                        <accessor-debug>
                                <instr>
                                        <type>ISOcat.access.data.dc.scope</type>
                                        <dc>var:dc</dc>
                                        <target>ffcpl:/trace/dc_scope_update.new.xml</target>
                                </instr>
                        </accessor-debug>
                        
                        <instr>
                                <type>xslt2</type>
                                <operand>this:response</operand>
                                <operator>
                                        <xsl:stylesheet
                                                xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
                                                version="2.0"
                                                >
                                                <xsl:template match="/scope">
                                                        <msg>INF: <xsl:value-of select="current-dateTime()"/>: update DC[<xsl:value-of select="@dc"/>][<xsl:value-of select="dc/@name"/> owned by <xsl:value-of select="dc/@owner"/>] scope shared[<xsl:value-of select="exists(shared/account)"/>] public[<xsl:value-of select="public/@rights='r'"/>]</msg> 
                                                </xsl:template>
                                        </xsl:stylesheet>
                                </operator>
                                <target>var:msg</target>
                        </instr>
                        <instr>
                                <type>sloot.log</type>
                                <operand>var:msg</operand>
                        </instr>
                </seq>
        </idoc>
        <exception>
                <debug/>
                <trace>ffcpl:/trace/dc_scope_update.exception.xml</trace>
                <throw/>
        </exception>
        <response>
                <debug>ffcpl:/trace/dc_scope_update.response.xml</debug>
                <mime>application/xml</mime>
        </response>
</accessor>