Project

General

Custom queries

Profile

Actions

Feature #5104

closed

create SQLSkeletonTemplate.xsl

Added by Reynaud Sylvain almost 12 years ago. Updated over 11 years ago.

Status:
Resolved
Priority:
Low
Assigned To:
Category:
Adaptors
Target version:
-
Start date:
09/19/2013
Due date:
% Done:

100%

Estimated time:

Description

This template will convert foreign keys description to a skeleton of the virtual XML document.

Example with root <dept:course>:

<dept:course>
    <dept:dno/>
    <course:cno>
        <teaching:teaching>
            <teaching:professor>
                <professor:pno/>
                <professor:pname/>
            </teaching:professor>
        </teaching:teaching>
        <prereq:course>
            <prereq:prereq>
                <course:cno/>
                <course:title/>
                <course:time/>
                <course:taughtBy/>
            </prereq:prereq>
            <course:cno/>
            <course:title/>
            <course:time/>
            <course:taughtBy/>
        </prereq:course>
        <prereq:prereq>
            <prereq:course>
                <course:cno/>
                <course:title/>
                <course:time/>
                <course:taughtBy/>
            </prereq:course>
            <course:cno/>
            <course:title/>
            <course:time/>
            <course:taughtBy/>
        </prereq:prereq>
    </course:cno>
    <course:title/>
    <course:time/>
    <course:taughtBy>
        <professor:pno>
            <teaching:professor>
                <teaching:teaching/>
            </teaching:professor>
        </professor:pno>
        <professor:pname/>
    </course:taughtBy>
</dept:course>

Actions #1

Updated by Reynaud Sylvain over 11 years ago

  • Status changed from New to Resolved
  • Assigned To set to Reynaud Sylvain
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF