/[volute]/trunk/projects/registry/regtap/RegTAP.tex
ViewVC logotype

Diff of /trunk/projects/registry/regtap/RegTAP.tex

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 2777 by volute@g-vo.org, Thu Nov 6 08:29:22 2014 UTC revision 2778 by volute@g-vo.org, Wed Dec 3 17:26:16 2014 UTC
# Line 2123  Line 2123 
2123  \rtent{rr.interface}, this requires  \rtent{rr.interface}, this requires
2124  a join:  a join:
2125    
2126    %CHECK_HERE
2127  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2128  SELECT ivoid, access\_url  SELECT ivoid, access_url
2129  FROM rr.capability  FROM rr.capability
2130  NATURAL JOIN rr.interface  NATURAL JOIN rr.interface
2131  WHERE standard\_id like 'ivo://ivoa.net/std/tap%'  WHERE standard_id like 'ivo://ivoa.net/std/tap%'
2132    AND intf\_type='vs:paramhttp'    AND intf_type='vs:paramhttp'
2133  \end{lstlisting}  \end{lstlisting}
2134    
2135  Other \rtent{standard\_id}s relevant here include:  Other \rtent{standard\_id}s relevant here include:
# Line 2163  Line 2163 
2163  the query would become:  the query would become:
2164    
2165    
2166    %CHECK_HERE
2167  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2168  SELECT ivoid, access_url  SELECT ivoid, access_url
2169  FROM rr.capability  FROM rr.capability
2170    NATURAL JOIN rr.resource    NATURAL JOIN rr.resource
2171    NATURAL JOIN rr.interface    NATURAL JOIN rr.interface
2172    NATURAL JOIN rr.res\_subject    NATURAL JOIN rr.res_subject
2173  WHERE standard_id='ivo://ivoa.net/std/sia'  WHERE standard_id='ivo://ivoa.net/std/sia'
2174    AND intf_type='vs:paramhttp'    AND intf_type='vs:paramhttp'
2175    AND (    AND (
# Line 2193  Line 2194 
2194  \rtent{rr.capability}, respectively.  \rtent{rr.capability}, respectively.
2195    
2196    
2197    %CHECK_HERE
2198  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2199  SELECT ivoid, access_url  SELECT ivoid, access_url
2200  FROM rr.capability  FROM rr.capability
# Line 2213  Line 2215 
2215  \rtent{rr.capability} and  \rtent{rr.capability} and
2216  \rtent{rr.interface}.  \rtent{rr.interface}.
2217  :  :
2218    %CHECK_HERE
2219  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2220  SELECT ivoid, access_\url  SELECT ivoid, access_url
2221  FROM rr.capability  FROM rr.capability
2222    NATURAL JOIN rr.table\_column    NATURAL JOIN rr.table_column
2223    NATURAL JOIN rr.interface    NATURAL JOIN rr.interface
2224  WHERE standard\_id='ivo://ivoa.net/std/conesearch'  WHERE standard_id='ivo://ivoa.net/std/conesearch'
2225    AND intf\_type='vs:paramhttp'    AND intf_type='vs:paramhttp'
2226    AND ucd='src.redshift'    AND ucd='src.redshift'
2227  \end{lstlisting}  \end{lstlisting}
2228    
# Line 2240  Line 2243 
2243  URIs, we make do with simple string matching:  URIs, we make do with simple string matching:
2244    
2245    
2246    %CHECK_HERE
2247  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2248  SELECT ivoid  SELECT ivoid
2249  FROM rr.resource  FROM rr.resource
# Line 2262  Line 2266 
2266  services.  services.
2267    
2268    
2269    %CHECK_HERE
2270  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2271  SELECT ivoid  SELECT ivoid
2272  FROM rr.res_role  FROM rr.res_role
# Line 2273  Line 2278 
2278  records,  records,
2279    
2280    
2281    %CHECK_HERE
2282  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2283  SELECT ivoid  SELECT ivoid
2284  FROM rr.res_role  FROM rr.res_role
# Line 2291  Line 2297 
2297  first get a list of all authorities managed by the CDS registry.  first get a list of all authorities managed by the CDS registry.
2298    
2299    
2300    %CHECK_HERE
2301  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2302  SELECT ivoid FROM rr.resource  SELECT ivoid FROM rr.resource
2303  RIGHT OUTER JOIN (  RIGHT OUTER JOIN (
2304    SELECT 'ivo://' || detail_value || '%' AS pat FROM rr.res_detail    SELECT 'ivo://' || detail_value || '%' AS pat FROM rr.res_detail
2305    WHERE detail\_xpath='/managedAuthority'    WHERE detail_xpath='/managedAuthority'
2306      AND ivoid='ivo://cds.vizier/registry')      AND ivoid='ivo://cds.vizier/registry')
2307    AS authpatterns    AS authpatterns
2308  ON (resource.ivoid LIKE authpatterns.pat)  ON (resource.ivoid LIKE authpatterns.pat)
# Line 2318  Line 2325 
2325  than exactly version 1.0.  than exactly version 1.0.
2326    
2327    
2328    %CHECK_HERE
2329  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2330  SELECT access_url  SELECT access_url
2331  FROM rr.interface  FROM rr.interface
# Line 2347  Line 2355 
2355  \rtent{rr.res\_table} for properties of tables.  \rtent{rr.res\_table} for properties of tables.
2356    
2357    
2358    %CHECK_HERE
2359  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2360  SELECT ivoid, access_url, name, ucd, column_description  SELECT ivoid, access_url, name, ucd, column_description
2361  FROM rr.capability  FROM rr.capability
# Line 2369  Line 2378 
2378  \rtent{rr.res\_detail}:  \rtent{rr.res\_detail}:
2379    
2380    
2381    %CHECK_HERE
2382  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2383  SELECT access_url  SELECT access_url
2384  FROM rr.res_detail  FROM rr.res_detail
# Line 2393  Line 2403 
2403  contact person by requiring \texttt{base\_role='contact'}.  contact person by requiring \texttt{base\_role='contact'}.
2404    
2405    
2406    %CHECK_HERE
2407  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2408  SELECT DISTINCT base_role, role_name, email  SELECT DISTINCT base_role, role_name, email
2409  FROM rr.res_role  FROM rr.res_role
# Line 2414  Line 2425 
2425  from  from
2426  \rtent{rr.capability}.  \rtent{rr.capability}.
2427    
2428    %CHECK_HERE
2429  \begin{lstlisting}[language=SQL,flexiblecolumns=true]  \begin{lstlisting}[language=SQL,flexiblecolumns=true]
2430  SELECT *  SELECT *
2431  FROM rr.relationship AS a  FROM rr.relationship AS a
# Line 2895  Line 2907 
2907  \item Migrated to ivoatex.  \item Migrated to ivoatex.
2908  \end{itemize}  \end{itemize}
2909    
2910  \subsection{Changes from  \subsection{Changes from PR-20140227}
 PR-20140227}  
2911    
2912  \label{changes-20140227}  \label{changes-20140227}
2913    
# Line 2943  Line 2954 
2954  % section changes-20140227  % section changes-20140227
2955  % HTML section start  % HTML section start
2956    
2957  \subsection{Changes from  \subsection{Changes from WD-20131203}
 WD-20131203}  
2958    
2959  \label{changes-20131203}  \label{changes-20131203}
2960    

Legend:
Removed from v.2777  
changed lines
  Added in v.2778

msdemlei@ari.uni-heidelberg.de
ViewVC Help
Powered by ViewVC 1.1.26