firethorn

changeset 4297:1cca1fc1f694 2.1.35-stv-issue-1182

Added an additional test for a datetime column query
author Stelios <stv@roe.ac.uk>
date Thu Mar 12 22:49:32 2020 +0200 (11 months ago)
parents d54e9c2efbe9
children 2840ac7384f9
files doc/notes/stv/20200312-Testing-1182.txt
line diff
     1.1 --- a/doc/notes/stv/20200312-Testing-1182.txt	Thu Mar 12 22:28:48 2020 +0200
     1.2 +++ b/doc/notes/stv/20200312-Testing-1182.txt	Thu Mar 12 22:49:32 2020 +0200
     1.3 @@ -554,3 +554,44 @@
     1.4  
     1.5  ## Query completed, but empty table
     1.6  
     1.7 +
     1.8 +
     1.9 +## Test5: Check a query on a field of type: datetime
    1.10 +## ---------------------------------------------------------------------------------------
    1.11 +
    1.12 +## Testing Column: ATLASDR1.Multiframe.creationDate
    1.13 +## Column type: "DATETIME"
    1.14 +
    1.15 +curl -L "http://localhost:8080/firethorn/tap/39559/sync?QUERY=SELECT+TOP+5+creationDate+FROM+ATLASDR1.Multiframe&REQUEST=doQuery&LANG=ADQL&FORMAT=VOTABLE"
    1.16 +
    1.17 +<?xml version="1.0" encoding="UTF-8"?>
    1.18 +<VOTABLE xmlns="http://www.ivoa.net/xml/VOTable/v1.3" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.ivoa.net/xml/VOTable/v1.3 http://www.ivoa.net/xml/VOTable/v1.3" version="1.3">
    1.19 +  <RESOURCE type="results">
    1.20 +    <INFO name="QUERY_STATUS" value="OK"/>
    1.21 +    <INFO name="link" value="http://localhost:8080/firethorn/adql/table/215777"/>
    1.22 +    <TABLE ID="table.215777" name="XX_W2RFSDGF2HWB2AAAAFYNA7WZU4">
    1.23 +      <FIELD ID="column.219142" name="creationDate" datatype="char">
    1.24 +        <LINK content-type="application/json" content-role="metadata" href="http://localhost:8080/firethorn/adql/column/219142"/>
    1.25 +      </FIELD>
    1.26 +      <DATA>
    1.27 +        <TABLEDATA>
    1.28 +          <TR>
    1.29 +            <TD>2011-08-17T00:00:00.000Z</TD>
    1.30 +          </TR>
    1.31 +          <TR>
    1.32 +            <TD>2011-08-17T00:00:00.000Z</TD>
    1.33 +          </TR>
    1.34 +          <TR>
    1.35 +            <TD>2011-08-17T00:00:00.000Z</TD>
    1.36 +          </TR>
    1.37 +          <TR>
    1.38 +            <TD>2011-08-17T00:00:00.000Z</TD>
    1.39 +          </TR>
    1.40 +          <TR>
    1.41 +            <TD>2011-08-17T00:00:00.000Z</TD>
    1.42 +          </TR>
    1.43 +        </TABLEDATA>
    1.44 +      </DATA>
    1.45 +    </TABLE>
    1.46 +  </RESOURCE>
    1.47 +</VOTABLE>