You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@chemistry.apache.org by fg...@apache.org on 2011/04/04 19:14:14 UTC
svn commit: r1088686 -
/chemistry/opencmis/trunk/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/src/test/java/org/apache/chemistry/opencmis/inmemory/query/QueryTypesTest.java
Author: fguillaume
Date: Mon Apr 4 17:14:14 2011
New Revision: 1088686
URL: http://svn.apache.org/viewvc?rev=1088686&view=rev
Log:
fix whitespace
Modified:
chemistry/opencmis/trunk/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/src/test/java/org/apache/chemistry/opencmis/inmemory/query/QueryTypesTest.java
Modified: chemistry/opencmis/trunk/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/src/test/java/org/apache/chemistry/opencmis/inmemory/query/QueryTypesTest.java
URL: http://svn.apache.org/viewvc/chemistry/opencmis/trunk/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/src/test/java/org/apache/chemistry/opencmis/inmemory/query/QueryTypesTest.java?rev=1088686&r1=1088685&r2=1088686&view=diff
==============================================================================
--- chemistry/opencmis/trunk/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/src/test/java/org/apache/chemistry/opencmis/inmemory/query/QueryTypesTest.java (original)
+++ chemistry/opencmis/trunk/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/src/test/java/org/apache/chemistry/opencmis/inmemory/query/QueryTypesTest.java Mon Apr 4 17:14:14 2011
@@ -42,7 +42,7 @@ import org.junit.Before;
import org.junit.Test;
public class QueryTypesTest extends AbstractQueryTest {
-
+
private static Log LOG = LogFactory.getLog(QueryTypesTest.class);
private TypeManagerImpl tm;
@@ -50,12 +50,12 @@ public class QueryTypesTest extends Abst
public void setUp() throws Exception {
tm = new TypeManagerImpl();
tm.initTypeSystem(null); // create CMIS default types
-
+
// create some types for testing
List<TypeDefinition> typeDefs = super.createTypes();
for (TypeDefinition typeDef : typeDefs)
tm.addTypeDefinition(typeDef);
-
+
// initialize query object with type manager
super.setUp(new QueryObject(tm), null);
}
@@ -66,31 +66,31 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesTest1() throws Exception {
- String statement = "SELECT " + TITLE_PROP + ", " + AUTHOR_PROP + " FROM " + BOOK_TYPE + " AS BooksAlias WHERE " + ISBN_PROP + " = '100'";
+ String statement = "SELECT " + TITLE_PROP + ", " + AUTHOR_PROP + " FROM " + BOOK_TYPE + " AS BooksAlias WHERE " + ISBN_PROP + " = '100'";
verifyResolveSelect(statement);
}
-
+
@Test
public void resolveTypesTest2() throws Exception {
- String statement = "SELECT BookType.Title, BookType.Author FROM BookType WHERE ISBN = '100'";
+ String statement = "SELECT BookType.Title, BookType.Author FROM BookType WHERE ISBN = '100'";
verifyResolveSelect(statement);
}
@Test
public void resolveTypesTest3() throws Exception {
- String statement = "SELECT BookType.Title, BookType.Author FROM BookType AS BooksAlias WHERE ISBN = '100'";
+ String statement = "SELECT BookType.Title, BookType.Author FROM BookType AS BooksAlias WHERE ISBN = '100'";
verifyResolveSelect(statement);
}
-
+
@Test
public void resolveTypesTest4() throws Exception {
- String statement = "SELECT BooksAlias.Title, BooksAlias.Author FROM BookType AS BooksAlias WHERE ISBN = '100'";
+ String statement = "SELECT BooksAlias.Title, BooksAlias.Author FROM BookType AS BooksAlias WHERE ISBN = '100'";
verifyResolveSelect(statement);
}
@Test
public void resolveTypesTest5() throws Exception {
- String statement = "SELECT BooksAlias.Title AS abc, BooksAlias.Author def FROM BookType AS BooksAlias WHERE ISBN = '100'";
+ String statement = "SELECT BooksAlias.Title AS abc, BooksAlias.Author def FROM BookType AS BooksAlias WHERE ISBN = '100'";
verifyResolveSelect(statement);
}
@@ -121,19 +121,19 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesTest8() throws Exception {
- String statement = "SELECT BookType.Title, BookType.Author FROM BookType WHERE ISBN = '100'";
+ String statement = "SELECT BookType.Title, BookType.Author FROM BookType WHERE ISBN = '100'";
verifyResolveSelect(statement);
}
@Test
public void resolveTypesTest9() throws Exception {
- String statement = "SELECT BookType.Author, Title TitleAlias FROM BookType WHERE TitleAlias <> 'Harry Potter'";
+ String statement = "SELECT BookType.Author, Title TitleAlias FROM BookType WHERE TitleAlias <> 'Harry Potter'";
verifyResolveSelect(statement);
}
@Test
public void resolveTypesTest10() throws Exception {
- String statement = "SELECT BookType.Author, BookType.Title TitleAlias FROM BookType WHERE TitleAlias <> 'Harry Potter'";
+ String statement = "SELECT BookType.Author, BookType.Title TitleAlias FROM BookType WHERE TitleAlias <> 'Harry Potter'";
verifyResolveSelect(statement);
}
@@ -151,11 +151,11 @@ public class QueryTypesTest extends Abst
assertTrue(colRef.getPropertyQueryName().equals(TITLE_PROP) || colRef.getPropertyQueryName().equals(AUTHOR_PROP));
}
}
-
+
@Test
public void resolveTypesWithTwoFromsQualified() throws Exception {
- String statement = "SELECT BookType.Title, MyDocType.MyStringProp FROM BookType JOIN MyDocType WHERE BookType.ISBN = '100'";
-
+ String statement = "SELECT BookType.Title, MyDocType.MyStringProp FROM BookType JOIN MyDocType WHERE BookType.ISBN = '100'";
+
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
Map<String,String> types = queryObj.getTypes();
@@ -169,13 +169,13 @@ public class QueryTypesTest extends Abst
colRef = ((ColumnReference) selects.get(1));
assertEquals(colRef.getTypeDefinition(), myType);
- assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
+ assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
}
@Test
public void resolveTypesWithTwoFromsUnqualified() throws Exception {
- String statement = "SELECT Title, MyStringProp FROM BookType JOIN MyDocType AS MyDocAlias WHERE BookType.ISBN = '100'";
-
+ String statement = "SELECT Title, MyStringProp FROM BookType JOIN MyDocType AS MyDocAlias WHERE BookType.ISBN = '100'";
+
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
Map<String,String> types = queryObj.getTypes();
@@ -189,13 +189,13 @@ public class QueryTypesTest extends Abst
colRef = ((ColumnReference) selects.get(1));
assertEquals(colRef.getTypeDefinition(), myType);
- assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
+ assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
}
@Test
public void resolveTypesWithTwoFromsNotUnique() throws Exception {
- String statement = "SELECT MyStringProp FROM MyDocTypeCopy JOIN MyDocType";
-
+ String statement = "SELECT MyStringProp FROM MyDocTypeCopy JOIN MyDocType";
+
try {
traverseStatement(statement);
fail("Select with an unqualified property that is not unique should fail.");
@@ -207,8 +207,8 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesWithTwoFromsUniqueByQualifying() throws Exception {
- String statement = "SELECT MyDocType.MyStringProp FROM MyDocTypeCopy JOIN MyDocType";
-
+ String statement = "SELECT MyDocType.MyStringProp FROM MyDocTypeCopy JOIN MyDocType";
+
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
Map<String,String> types = queryObj.getTypes();
@@ -217,12 +217,12 @@ public class QueryTypesTest extends Abst
assertTrue(1 == selects.size());
ColumnReference colRef = ((ColumnReference) selects.get(0));
assertEquals(myType, colRef.getTypeDefinition());
- assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
+ assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
}
@Test
public void resolveTypesTest11() throws Exception {
- String statement = "SELECT BookType.* FROM BookType WHERE ISBN = '100'";
+ String statement = "SELECT BookType.* FROM BookType WHERE ISBN = '100'";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
Map<String,String> types = queryObj.getTypes();
@@ -230,13 +230,13 @@ public class QueryTypesTest extends Abst
List<CmisSelector> selects = queryObj.getSelectReferences();
assertTrue(1 == selects.size());
ColumnReference colRef = ((ColumnReference) selects.get(0));
- assertTrue(colRef.getPropertyQueryName().equals("*"));
+ assertTrue(colRef.getPropertyQueryName().equals("*"));
assertEquals(bookType, colRef.getTypeDefinition());
}
@Test
public void resolveTypesTest12() throws Exception {
- String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType";
+ String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
Map<String,String> types = queryObj.getTypes();
@@ -244,37 +244,37 @@ public class QueryTypesTest extends Abst
List<CmisSelector> selects = queryObj.getSelectReferences();
assertTrue(1 == selects.size());
ColumnReference colRef = ((ColumnReference) selects.get(0));
- assertTrue(colRef.getPropertyQueryName().equals("*"));
+ assertTrue(colRef.getPropertyQueryName().equals("*"));
assertEquals(null, colRef.getTypeDefinition());
}
-
+
@Test
public void resolveTypesWhere1() throws Exception {
- String statement = "SELECT * FROM BookType WHERE ISBN = '100'";
+ String statement = "SELECT * FROM BookType WHERE ISBN = '100'";
verifyResolveWhere(statement);
}
@Test
public void resolveTypesWhere2() throws Exception {
- String statement = "SELECT * FROM BookType WHERE BookType.ISBN = '100'";
+ String statement = "SELECT * FROM BookType WHERE BookType.ISBN = '100'";
verifyResolveWhere(statement);
}
@Test
public void resolveTypesWhere3() throws Exception {
- String statement = "SELECT * FROM BookType As BookAlias WHERE BookAlias.ISBN = '100'";
+ String statement = "SELECT * FROM BookType As BookAlias WHERE BookAlias.ISBN = '100'";
verifyResolveWhere(statement);
}
@Test
public void resolveTypesWhere4() throws Exception {
- String statement = "SELECT BookType.ISBN IsbnAlias FROM BookType WHERE IsbnAlias < '100'";
+ String statement = "SELECT BookType.ISBN IsbnAlias FROM BookType WHERE IsbnAlias < '100'";
verifyResolveWhere(statement);
}
@Test
public void resolveTypesWhereWithTwoFromsUnqualified() throws Exception {
- String statement = "SELECT * FROM BookType JOIN MyDocType WHERE ISBN = '100'";
+ String statement = "SELECT * FROM BookType JOIN MyDocType WHERE ISBN = '100'";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<CmisSelector> wheres = queryObj.getWhereReferences();
@@ -289,7 +289,7 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesWhereWithTwoFromsQualified() throws Exception {
- String statement = "SELECT * FROM BookType JOIN MyDocType AS MyDocAlias WHERE BookType.ISBN = '100'";
+ String statement = "SELECT * FROM BookType JOIN MyDocType AS MyDocAlias WHERE BookType.ISBN = '100'";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<CmisSelector> wheres = queryObj.getWhereReferences();
@@ -301,11 +301,11 @@ public class QueryTypesTest extends Abst
assertTrue(colRef.getPropertyQueryName().equals(ISBN_PROP));
}
}
-
+
@Test
public void resolveTypesWhereWithTwoFromsQualifiedWithAlias() throws Exception {
- String statement = "SELECT * FROM BookType AS MyBookAlias JOIN MyDocType WHERE MyBookAlias.ISBN = '100'";
+ String statement = "SELECT * FROM BookType AS MyBookAlias JOIN MyDocType WHERE MyBookAlias.ISBN = '100'";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<CmisSelector> wheres = queryObj.getWhereReferences();
@@ -321,7 +321,7 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesWhereWithTwoFromsQualifiedWithAlias2() throws Exception {
// String statement = "SELECT X.aaa FROM MyType AS X WHERE 10 = ANY X.aaa ";
- String statement = "SELECT MyBookAlias.Title FROM BookType AS MyBookAlias WHERE MyBookAlias.ISBN = '100'";
+ String statement = "SELECT MyBookAlias.Title FROM BookType AS MyBookAlias WHERE MyBookAlias.ISBN = '100'";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<CmisSelector> wheres = queryObj.getWhereReferences();
@@ -332,7 +332,7 @@ public class QueryTypesTest extends Abst
assertEquals(colRef.getTypeDefinition(), bookType);
}
}
-
+
private void verifyResolveWhere(String statement) throws Exception {
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
@@ -350,8 +350,8 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesWhereWithTwoFromsNotUnique() throws Exception {
- String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType WHERE MyStringProp = '100'";
-
+ String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType WHERE MyStringProp = '100'";
+
try {
traverseStatement(statement);
fail("Select with an unqualified property that is not unique should fail.");
@@ -360,10 +360,10 @@ public class QueryTypesTest extends Abst
assertTrue(e.toString().contains("is not a unique property query name within the types in from"));
}
}
-
+
@Test
public void resolveTypesWhereWithTwoFromsUniqueByQualifying() throws Exception {
- String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType WHERE MyDocType.MyStringProp = '100'";
+ String statement = "SELECT * FROM MyDocTypeCopy JOIN MyDocType WHERE MyDocType.MyStringProp = '100'";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<CmisSelector> wheres = queryObj.getWhereReferences();
@@ -378,7 +378,7 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesOrderBy() throws Exception {
- String statement = "SELECT Title AS TitleAlias FROM BookType WHERE Author = 'Jim' ORDER BY TitleAlias";
+ String statement = "SELECT Title AS TitleAlias FROM BookType WHERE Author = 'Jim' ORDER BY TitleAlias";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<SortSpec> sorts = queryObj.getOrderBys();
@@ -393,7 +393,7 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesOrderBy2() throws Exception {
- String statement = "SELECT Title AS TitleAlias FROM BookType WHERE Author = 'Jim' ORDER BY BookType.Author";
+ String statement = "SELECT Title AS TitleAlias FROM BookType WHERE Author = 'Jim' ORDER BY BookType.Author";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<SortSpec> sorts = queryObj.getOrderBys();
@@ -408,7 +408,7 @@ public class QueryTypesTest extends Abst
@Test
public void resolveTypesOrderBy3() throws Exception {
- String statement = "SELECT Title FROM BookType WHERE ISBN < '100' ORDER BY Author";
+ String statement = "SELECT Title FROM BookType WHERE ISBN < '100' ORDER BY Author";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<SortSpec> sorts = queryObj.getOrderBys();
@@ -423,7 +423,7 @@ public class QueryTypesTest extends Abst
@Test
public void resolveJoinTypesSimple() throws Exception {
- String statement = "SELECT * FROM MyDocType JOIN BookType ON MyDocType.MyStringProp = BookType.Title";
+ String statement = "SELECT * FROM MyDocType JOIN BookType ON MyDocType.MyStringProp = BookType.Title";
CmisQueryWalker walker = traverseStatement(statement);
assertNotNull(walker);
List<CmisSelector> joins = queryObj.getJoinReferences();
@@ -435,11 +435,11 @@ public class QueryTypesTest extends Abst
assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
} else if (bookType.equals(colRef.getTypeDefinition())) {
assertTrue(colRef.getPropertyQueryName().equals(TITLE_PROP));
- } else
+ } else
fail("Unexpected type in JOIN reference");
}
}
-
+
@Test
public void resolveJoinTypesWithAlias() throws Exception {
String statement = "SELECT Y.ISBN, X.MyBooleanProp, Y.Author FROM (MyDocType AS X JOIN BookType AS Y ON X.MyStringProp = Y.Title) "+
@@ -458,7 +458,7 @@ public class QueryTypesTest extends Abst
assertTrue(colRef.getPropertyQueryName().equals(STRING_PROP));
} else if (bookType.equals(colRef.getTypeDefinition())) {
assertTrue(colRef.getPropertyQueryName().equals(TITLE_PROP));
- } else
+ } else
fail("Unexpected type in JOIN reference");
}
}