Re: ADQL/x schema, SkyNode WSDL

From: Yuji SHIRASAKI <yuji.shirasaki-at-nao.ac.jp>
Date: Thu, 13 Jul 2006 00:37:27 +0900 (JST)

Hi Ray and All,

I have uploaded updated schema at:

  http://www.ivoa.net/internal/IVOA/IvoaVOQL/ADQ-Core-v0.2.xsd   http://www.ivoa.net/internal/IVOA/IvoaVOQL/ADQL-v1.05.xsd

At least these files are successfully compiled by JAXB. I think all the troubles seen in v1.0 are now fixed.

I am preparing a WSDL file too. That will be dstriubted next week.

Here is a sample ADQL:

SELECT t.c2 AS alias, t."123"
FROM galaxy AS t
WHERE t.c1 = 'test" AND t.c1 NOT LIKE 'test%'

       AND t.c1 BETWEEN 10 AND 20 
       AND t.c1 IN (10, 20)
       AND REGION('FK5-GEO-SPH 120 30 1.0')

<Select xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ns1="http://www.ivoa.net/xml/ADQL/v1.04" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:stc="http://www.ivoa.net/xml/STC/stc-v1.30.xsd" xmlns="http://www.ivoa.net/xml/ADQL-Core/v0.2">

    <SelectionList xsi:type="selectionListCoreType">

        <Item xsi:type="aliasSelectionItemCoreType" As="alias">
            <Column Name="c2" Table="t"/>
        </Item>
        <Item xsi:type="aliasSelectionItemCoreType">
            <Column Name="123" Table="t" Delimited="true"/>
        </Item>

    </SelectionList>
    <From>

        <Table xsi:type="tableType" Alias="t" Name="galaxy"/>     </From>
    <Where>

        <Condition xsi:type="unionSearchType">
            <Condition xsi:type="unionSearchType">
                <Condition xsi:type="unionSearchType">


                    <Condition xsi:type="unionSearchType">

                        <Condition xsi:type="comparisonPredType" Comparison="=">
                            <Arg xsi:type="columnReferenceType" Name="c1" Table="t"/>
                            <Arg xsi:type="nonNumericType" value="test"/>
                        </Condition>
                        <Condition xsi:type="likePredType" not="true">
                            <Arg xsi:type="columnReferenceType" Name="c1" Table="t"/>
                            <Pattern value="test%"/>
                        </Condition>


                    </Condition>

                    <Condition xsi:type="betweenPredType">

                        <Arg xsi:type="columnReferenceType"  Name="c1" Table="t"/>
                        <Arg xsi:type="integerType" value="10"/>
                        <Arg xsi:type="integerType" value="20"/>


                    </Condition>

                </Condition>
                <Condition xsi:type="inclusiveSearchType">


                    <Arg xsi:type="columnReferenceType" Name="c1" Table="t"/>

                    <Set xsi:type="constantListSet">

                        <Item xsi:type="integerType" value="10"/>
                        <Item xsi:type="integerType" value="20"/>


                    </Set>

                </Condition>
            </Condition>
            <Condition xsi:type="regionSearchCoreType">
                <Frame>


                    <stc:FK5/>

                    <stc:GEOCENTER/>

                    <stc:SPHERICAL/>

                </Frame>
                <Circle>


                    <Center>

                        <C1>120.0</C1>
                        <C2>30.0</C2>


                    </Center>

                    <Radius>1.0</Radius>

                </Circle>
            </Condition>
        </Condition>

    </Where>
</Select>

Yuji Shirasaki

From: Ray Plante <rplante-at-ncsa.uiuc.edu> Subject: ADQL/x schema, SkyNode WSDL
Date: Tue, 11 Jul 2006 16:13:44 -0500 (CDT)

> Hey Yuji,
> 
> Is the ADQL-v1.0.xsd file that is available via 
> http://www.ivoa.net/xml/ADQL/v1.0 up to date with the document you 
> released this week (v1.05)?  
> 
> In any event, I'm having some trouble validating my ADQL/x examples with 
> that version...
> 
>   o  in line 308, the "Alias" attribute definition should have 
>        use="required", not use="alias".  
> 
>   o  the imported STC schema (v1.10) has some trouble validating 
>        with Xerces because a well-known Schema bug.  I recommend we use 
>        v1.30 which gets around this problem.  
> 
> One a similar note, is there a version of the SkyNode WSDL that today's WD 
> corresponds to?  I'm curious to see how you handle the ADQL version issue.  
> 
> thanks,
> Ray
> 
> 
> 
> 
> 

Received on 2006-07-12Z17:41:16