blob: b5a1507c466eb50828f6c1b8dbda7ccec1a0915f [file] [log] [blame]
<!DOCTYPE HTML>
<!-- NewPage -->
<html lang="en">
<head>
<!-- Generated by javadoc -->
<title>SqlTest (Calcite 1.21.0 Test API)</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
<link rel="stylesheet" type="text/css" href="../../../../../jquery/jquery-ui.css" title="Style">
<script type="text/javascript" src="../../../../../script.js"></script>
<script type="text/javascript" src="../../../../../jquery/jszip/dist/jszip.min.js"></script>
<script type="text/javascript" src="../../../../../jquery/jszip-utils/dist/jszip-utils.min.js"></script>
<!--[if IE]>
<script type="text/javascript" src="../../../../../jquery/jszip-utils/dist/jszip-utils-ie.min.js"></script>
<![endif]-->
<script type="text/javascript" src="../../../../../jquery/jquery-3.3.1.js"></script>
<script type="text/javascript" src="../../../../../jquery/jquery-migrate-3.0.1.js"></script>
<script type="text/javascript" src="../../../../../jquery/jquery-ui.js"></script>
</head>
<body>
<script type="text/javascript"><!--
try {
if (location.href.indexOf('is-external=true') == -1) {
parent.document.title="SqlTest (Calcite 1.21.0 Test API)";
}
}
catch(err) {
}
//-->
var data = {"i0":10,"i1":10,"i2":9,"i3":9,"i4":9,"i5":10,"i6":10,"i7":10,"i8":10,"i9":10,"i10":10,"i11":10,"i12":10,"i13":10,"i14":10,"i15":10,"i16":10,"i17":10,"i18":10,"i19":10,"i20":10,"i21":10,"i22":9};
var tabs = {65535:["t0","All Methods"],1:["t1","Static Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]};
var altColor = "altColor";
var rowColor = "rowColor";
var tableTab = "tableTab";
var activeTableTab = "activeTableTab";
var pathtoroot = "../../../../../";
var useModuleDirectories = true;
loadScripts(document, 'script');</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<header role="banner">
<nav role="navigation">
<div class="fixedNav">
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a id="navbar.top">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div>
<a id="navbar.top.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../index.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/SqlTest.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../allclasses.html">All&nbsp;Classes</a></li>
</ul>
<ul class="navListSearch">
<li><label for="search">SEARCH:</label>
<input type="text" id="search" value="search" disabled="disabled">
<input type="reset" id="reset" value="reset" disabled="disabled">
</li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_top");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li><a href="#nested.class.summary">Nested</a>&nbsp;|&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.detail">Method</a></li>
</ul>
</div>
<a id="skip.navbar.top">
<!-- -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
</div>
<div class="navPadding">&nbsp;</div>
<script type="text/javascript"><!--
$('.navPadding').css('padding-top', $('.fixedNav').css("height"));
//-->
</script>
</nav>
</header>
<!-- ======== START OF CLASS DATA ======== -->
<main role="main">
<div class="header">
<div class="subTitle"><span class="packageLabelInType">Package</span>&nbsp;<a href="package-summary.html">org.apache.calcite.adapter.file</a></div>
<h2 title="Class SqlTest" class="title">Class SqlTest</h2>
</div>
<div class="contentContainer">
<ul class="inheritance">
<li>java.lang.Object</li>
<li>
<ul class="inheritance">
<li>org.apache.calcite.adapter.file.SqlTest</li>
</ul>
</li>
</ul>
<div class="description">
<ul class="blockList">
<li class="blockList">
<hr>
<pre>public class <span class="typeNameLabel">SqlTest</span>
extends java.lang.Object</pre>
<div class="block">System test of the Calcite file adapter, which can also read and parse
HTML tables over HTTP.</div>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- ======== NESTED CLASS SUMMARY ======== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="nested.class.summary">
<!-- -->
</a>
<h3>Nested Class Summary</h3>
<table class="memberSummary">
<caption><span>Nested Classes</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Class</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>private class&nbsp;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="SqlTest.Fluent.html" title="class in org.apache.calcite.adapter.file">SqlTest.Fluent</a></span></code></th>
<td class="colLast">
<div class="block">Fluent API to perform test actions.</div>
</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="constructor.summary">
<!-- -->
</a>
<h3>Constructor Summary</h3>
<table class="memberSummary">
<caption><span>Constructors</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Constructor</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr class="altColor">
<th class="colConstructorName" scope="row"><code><span class="memberNameLink"><a href="#%3Cinit%3E()">SqlTest</a></span>()</code></th>
<td class="colLast">&nbsp;</td>
</tr>
</table>
</li>
</ul>
</section>
<!-- ========== METHOD SUMMARY =========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="method.summary">
<!-- -->
</a>
<h3>Method Summary</h3>
<table class="memberSummary">
<caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd">&nbsp;</span></span><span id="t1" class="tableTab"><span><a href="javascript:show(1);">Static Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd">&nbsp;</span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd">&nbsp;</span></span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colSecond" scope="col">Method</th>
<th class="colLast" scope="col">Description</th>
</tr>
<tr id="i0" class="altColor">
<td class="colFirst"><code>private void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#checkSql(java.lang.String,java.lang.String,java.util.function.Function)">checkSql</a></span>&#8203;(java.lang.String&nbsp;sql,
java.lang.String&nbsp;model,
java.util.function.Function&lt;java.sql.ResultSet,&#8203;java.lang.Void&gt;&nbsp;fn)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i1" class="rowColor">
<td class="colFirst"><code>private void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#close(java.sql.Connection,java.sql.Statement)">close</a></span>&#8203;(java.sql.Connection&nbsp;connection,
java.sql.Statement&nbsp;statement)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i2" class="altColor">
<td class="colFirst"><code>private static void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#collect(java.util.List,java.sql.ResultSet)">collect</a></span>&#8203;(java.util.List&lt;java.lang.String&gt;&nbsp;result,
java.sql.ResultSet&nbsp;resultSet)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i3" class="rowColor">
<td class="colFirst"><code>private static java.util.function.Function&lt;java.sql.ResultSet,&#8203;java.lang.Void&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#expect(java.lang.String...)">expect</a></span>&#8203;(java.lang.String...&nbsp;expectedLines)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i4" class="altColor">
<td class="colFirst"><code>private static java.util.function.Function&lt;java.sql.ResultSet,&#8203;java.lang.Void&gt;</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#expectUnordered(java.lang.String...)">expectUnordered</a></span>&#8203;(java.lang.String...&nbsp;expected)</code></th>
<td class="colLast">
<div class="block">Returns a function that checks the contents of a result set against an
expected string.</div>
</td>
</tr>
<tr id="i5" class="rowColor">
<td class="colFirst"><code>private <a href="SqlTest.Fluent.html" title="class in org.apache.calcite.adapter.file">SqlTest.Fluent</a></code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#sql(java.lang.String,java.lang.String)">sql</a></span>&#8203;(java.lang.String&nbsp;model,
java.lang.String&nbsp;sql)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
<tr id="i6" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCsvGroupByTimestampAdd()">testCsvGroupByTimestampAdd</a></span>()</code></th>
<td class="colLast">
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1754">[CALCITE-1754]
In Csv adapter, convert DATE and TIME values to int, and TIMESTAMP values
to long</a>.</div>
</td>
</tr>
<tr id="i7" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCsvSalesDepts()">testCsvSalesDepts</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the DEPTS table from the CSV schema.</div>
</td>
</tr>
<tr id="i8" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCsvSalesEmps()">testCsvSalesEmps</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the EMPS table from the CSV schema.</div>
</td>
</tr>
<tr id="i9" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCsvSalesEmpty()">testCsvSalesEmpty</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the EMPTY table from the CSV schema.</div>
</td>
</tr>
<tr id="i10" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testCsvSalesHeaderOnly()">testCsvSalesHeaderOnly</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the HEADER_ONLY table from the CSV schema.</div>
</td>
</tr>
<tr id="i11" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFileSelect()">testFileSelect</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads from a local file and checks the result.</div>
</td>
</tr>
<tr id="i12" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testFindBiggerNoTh()">testFindBiggerNoTh</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads from a local file - finds larger table even without &lt;TH&gt;
elements.</div>
</td>
</tr>
<tr id="i13" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonJoinOnString()">testJsonJoinOnString</a></span>()</code></th>
<td class="colLast">
<div class="block">Test returns the result of two json file joins.</div>
</td>
</tr>
<tr id="i14" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonSalesDepts()">testJsonSalesDepts</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the DEPTS table from the JSON schema.</div>
</td>
</tr>
<tr id="i15" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonSalesEmps()">testJsonSalesEmps</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the EMPS table from the JSON schema.</div>
</td>
</tr>
<tr id="i16" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonSalesEmpty()">testJsonSalesEmpty</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the EMPTY table from the JSON schema.</div>
</td>
</tr>
<tr id="i17" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testJsonWithCsvJoin()">testJsonWithCsvJoin</a></span>()</code></th>
<td class="colLast">
<div class="block">The folder contains both JSON files and CSV files joins.</div>
</td>
</tr>
<tr id="i18" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testNoThSelect()">testNoThSelect</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads from a local file without table headers &lt;TH&gt; and checks the
result.</div>
</td>
</tr>
<tr id="i19" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSalesDepts()">testSalesDepts</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the DEPTS table.</div>
</td>
</tr>
<tr id="i20" class="altColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testSalesEmps()">testSalesEmps</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads the EMPS table.</div>
</td>
</tr>
<tr id="i21" class="rowColor">
<td class="colFirst"><code>void</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#testUrlSelect()">testUrlSelect</a></span>()</code></th>
<td class="colLast">
<div class="block">Reads from a URL and checks the result.</div>
</td>
</tr>
<tr id="i22" class="altColor">
<td class="colFirst"><code>private static java.lang.String</code></td>
<th class="colSecond" scope="row"><code><span class="memberNameLink"><a href="#toString(java.sql.ResultSet)">toString</a></span>&#8203;(java.sql.ResultSet&nbsp;resultSet)</code></th>
<td class="colLast">&nbsp;</td>
</tr>
</table>
<ul class="blockList">
<li class="blockList"><a id="methods.inherited.from.class.java.lang.Object">
<!-- -->
</a>
<h3>Methods inherited from class&nbsp;java.lang.Object</h3>
<code>clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait</code></li>
</ul>
</li>
</ul>
</section>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ========= CONSTRUCTOR DETAIL ======== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="constructor.detail">
<!-- -->
</a>
<h3>Constructor Detail</h3>
<a id="&lt;init&gt;()">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>SqlTest</h4>
<pre>public&nbsp;SqlTest()</pre>
</li>
</ul>
</li>
</ul>
</section>
<!-- ============ METHOD DETAIL ========== -->
<section role="region">
<ul class="blockList">
<li class="blockList"><a id="method.detail">
<!-- -->
</a>
<h3>Method Detail</h3>
<a id="sql(java.lang.String,java.lang.String)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>sql</h4>
<pre class="methodSignature">private&nbsp;<a href="SqlTest.Fluent.html" title="class in org.apache.calcite.adapter.file">SqlTest.Fluent</a>&nbsp;sql&#8203;(java.lang.String&nbsp;model,
java.lang.String&nbsp;sql)</pre>
</li>
</ul>
<a id="expect(java.lang.String...)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>expect</h4>
<pre class="methodSignature">private static&nbsp;java.util.function.Function&lt;java.sql.ResultSet,&#8203;java.lang.Void&gt;&nbsp;expect&#8203;(java.lang.String...&nbsp;expectedLines)</pre>
</li>
</ul>
<a id="expectUnordered(java.lang.String...)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>expectUnordered</h4>
<pre class="methodSignature">private static&nbsp;java.util.function.Function&lt;java.sql.ResultSet,&#8203;java.lang.Void&gt;&nbsp;expectUnordered&#8203;(java.lang.String...&nbsp;expected)</pre>
<div class="block">Returns a function that checks the contents of a result set against an
expected string.</div>
</li>
</ul>
<a id="collect(java.util.List,java.sql.ResultSet)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>collect</h4>
<pre class="methodSignature">private static&nbsp;void&nbsp;collect&#8203;(java.util.List&lt;java.lang.String&gt;&nbsp;result,
java.sql.ResultSet&nbsp;resultSet)
throws java.sql.SQLException</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="checkSql(java.lang.String,java.lang.String,java.util.function.Function)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>checkSql</h4>
<pre class="methodSignature">private&nbsp;void&nbsp;checkSql&#8203;(java.lang.String&nbsp;sql,
java.lang.String&nbsp;model,
java.util.function.Function&lt;java.sql.ResultSet,&#8203;java.lang.Void&gt;&nbsp;fn)
throws java.sql.SQLException</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="toString(java.sql.ResultSet)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>toString</h4>
<pre class="methodSignature">private static&nbsp;java.lang.String&nbsp;toString&#8203;(java.sql.ResultSet&nbsp;resultSet)
throws java.sql.SQLException</pre>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="close(java.sql.Connection,java.sql.Statement)">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>close</h4>
<pre class="methodSignature">private&nbsp;void&nbsp;close&#8203;(java.sql.Connection&nbsp;connection,
java.sql.Statement&nbsp;statement)</pre>
</li>
</ul>
<a id="testFileSelect()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testFileSelect</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testFileSelect()
throws java.sql.SQLException</pre>
<div class="block">Reads from a local file and checks the result.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testNoThSelect()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testNoThSelect</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testNoThSelect()
throws java.sql.SQLException</pre>
<div class="block">Reads from a local file without table headers &lt;TH&gt; and checks the
result.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testFindBiggerNoTh()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testFindBiggerNoTh</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testFindBiggerNoTh()
throws java.sql.SQLException</pre>
<div class="block">Reads from a local file - finds larger table even without &lt;TH&gt;
elements.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testUrlSelect()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testUrlSelect</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testUrlSelect()
throws java.sql.SQLException</pre>
<div class="block">Reads from a URL and checks the result.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testSalesEmps()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testSalesEmps</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testSalesEmps()
throws java.sql.SQLException</pre>
<div class="block">Reads the EMPS table.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testSalesDepts()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testSalesDepts</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testSalesDepts()
throws java.sql.SQLException</pre>
<div class="block">Reads the DEPTS table.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testCsvSalesDepts()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCsvSalesDepts</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCsvSalesDepts()
throws java.sql.SQLException</pre>
<div class="block">Reads the DEPTS table from the CSV schema.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testCsvSalesEmps()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCsvSalesEmps</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCsvSalesEmps()
throws java.sql.SQLException</pre>
<div class="block">Reads the EMPS table from the CSV schema.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testCsvSalesHeaderOnly()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCsvSalesHeaderOnly</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCsvSalesHeaderOnly()
throws java.sql.SQLException</pre>
<div class="block">Reads the HEADER_ONLY table from the CSV schema. The CSV file has one
line - the column headers - but no rows of data.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testCsvSalesEmpty()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCsvSalesEmpty</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCsvSalesEmpty()
throws java.sql.SQLException</pre>
<div class="block">Reads the EMPTY table from the CSV schema. The CSV file has no lines,
therefore the table has a system-generated column called
"EmptyFileHasNoColumns".</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testCsvGroupByTimestampAdd()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testCsvGroupByTimestampAdd</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testCsvGroupByTimestampAdd()
throws java.sql.SQLException</pre>
<div class="block">Test case for
<a href="https://issues.apache.org/jira/browse/CALCITE-1754">[CALCITE-1754]
In Csv adapter, convert DATE and TIME values to int, and TIMESTAMP values
to long</a>.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testJsonSalesDepts()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJsonSalesDepts</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJsonSalesDepts()
throws java.sql.SQLException</pre>
<div class="block">Reads the DEPTS table from the JSON schema.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testJsonSalesEmps()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJsonSalesEmps</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJsonSalesEmps()
throws java.sql.SQLException</pre>
<div class="block">Reads the EMPS table from the JSON schema.</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testJsonSalesEmpty()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJsonSalesEmpty</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJsonSalesEmpty()
throws java.sql.SQLException</pre>
<div class="block">Reads the EMPTY table from the JSON schema. The JSON file has no lines,
therefore the table has a system-generated column called
"EmptyFileHasNoColumns".</div>
<dl>
<dt><span class="throwsLabel">Throws:</span></dt>
<dd><code>java.sql.SQLException</code></dd>
</dl>
</li>
</ul>
<a id="testJsonJoinOnString()">
<!-- -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>testJsonJoinOnString</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJsonJoinOnString()</pre>
<div class="block">Test returns the result of two json file joins.</div>
</li>
</ul>
<a id="testJsonWithCsvJoin()">
<!-- -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>testJsonWithCsvJoin</h4>
<pre class="methodSignature">public&nbsp;void&nbsp;testJsonWithCsvJoin()</pre>
<div class="block">The folder contains both JSON files and CSV files joins.</div>
</li>
</ul>
</li>
</ul>
</section>
</li>
</ul>
</div>
</div>
</main>
<!-- ========= END OF CLASS DATA ========= -->
<footer role="contentinfo">
<nav role="navigation">
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a id="navbar.bottom">
<!-- -->
</a>
<div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div>
<a id="navbar.bottom.firstrow">
<!-- -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../index.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/SqlTest.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../allclasses.html">All&nbsp;Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
allClassesLink = document.getElementById("allclasses_navbar_bottom");
if(window==top) {
allClassesLink.style.display = "block";
}
else {
allClassesLink.style.display = "none";
}
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
</div>
<div>
<ul class="subNavList">
<li>Summary:&nbsp;</li>
<li><a href="#nested.class.summary">Nested</a>&nbsp;|&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li><a href="#constructor.summary">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.summary">Method</a></li>
</ul>
<ul class="subNavList">
<li>Detail:&nbsp;</li>
<li>Field&nbsp;|&nbsp;</li>
<li><a href="#constructor.detail">Constr</a>&nbsp;|&nbsp;</li>
<li><a href="#method.detail">Method</a></li>
</ul>
</div>
<a id="skip.navbar.bottom">
<!-- -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
</nav>
<p class="legalCopy"><small>Copyright &#169; 2012&#x2013;2019 <a href="https://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</small></p>
</footer>
</body>
</html>