xsd schemas - how to...

[Sergey Poberezovskiy]

Hi,

I have to specify that a person needs to have at least one out of three
phone elements:

<Phone type="home"/>,
<Phone type="work"/>,
<Phone type="mobile"/>,

Can anyone please suggest how to define xsd schema to enforce such a rule
(note that one type cannot be specified more than once).

Thanks in advance,

Sergey

[Martin Honnen]

Sergey Poberezovskiy wrote:

I have to specify that a person needs to have at least one out of three
phone elements:

<Phone type="home"/>,
<Phone type="work"/>,
<Phone type="mobile"/>,

The schema below defines a simple type enumerating the possible phone
types and then defines other elements.

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema
xmlns:xs="http://www.w3.org/2001/XMLSchema"
version="1.0">

<xs:simpleType name="phoneType">
<xs:restriction base="xs:string">
<xs:enumeration value="home" />
<xs:enumeration value="work" />
<xs:enumeration value="mobile" />
</xs:restriction>
</xs:simpleType>

<xs:element name="Persons">
<xs:complexType>
<xs:sequence>
<xs:element name="Person" type="PersonType"
maxOccurs="unbounded" />
</xs:sequence>
</xs:complexType>
</xs:element>

<xs:complexType name="PersonType">
<xs:sequence>
<xs:element name="Name" type="xs:string" />
<xs:element name="Phone-Numbers">
<xs:complexType>
<xs:sequence>
<xs:element name="Phone" maxOccurs="10">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="phoneType" />
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>

</xs:schema>

An example document is

<?xml version="1.0" encoding="UTF-8"?>
<Persons
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="test2005102401Xsd.x ml">
<Person>
<Name>Prename1 Surname1</Name>
<Phone-Numbers>
<Phone type="home">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename2 Surname2</Name>
<Phone-Numbers>
<Phone type="work">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename3 Surname3</Name>
<Phone-Numbers>
<Phone type="mobile">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename4 Surname4</Name>
<Phone-Numbers>
</Phone-Numbers>
</Person>
</Persons>

were a validating parser will flag the Phone-Numbers element in the last
Person element as an error as it needs to have at least one Phone child
element.

I don't know how many phone numbers you want to store for one person,
the schema above allows 1 to 10 as an example.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Sergey Poberezovskiy]

Martin,

As in previous post I need all three phones to be different (cannot have
more than one home, for example) with at least one specified.
"Martin Honnen" wrote:

Sergey Poberezovskiy wrote:

I have to specify that a person needs to have at least one out of three
phone elements:

<Phone type="home"/>,
<Phone type="work"/>,
<Phone type="mobile"/>,

The schema below defines a simple type enumerating the possible phone
types and then defines other elements.

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema
xmlns:xs="http://www.w3.org/2001/XMLSchema"
version="1.0">

<xs:simpleType name="phoneType">
<xs:restriction base="xs:string">
<xs:enumeration value="home" />
<xs:enumeration value="work" />
<xs:enumeration value="mobile" />
</xs:restriction>
</xs:simpleType>

<xs:element name="Persons">
<xs:complexType>
<xs:sequence>
<xs:element name="Person" type="PersonType"
maxOccurs="unbounded" />
</xs:sequence>
</xs:complexType>
</xs:element>

<xs:complexType name="PersonType">
<xs:sequence>
<xs:element name="Name" type="xs:string" />
<xs:element name="Phone-Numbers">
<xs:complexType>
<xs:sequence>
<xs:element name="Phone" maxOccurs="10">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="phoneType" />
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>

</xs:schema>

An example document is

<?xml version="1.0" encoding="UTF-8"?>
<Persons
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="test2005102401Xsd.x ml">
<Person>
<Name>Prename1 Surname1</Name>
<Phone-Numbers>
<Phone type="home">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename2 Surname2</Name>
<Phone-Numbers>
<Phone type="work">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename3 Surname3</Name>
<Phone-Numbers>
<Phone type="mobile">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename4 Surname4</Name>
<Phone-Numbers>
</Phone-Numbers>
</Person>
</Persons>

were a validating parser will flag the Phone-Numbers element in the last
Person element as an error as it needs to have at least one Phone child
element.

I don't know how many phone numbers you want to store for one person,
the schema above allows 1 to 10 as an example.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Stan Kitsis [MSFT]]

You need to use uniqueness constraint for that. Below is an example:

<xs:schema targetNamespace="http://myNS"
elementFormDefault="qualified"
xmlns="http://myNS"
xmlns:p="http://myNS"
xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:simpleType name="phoneType">
<xs:restriction base="xs:string">
<xs:enumeration value="home" />
<xs:enumeration value="work" />
<xs:enumeration value="mobile" />
</xs:restriction>
</xs:simpleType>

<xs:complexType name="phone">
<xs:attribute name="type" type="phoneType" use="required"/>
</xs:complexType>

<xs:element name="phoneNumbers">
<xs:complexType>
<xs:sequence>
<xs:element name="Phone" type="phone" minOccurs="1" maxOccurs="3"/>
</xs:sequence>
</xs:complexType>
<xs:unique name="phoneTypes">
<xs:selector xpath="p:Phone"/>
<xs:field xpath="@type"/>
</xs:unique>
</xs:element>
</xs:schema>

