Project

General

Profile

Download (4.33 KB) Statistics
| Revision:

metacat/xmldbms/samples/sales.map @ 109

1 
<?xml version="1.0" ?>
2 
<!DOCTYPE XMLToDBMS SYSTEM "../xmldbms.dtd">
3 
<XMLToDBMS Version="1.0">
4 
   <Options>
5 
      <DateTimeFormats>
6 
         <Patterns Timestamp="MM.dd.yy"/>
7 
      </DateTimeFormats>
8 
   </Options>
9 
   <Maps>
10 
      <IgnoreRoot>
11 
         <ElementType Name="Orders"/>
12 
         <PseudoRoot>
13 
            <ElementType Name="SalesOrder"/>
14 
            <CandidateKey Generate="No">
15 
               <Column Name="Number"/>
16 
            </CandidateKey>
17 
         </PseudoRoot>
18 
      </IgnoreRoot>
19 
      <ClassMap>
20 
         <ElementType Name="Customer"/>
21 
         <ToClassTable>
22 
            <Table Name="Customers"/>
23 
         </ToClassTable>
24 
         <PropertyMap>
25 
            <Attribute Name="CustNumber"/>
26 
            <ToColumn>
27 
               <Column Name="Number"/>
28 
            </ToColumn>
29 
         </PropertyMap>
30 
         <PropertyMap>
31 
            <ElementType Name="CustName"/>
32 
            <ToColumn>
33 
               <Column Name="Name"/>
34 
            </ToColumn>
35 
         </PropertyMap>
36 
         <PropertyMap>
37 
            <ElementType Name="PostCode"/>
38 
            <ToColumn>
39 
               <Column Name="PostalCode"/>
40 
            </ToColumn>
41 
         </PropertyMap>
42 
         <PropertyMap>
43 
            <ElementType Name="Street"/>
44 
            <ToColumn>
45 
               <Column Name="Street"/>
46 
            </ToColumn>
47 
         </PropertyMap>
48 
         <PropertyMap>
49 
            <ElementType Name="City"/>
50 
            <ToColumn>
51 
               <Column Name="City"/>
52 
            </ToColumn>
53 
         </PropertyMap>
54 
         <PropertyMap>
55 
            <ElementType Name="State"/>
56 
            <ToColumn>
57 
               <Column Name="State"/>
58 
            </ToColumn>
59 
         </PropertyMap>
60 
      </ClassMap>
61 
      <ClassMap>
62 
         <ElementType Name="SalesOrder"/>
63 
         <ToClassTable>
64 
            <Table Name="Sales"/>
65 
         </ToClassTable>
66 
         <PropertyMap>
67 
            <Attribute Name="SONumber"/>
68 
            <ToColumn>
69 
               <Column Name="Number"/>
70 
            </ToColumn>
71 
         </PropertyMap>
72 
         <PropertyMap>
73 
            <ElementType Name="OrderDate"/>
74 
            <ToColumn>
75 
               <Column Name="Date"/>
76 
            </ToColumn>
77 
         </PropertyMap>
78 
         <RelatedClass KeyInParentTable="Candidate">
79 
            <ElementType Name="Line"/>
80 
            <CandidateKey Generate="No">
81 
               <Column Name="Number"/>
82 
            </CandidateKey>
83 
            <ForeignKey>
84 
               <Column Name="SONumber"/>
85 
            </ForeignKey>
86 
            <OrderColumn Name="Number" Generate="No"/>
87 
         </RelatedClass>
88 
         <RelatedClass KeyInParentTable="Foreign">
89 
            <ElementType Name="Customer"/>
90 
            <CandidateKey Generate="No">
91 
               <Column Name="Number"/>
92 
            </CandidateKey>
93 
            <ForeignKey>
94 
               <Column Name="CustNumber"/>
95 
            </ForeignKey>
96 
         </RelatedClass>
97 
      </ClassMap>
98 
      <ClassMap>
99 
         <ElementType Name="Part"/>
100 
         <ToClassTable>
101 
            <Table Name="Parts"/>
102 
         </ToClassTable>
103 
         <PropertyMap>
104 
            <Attribute Name="PartNumber"/>
105 
            <ToColumn>
106 
               <Column Name="Number"/>
107 
            </ToColumn>
108 
         </PropertyMap>
109 
         <PropertyMap>
110 
            <ElementType Name="Description"/>
111 
            <ToColumn>
112 
               <Column Name="Description"/>
113 
            </ToColumn>
114 
         </PropertyMap>
115 
         <PropertyMap>
116 
            <ElementType Name="Price"/>
117 
            <ToColumn>
118 
               <Column Name="Price"/>
119 
            </ToColumn>
120 
         </PropertyMap>
121 
      </ClassMap>
122 
      <ClassMap>
123 
         <ElementType Name="Line"/>
124 
         <ToClassTable>
125 
            <Table Name="Lines"/>
126 
         </ToClassTable>
127 
         <PropertyMap>
128 
            <Attribute Name="LineNumber"/>
129 
            <ToColumn>
130 
               <Column Name="Number"/>
131 
            </ToColumn>
132 
         </PropertyMap>
133 
         <PropertyMap>
134 
            <ElementType Name="Quantity"/>
135 
            <ToColumn>
136 
               <Column Name="Quantity"/>
137 
            </ToColumn>
138 
         </PropertyMap>
139 
         <RelatedClass KeyInParentTable="Foreign">
140 
            <ElementType Name="Part"/>
141 
            <CandidateKey Generate="No">
142 
               <Column Name="Number"/>
143 
            </CandidateKey>
144 
            <ForeignKey>
145 
               <Column Name="Part"/>
146 
            </ForeignKey>
147 
         </RelatedClass>
148 
      </ClassMap>
149 
   </Maps>
150 
</XMLToDBMS>
151 

    		
  









  (13-13/14)