se/SE/schema/default_db_xml_cache/mysl_xml_to_mysql.xsl

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
    xmlns:system_cache__procesy5_xsd_business_objects="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/procesy5_xsd_business_objects.xsd"
    exclude-result-prefixes="xs system_cache__procesy5_xsd_business_objects"
    version="2.0">
    
    <xsl:output method="xml"  indent="yes" exclude-result-prefixes="system_cache__procesy5_xsd_business_objects"/>
    
    <xsl:template match="system_cache__procesy5_xsd_business_objects:resource" >
        
        Insert into CRM_LISTA_ZASOBOW ( `ID`,`PARENT_ID`,`TYPE`,`ALIAS_ID`,`DESC`, `OPIS`) values 
            ('<xsl:value-of select="system_cache__procesy5_xsd_business_objects:path"></xsl:value-of>',
             '<xsl:value-of select="system_cache__procesy5_xsd_business_objects:resource_parent_id"/>'
            
        
            
        
            <xsl:for-each select="system_cache__procesy5_xsd_business_objects:resource_type/child::node()">
                 <xsl:if test="name()">
                  ,'<xsl:value-of select="replace(name(),'system_cache__procesy5_xsd_business_objects:','')"/>'
                     
                     <xsl:choose>
                         <xsl:when test="system_cache__procesy5_xsd_business_objects:alias_id">
                             ,'<xsl:value-of select="system_cache__procesy5_xsd_business_objects:alias_id"/>'
                         </xsl:when>
                         <xsl:otherwise>
                             ,''  
                         </xsl:otherwise>
                     </xsl:choose>
                     ,'<xsl:value-of select="replace(name(),'system_cache__procesy5_xsd_business_objects:','')"/>'
                 </xsl:if>
                  
              </xsl:for-each>
            
              ,'<xsl:value-of select="system_cache__procesy5_xsd_business_objects:annotation_documentation"/>');
            
            
        
        
        
        
       
    </xsl:template>
    
</xsl:stylesheet>