--
Stan Kitsis
Program Manager, XML Technologies
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sergey Poberezovskiy" <Se*****************@discussions.microsoft.com> wrote
in message news:5B**********************************@microsof t.com...

Hi,

I have to specify that a person needs to have at least one out of three
phone elements:

<Phone type="home"/>,
<Phone type="work"/>,
<Phone type="mobile"/>,

Can anyone please suggest how to define xsd schema to enforce such a rule
(note that one type cannot be specified more than once).

Thanks in advance,

Sergey

[Zafar Abbas]

You can make use of xs:unique constraint here. Make the Person your context
node, and put the unique constraint on the @type attribute so that no values
are repeated under <Person>

"Sergey Poberezovskiy" <Se*****************@discussions.microsoft.com> wrote
in message news:B0**********************************@microsof t.com...

Martin,

As in previous post I need all three phones to be different (cannot have
more than one home, for example) with at least one specified.
"Martin Honnen" wrote:

Sergey Poberezovskiy wrote:

I have to specify that a person needs to have at least one out of three phone elements:

<Phone type="home"/>,
<Phone type="work"/>,
<Phone type="mobile"/>,

The schema below defines a simple type enumerating the possible phone
types and then defines other elements.

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema
xmlns:xs="http://www.w3.org/2001/XMLSchema"
version="1.0">

<xs:simpleType name="phoneType">
<xs:restriction base="xs:string">
<xs:enumeration value="home" />
<xs:enumeration value="work" />
<xs:enumeration value="mobile" />
</xs:restriction>
</xs:simpleType>

<xs:element name="Persons">
<xs:complexType>
<xs:sequence>
<xs:element name="Person" type="PersonType"
maxOccurs="unbounded" />
</xs:sequence>
</xs:complexType>
</xs:element>

<xs:complexType name="PersonType">
<xs:sequence>
<xs:element name="Name" type="xs:string" />
<xs:element name="Phone-Numbers">
<xs:complexType>
<xs:sequence>
<xs:element name="Phone" maxOccurs="10">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="type" type="phoneType" />
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>

</xs:schema>

An example document is

<?xml version="1.0" encoding="UTF-8"?>
<Persons
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="test2005102401Xsd.x ml">
<Person>
<Name>Prename1 Surname1</Name>
<Phone-Numbers>
<Phone type="home">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename2 Surname2</Name>
<Phone-Numbers>
<Phone type="work">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename3 Surname3</Name>
<Phone-Numbers>
<Phone type="mobile">12345</Phone>
</Phone-Numbers>
</Person>
<Person>
<Name>Prename4 Surname4</Name>
<Phone-Numbers>
</Phone-Numbers>
</Person>
</Persons>

were a validating parser will flag the Phone-Numbers element in the last
Person element as an error as it needs to have at least one Phone child
element.

I don't know how many phone numbers you want to store for one person,
the schema above allows 1 to 10 as an example.

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/

[Sergey Poberezovskiy]

Stan and Zafar,

Thanks a lot for your response.

If you could please answer the question from the previous post - that would
be terrific:

I have to specify that at least one out of two elements must exist (both is
fine), but no more than one of each - silimar to the example in this code. I
have come up with a schema that seems to enforce these rules - the only
problem is that I cannot validate against it in .Net - when both elements are
specified - the validation fails. Please see my previous post for more info.
"Stan Kitsis [MSFT]" wrote:

You need to use uniqueness constraint for that. Below is an example:

<xs:schema targetNamespace="http://myNS"
elementFormDefault="qualified"
xmlns="http://myNS"
xmlns:p="http://myNS"
xmlns:xs="http://www.w3.org/2001/XMLSchema">

<xs:simpleType name="phoneType">
<xs:restriction base="xs:string">
<xs:enumeration value="home" />
<xs:enumeration value="work" />
<xs:enumeration value="mobile" />
</xs:restriction>
</xs:simpleType>

<xs:complexType name="phone">
<xs:attribute name="type" type="phoneType" use="required"/>
</xs:complexType>

<xs:element name="phoneNumbers">
<xs:complexType>
<xs:sequence>
<xs:element name="Phone" type="phone" minOccurs="1" maxOccurs="3"/>
</xs:sequence>
</xs:complexType>
<xs:unique name="phoneTypes">
<xs:selector xpath="p:Phone"/>
<xs:field xpath="@type"/>
</xs:unique>
</xs:element>
</xs:schema>

--
Stan Kitsis
Program Manager, XML Technologies
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sergey Poberezovskiy" <Se*****************@discussions.microsoft.com> wrote
in message news:5B**********************************@microsof t.com...

Hi,

I have to specify that a person needs to have at least one out of three
phone elements:

<Phone type="home"/>,
<Phone type="work"/>,
<Phone type="mobile"/>,

Can anyone please suggest how to define xsd schema to enforce such a rule
(note that one type cannot be specified more than once).

Thanks in advance,

Sergey