Package org.teiid.language

Examples of org.teiid.language.Select

120
121
122
123
124
125
126
127
128
129
    }   

  private static TranslationUtility translationUtility = new TranslationUtility(exampleSalesforce());

  @Test public void testOr() throws Exception {
    Select command = (Select)translationUtility.parseCommand("select * from Account where Name = 'foo' or Stuff = 'bar'"); //$NON-NLS-1$
    SelectVisitor visitor = new SelectVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT Account.id, Account.AccountName, Account.Stuff, Account.Industry FROM Account WHERE (Account.AccountName = 'foo') OR (Account.Stuff = 'bar')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
    visitor.visit(command);
    assertEquals("SELECT Account.id, Account.AccountName, Account.Stuff, Account.Industry FROM Account WHERE (Account.AccountName = 'foo') OR (Account.Stuff = 'bar')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
 
  @Test public void testNot() throws Exception {
    Select command = (Select)translationUtility.parseCommand("select * from Account where not (Name = 'foo' and Stuff = 'bar')"); //$NON-NLS-1$
    SelectVisitor visitor = new SelectVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT Account.id, Account.AccountName, Account.Stuff, Account.Industry FROM Account WHERE (Account.AccountName != 'foo') OR (Account.Stuff != 'bar')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
    visitor.visit(command);
    assertEquals("SELECT Account.id, Account.AccountName, Account.Stuff, Account.Industry FROM Account WHERE (Account.AccountName != 'foo') OR (Account.Stuff != 'bar')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
 
  @Test public void testCountStart() throws Exception {
    Select command = (Select)translationUtility.parseCommand("select count(*) from Account"); //$NON-NLS-1$
    SelectVisitor visitor = new SelectVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT count() FROM Account", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
141
142
143
144
145
146
147
148
149
150
    visitor.visit(command);
    assertEquals("SELECT count() FROM Account", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
 
  @Test public void testNotLike() throws Exception {
    Select command = (Select)translationUtility.parseCommand("select * from Account where Name not like '%foo' or Stuff = 'bar'"); //$NON-NLS-1$
    SelectVisitor visitor = new SelectVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT Account.id, Account.AccountName, Account.Stuff, Account.Industry FROM Account WHERE (NOT (Account.AccountName LIKE '%foo')) OR (Account.Stuff = 'bar')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
149
150
151
152
153
154
155
156
157
158
159
    assertEquals("SELECT Account.id, Account.AccountName, Account.Stuff, Account.Industry FROM Account WHERE (NOT (Account.AccountName LIKE '%foo')) OR (Account.Stuff = 'bar')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }

 
  @Test public void testIN() throws Exception {
    Select command = (Select)translationUtility.parseCommand("select * from Account where Industry IN (1,2,3)"); //$NON-NLS-1$
    SelectVisitor visitor = new SelectVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertFalse(visitor.hasOnlyIDCriteria());
    assertEquals("SELECT Account.id, Account.AccountName, Account.Stuff, Account.Industry FROM Account WHERE Industry IN('1','2','3')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
   
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
   
  }

  @Test public void testOnlyIDsIN() throws Exception {
    // this can resolve to a better performing retrieve call
    Select command = (Select)translationUtility.parseCommand("select * from Account where ID IN (1,2,3)"); //$NON-NLS-1$
    SelectVisitor visitor = new SelectVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertTrue(visitor.hasOnlyIdInCriteria());
    assertEquals("Account", visitor.getTableName());
    assertEquals("Account.id, Account.AccountName, Account.Stuff, Account.Industry", visitor.getRetrieveFieldList());
View Full Code Here
169
170
171
172
173
174
175
176
177
178
    assertEquals("Account.id, Account.AccountName, Account.Stuff, Account.Industry", visitor.getRetrieveFieldList());
    assertEquals(Arrays.asList(new String[]{"1", "2", "3"}), visitor.getIdInCriteria()); 
  }
 
  @Test public void testJoin() throws Exception {
    Select command = (Select)translationUtility.parseCommand("SELECT Account.Name, Contacts.Name FROM Contacts LEFT OUTER JOIN Account ON Account.Id = Contacts.AccountId"); //$NON-NLS-1$
    SelectVisitor visitor = new JoinQueryVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT Account.AccountName, Contact.ContactName FROM Contact", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
176
177
178
179
180
181
182
183
184
185
    visitor.visit(command);
    assertEquals("SELECT Account.AccountName, Contact.ContactName FROM Contact", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
 
  @Test public void testJoin2() throws Exception {
    Select command = (Select)translationUtility.parseCommand("SELECT Account.Name, Contacts.Name FROM Account LEFT OUTER JOIN Contacts ON Account.Id = Contacts.AccountId"); //$NON-NLS-1$
    SelectVisitor visitor = new JoinQueryVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT Account.AccountName, (SELECT Contact.ContactName FROM Contacts) FROM Account", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
183
184
185
186
187
188
189
190
191
192
    visitor.visit(command);
    assertEquals("SELECT Account.AccountName, (SELECT Contact.ContactName FROM Contacts) FROM Account", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
 
  @Test public void testJoin3() throws Exception {
    Select command = (Select)translationUtility.parseCommand("SELECT Contacts.Name FROM Account LEFT OUTER JOIN Contacts ON Account.Id = Contacts.AccountId"); //$NON-NLS-1$
    SelectVisitor visitor = new JoinQueryVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT (SELECT Contact.ContactName FROM Contacts) FROM Account", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
190
191
192
193
194
195
196
197
198
199
    visitor.visit(command);
    assertEquals("SELECT (SELECT Contact.ContactName FROM Contacts) FROM Account", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
 
  @Test public void testInWithNameInSourceDifferent() throws Exception {
    Select command = (Select)translationUtility.parseCommand("SELECT Contacts.Name FROM Contacts WHERE Contacts.Name in ('x', 'y')"); //$NON-NLS-1$
    SelectVisitor visitor = new SelectVisitor(translationUtility.createRuntimeMetadata());
    visitor.visit(command);
    assertEquals("SELECT Contact.ContactName FROM Contact WHERE ContactName IN('x','y')", visitor.getQuery().toString().trim()); //$NON-NLS-1$
  }
View Full Code Here
TOP

Related Classes of org.teiid.language.Select

  • org.teiid.cdk.api.TestTranslationUtility
  • org.teiid.connector.language.TestLanguageUtil
  • org.teiid.connector.metadata.runtime.TestElement
  • org.teiid.connector.metadata.runtime.TestGroup
  • org.teiid.connector.metadata.runtime.TestMetadataObject
  • org.teiid.connector.visitor.util.TestCollectorVisitor
  • org.teiid.connector.visitor.util.TestSQLStringVisitor
  • org.teiid.dqp.internal.datamgr.LanguageBridgeFactory
  • org.teiid.dqp.internal.datamgr.TestScalarSubqueryImpl
  • org.teiid.dqp.internal.datamgr.TestSelectSymbolImpl
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.