You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@calcite.apache.org by el...@apache.org on 2017/06/16 02:21:04 UTC
svn commit: r1798892 - /calcite/site/avatica/docs/
Author: elserj
Date: Fri Jun 16 02:21:03 2017
New Revision: 1798892
URL: http://svn.apache.org/viewvc?rev=1798892&view=rev
Log:
[CALCITE-1195] Update website with Kevin's curl Avatica "client"
Added:
calcite/site/avatica/docs/protocol_testing.html
Modified:
calcite/site/avatica/docs/client_reference.html
calcite/site/avatica/docs/compatibility.html
calcite/site/avatica/docs/custom_client_artifacts.html
calcite/site/avatica/docs/docker.html
calcite/site/avatica/docs/history.html
calcite/site/avatica/docs/howto.html
calcite/site/avatica/docs/index.html
calcite/site/avatica/docs/json_reference.html
calcite/site/avatica/docs/protobuf_reference.html
calcite/site/avatica/docs/roadmap.html
calcite/site/avatica/docs/security.html
Modified: calcite/site/avatica/docs/client_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/client_reference.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/client_reference.html (original)
+++ calcite/site/avatica/docs/client_reference.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -822,6 +880,16 @@ necessary when using HTTPS.</p>
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/compatibility.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/compatibility.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/compatibility.html (original)
+++ calcite/site/avatica/docs/compatibility.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -749,6 +807,16 @@ running the TCK, reference the provided
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/custom_client_artifacts.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/custom_client_artifacts.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/custom_client_artifacts.html (original)
+++ calcite/site/avatica/docs/custom_client_artifacts.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -781,6 +839,16 @@ a brief <code class="highlighter-rouge">
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/docker.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/docker.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/docker.html (original)
+++ calcite/site/avatica/docs/docker.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -682,7 +740,7 @@ $ docker run --rm -p 8765:8765 \
- <a href="/avatica/docs/history.html" class="next">Next</a>
+ <a href="/avatica/docs/protocol_testing.html" class="next">Next</a>
</div>
</div>
@@ -808,6 +866,16 @@ $ docker run --rm -p 8765:8765 \
<li class="current"><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/history.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/history.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/history.html (original)
+++ calcite/site/avatica/docs/history.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -213,6 +251,8 @@
+
+
@@ -243,6 +283,8 @@
+
+
@@ -273,6 +315,8 @@
+
+
@@ -303,6 +347,8 @@
+
+
@@ -333,6 +379,8 @@
+
+
@@ -363,6 +411,8 @@
+
+
@@ -393,6 +443,8 @@
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -941,12 +999,15 @@ for information about previous Avatica r
+
+
+
<div class="section-nav">
<div class="left align-right">
- <a href="/avatica/docs/docker.html" class="prev">Previous</a>
+ <a href="/avatica/docs/protocol_testing.html" class="prev">Previous</a>
</div>
<div class="right align-left">
@@ -1079,6 +1140,16 @@ for information about previous Avatica r
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/howto.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/howto.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/howto.html (original)
+++ calcite/site/avatica/docs/howto.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -1207,6 +1265,16 @@ as a template. Be sure to include a brie
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/index.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/index.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/index.html (original)
+++ calcite/site/avatica/docs/index.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -825,6 +883,16 @@ highly welcomed!</p>
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/json_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/json_reference.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/json_reference.html (original)
+++ calcite/site/avatica/docs/json_reference.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -1818,6 +1876,16 @@ for more information on valid attributes
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/protobuf_reference.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/protobuf_reference.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/protobuf_reference.html (original)
+++ calcite/site/avatica/docs/protobuf_reference.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -1898,6 +1956,16 @@ to the attributes in this message:</p>
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Added: calcite/site/avatica/docs/protocol_testing.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/protocol_testing.html?rev=1798892&view=auto
==============================================================================
--- calcite/site/avatica/docs/protocol_testing.html (added)
+++ calcite/site/avatica/docs/protocol_testing.html Fri Jun 16 02:21:03 2017
@@ -0,0 +1,913 @@
+<!DOCTYPE HTML>
+<html lang="en-US">
+<head>
+ <meta charset="UTF-8">
+ <title>Protocol Testing</title>
+ <meta name="viewport" content="width=device-width,initial-scale=1">
+ <meta name="generator" content="Jekyll v3.0.3">
+ <link rel="stylesheet" href="//fonts.googleapis.com/css?family=Lato:300,300italic,400,400italic,700,700italic,900">
+ <link rel="stylesheet" href="/avatica/css/screen.css">
+ <link rel="icon" type="image/x-icon" href="/avatica/favicon.ico">
+ <!--[if lt IE 9]>
+ <script src="/js/html5shiv.min.js"></script>
+ <script src="/js/respond.min.js"></script>
+ <![endif]-->
+</head>
+
+
+<body class="wrap">
+ <header role="banner">
+ <nav class="mobile-nav show-on-mobiles">
+ <ul>
+ <li class="">
+ <a href="/avatica/">Home</a>
+ </li>
+ <li class="">
+ <a href="/avatica/downloads/">Download</a>
+ </li>
+ <li class="">
+ <a href="/avatica/community/">Community</a>
+ </li>
+ <li class="">
+ <a href="/avatica/develop/">Develop</a>
+ </li>
+ <li class="">
+ <a href="/avatica/news/">News</a>
+ </li>
+ <li class="current">
+ <a href="/avatica/docs/">Docs</a>
+ </li>
+</ul>
+
+ </nav>
+ <div class="grid">
+ <div class="unit one-third center-on-mobiles">
+ <h1>
+ <a href="/avatica/">
+ <span class="sr-only">Apache Calcite Avatica</span>
+ <img src="/avatica/img/logo.png" width="226" height="140" alt="Calcite Logo">
+ </a>
+ </h1>
+ </div>
+ <nav class="main-nav unit two-thirds hide-on-mobiles">
+ <ul>
+ <li class="">
+ <a href="/avatica/">Home</a>
+ </li>
+ <li class="">
+ <a href="/avatica/downloads/">Download</a>
+ </li>
+ <li class="">
+ <a href="/avatica/community/">Community</a>
+ </li>
+ <li class="">
+ <a href="/avatica/develop/">Develop</a>
+ </li>
+ <li class="">
+ <a href="/avatica/news/">News</a>
+ </li>
+ <li class="current">
+ <a href="/avatica/docs/">Docs</a>
+ </li>
+</ul>
+
+ </nav>
+ </div>
+</header>
+
+
+ <section class="docs">
+ <div class="grid">
+
+ <div class="docs-nav-mobile unit whole show-on-mobiles">
+ <select onchange="if (this.value) window.location.href=this.value">
+ <option value="">Navigate the docsâ¦</option>
+
+ <optgroup label="Overview">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ <optgroup label="Reference">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ <optgroup label="Meta">
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </optgroup>
+
+ </select>
+</div>
+
+
+ <div class="unit four-fifths">
+ <article>
+ <h1>Protocol Testing</h1>
+ <!--
+
+-->
+
+<p>Building Avatica clients in a variety of languages is one of the primary
+goals of Avatica. There are various tools which can help in this process,
+but one of the most useful is a reference for how clients interact with
+the Avatica server.</p>
+
+<h2 id="testing-with-curl">Testing with cURL</h2>
+
+<p>A trivial way to interact with an Avatica server is using cURL and the JSON
+serialization. The below was tested to work with Avatica 1.10.0:</p>
+
+<figure class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="c">#!/usr/bin/env bash</span>
+
+<span class="nb">set</span> -u
+
+<span class="nv">AVATICA</span><span class="o">=</span><span class="nv">$1</span>
+<span class="nv">SQL</span><span class="o">=</span><span class="nv">$2</span>
+
+<span class="nv">CONNECTION_ID</span><span class="o">=</span><span class="s2">"conn-</span><span class="k">$(</span>whoami<span class="k">)</span><span class="s2">-</span><span class="k">$(</span>date +%s<span class="k">)</span><span class="s2">"</span>
+<span class="nv">MAX_ROW_COUNT</span><span class="o">=</span>100
+<span class="nv">NUM_ROWS</span><span class="o">=</span>2
+<span class="nv">OFFSET</span><span class="o">=</span>0
+
+<span class="nb">echo</span> <span class="s2">"Open connection"</span>
+<span class="nv">openConnectionReq</span><span class="o">=</span><span class="s2">"{</span><span class="se">\"</span><span class="s2">request</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">openConnection</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">connectionId</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="k">${</span><span class="nv">CONNECTION_ID</span><span class="k">}</span><span class="se">\"</span><span class="s2">}"</span>
+<span class="c"># Example of how to set connection properties with info key</span>
+<span class="c"># openConnectionReqWithProperties="{\"request\": \"openConnection\",\"connectionId\": \"${CONNECTION_ID}\",\"info\": {\"user\": \"SCOTT\",\"password\": \"TIGER\"}}"</span>
+curl -i -w <span class="s2">"</span><span class="se">\n</span><span class="s2">"</span> <span class="s2">"</span><span class="nv">$AVATICA</span><span class="s2">"</span> -H <span class="s2">"Content-Type: application/json"</span> --data <span class="s2">"</span><span class="nv">$openConnectionReq</span><span class="s2">"</span>
+<span class="nb">echo
+
+echo</span> <span class="s2">"Create statement"</span>
+<span class="nv">STATEMENTRSP</span><span class="o">=</span><span class="k">$(</span>curl -s <span class="s2">"</span><span class="nv">$AVATICA</span><span class="s2">"</span> -H <span class="s2">"Content-Type: application/json"</span> --data <span class="s2">"{</span><span class="se">\"</span><span class="s2">request</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">createStatement</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">connectionId</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="k">${</span><span class="nv">CONNECTION_ID</span><span class="k">}</span><span class="se">\"</span><span class="s2">}"</span><span class="k">)</span>
+<span class="nv">STATEMENTID</span><span class="o">=</span><span class="k">$(</span><span class="nb">echo</span> <span class="s2">"</span><span class="nv">$STATEMENTRSP</span><span class="s2">"</span> | jq .statementId<span class="k">)</span>
+<span class="nb">echo
+
+echo</span> <span class="s2">"PrepareAndExecuteRequest"</span>
+curl -i -w <span class="s2">"</span><span class="se">\n</span><span class="s2">"</span> <span class="s2">"</span><span class="nv">$AVATICA</span><span class="s2">"</span> -H <span class="s2">"Content-Type: application/json"</span> --data <span class="s2">"{</span><span class="se">\"</span><span class="s2">request</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">prepareAndExecute</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">connectionId</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="k">${</span><span class="nv">CONNECTION_ID</span><span class="k">}</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">statementId</span><span class="se">\"</span><span class="s2">: </span><span class="nv">$STATEMENTID</span><span class="s2">,</span><span class="se">\"</span><span class="s2">sql</span><s
pan class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="nv">$SQL</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">maxRowCount</span><span class="se">\"</span><span class="s2">: </span><span class="k">${</span><span class="nv">MAX_ROW_COUNT</span><span class="k">}</span><span class="s2">, </span><span class="se">\"</span><span class="s2">maxRowsInFirstFrame</span><span class="se">\"</span><span class="s2">: </span><span class="k">${</span><span class="nv">NUM_ROWS</span><span class="k">}</span><span class="s2">}"</span>
+<span class="nb">echo</span>
+
+<span class="c"># Loop through all the results</span>
+<span class="nv">ISDONE</span><span class="o">=</span><span class="nb">false
+</span><span class="k">while</span> ! <span class="nv">$ISDONE</span>; <span class="k">do
+ </span><span class="nv">OFFSET</span><span class="o">=</span><span class="k">$((</span>OFFSET <span class="o">+</span> NUM_ROWS<span class="k">))</span>
+ <span class="nb">echo</span> <span class="s2">"FetchRequest - Offset=</span><span class="nv">$OFFSET</span><span class="s2">"</span>
+ <span class="nv">FETCHRSP</span><span class="o">=</span><span class="k">$(</span>curl -s <span class="s2">"</span><span class="nv">$AVATICA</span><span class="s2">"</span> -H <span class="s2">"Content-Type: application/json"</span> --data <span class="s2">"{</span><span class="se">\"</span><span class="s2">request</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">fetch</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">connectionId</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="k">${</span><span class="nv">CONNECTION_ID</span><span class="k">}</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">statementId</span><span class="se">\"</span><span class="s2">: </span><span class="nv">$STATEMENTID</span><span class="s2">,</span><span class="se">\"</span><span class="s2">offset</span><span cl
ass="se">\"</span><span class="s2">: </span><span class="k">${</span><span class="nv">OFFSET</span><span class="k">}</span><span class="s2">,</span><span class="se">\"</span><span class="s2">fetchMaxRowCount</span><span class="se">\"</span><span class="s2">: </span><span class="k">${</span><span class="nv">NUM_ROWS</span><span class="k">}</span><span class="s2">}"</span><span class="k">)</span>
+ <span class="nb">echo</span> <span class="s2">"</span><span class="nv">$FETCHRSP</span><span class="s2">"</span>
+ <span class="nv">ISDONE</span><span class="o">=</span><span class="k">$(</span><span class="nb">echo</span> <span class="s2">"</span><span class="nv">$FETCHRSP</span><span class="s2">"</span> | jq .frame.done<span class="k">)</span>
+ <span class="nb">echo
+</span><span class="k">done
+
+</span><span class="nb">echo</span> <span class="s2">"Close statement"</span>
+curl -i -w <span class="s2">"</span><span class="se">\n</span><span class="s2">"</span> <span class="s2">"</span><span class="nv">$AVATICA</span><span class="s2">"</span> -H <span class="s2">"Content-Type: application/json"</span> --data <span class="s2">"{</span><span class="se">\"</span><span class="s2">request</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">closeStatement</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">connectionId</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="k">${</span><span class="nv">CONNECTION_ID</span><span class="k">}</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">statementId</span><span class="se">\"</span><span class="s2">: </span><span class="nv">$STATEMENTID</span><span class="s2">}"</span>
+<span class="nb">echo
+
+echo</span> <span class="s2">"Close connection"</span>
+curl -i -w <span class="s2">"</span><span class="se">\n</span><span class="s2">"</span> <span class="s2">"</span><span class="nv">$AVATICA</span><span class="s2">"</span> -H <span class="s2">"Content-Type: application/json"</span> --data <span class="s2">"{</span><span class="se">\"</span><span class="s2">request</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">closeConnection</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">connectionId</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="k">${</span><span class="nv">CONNECTION_ID</span><span class="k">}</span><span class="se">\"</span><span class="s2">}"</span>
+<span class="nb">echo</span></code></pre></figure>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <div class="section-nav">
+ <div class="left align-right">
+
+
+
+ <a href="/avatica/docs/docker.html" class="prev">Previous</a>
+
+ </div>
+ <div class="right align-left">
+
+
+
+ <a href="/avatica/docs/history.html" class="next">Next</a>
+
+ </div>
+ </div>
+ <div class="clear"></div>
+
+
+ </article>
+ </div>
+
+ <div class="unit one-fifth hide-on-mobiles">
+ <aside>
+
+ <h4>Overview</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/index.html">Background</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/roadmap.html">Roadmap</a></li>
+
+
+</ul>
+
+
+ <h4>Reference</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/client_reference.html">Client Reference</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/json_reference.html">JSON Reference</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protobuf_reference.html">Protobuf Reference</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/howto.html">HOWTO</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/security.html">Security</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/compatibility.html">Compatibility</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/custom_client_artifacts.html">Custom Client Artifacts</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+
+
+ <li class="current"><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
+</ul>
+
+
+ <h4>Meta</h4>
+
+
+<ul>
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/history.html">History</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/api/">API</a></li>
+
+
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/testapi/">Test API</a></li>
+
+
+</ul>
+
+
+ </aside>
+</div>
+
+
+ <div class="clear"></div>
+
+ </div>
+ </section>
+
+
+ <footer role="contentinfo">
+ <div id="poweredby">
+ <a href="http://www.apache.org/">
+ <span class="sr-only">Apache</span>
+ <img src="/avatica/img/feather.png" width="190" height="77" alt="Apache Logo"></a>
+ </div>
+ <div id="copyright">
+ <p>The contents of this website are © 2017
+ <a href="https://www.apache.org/">Apache Software Foundation</a>
+ under the terms of
+ the <a href="https://www.apache.org/licenses/LICENSE-2.0.html">
+ Apache License v2</a>. Apache Calcite and its logo are
+ trademarks of the Apache Software Foundation.</p>
+ </div>
+</footer>
+
+ <script>
+ var anchorForId = function (id) {
+ var anchor = document.createElement("a");
+ anchor.className = "header-link";
+ anchor.href = "#" + id;
+ anchor.innerHTML = "<span class=\"sr-only\">Permalink</span><i class=\"fa fa-link\"></i>";
+ anchor.title = "Permalink";
+ return anchor;
+ };
+
+ var linkifyAnchors = function (level, containingElement) {
+ var headers = containingElement.getElementsByTagName("h" + level);
+ for (var h = 0; h < headers.length; h++) {
+ var header = headers[h];
+
+ if (typeof header.id !== "undefined" && header.id !== "") {
+ header.appendChild(anchorForId(header.id));
+ }
+ }
+ };
+
+ document.onreadystatechange = function () {
+ if (this.readyState === "complete") {
+ var contentBlock = document.getElementsByClassName("docs")[0] || document.getElementsByClassName("news")[0];
+ if (!contentBlock) {
+ return;
+ }
+ for (var level = 1; level <= 6; level++) {
+ linkifyAnchors(level, contentBlock);
+ }
+ }
+ };
+</script>
+
+
+</body>
+</html>
Modified: calcite/site/avatica/docs/roadmap.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/roadmap.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/roadmap.html (original)
+++ calcite/site/avatica/docs/roadmap.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -693,6 +751,16 @@
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>
Modified: calcite/site/avatica/docs/security.html
URL: http://svn.apache.org/viewvc/calcite/site/avatica/docs/security.html?rev=1798892&r1=1798891&r2=1798892&view=diff
==============================================================================
--- calcite/site/avatica/docs/security.html (original)
+++ calcite/site/avatica/docs/security.html Fri Jun 16 02:21:03 2017
@@ -116,6 +116,8 @@
+
+
@@ -146,6 +148,8 @@
+
+
</optgroup>
@@ -183,6 +187,8 @@
+
+
@@ -213,6 +219,8 @@
+
+
@@ -243,6 +251,8 @@
+
+
@@ -273,6 +283,8 @@
+
+
@@ -303,6 +315,8 @@
+
+
@@ -333,6 +347,8 @@
+
+
@@ -363,6 +379,8 @@
+
+
@@ -393,6 +411,40 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</optgroup>
@@ -430,6 +482,8 @@
+
+
@@ -460,6 +514,8 @@
+
+
@@ -490,6 +546,8 @@
+
+
</optgroup>
@@ -902,6 +960,16 @@ superfluous.</p>
<li class=""><a href="/avatica/docs/docker.html">Docker Images</a></li>
+
+
+
+
+
+
+
+ <li class=""><a href="/avatica/docs/protocol_testing.html">Protocol Testing</a></li>
+
+
</ul>