Google Git
Sign in
apache / juddi / refs/heads/asf-site / . / juddi-core / xref / org / apache / juddi / query / FindEntityByIdentifierQuery.html
blob: 06904388e992d2008ea744cbb952a43655fdb556 [file] [log] [blame]
<!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>FindEntityByIdentifierQuery xref</title>
<link type="text/css" rel="stylesheet" href="../../../../stylesheet.css" />
</head>
<body>
<div id="overview"><a href="../../../../../apidocs/org/apache/juddi/query/FindEntityByIdentifierQuery.html">View Javadoc</a></div><pre>
<a class="jxr_linenumber" name="L1" href="#L1">1</a> <em class="jxr_comment">/*</em>
<a class="jxr_linenumber" name="L2" href="#L2">2</a> <em class="jxr_comment"> * Copyright 2001-2008 The Apache Software Foundation.</em>
<a class="jxr_linenumber" name="L3" href="#L3">3</a> <em class="jxr_comment"> * </em>
<a class="jxr_linenumber" name="L4" href="#L4">4</a> <em class="jxr_comment"> * Licensed under the Apache License, Version 2.0 (the "License");</em>
<a class="jxr_linenumber" name="L5" href="#L5">5</a> <em class="jxr_comment"> * you may not use this file except in compliance with the License.</em>
<a class="jxr_linenumber" name="L6" href="#L6">6</a> <em class="jxr_comment"> * You may obtain a copy of the License at</em>
<a class="jxr_linenumber" name="L7" href="#L7">7</a> <em class="jxr_comment"> * </em>
<a class="jxr_linenumber" name="L8" href="#L8">8</a> <em class="jxr_comment"> * <a href="http://www.apache.org/licenses/LICENSE-2." target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.</a>0</em>
<a class="jxr_linenumber" name="L9" href="#L9">9</a> <em class="jxr_comment"> * </em>
<a class="jxr_linenumber" name="L10" href="#L10">10</a> <em class="jxr_comment"> * Unless required by applicable law or agreed to in writing, software</em>
<a class="jxr_linenumber" name="L11" href="#L11">11</a> <em class="jxr_comment"> * distributed under the License is distributed on an "AS IS" BASIS,</em>
<a class="jxr_linenumber" name="L12" href="#L12">12</a> <em class="jxr_comment"> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</em>
<a class="jxr_linenumber" name="L13" href="#L13">13</a> <em class="jxr_comment"> * See the License for the specific language governing permissions and</em>
<a class="jxr_linenumber" name="L14" href="#L14">14</a> <em class="jxr_comment"> * limitations under the License.</em>
<a class="jxr_linenumber" name="L15" href="#L15">15</a> <em class="jxr_comment"> *</em>
<a class="jxr_linenumber" name="L16" href="#L16">16</a> <em class="jxr_comment"> */</em>
<a class="jxr_linenumber" name="L17" href="#L17">17</a>
<a class="jxr_linenumber" name="L18" href="#L18">18</a> <strong class="jxr_keyword">package</strong> org.apache.juddi.query;
<a class="jxr_linenumber" name="L19" href="#L19">19</a>
<a class="jxr_linenumber" name="L20" href="#L20">20</a> <strong class="jxr_keyword">import</strong> java.util.Collections;
<a class="jxr_linenumber" name="L21" href="#L21">21</a> <strong class="jxr_keyword">import</strong> java.util.List;
<a class="jxr_linenumber" name="L22" href="#L22">22</a>
<a class="jxr_linenumber" name="L23" href="#L23">23</a> <strong class="jxr_keyword">import</strong> javax.persistence.EntityManager;
<a class="jxr_linenumber" name="L24" href="#L24">24</a>
<a class="jxr_linenumber" name="L25" href="#L25">25</a> <strong class="jxr_keyword">import</strong> org.apache.commons.logging.Log;
<a class="jxr_linenumber" name="L26" href="#L26">26</a> <strong class="jxr_keyword">import</strong> org.apache.commons.logging.LogFactory;
<a class="jxr_linenumber" name="L27" href="#L27">27</a> <strong class="jxr_keyword">import</strong> org.apache.juddi.config.Constants;
<a class="jxr_linenumber" name="L28" href="#L28">28</a> <strong class="jxr_keyword">import</strong> org.apache.juddi.query.util.DynamicQuery;
<a class="jxr_linenumber" name="L29" href="#L29">29</a> <strong class="jxr_keyword">import</strong> org.apache.juddi.query.util.FindQualifiers;
<a class="jxr_linenumber" name="L30" href="#L30">30</a> <strong class="jxr_keyword">import</strong> org.apache.juddi.query.util.KeyedRefTModelComparator;
<a class="jxr_linenumber" name="L31" href="#L31">31</a> <strong class="jxr_keyword">import</strong> org.uddi.api_v3.IdentifierBag;
<a class="jxr_linenumber" name="L32" href="#L32">32</a> <strong class="jxr_keyword">import</strong> org.uddi.api_v3.KeyedReference;
<a class="jxr_linenumber" name="L33" href="#L33">33</a>
<a class="jxr_linenumber" name="L34" href="#L34">34</a> <em class="jxr_javadoccomment">/**</em>
<a class="jxr_linenumber" name="L35" href="#L35">35</a> <em class="jxr_javadoccomment"> * Returns the list of "entity" keys possessing the keyedReferences in the passed identifier bag.</em>
<a class="jxr_linenumber" name="L36" href="#L36">36</a> <em class="jxr_javadoccomment"> * Output is restricted by list of "entity" keys passed in. If null, all entities are searched.</em>
<a class="jxr_linenumber" name="L37" href="#L37">37</a> <em class="jxr_javadoccomment"> * Output is produced by building the appropriate JPA query based on input and find qualifiers.</em>
<a class="jxr_linenumber" name="L38" href="#L38">38</a> <em class="jxr_javadoccomment"> * </em>
<a class="jxr_linenumber" name="L39" href="#L39">39</a> <em class="jxr_javadoccomment"> * NOTES:</em>
<a class="jxr_linenumber" name="L40" href="#L40">40</a> <em class="jxr_javadoccomment"> * 1) Identifiers are grouped with a logical OR by default.</em>
<a class="jxr_linenumber" name="L41" href="#L41">41</a> <em class="jxr_javadoccomment"> * 2) In the case that the "andAllKeys" find qualifier is used the identifiers are AND'd together. The only way this can be done</em>
<a class="jxr_linenumber" name="L42" href="#L42">42</a> <em class="jxr_javadoccomment"> * with a single query was to create a self-join for each identifier. If there are a lot of identifiers, the performance could suffer.</em>
<a class="jxr_linenumber" name="L43" href="#L43">43</a> <em class="jxr_javadoccomment"> * TODO: Test performance with multiple AND'd identifiers. If too slow, look to process this query in multiple steps.</em>
<a class="jxr_linenumber" name="L44" href="#L44">44</a> <em class="jxr_javadoccomment"> * 3) The "orLikeKeys" qualifier complicates matters. The "like" keys are OR'd together and these groups of "like" keys are AND'd together.</em>
<a class="jxr_linenumber" name="L45" href="#L45">45</a> <em class="jxr_javadoccomment"> * As with "andAllKeys", self-joins are created but only one for each group of "like" keys. If none of the keyedReferences passed are alike then this</em>
<a class="jxr_linenumber" name="L46" href="#L46">46</a> <em class="jxr_javadoccomment"> * will reduce to an "andAllKeys" query. If all are alike, then this will query will exhibit the default behavior of OR'ing all keys.</em>
<a class="jxr_linenumber" name="L47" href="#L47">47</a> <em class="jxr_javadoccomment"> * </em>
<a class="jxr_linenumber" name="L48" href="#L48">48</a> <em class="jxr_javadoccomment"> * @author &lt;a href="<a href="mailto:jfaath@apache.org" target="alexandria_uri">mailto:jfaath@apache.org</a>"&gt;Jeff Faath&lt;/a&gt;</em>
<a class="jxr_linenumber" name="L49" href="#L49">49</a> <em class="jxr_javadoccomment"> */</em>
<a class="jxr_linenumber" name="L50" href="#L50">50</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../org/apache/juddi/query/FindEntityByIdentifierQuery.html">FindEntityByIdentifierQuery</a> <strong class="jxr_keyword">extends</strong> <a href="../../../../org/apache/juddi/query/EntityQuery.html">EntityQuery</a> {
<a class="jxr_linenumber" name="L51" href="#L51">51</a>
<a class="jxr_linenumber" name="L52" href="#L52">52</a> @SuppressWarnings(<span class="jxr_string">"unused"</span>)
<a class="jxr_linenumber" name="L53" href="#L53">53</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> <strong class="jxr_keyword">static</strong> Log log = LogFactory.getLog(FindEntityByIdentifierQuery.<strong class="jxr_keyword">class</strong>);
<a class="jxr_linenumber" name="L54" href="#L54">54</a>
<a class="jxr_linenumber" name="L55" href="#L55">55</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String entityName;
<a class="jxr_linenumber" name="L56" href="#L56">56</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String entityAlias;
<a class="jxr_linenumber" name="L57" href="#L57">57</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String keyName;
<a class="jxr_linenumber" name="L58" href="#L58">58</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String entityField;
<a class="jxr_linenumber" name="L59" href="#L59">59</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String entityNameChild;
<a class="jxr_linenumber" name="L60" href="#L60">60</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String entityAliasChild;
<a class="jxr_linenumber" name="L61" href="#L61">61</a> <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">final</strong> String selectSQL;
<a class="jxr_linenumber" name="L62" href="#L62">62</a> <strong class="jxr_keyword">private</strong> String signaturePresent;
<a class="jxr_linenumber" name="L63" href="#L63">63</a>
<a class="jxr_linenumber" name="L64" href="#L64">64</a> <strong class="jxr_keyword">public</strong> <a href="../../../../org/apache/juddi/query/FindEntityByIdentifierQuery.html">FindEntityByIdentifierQuery</a>(String entityName, String entityAlias, String keyName,
<a class="jxr_linenumber" name="L65" href="#L65">65</a> String entityField, String entityNameChild, String signaturePresent) {
<a class="jxr_linenumber" name="L66" href="#L66">66</a> <strong class="jxr_keyword">this</strong>.entityName = entityName;
<a class="jxr_linenumber" name="L67" href="#L67">67</a> <strong class="jxr_keyword">this</strong>.entityAlias = entityAlias;
<a class="jxr_linenumber" name="L68" href="#L68">68</a> <strong class="jxr_keyword">this</strong>.keyName = keyName;
<a class="jxr_linenumber" name="L69" href="#L69">69</a> <strong class="jxr_keyword">this</strong>.entityField = entityField;
<a class="jxr_linenumber" name="L70" href="#L70">70</a> <strong class="jxr_keyword">this</strong>.entityNameChild = entityNameChild;
<a class="jxr_linenumber" name="L71" href="#L71">71</a> <strong class="jxr_keyword">this</strong>.entityAliasChild = buildAlias(entityNameChild);
<a class="jxr_linenumber" name="L72" href="#L72">72</a> <strong class="jxr_keyword">this</strong>.signaturePresent = signaturePresent;
<a class="jxr_linenumber" name="L73" href="#L73">73</a>
<a class="jxr_linenumber" name="L74" href="#L74">74</a> StringBuilder sql = <strong class="jxr_keyword">new</strong> StringBuilder(200);
<a class="jxr_linenumber" name="L75" href="#L75">75</a> sql.append(<span class="jxr_string">"select distinct "</span>).append(entityAlias).append(<span class="jxr_string">"."</span>).append(keyName).append(<span class="jxr_string">" from "</span>).append(entityName).append(<span class="jxr_string">" "</span>).append(entityAlias).append(<span class="jxr_string">" "</span>);
<a class="jxr_linenumber" name="L76" href="#L76">76</a> selectSQL = sql.toString();
<a class="jxr_linenumber" name="L77" href="#L77">77</a> }
<a class="jxr_linenumber" name="L78" href="#L78">78</a>
<a class="jxr_linenumber" name="L79" href="#L79">79</a> <strong class="jxr_keyword">public</strong> String getEntityName() {
<a class="jxr_linenumber" name="L80" href="#L80">80</a> <strong class="jxr_keyword">return</strong> entityName;
<a class="jxr_linenumber" name="L81" href="#L81">81</a> }
<a class="jxr_linenumber" name="L82" href="#L82">82</a>
<a class="jxr_linenumber" name="L83" href="#L83">83</a> <strong class="jxr_keyword">public</strong> String getEntityAlias() {
<a class="jxr_linenumber" name="L84" href="#L84">84</a> <strong class="jxr_keyword">return</strong> entityAlias;
<a class="jxr_linenumber" name="L85" href="#L85">85</a> }
<a class="jxr_linenumber" name="L86" href="#L86">86</a>
<a class="jxr_linenumber" name="L87" href="#L87">87</a> <strong class="jxr_keyword">public</strong> String getKeyName() {
<a class="jxr_linenumber" name="L88" href="#L88">88</a> <strong class="jxr_keyword">return</strong> keyName;
<a class="jxr_linenumber" name="L89" href="#L89">89</a> }
<a class="jxr_linenumber" name="L90" href="#L90">90</a>
<a class="jxr_linenumber" name="L91" href="#L91">91</a> <strong class="jxr_keyword">public</strong> String getEntityField() {
<a class="jxr_linenumber" name="L92" href="#L92">92</a> <strong class="jxr_keyword">return</strong> entityField;
<a class="jxr_linenumber" name="L93" href="#L93">93</a> }
<a class="jxr_linenumber" name="L94" href="#L94">94</a>
<a class="jxr_linenumber" name="L95" href="#L95">95</a> <strong class="jxr_keyword">public</strong> String getEntityNameChild() {
<a class="jxr_linenumber" name="L96" href="#L96">96</a> <strong class="jxr_keyword">return</strong> entityNameChild;
<a class="jxr_linenumber" name="L97" href="#L97">97</a> }
<a class="jxr_linenumber" name="L98" href="#L98">98</a>
<a class="jxr_linenumber" name="L99" href="#L99">99</a> <strong class="jxr_keyword">public</strong> String getEntityAliasChild() {
<a class="jxr_linenumber" name="L100" href="#L100">100</a> <strong class="jxr_keyword">return</strong> entityAliasChild;
<a class="jxr_linenumber" name="L101" href="#L101">101</a> }
<a class="jxr_linenumber" name="L102" href="#L102">102</a>
<a class="jxr_linenumber" name="L103" href="#L103">103</a> <strong class="jxr_keyword">public</strong> String getSelectSQL() {
<a class="jxr_linenumber" name="L104" href="#L104">104</a> <strong class="jxr_keyword">return</strong> selectSQL;
<a class="jxr_linenumber" name="L105" href="#L105">105</a> }
<a class="jxr_linenumber" name="L106" href="#L106">106</a>
<a class="jxr_linenumber" name="L107" href="#L107">107</a> <strong class="jxr_keyword">public</strong> String getSignaturePresent() {
<a class="jxr_linenumber" name="L108" href="#L108">108</a> <strong class="jxr_keyword">return</strong> signaturePresent;
<a class="jxr_linenumber" name="L109" href="#L109">109</a> }
<a class="jxr_linenumber" name="L110" href="#L110">110</a>
<a class="jxr_linenumber" name="L111" href="#L111">111</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setSignaturePresent(String signaturePresent) {
<a class="jxr_linenumber" name="L112" href="#L112">112</a> <strong class="jxr_keyword">this</strong>.signaturePresent = signaturePresent;
<a class="jxr_linenumber" name="L113" href="#L113">113</a> }
<a class="jxr_linenumber" name="L114" href="#L114">114</a>
<a class="jxr_linenumber" name="L115" href="#L115">115</a>
<a class="jxr_linenumber" name="L116" href="#L116">116</a> <strong class="jxr_keyword">public</strong> List&lt;Object&gt; select(EntityManager em, <a href="../../../../org/apache/juddi/query/util/FindQualifiers.html">FindQualifiers</a> fq, IdentifierBag identifiers, List&lt;Object&gt; keysIn, DynamicQuery.Parameter... restrictions) {
<a class="jxr_linenumber" name="L117" href="#L117">117</a> <em class="jxr_comment">// If keysIn is not null and empty, then search is over.</em>
<a class="jxr_linenumber" name="L118" href="#L118">118</a> <strong class="jxr_keyword">if</strong> ((keysIn != <strong class="jxr_keyword">null</strong>) &amp;&amp; (keysIn.size() == 0))
<a class="jxr_linenumber" name="L119" href="#L119">119</a> <strong class="jxr_keyword">return</strong> keysIn;
<a class="jxr_linenumber" name="L120" href="#L120">120</a>
<a class="jxr_linenumber" name="L121" href="#L121">121</a> <strong class="jxr_keyword">if</strong> (identifiers == <strong class="jxr_keyword">null</strong>)
<a class="jxr_linenumber" name="L122" href="#L122">122</a> <strong class="jxr_keyword">return</strong> keysIn;
<a class="jxr_linenumber" name="L123" href="#L123">123</a>
<a class="jxr_linenumber" name="L124" href="#L124">124</a> List&lt;KeyedReference&gt; keyedRefs = identifiers.getKeyedReference();
<a class="jxr_linenumber" name="L125" href="#L125">125</a> <strong class="jxr_keyword">if</strong> (keyedRefs == <strong class="jxr_keyword">null</strong> || keyedRefs.size() == 0)
<a class="jxr_linenumber" name="L126" href="#L126">126</a> <strong class="jxr_keyword">return</strong> keysIn;
<a class="jxr_linenumber" name="L127" href="#L127">127</a>
<a class="jxr_linenumber" name="L128" href="#L128">128</a> DynamicQuery dynamicQry = <strong class="jxr_keyword">new</strong> <a href="../../../../org/apache/juddi/query/util/DynamicQuery.html">DynamicQuery</a>(selectSQL);
<a class="jxr_linenumber" name="L129" href="#L129">129</a> appendConditions(dynamicQry, fq, keyedRefs);
<a class="jxr_linenumber" name="L130" href="#L130">130</a> <strong class="jxr_keyword">if</strong> (restrictions != <strong class="jxr_keyword">null</strong> &amp;&amp; restrictions.length &gt; 0)
<a class="jxr_linenumber" name="L131" href="#L131">131</a> dynamicQry.AND().pad().appendGroupedAnd(restrictions);
<a class="jxr_linenumber" name="L132" href="#L132">132</a>
<a class="jxr_linenumber" name="L133" href="#L133">133</a> <strong class="jxr_keyword">return</strong> getQueryResult(em, dynamicQry, keysIn, entityAlias + <span class="jxr_string">"."</span> + keyName);
<a class="jxr_linenumber" name="L134" href="#L134">134</a> }
<a class="jxr_linenumber" name="L135" href="#L135">135</a>
<a class="jxr_linenumber" name="L136" href="#L136">136</a>
<a class="jxr_linenumber" name="L137" href="#L137">137</a> <em class="jxr_comment">/*</em>
<a class="jxr_linenumber" name="L138" href="#L138">138</a> <em class="jxr_comment"> * Appends the conditions to the query based on the keyedReference list. With the default or when "andAllKeys" is passed, the keyedReferences are autonomous and are</em>
<a class="jxr_linenumber" name="L139" href="#L139">139</a> <em class="jxr_comment"> * all OR'd or AND'd respectively. However, "orLikeKeys" requires special treatment. The goal is to create the conditions in this format:</em>
<a class="jxr_linenumber" name="L140" href="#L140">140</a> <em class="jxr_comment"> * </em>
<a class="jxr_linenumber" name="L141" href="#L141">141</a> <em class="jxr_comment"> * (likeKey1 = X or likeKey1 = Y) and (likeKey2 = A or likeKey2 = B or likeKey2 = C) </em>
<a class="jxr_linenumber" name="L142" href="#L142">142</a> <em class="jxr_comment"> * </em>
<a class="jxr_linenumber" name="L143" href="#L143">143</a> <em class="jxr_comment"> * ie. the "like" KeyedReferences are OR'd and the groups of "like" KeyedReferences are AND'd with each other.</em>
<a class="jxr_linenumber" name="L144" href="#L144">144</a> <em class="jxr_comment"> */</em>
<a class="jxr_linenumber" name="L145" href="#L145">145</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> appendConditions(<a href="../../../../org/apache/juddi/query/util/DynamicQuery.html">DynamicQuery</a> qry, <a href="../../../../org/apache/juddi/query/util/FindQualifiers.html">FindQualifiers</a> fq, List&lt;KeyedReference&gt; keyedRefs) {
<a class="jxr_linenumber" name="L146" href="#L146">146</a>
<a class="jxr_linenumber" name="L147" href="#L147">147</a> <em class="jxr_comment">// Append the necessary tables (one will always be added connecting the entity to its identifier table).</em>
<a class="jxr_linenumber" name="L148" href="#L148">148</a> appendJoinTables(qry, fq, keyedRefs);
<a class="jxr_linenumber" name="L149" href="#L149">149</a> qry.AND().pad().openParen().pad();
<a class="jxr_linenumber" name="L150" href="#L150">150</a>
<a class="jxr_linenumber" name="L151" href="#L151">151</a> String predicate = DynamicQuery.PREDICATE_EQUALS;
<a class="jxr_linenumber" name="L152" href="#L152">152</a> <strong class="jxr_keyword">if</strong> (fq.isApproximateMatch()) {
<a class="jxr_linenumber" name="L153" href="#L153">153</a> predicate = DynamicQuery.PREDICATE_LIKE;
<a class="jxr_linenumber" name="L154" href="#L154">154</a> }
<a class="jxr_linenumber" name="L155" href="#L155">155</a>
<a class="jxr_linenumber" name="L156" href="#L156">156</a> <em class="jxr_comment">// Sorting the collection by tModel Key</em>
<a class="jxr_linenumber" name="L157" href="#L157">157</a> Collections.sort(keyedRefs, <strong class="jxr_keyword">new</strong> <a href="../../../../org/apache/juddi/query/util/KeyedRefTModelComparator.html">KeyedRefTModelComparator</a>());
<a class="jxr_linenumber" name="L158" href="#L158">158</a>
<a class="jxr_linenumber" name="L159" href="#L159">159</a> String prevTModelKey = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L160" href="#L160">160</a> <strong class="jxr_keyword">int</strong> count = 0;
<a class="jxr_linenumber" name="L161" href="#L161">161</a> <strong class="jxr_keyword">int</strong> tblCount = -1;
<a class="jxr_linenumber" name="L162" href="#L162">162</a> <strong class="jxr_keyword">for</strong>(KeyedReference keyedRef : keyedRefs) {
<a class="jxr_linenumber" name="L163" href="#L163">163</a> String tmodelKey = keyedRef.getTModelKey();
<a class="jxr_linenumber" name="L164" href="#L164">164</a> String keyValue = keyedRef.getKeyValue();
<a class="jxr_linenumber" name="L165" href="#L165">165</a> String keyName = keyedRef.getKeyName();
<a class="jxr_linenumber" name="L166" href="#L166">166</a>
<a class="jxr_linenumber" name="L167" href="#L167">167</a> <strong class="jxr_keyword">if</strong> (fq.isApproximateMatch()) {
<a class="jxr_linenumber" name="L168" href="#L168">168</a> <em class="jxr_comment">// JUDDI-235: wildcards are provided by user (only commenting in case a new interpretation arises)</em>
<a class="jxr_linenumber" name="L169" href="#L169">169</a> <em class="jxr_comment">//keyValue = keyValue.endsWith(DynamicQuery.WILDCARD)?keyValue:keyValue + DynamicQuery.WILDCARD;</em>
<a class="jxr_linenumber" name="L170" href="#L170">170</a> <em class="jxr_comment">//keyName = keyName.endsWith(DynamicQuery.WILDCARD)?keyName:keyName + DynamicQuery.WILDCARD;</em>
<a class="jxr_linenumber" name="L171" href="#L171">171</a> }
<a class="jxr_linenumber" name="L172" href="#L172">172</a>
<a class="jxr_linenumber" name="L173" href="#L173">173</a> <em class="jxr_comment">// Either opening up (and AND'ing) a new "group" of like keys or simply appending an "or". If this is not "orLikeKeys", then just need to increment</em>
<a class="jxr_linenumber" name="L174" href="#L174">174</a> <em class="jxr_comment">// the table count.</em>
<a class="jxr_linenumber" name="L175" href="#L175">175</a> <strong class="jxr_keyword">if</strong> (fq.isOrLikeKeys()) {
<a class="jxr_linenumber" name="L176" href="#L176">176</a> <strong class="jxr_keyword">if</strong> (count == 0) {
<a class="jxr_linenumber" name="L177" href="#L177">177</a> qry.openParen().pad();
<a class="jxr_linenumber" name="L178" href="#L178">178</a> tblCount++;
<a class="jxr_linenumber" name="L179" href="#L179">179</a> }
<a class="jxr_linenumber" name="L180" href="#L180">180</a> <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L181" href="#L181">181</a> <strong class="jxr_keyword">if</strong> (!tmodelKey.equals(prevTModelKey)) {
<a class="jxr_linenumber" name="L182" href="#L182">182</a> qry.closeParen().pad().AND().pad().openParen().pad();
<a class="jxr_linenumber" name="L183" href="#L183">183</a> tblCount++;
<a class="jxr_linenumber" name="L184" href="#L184">184</a> }
<a class="jxr_linenumber" name="L185" href="#L185">185</a> <strong class="jxr_keyword">else</strong>
<a class="jxr_linenumber" name="L186" href="#L186">186</a> qry.OR().pad();
<a class="jxr_linenumber" name="L187" href="#L187">187</a> }
<a class="jxr_linenumber" name="L188" href="#L188">188</a> }
<a class="jxr_linenumber" name="L189" href="#L189">189</a> <strong class="jxr_keyword">else</strong>
<a class="jxr_linenumber" name="L190" href="#L190">190</a> tblCount++;
<a class="jxr_linenumber" name="L191" href="#L191">191</a>
<a class="jxr_linenumber" name="L192" href="#L192">192</a> String keyValueTerm = (fq.isAndAllKeys()||fq.isOrLikeKeys()?entityAliasChild + tblCount:entityAliasChild + <span class="jxr_string">"0"</span>) + <span class="jxr_string">".keyValue"</span>;
<a class="jxr_linenumber" name="L193" href="#L193">193</a> String keyNameTerm = (fq.isAndAllKeys()||fq.isOrLikeKeys()?entityAliasChild + tblCount:entityAliasChild + <span class="jxr_string">"0"</span>) + <span class="jxr_string">".keyName"</span>;
<a class="jxr_linenumber" name="L194" href="#L194">194</a> String tmodelKeyTerm = (fq.isAndAllKeys()||fq.isOrLikeKeys()?entityAliasChild + tblCount:entityAliasChild + <span class="jxr_string">"0"</span>) + <span class="jxr_string">".tmodelKeyRef"</span>;
<a class="jxr_linenumber" name="L195" href="#L195">195</a> <strong class="jxr_keyword">if</strong> (fq.isCaseInsensitiveMatch()) {
<a class="jxr_linenumber" name="L196" href="#L196">196</a> keyValueTerm = <span class="jxr_string">"upper("</span> + keyValueTerm + <span class="jxr_string">")"</span>;
<a class="jxr_linenumber" name="L197" href="#L197">197</a> keyValue = keyValue.toUpperCase();
<a class="jxr_linenumber" name="L198" href="#L198">198</a>
<a class="jxr_linenumber" name="L199" href="#L199">199</a> keyNameTerm = <span class="jxr_string">"upper("</span> + keyNameTerm + <span class="jxr_string">")"</span>;
<a class="jxr_linenumber" name="L200" href="#L200">200</a> keyName = keyName.toUpperCase();
<a class="jxr_linenumber" name="L201" href="#L201">201</a> }
<a class="jxr_linenumber" name="L202" href="#L202">202</a>
<a class="jxr_linenumber" name="L203" href="#L203">203</a>
<a class="jxr_linenumber" name="L204" href="#L204">204</a> <em class="jxr_comment">// According to specification, if the "general keyword" tmodel is used, then the keyName must be part of the query.</em>
<a class="jxr_linenumber" name="L205" href="#L205">205</a> <strong class="jxr_keyword">if</strong> (Constants.GENERAL_KEYWORD_TMODEL.equalsIgnoreCase(tmodelKey)) {
<a class="jxr_linenumber" name="L206" href="#L206">206</a> qry.appendGroupedAnd(<strong class="jxr_keyword">new</strong> DynamicQuery.Parameter(tmodelKeyTerm, tmodelKey, DynamicQuery.PREDICATE_EQUALS),
<a class="jxr_linenumber" name="L207" href="#L207">207</a> <strong class="jxr_keyword">new</strong> DynamicQuery.Parameter(keyValueTerm, keyValue, predicate),
<a class="jxr_linenumber" name="L208" href="#L208">208</a> <strong class="jxr_keyword">new</strong> DynamicQuery.Parameter(keyNameTerm, keyName, predicate));
<a class="jxr_linenumber" name="L209" href="#L209">209</a> }
<a class="jxr_linenumber" name="L210" href="#L210">210</a> <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L211" href="#L211">211</a> qry.appendGroupedAnd(<strong class="jxr_keyword">new</strong> DynamicQuery.Parameter(tmodelKeyTerm, tmodelKey, DynamicQuery.PREDICATE_EQUALS),
<a class="jxr_linenumber" name="L212" href="#L212">212</a> <strong class="jxr_keyword">new</strong> DynamicQuery.Parameter(keyValueTerm, keyValue, predicate));
<a class="jxr_linenumber" name="L213" href="#L213">213</a>
<a class="jxr_linenumber" name="L214" href="#L214">214</a> }
<a class="jxr_linenumber" name="L215" href="#L215">215</a>
<a class="jxr_linenumber" name="L216" href="#L216">216</a> <strong class="jxr_keyword">if</strong> (count + 1 &lt; keyedRefs.size()) {
<a class="jxr_linenumber" name="L217" href="#L217">217</a> <strong class="jxr_keyword">if</strong> (fq.isAndAllKeys())
<a class="jxr_linenumber" name="L218" href="#L218">218</a> qry.AND().pad();
<a class="jxr_linenumber" name="L219" href="#L219">219</a> <strong class="jxr_keyword">else</strong> <strong class="jxr_keyword">if</strong> (fq.isOrLikeKeys()) {
<a class="jxr_linenumber" name="L220" href="#L220">220</a> }
<a class="jxr_linenumber" name="L221" href="#L221">221</a> <strong class="jxr_keyword">else</strong>
<a class="jxr_linenumber" name="L222" href="#L222">222</a> qry.OR().pad();
<a class="jxr_linenumber" name="L223" href="#L223">223</a> }
<a class="jxr_linenumber" name="L224" href="#L224">224</a>
<a class="jxr_linenumber" name="L225" href="#L225">225</a> <em class="jxr_comment">// The "orLikeKeys" will always leave an unclosed parenthesis. This will close it.</em>
<a class="jxr_linenumber" name="L226" href="#L226">226</a> <strong class="jxr_keyword">if</strong> (fq.isOrLikeKeys() &amp;&amp; (count + 1 == keyedRefs.size()))
<a class="jxr_linenumber" name="L227" href="#L227">227</a> qry.closeParen().pad();
<a class="jxr_linenumber" name="L228" href="#L228">228</a>
<a class="jxr_linenumber" name="L229" href="#L229">229</a> prevTModelKey = tmodelKey;
<a class="jxr_linenumber" name="L230" href="#L230">230</a> count++;
<a class="jxr_linenumber" name="L231" href="#L231">231</a> }
<a class="jxr_linenumber" name="L232" href="#L232">232</a> qry.closeParen().pad();
<a class="jxr_linenumber" name="L233" href="#L233">233</a>
<a class="jxr_linenumber" name="L234" href="#L234">234</a> }
<a class="jxr_linenumber" name="L235" href="#L235">235</a>
<a class="jxr_linenumber" name="L236" href="#L236">236</a> <em class="jxr_comment">/*</em>
<a class="jxr_linenumber" name="L237" href="#L237">237</a> <em class="jxr_comment"> * Appends the necessary join table for the child entity and additional tables for when keys are AND'd. When "orLikeKeys" is used, </em>
<a class="jxr_linenumber" name="L238" href="#L238">238</a> <em class="jxr_comment"> * we only need an extra table for each distinct tmodelKey.</em>
<a class="jxr_linenumber" name="L239" href="#L239">239</a> <em class="jxr_comment"> */</em>
<a class="jxr_linenumber" name="L240" href="#L240">240</a> <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> appendJoinTables(<a href="../../../../org/apache/juddi/query/util/DynamicQuery.html">DynamicQuery</a> qry, <a href="../../../../org/apache/juddi/query/util/FindQualifiers.html">FindQualifiers</a> fq, List&lt;KeyedReference&gt; keyedRefs) {
<a class="jxr_linenumber" name="L241" href="#L241">241</a>
<a class="jxr_linenumber" name="L242" href="#L242">242</a> <strong class="jxr_keyword">if</strong> (keyedRefs != <strong class="jxr_keyword">null</strong> &amp;&amp; keyedRefs.size() &gt; 0) {
<a class="jxr_linenumber" name="L243" href="#L243">243</a> <em class="jxr_comment">// Sorting the collection by tModel Key</em>
<a class="jxr_linenumber" name="L244" href="#L244">244</a> Collections.sort(keyedRefs, <strong class="jxr_keyword">new</strong> <a href="../../../../org/apache/juddi/query/util/KeyedRefTModelComparator.html">KeyedRefTModelComparator</a>());
<a class="jxr_linenumber" name="L245" href="#L245">245</a>
<a class="jxr_linenumber" name="L246" href="#L246">246</a> StringBuffer thetaJoins = <strong class="jxr_keyword">new</strong> StringBuffer(200);
<a class="jxr_linenumber" name="L247" href="#L247">247</a> <strong class="jxr_keyword">int</strong> tblCount = 0;
<a class="jxr_linenumber" name="L248" href="#L248">248</a> <strong class="jxr_keyword">int</strong> count = 0;
<a class="jxr_linenumber" name="L249" href="#L249">249</a> String curTModelKey = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L250" href="#L250">250</a> String prevTModelKey = <strong class="jxr_keyword">null</strong>;
<a class="jxr_linenumber" name="L251" href="#L251">251</a> <strong class="jxr_keyword">for</strong>(KeyedReference kr : keyedRefs) {
<a class="jxr_linenumber" name="L252" href="#L252">252</a> curTModelKey = kr.getTModelKey();
<a class="jxr_linenumber" name="L253" href="#L253">253</a> <strong class="jxr_keyword">if</strong> (count != 0) {
<a class="jxr_linenumber" name="L254" href="#L254">254</a> <strong class="jxr_keyword">if</strong> (fq.isOrLikeKeys() &amp;&amp; curTModelKey.equals(prevTModelKey)) {
<a class="jxr_linenumber" name="L255" href="#L255">255</a> <em class="jxr_comment">// Do nothing</em>
<a class="jxr_linenumber" name="L256" href="#L256">256</a> }
<a class="jxr_linenumber" name="L257" href="#L257">257</a> <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L258" href="#L258">258</a> tblCount++;
<a class="jxr_linenumber" name="L259" href="#L259">259</a> qry.comma().pad().append(entityNameChild + <span class="jxr_string">" "</span> + entityAliasChild + tblCount).pad();
<a class="jxr_linenumber" name="L260" href="#L260">260</a> thetaJoins.append(entityAliasChild + (tblCount - 1) + <span class="jxr_string">"."</span> + entityField + <span class="jxr_string">"."</span> + keyName + <span class="jxr_string">" = "</span> + entityAliasChild + tblCount + <span class="jxr_string">"."</span> + entityField + <span class="jxr_string">"."</span> + keyName + <span class="jxr_string">" "</span>);
<a class="jxr_linenumber" name="L261" href="#L261">261</a> thetaJoins.append(DynamicQuery.OPERATOR_AND + <span class="jxr_string">" "</span>);
<a class="jxr_linenumber" name="L262" href="#L262">262</a> }
<a class="jxr_linenumber" name="L263" href="#L263">263</a>
<a class="jxr_linenumber" name="L264" href="#L264">264</a> }
<a class="jxr_linenumber" name="L265" href="#L265">265</a> <strong class="jxr_keyword">else</strong> {
<a class="jxr_linenumber" name="L266" href="#L266">266</a> qry.comma().pad().append(entityNameChild + <span class="jxr_string">" "</span> + entityAliasChild + tblCount).pad();
<a class="jxr_linenumber" name="L267" href="#L267">267</a> thetaJoins.append(entityAlias + <span class="jxr_string">"."</span> + keyName + <span class="jxr_string">" = "</span> + entityAliasChild + tblCount + <span class="jxr_string">"."</span> + entityField + <span class="jxr_string">"."</span> + keyName + <span class="jxr_string">" "</span>);
<a class="jxr_linenumber" name="L268" href="#L268">268</a> thetaJoins.append(DynamicQuery.OPERATOR_AND + <span class="jxr_string">" "</span>);
<a class="jxr_linenumber" name="L269" href="#L269">269</a> }
<a class="jxr_linenumber" name="L270" href="#L270">270</a> prevTModelKey = curTModelKey;
<a class="jxr_linenumber" name="L271" href="#L271">271</a> count++;
<a class="jxr_linenumber" name="L272" href="#L272">272</a> }
<a class="jxr_linenumber" name="L273" href="#L273">273</a>
<a class="jxr_linenumber" name="L274" href="#L274">274</a> qry.WHERE().pad().openParen().pad();
<a class="jxr_linenumber" name="L275" href="#L275">275</a>
<a class="jxr_linenumber" name="L276" href="#L276">276</a> String thetaJoinsStr = thetaJoins.toString();
<a class="jxr_linenumber" name="L277" href="#L277">277</a> <strong class="jxr_keyword">if</strong> (thetaJoinsStr.endsWith(DynamicQuery.OPERATOR_AND + <span class="jxr_string">" "</span>))
<a class="jxr_linenumber" name="L278" href="#L278">278</a> thetaJoinsStr = thetaJoinsStr.substring(0, thetaJoinsStr.length() - (DynamicQuery.OPERATOR_AND + <span class="jxr_string">" "</span>).length());
<a class="jxr_linenumber" name="L279" href="#L279">279</a> qry.append(thetaJoinsStr);
<a class="jxr_linenumber" name="L280" href="#L280">280</a>
<a class="jxr_linenumber" name="L281" href="#L281">281</a> qry.closeParen().pad();
<a class="jxr_linenumber" name="L282" href="#L282">282</a> <strong class="jxr_keyword">if</strong> (fq!=<strong class="jxr_keyword">null</strong> &amp;&amp; fq.isSignaturePresent()) {
<a class="jxr_linenumber" name="L283" href="#L283">283</a> qry.AND().pad().openParen().pad().append(getSignaturePresent()).pad().closeParen().pad();
<a class="jxr_linenumber" name="L284" href="#L284">284</a> }
<a class="jxr_linenumber" name="L285" href="#L285">285</a> }
<a class="jxr_linenumber" name="L286" href="#L286">286</a> }
<a class="jxr_linenumber" name="L287" href="#L287">287</a>
<a class="jxr_linenumber" name="L288" href="#L288">288</a> }
</pre>
<hr/>
<div id="footer">Copyright &#169; 2004&#x2013;2022 <a href="https://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</div>
</body>
</html>