Package org.teiid.cdk

Examples of org.teiid.cdk.CommandBuilder

509
510
511
512
513
514
515
516
517
    /** Helper method takes a QueryMetadataInterface impl instead of a VDB filename
     * @throws TranslatorException
     */
    private void helpTestVisitor(QueryMetadataInterface metadata, String input, ExecutionContext context, String dbmsTimeZone, String expectedOutput) throws TranslatorException {
        // Convert from sql to objects
        CommandBuilder commandBuilder = new CommandBuilder(metadata);
        Command obj = commandBuilder.getCommand(input);
    this.helpTestVisitor(obj, context, dbmsTimeZone, expectedOutput);
    }
View Full Code Here
761
762
763
764
765
766
767
768
769
   
    @Test public void testRowLimitWithUnionOrderBy() throws Exception {
        String input = "(select intkey from bqt1.smalla limit 50, 100) union select intnum from bqt1.smalla order by intkey"; //$NON-NLS-1$
        String output = "SELECT c_0 FROM (SELECT VIEW_FOR_LIMIT.*, ROWNUM ROWNUM_ FROM (SELECT g_1.IntKey AS c_0 FROM SmallA g_1) VIEW_FOR_LIMIT WHERE ROWNUM <= 150) WHERE ROWNUM_ > 50 UNION SELECT g_0.IntNum AS c_0 FROM SmallA g_0 ORDER BY c_0"; //$NON-NLS-1$
              
    CommandBuilder commandBuilder = new CommandBuilder(FakeMetadataFactory.exampleBQTCached());
        Command obj = commandBuilder.getCommand(input, true, true);
    this.helpTestVisitor(obj, EMPTY_CONTEXT, null, output);
    }
View Full Code Here
172
173
174
175
176
177
178
179
180
   
    @Test public void testRowLimitWithInlineViewOrderBy() throws Exception {
        String input = "select intkey from (select intkey from bqt1.smalla) as x order by intkey limit 100"; //$NON-NLS-1$
        String output = "SELECT TOP 100 v_0.c_0 FROM (SELECT g_0.IntKey AS c_0 FROM SmallA g_0) v_0 ORDER BY v_0.c_0"; //$NON-NLS-1$
              
    CommandBuilder commandBuilder = new CommandBuilder(FakeMetadataFactory.exampleBQTCached());
        Command obj = commandBuilder.getCommand(input, true, true);
        TranslationHelper.helpTestVisitor(output, trans, obj);
    }
View Full Code Here
73
74
75
76
77
78
79
80
    public TranslationUtility(QueryMetadataInterface metadata) {
      this.metadata = metadata;
    }
   
    public Command parseCommand(String sql, boolean generateAliases, boolean supportsGroupAliases) {
        CommandBuilder commandBuilder = new CommandBuilder(metadata);
        return commandBuilder.getCommand(sql, generateAliases, supportsGroupAliases);
    }
View Full Code Here
83
84
85
86
87
88
89
90
     * Parse a SQL command and return an ICommand object.
     * @param sql
     * @return Command using the language interfaces
     */
    public Command parseCommand(String sql) {
        CommandBuilder commandBuilder = new CommandBuilder(metadata);
        return commandBuilder.getCommand(sql);
    }
View Full Code Here
70
71
72
73
74
75
76
77
  /**
     * Get Resolved Command using SQL String and metadata.
     */
    public Command getCommand(String sql, QueryMetadataInterface metadata) {
      CommandBuilder builder = new CommandBuilder(metadata);
      return builder.getCommand(sql);
    }
View Full Code Here
TOP

Related Classes of org.teiid.cdk.CommandBuilder

  • org.teiid.cdk.api.TranslationUtility
  • org.teiid.dqp.internal.datamgr.LanguageBridgeFactory
  • org.teiid.query.optimizer.relational.AliasGenerator
  • org.teiid.query.sql.lang.Command
  • org.teiid.query.sql.lang.Query
  • org.teiid.query.sql.lang.Select
  • org.teiid.query.sql.symbol.AllSymbol
  • org.teiid.translator.jdbc.oracle.TestOracleTranslator
  • org.teiid.translator.jdbc.sqlserver.TestSqlServerConversionVisitor
  • org.teiid.translator.ldap.TestIQueryToLdapSearchParser
    • 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.