| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
| <head> |
| <meta http-equiv="content-type" content="text/html; charset=UTF-8" /> |
| <title>QueryStatementTest xref</title> |
| <link type="text/css" rel="stylesheet" href="../../../../../../stylesheet.css" /> |
| </head> |
| <body> |
| <div id="overview"><a href="../../../../../../../testapidocs/org/apache/chemistry/opencmis/client/runtime/QueryStatementTest.html">View Javadoc</a></div><pre> |
| |
| <a class="jxr_linenumber" name="1" href="#1">1</a> <em class="jxr_comment">/*</em> |
| <a class="jxr_linenumber" name="2" href="#2">2</a> <em class="jxr_comment"> * Licensed to the Apache Software Foundation (ASF) under one</em> |
| <a class="jxr_linenumber" name="3" href="#3">3</a> <em class="jxr_comment"> * or more contributor license agreements. See the NOTICE file</em> |
| <a class="jxr_linenumber" name="4" href="#4">4</a> <em class="jxr_comment"> * distributed with this work for additional information</em> |
| <a class="jxr_linenumber" name="5" href="#5">5</a> <em class="jxr_comment"> * regarding copyright ownership. The ASF licenses this file</em> |
| <a class="jxr_linenumber" name="6" href="#6">6</a> <em class="jxr_comment"> * to you under the Apache License, Version 2.0 (the</em> |
| <a class="jxr_linenumber" name="7" href="#7">7</a> <em class="jxr_comment"> * "License"); you may not use this file except in compliance</em> |
| <a class="jxr_linenumber" name="8" href="#8">8</a> <em class="jxr_comment"> * with the License. You may obtain a copy of the License at</em> |
| <a class="jxr_linenumber" name="9" href="#9">9</a> <em class="jxr_comment"> *</em> |
| <a class="jxr_linenumber" name="10" href="#10">10</a> <em class="jxr_comment"> * <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em> |
| <a class="jxr_linenumber" name="11" href="#11">11</a> <em class="jxr_comment"> *</em> |
| <a class="jxr_linenumber" name="12" href="#12">12</a> <em class="jxr_comment"> * Unless required by applicable law or agreed to in writing,</em> |
| <a class="jxr_linenumber" name="13" href="#13">13</a> <em class="jxr_comment"> * software distributed under the License is distributed on an</em> |
| <a class="jxr_linenumber" name="14" href="#14">14</a> <em class="jxr_comment"> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY</em> |
| <a class="jxr_linenumber" name="15" href="#15">15</a> <em class="jxr_comment"> * KIND, either express or implied. See the License for the</em> |
| <a class="jxr_linenumber" name="16" href="#16">16</a> <em class="jxr_comment"> * specific language governing permissions and limitations</em> |
| <a class="jxr_linenumber" name="17" href="#17">17</a> <em class="jxr_comment"> * under the License.</em> |
| <a class="jxr_linenumber" name="18" href="#18">18</a> <em class="jxr_comment"> */</em> |
| <a class="jxr_linenumber" name="19" href="#19">19</a> <strong class="jxr_keyword">package</strong> org.apache.chemistry.opencmis.client.runtime; |
| <a class="jxr_linenumber" name="20" href="#20">20</a> |
| <a class="jxr_linenumber" name="21" href="#21">21</a> <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.assertEquals; |
| <a class="jxr_linenumber" name="22" href="#22">22</a> <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.fail; |
| <a class="jxr_linenumber" name="23" href="#23">23</a> |
| <a class="jxr_linenumber" name="24" href="#24">24</a> <strong class="jxr_keyword">import</strong> java.net.MalformedURLException; |
| <a class="jxr_linenumber" name="25" href="#25">25</a> <strong class="jxr_keyword">import</strong> java.net.URI; |
| <a class="jxr_linenumber" name="26" href="#26">26</a> <strong class="jxr_keyword">import</strong> java.net.URISyntaxException; |
| <a class="jxr_linenumber" name="27" href="#27">27</a> <strong class="jxr_keyword">import</strong> java.net.URL; |
| <a class="jxr_linenumber" name="28" href="#28">28</a> <strong class="jxr_keyword">import</strong> java.util.GregorianCalendar; |
| <a class="jxr_linenumber" name="29" href="#29">29</a> <strong class="jxr_keyword">import</strong> java.util.HashMap; |
| <a class="jxr_linenumber" name="30" href="#30">30</a> <strong class="jxr_keyword">import</strong> java.util.TimeZone; |
| <a class="jxr_linenumber" name="31" href="#31">31</a> |
| <a class="jxr_linenumber" name="32" href="#32">32</a> <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.client.api.QueryStatement; |
| <a class="jxr_linenumber" name="33" href="#33">33</a> <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.client.api.Session; |
| <a class="jxr_linenumber" name="34" href="#34">34</a> <strong class="jxr_keyword">import</strong> org.junit.Test; |
| <a class="jxr_linenumber" name="35" href="#35">35</a> |
| <a class="jxr_linenumber" name="36" href="#36">36</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../../org/apache/chemistry/opencmis/client/runtime/QueryStatementTest.html">QueryStatementTest</a> { |
| <a class="jxr_linenumber" name="37" href="#37">37</a> |
| <a class="jxr_linenumber" name="38" href="#38">38</a> @Test |
| <a class="jxr_linenumber" name="39" href="#39">39</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testStaticQueries() { |
| <a class="jxr_linenumber" name="40" href="#40">40</a> Session session = <strong class="jxr_keyword">new</strong> SessionImpl(<strong class="jxr_keyword">new</strong> HashMap<String, String>(), <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>); |
| <a class="jxr_linenumber" name="41" href="#41">41</a> String query; |
| <a class="jxr_linenumber" name="42" href="#42">42</a> QueryStatement st; |
| <a class="jxr_linenumber" name="43" href="#43">43</a> |
| <a class="jxr_linenumber" name="44" href="#44">44</a> query = <span class="jxr_string">"SELECT cmis:name FROM cmis:folder"</span>; |
| <a class="jxr_linenumber" name="45" href="#45">45</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="46" href="#46">46</a> assertEquals(query, st.toQueryString()); |
| <a class="jxr_linenumber" name="47" href="#47">47</a> |
| <a class="jxr_linenumber" name="48" href="#48">48</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE cmis:createdBy = \'admin\' AND abc:int = 42"</span>; |
| <a class="jxr_linenumber" name="49" href="#49">49</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="50" href="#50">50</a> assertEquals(query, st.toQueryString()); |
| <a class="jxr_linenumber" name="51" href="#51">51</a> |
| <a class="jxr_linenumber" name="52" href="#52">52</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:test = 'x?z'"</span>; |
| <a class="jxr_linenumber" name="53" href="#53">53</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="54" href="#54">54</a> st.setString(1, <span class="jxr_string">"y"</span>); |
| <a class="jxr_linenumber" name="55" href="#55">55</a> assertEquals(query, st.toQueryString()); |
| <a class="jxr_linenumber" name="56" href="#56">56</a> } |
| <a class="jxr_linenumber" name="57" href="#57">57</a> |
| <a class="jxr_linenumber" name="58" href="#58">58</a> @Test |
| <a class="jxr_linenumber" name="59" href="#59">59</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testWherePlacholder() { |
| <a class="jxr_linenumber" name="60" href="#60">60</a> Session session = <strong class="jxr_keyword">new</strong> SessionImpl(<strong class="jxr_keyword">new</strong> HashMap<String, String>(), <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>); |
| <a class="jxr_linenumber" name="61" href="#61">61</a> String query; |
| <a class="jxr_linenumber" name="62" href="#62">62</a> QueryStatement st; |
| <a class="jxr_linenumber" name="63" href="#63">63</a> |
| <a class="jxr_linenumber" name="64" href="#64">64</a> <em class="jxr_comment">// strings</em> |
| <a class="jxr_linenumber" name="65" href="#65">65</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string = ?"</span>; |
| <a class="jxr_linenumber" name="66" href="#66">66</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="67" href="#67">67</a> st.setString(1, <span class="jxr_string">"test"</span>); |
| <a class="jxr_linenumber" name="68" href="#68">68</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string = 'test'"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="69" href="#69">69</a> |
| <a class="jxr_linenumber" name="70" href="#70">70</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string = ?"</span>; |
| <a class="jxr_linenumber" name="71" href="#71">71</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="72" href="#72">72</a> st.setString(1, <span class="jxr_string">"te'st"</span>); |
| <a class="jxr_linenumber" name="73" href="#73">73</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string = 'te\\'st'"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="74" href="#74">74</a> |
| <a class="jxr_linenumber" name="75" href="#75">75</a> <em class="jxr_comment">// likes</em> |
| <a class="jxr_linenumber" name="76" href="#76">76</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string LIKE ?"</span>; |
| <a class="jxr_linenumber" name="77" href="#77">77</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="78" href="#78">78</a> st.setStringLike(1, <span class="jxr_string">"%test%"</span>); |
| <a class="jxr_linenumber" name="79" href="#79">79</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string LIKE '%test%'"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="80" href="#80">80</a> |
| <a class="jxr_linenumber" name="81" href="#81">81</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string LIKE ?"</span>; |
| <a class="jxr_linenumber" name="82" href="#82">82</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="83" href="#83">83</a> st.setStringLike(1, <span class="jxr_string">"\\_test\\%blah\\\\blah"</span>); |
| <a class="jxr_linenumber" name="84" href="#84">84</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:string LIKE '\\_test\\%blah\\\\\\\\blah'"</span>, |
| <a class="jxr_linenumber" name="85" href="#85">85</a> st.toQueryString()); |
| <a class="jxr_linenumber" name="86" href="#86">86</a> |
| <a class="jxr_linenumber" name="87" href="#87">87</a> <em class="jxr_comment">// contains</em> |
| <a class="jxr_linenumber" name="88" href="#88">88</a> |
| <a class="jxr_linenumber" name="89" href="#89">89</a> <em class="jxr_comment">// *, ? and - are treated as text search operators: 1st level escaping:</em> |
| <a class="jxr_linenumber" name="90" href="#90">90</a> <em class="jxr_comment">// none, 2nd level escaping: none</em> |
| <a class="jxr_linenumber" name="91" href="#91">91</a> <em class="jxr_comment">// \*, \? and \- are used as literals, 1st level escaping: none, 2nd</em> |
| <a class="jxr_linenumber" name="92" href="#92">92</a> <em class="jxr_comment">// level escaping: \\*, \\?, \\-</em> |
| <a class="jxr_linenumber" name="93" href="#93">93</a> <em class="jxr_comment">// ' and " are used as literals, 1st level escaping: \', \", 2nd level</em> |
| <a class="jxr_linenumber" name="94" href="#94">94</a> <em class="jxr_comment">// escaping: \\\', \\\",</em> |
| <a class="jxr_linenumber" name="95" href="#95">95</a> <em class="jxr_comment">// \ plus any other character, 1st level escaping \\ plus character, 2nd</em> |
| <a class="jxr_linenumber" name="96" href="#96">96</a> <em class="jxr_comment">// level: \\\\ plus character</em> |
| <a class="jxr_linenumber" name="97" href="#97">97</a> |
| <a class="jxr_linenumber" name="98" href="#98">98</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS(?)"</span>; |
| <a class="jxr_linenumber" name="99" href="#99">99</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="100" href="#100">100</a> st.setStringContains(1, <span class="jxr_string">"John's"</span>); |
| <a class="jxr_linenumber" name="101" href="#101">101</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('John\\\\\\'s')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="102" href="#102">102</a> st.setStringContains(1, <span class="jxr_string">"John'sPresentation-Version2"</span>); |
| <a class="jxr_linenumber" name="103" href="#103">103</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('John\\\\\\'sPresentation\\\\-Version2')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="104" href="#104">104</a> st.setStringContains(1, <span class="jxr_string">"search\\'"</span>); |
| <a class="jxr_linenumber" name="105" href="#105">105</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('search\\\\\\\\\\\\\\'')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="106" href="#106">106</a> st.setStringContains(1, <span class="jxr_string">"foo -bar"</span>); |
| <a class="jxr_linenumber" name="107" href="#107">107</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('foo -bar')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="108" href="#108">108</a> st.setStringContains(1, <span class="jxr_string">"foo*"</span>); |
| <a class="jxr_linenumber" name="109" href="#109">109</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('foo*')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="110" href="#110">110</a> st.setStringContains(1, <span class="jxr_string">"foo?"</span>); |
| <a class="jxr_linenumber" name="111" href="#111">111</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('foo?')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="112" href="#112">112</a> st.setStringContains(1, <span class="jxr_string">"foo\\-bar"</span>); |
| <a class="jxr_linenumber" name="113" href="#113">113</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('foo\\\\-bar')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="114" href="#114">114</a> st.setStringContains(1, <span class="jxr_string">"foo\\*"</span>); |
| <a class="jxr_linenumber" name="115" href="#115">115</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('foo\\\\\\\\*')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="116" href="#116">116</a> st.setStringContains(1, <span class="jxr_string">"foo\\?"</span>); |
| <a class="jxr_linenumber" name="117" href="#117">117</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('foo\\\\\\\\?')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="118" href="#118">118</a> st.setStringContains(1, <span class="jxr_string">"\"Cool\""</span>); |
| <a class="jxr_linenumber" name="119" href="#119">119</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('\\\\\"Cool\\\\\"')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="120" href="#120">120</a> st.setStringContains(1, <span class="jxr_string">"c:\\MyDocuments"</span>); |
| <a class="jxr_linenumber" name="121" href="#121">121</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('c:\\\\\\\\MyDocuments')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="122" href="#122">122</a> |
| <a class="jxr_linenumber" name="123" href="#123">123</a> <em class="jxr_comment">// ids</em> |
| <a class="jxr_linenumber" name="124" href="#124">124</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:id = ?"</span>; |
| <a class="jxr_linenumber" name="125" href="#125">125</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="126" href="#126">126</a> st.setId(1, <strong class="jxr_keyword">new</strong> ObjectIdImpl(<span class="jxr_string">"123"</span>)); |
| <a class="jxr_linenumber" name="127" href="#127">127</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:id = '123'"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="128" href="#128">128</a> |
| <a class="jxr_linenumber" name="129" href="#129">129</a> <em class="jxr_comment">// URIs</em> |
| <a class="jxr_linenumber" name="130" href="#130">130</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="131" href="#131">131</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:uri = ?"</span>; |
| <a class="jxr_linenumber" name="132" href="#132">132</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="133" href="#133">133</a> st.setUri(1, <strong class="jxr_keyword">new</strong> URI(<span class="jxr_string">"http://apache.org/test"</span>)); |
| <a class="jxr_linenumber" name="134" href="#134">134</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:uri = 'http://apache.org/test'"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="135" href="#135">135</a> } <strong class="jxr_keyword">catch</strong> (URISyntaxException e) { |
| <a class="jxr_linenumber" name="136" href="#136">136</a> fail(e.toString()); |
| <a class="jxr_linenumber" name="137" href="#137">137</a> } |
| <a class="jxr_linenumber" name="138" href="#138">138</a> |
| <a class="jxr_linenumber" name="139" href="#139">139</a> <em class="jxr_comment">// URLs</em> |
| <a class="jxr_linenumber" name="140" href="#140">140</a> <strong class="jxr_keyword">try</strong> { |
| <a class="jxr_linenumber" name="141" href="#141">141</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:url = ?"</span>; |
| <a class="jxr_linenumber" name="142" href="#142">142</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="143" href="#143">143</a> st.setUrl(1, <strong class="jxr_keyword">new</strong> URL(<span class="jxr_string">"http://apache.org/test"</span>)); |
| <a class="jxr_linenumber" name="144" href="#144">144</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:url = 'http://apache.org/test'"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="145" href="#145">145</a> } <strong class="jxr_keyword">catch</strong> (MalformedURLException e) { |
| <a class="jxr_linenumber" name="146" href="#146">146</a> fail(e.toString()); |
| <a class="jxr_linenumber" name="147" href="#147">147</a> } |
| <a class="jxr_linenumber" name="148" href="#148">148</a> |
| <a class="jxr_linenumber" name="149" href="#149">149</a> <em class="jxr_comment">// booleans</em> |
| <a class="jxr_linenumber" name="150" href="#150">150</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:bool = ?"</span>; |
| <a class="jxr_linenumber" name="151" href="#151">151</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="152" href="#152">152</a> st.setBoolean(1, <strong class="jxr_keyword">true</strong>); |
| <a class="jxr_linenumber" name="153" href="#153">153</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:bool = TRUE"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="154" href="#154">154</a> |
| <a class="jxr_linenumber" name="155" href="#155">155</a> <em class="jxr_comment">// numbers</em> |
| <a class="jxr_linenumber" name="156" href="#156">156</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:int = ? AND abc:int2 = 123"</span>; |
| <a class="jxr_linenumber" name="157" href="#157">157</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="158" href="#158">158</a> st.setNumber(1, 42); |
| <a class="jxr_linenumber" name="159" href="#159">159</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:int = 42 AND abc:int2 = 123"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="160" href="#160">160</a> |
| <a class="jxr_linenumber" name="161" href="#161">161</a> <em class="jxr_comment">// dateTime</em> |
| <a class="jxr_linenumber" name="162" href="#162">162</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP ?"</span>; |
| <a class="jxr_linenumber" name="163" href="#163">163</a> GregorianCalendar cal = <strong class="jxr_keyword">new</strong> GregorianCalendar(TimeZone.getTimeZone(<span class="jxr_string">"GMT"</span>)); |
| <a class="jxr_linenumber" name="164" href="#164">164</a> cal.clear(); |
| <a class="jxr_linenumber" name="165" href="#165">165</a> cal.set(2012, 1, 2, 3, 4, 5); |
| <a class="jxr_linenumber" name="166" href="#166">166</a> |
| <a class="jxr_linenumber" name="167" href="#167">167</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="168" href="#168">168</a> st.setDateTime(1, cal); |
| <a class="jxr_linenumber" name="169" href="#169">169</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP '2012-02-02T03:04:05.000Z'"</span>, |
| <a class="jxr_linenumber" name="170" href="#170">170</a> st.toQueryString()); |
| <a class="jxr_linenumber" name="171" href="#171">171</a> |
| <a class="jxr_linenumber" name="172" href="#172">172</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="173" href="#173">173</a> st.setDateTime(1, cal.getTimeInMillis()); |
| <a class="jxr_linenumber" name="174" href="#174">174</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP '2012-02-02T03:04:05.000Z'"</span>, |
| <a class="jxr_linenumber" name="175" href="#175">175</a> st.toQueryString()); |
| <a class="jxr_linenumber" name="176" href="#176">176</a> |
| <a class="jxr_linenumber" name="177" href="#177">177</a> <em class="jxr_comment">// dateTime Timestamp</em> |
| <a class="jxr_linenumber" name="178" href="#178">178</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime = ?"</span>; |
| <a class="jxr_linenumber" name="179" href="#179">179</a> |
| <a class="jxr_linenumber" name="180" href="#180">180</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="181" href="#181">181</a> st.setDateTimeTimestamp(1, cal); |
| <a class="jxr_linenumber" name="182" href="#182">182</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP '2012-02-02T03:04:05.000Z'"</span>, |
| <a class="jxr_linenumber" name="183" href="#183">183</a> st.toQueryString()); |
| <a class="jxr_linenumber" name="184" href="#184">184</a> |
| <a class="jxr_linenumber" name="185" href="#185">185</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="186" href="#186">186</a> st.setDateTimeTimestamp(1, cal.getTimeInMillis()); |
| <a class="jxr_linenumber" name="187" href="#187">187</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP '2012-02-02T03:04:05.000Z'"</span>, |
| <a class="jxr_linenumber" name="188" href="#188">188</a> st.toQueryString()); |
| <a class="jxr_linenumber" name="189" href="#189">189</a> |
| <a class="jxr_linenumber" name="190" href="#190">190</a> query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime IN (?)"</span>; |
| <a class="jxr_linenumber" name="191" href="#191">191</a> |
| <a class="jxr_linenumber" name="192" href="#192">192</a> st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="193" href="#193">193</a> st.setDateTimeTimestamp(1, cal.getTime(), cal.getTime()); |
| <a class="jxr_linenumber" name="194" href="#194">194</a> assertEquals(<span class="jxr_string">"SELECT * FROM cmis:document WHERE abc:dateTime "</span> |
| <a class="jxr_linenumber" name="195" href="#195">195</a> + <span class="jxr_string">"IN (TIMESTAMP '2012-02-02T03:04:05.000Z',TIMESTAMP '2012-02-02T03:04:05.000Z')"</span>, st.toQueryString()); |
| <a class="jxr_linenumber" name="196" href="#196">196</a> } |
| <a class="jxr_linenumber" name="197" href="#197">197</a> |
| <a class="jxr_linenumber" name="198" href="#198">198</a> <em class="jxr_comment">// @Test</em> |
| <a class="jxr_linenumber" name="199" href="#199">199</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testQueryApiEscaping() { |
| <a class="jxr_linenumber" name="200" href="#200">200</a> <em class="jxr_comment">// contains</em> |
| <a class="jxr_linenumber" name="201" href="#201">201</a> Session session = <strong class="jxr_keyword">new</strong> SessionImpl(<strong class="jxr_keyword">new</strong> HashMap<String, String>(), <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>, <strong class="jxr_keyword">null</strong>); |
| <a class="jxr_linenumber" name="202" href="#202">202</a> |
| <a class="jxr_linenumber" name="203" href="#203">203</a> String query = <span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS(?)"</span>; |
| <a class="jxr_linenumber" name="204" href="#204">204</a> String ss = <span class="jxr_string">"a\\xc"</span>; |
| <a class="jxr_linenumber" name="205" href="#205">205</a> assertEquals(4, ss.length()); |
| <a class="jxr_linenumber" name="206" href="#206">206</a> System.out.println(ss); |
| <a class="jxr_linenumber" name="207" href="#207">207</a> QueryStatement st = <strong class="jxr_keyword">new</strong> QueryStatementImpl(session, query); |
| <a class="jxr_linenumber" name="208" href="#208">208</a> st.setStringContains(1, <span class="jxr_string">"John's"</span>); |
| <a class="jxr_linenumber" name="209" href="#209">209</a> System.out.println(<span class="jxr_string">"setStringContains: "</span> + st.toQueryString()); |
| <a class="jxr_linenumber" name="210" href="#210">210</a> String expected = <span class="jxr_string">"SELECT * FROM cmis:document WHERE CONTAINS('John\\\'s')"</span>; |
| <a class="jxr_linenumber" name="211" href="#211">211</a> System.out.println(<span class="jxr_string">"Expected: "</span> + expected); |
| <a class="jxr_linenumber" name="212" href="#212">212</a> |
| <a class="jxr_linenumber" name="213" href="#213">213</a> assertEquals(expected, st.toQueryString()); |
| <a class="jxr_linenumber" name="214" href="#214">214</a> |
| <a class="jxr_linenumber" name="215" href="#215">215</a> } |
| <a class="jxr_linenumber" name="216" href="#216">216</a> |
| <a class="jxr_linenumber" name="217" href="#217">217</a> } |
| </pre> |
| <hr/><div id="footer">This page was automatically generated by <a href="http://maven.apache.org/">Maven</a></div></body> |
| </html> |
| |
