Re: ADQL/x v1.0 to SQL string XSLT files

From: Maria A. Nieto-Santisteban <nieto-at-skysrv.pha.jhu.edu>
Date: Tue, 20 Sep 2005 13:32:07 -0400 (EDT)


Hi Aurelien,

Just reviewed your xslt to convert ADQL/x into SQL (nice job!) and I realized there is no elements to define JOIN clauses.

http://www.ivoa.net/xml/ADQL/v1.0 includes JOINS.

+ <xs:simpleType name="jointTableQualifierType">
- <xs:annotation>
  <xs:documentation>Denotes the type of a Join 
operation</xs:documentation>
  </xs:annotation>
- <xs:restriction base="xs:string">
  <xs:enumeration value="LEFT_OUTER" /> 
  <xs:enumeration value="RIGHT_OUTER" /> 
  <xs:enumeration value="FULL_OUTER" /> 
  <xs:enumeration value="INNER" /> 
  <xs:enumeration value="CROSS" /> 
  </xs:restriction>
  </xs:simpleType>
+ <xs:complexType name="joinTableType" mixed="false">


Is the lack of JOIN element intended?

Thanks

Maria

On Thu, 11 Aug 2005, Aurelien Stebe wrote:

> Hi all,
>
> I created XSLT files to convert ADQL/x to SQL both supporting the full
> schema
> and only the part needed for the registry.
> Those files should work for ADQL v1.0, but should also work just as fine
> for v0.9 and v0.8,
> just by changing the namespace declaration.
> I thought they might interest some of you.
>
> I didn't implement the XMatch or the CircleRegion as those are specific
> to your datamodels.
> Please contact me for any problem or question.
>
> I'll try to upload these files on the IVOA twiki soon.
>
> Cheers,
> Aurelien STEBE
>

-- 
------------------------------------------------
Maria A. Nieto-Santisteban (nieto-at-pha.jhu.edu)
Johns Hopkins University
3400 N. Charles St.
Physics & Astronomy Department
Baltimore, MD 21218 (USA)

Tel: 	1 410 516-7679  Fax: 	1 410 516-5096
Received on 2005-09-20Z19:32:51