QueryStatementTest xref

This project has retired. For details please refer to its Attic page.

1   /*
2    * Licensed to the Apache Software Foundation (ASF) under one
3    * or more contributor license agreements.  See the NOTICE file
4    * distributed with this work for additional information
5    * regarding copyright ownership.  The ASF licenses this file
6    * to you under the Apache License, Version 2.0 (the
7    * "License"); you may not use this file except in compliance
8    * with the License.  You may obtain a copy of the License at
9    *
10   * http://www.apache.org/licenses/LICENSE-2.0
11   *
12   * Unless required by applicable law or agreed to in writing,
13   * software distributed under the License is distributed on an
14   * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
15   * KIND, either express or implied.  See the License for the
16   * specific language governing permissions and limitations
17   * under the License.
18   */
19  package org.apache.chemistry.opencmis.client.runtime;
20  
21  import static org.junit.Assert.assertEquals;
22  
23  import java.util.GregorianCalendar;
24  import java.util.HashMap;
25  import java.util.TimeZone;
26  
27  import org.apache.chemistry.opencmis.client.api.QueryStatement;
28  import org.apache.chemistry.opencmis.client.api.Session;
29  import org.junit.Test;
30  
31  public class QueryStatementTest {
32  
33      @Test
34      public void testStaticQueries() {
35          Session session = new SessionImpl(new HashMap<String, String>(), null, null, null);
36          String query;
37          QueryStatement st;
38  
39          query = "SELECT cmis:name FROM cmis:folder";
40          st = new QueryStatementImpl(session, query);
41          assertEquals(query, st.toQueryString());
42  
43          query = "SELECT * FROM cmis:document WHERE cmis:createdBy = \'admin\' AND abc:int = 42";
44          st = new QueryStatementImpl(session, query);
45          assertEquals(query, st.toQueryString());
46          
47          query = "SELECT * FROM cmis:document WHERE abc:test = 'x?z'";
48          st = new QueryStatementImpl(session, query);
49          st.setString(1, "y");
50          assertEquals(query, st.toQueryString());
51      }
52  
53      @Test
54      public void testWherePlacholder() {
55          Session session = new SessionImpl(new HashMap<String, String>(), null, null, null);
56          String query;
57          QueryStatement st;
58  
59          // strings
60          query = "SELECT * FROM cmis:document WHERE abc:string = ?";
61          st = new QueryStatementImpl(session, query);
62          st.setString(1, "test");
63          assertEquals("SELECT * FROM cmis:document WHERE abc:string = 'test'", st.toQueryString());
64  
65          query = "SELECT * FROM cmis:document WHERE abc:string = ?";
66          st = new QueryStatementImpl(session, query);
67          st.setString(1, "te'st");
68          assertEquals("SELECT * FROM cmis:document WHERE abc:string = 'te\\'st'", st.toQueryString());
69  
70          // likes
71          query = "SELECT * FROM cmis:document WHERE abc:string LIKE ?";
72          st = new QueryStatementImpl(session, query);
73          st.setStringLike(1, "%test%");
74          assertEquals("SELECT * FROM cmis:document WHERE abc:string LIKE '%test%'", st.toQueryString());
75  
76          query = "SELECT * FROM cmis:document WHERE abc:string LIKE ?";
77          st = new QueryStatementImpl(session, query);
78          st.setStringLike(1, "\\_test\\%blah\\\\blah");
79          assertEquals("SELECT * FROM cmis:document WHERE abc:string LIKE '\\_test\\%blah\\\\\\\\blah'",
80                  st.toQueryString());
81  
82          // ids
83          query = "SELECT * FROM cmis:document WHERE abc:id = ?";
84          st = new QueryStatementImpl(session, query);
85          st.setId(1, new ObjectIdImpl("123"));
86          assertEquals("SELECT * FROM cmis:document WHERE abc:id = '123'", st.toQueryString());
87  
88          // booleans
89          query = "SELECT * FROM cmis:document WHERE abc:bool = ?";
90          st = new QueryStatementImpl(session, query);
91          st.setBoolean(1, true);
92          assertEquals("SELECT * FROM cmis:document WHERE abc:bool = TRUE", st.toQueryString());
93  
94          // numbers
95          query = "SELECT * FROM cmis:document WHERE abc:int = ? AND abc:int2 = 123";
96          st = new QueryStatementImpl(session, query);
97          st.setNumber(1, 42);
98          assertEquals("SELECT * FROM cmis:document WHERE abc:int = 42 AND abc:int2 = 123", st.toQueryString());
99  
100         // dateTime
101         query = "SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP ?";
102         GregorianCalendar cal = new GregorianCalendar(TimeZone.getTimeZone("GMT"));
103         cal.clear();
104         cal.set(2012, 1, 2, 3, 4, 5);
105 
106         st = new QueryStatementImpl(session, query);
107         st.setDateTime(1, cal);
108         assertEquals("SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP '2012-02-02T03:04:05.000Z'",
109                 st.toQueryString());
110 
111         st = new QueryStatementImpl(session, query);
112         st.setDateTime(1, cal.getTimeInMillis());
113         assertEquals("SELECT * FROM cmis:document WHERE abc:dateTime = TIMESTAMP '2012-02-02T03:04:05.000Z'",
114                 st.toQueryString());
115     }
116 }