public void visit(DynamicCommand obj) { obj.setSql(replaceExpression(obj.getSql())); if (obj.getUsing() != null) { for (SetClause clause : obj.getUsing().getClauses()) { visit(clause); } } }
public void visit(DynamicCommand obj) { obj.setSql(replaceExpression(obj.getSql())); if (obj.getUsing() != null) { for (SetClause clause : obj.getUsing().getClauses()) { visit(clause); } } }
public void visit(DynamicCommand obj) { obj.setSql(replaceExpression(obj.getSql())); if (obj.getUsing() != null) { for (SetClause clause : obj.getUsing().getClauses()) { visit(clause); } } }
@Test public void testDynamicCommand() { List<ElementSymbol> symbols = new ArrayList<ElementSymbol>(); ElementSymbol a1 = new ElementSymbol("a1"); //$NON-NLS-1$ a1.setType(DataTypeManager.DefaultDataClasses.STRING); symbols.add(a1); DynamicCommand obj = new DynamicCommand(); Expression sql = new Constant("SELECT a1 FROM g WHERE a2 = 5"); //$NON-NLS-1$ obj.setSql(sql); obj.setAsColumns(symbols); obj.setAsClauseSet(true); obj.setIntoGroup(new GroupSymbol("#g")); //$NON-NLS-1$ helpTest(obj, "EXECUTE IMMEDIATE 'SELECT a1 FROM g WHERE a2 = 5' AS a1 string INTO #g"); //$NON-NLS-1$ }
public void testClone1() { List symbols = new ArrayList(); ElementSymbol a1 = new ElementSymbol("a1"); //$NON-NLS-1$ a1.setType(DataTypeManager.DefaultDataClasses.STRING); symbols.add(a1); DynamicCommand sqlCmd = new DynamicCommand(); Expression sql = new Constant("SELECT a1 FROM g WHERE a2 = 5"); //$NON-NLS-1$ sqlCmd.setSql(sql); sqlCmd.setAsColumns(symbols); sqlCmd.setAsClauseSet(true); sqlCmd.setIntoGroup(new GroupSymbol("#g")); //$NON-NLS-1$ UnitTestUtil.helpTestEquivalence(0, sqlCmd, sqlCmd.clone()); }
@Test public void testDynamicCommandStatement() throws Exception { List<ElementSymbol> symbols = new ArrayList<ElementSymbol>(); ElementSymbol a1 = new ElementSymbol("a1"); //$NON-NLS-1$ a1.setType(DataTypeManager.DefaultDataClasses.STRING); symbols.add(a1); DynamicCommand sqlCmd = new DynamicCommand(); Expression sql = new Constant("SELECT a1 FROM g WHERE a2 = 5"); //$NON-NLS-1$ sqlCmd.setSql(sql); sqlCmd.setAsColumns(symbols); sqlCmd.setAsClauseSet(true); sqlCmd.setIntoGroup(new GroupSymbol("#g")); //$NON-NLS-1$ CommandStatement cmdStmt = new CommandStatement(sqlCmd); helpStmtTest("exec string 'SELECT a1 FROM g WHERE a2 = 5' as a1 string into #g;", "EXECUTE IMMEDIATE 'SELECT a1 FROM g WHERE a2 = 5' AS a1 string INTO #g;", //$NON-NLS-1$ //$NON-NLS-2$ cmdStmt); }
@Test public void testDynamicCommandStatement1() throws Exception { List<ElementSymbol> symbols = new ArrayList<ElementSymbol>(); ElementSymbol a1 = new ElementSymbol("a1"); //$NON-NLS-1$ a1.setType(DataTypeManager.DefaultDataClasses.STRING); symbols.add(a1); ElementSymbol a2 = new ElementSymbol("a2"); //$NON-NLS-1$ a1.setType(DataTypeManager.DefaultDataClasses.INTEGER); symbols.add(a2); DynamicCommand sqlCmd = new DynamicCommand(); Expression sql = new ElementSymbol("z"); //$NON-NLS-1$ sqlCmd.setSql(sql); sqlCmd.setAsColumns(symbols); sqlCmd.setAsClauseSet(true); sqlCmd.setIntoGroup(new GroupSymbol("#g")); //$NON-NLS-1$ sqlCmd.setUpdatingModelCount(1); CommandStatement cmdStmt = new CommandStatement(sqlCmd); helpStmtTest("execute IMMEDIATE z as a1 string, a2 integer into #g update 1;", "EXECUTE IMMEDIATE z AS a1 string, a2 integer INTO #g UPDATE 1;", //$NON-NLS-1$ //$NON-NLS-2$ cmdStmt); }
/** * @see org.teiid.query.sql.lang.QueryCommand#clone() */ public Object clone() { DynamicCommand clone = new DynamicCommand(); clone.setSql((Expression)getSql().clone()); if (asColumns != null) { List<ElementSymbol> cloneColumns = LanguageObject.Util.deepClone(asColumns, ElementSymbol.class); clone.setAsColumns(cloneColumns); } if (intoGroup != null) { clone.setIntoGroup(intoGroup.clone()); } if (using != null) { clone.setUsing((SetClauseList)using.clone()); } clone.setUpdatingModelCount(getUpdatingModelCount()); copyMetadataState(clone); clone.setAsClauseSet(isAsClauseSet()); return clone; }
public void testClone3() { List symbols = new ArrayList(); ElementSymbol a1 = new ElementSymbol("a1"); //$NON-NLS-1$ a1.setType(DataTypeManager.DefaultDataClasses.STRING); symbols.add(a1); DynamicCommand sqlCmd = new DynamicCommand(); Expression sql = new Constant("SELECT a1 FROM g WHERE a2 = 5"); //$NON-NLS-1$ sqlCmd.setSql(sql); sqlCmd.setAsColumns(symbols); sqlCmd.setAsClauseSet(true); sqlCmd.setIntoGroup(new GroupSymbol("#g")); //$NON-NLS-1$ List projectedSymbols = sqlCmd.getProjectedSymbols(); UnitTestUtil.helpTestEquivalence(0, sqlCmd, sqlCmd.clone()); assertEquals(projectedSymbols, ((DynamicCommand)sqlCmd.clone()).getProjectedSymbols()); }
/** * @see org.teiid.query.sql.lang.QueryCommand#clone() */ public Object clone() { DynamicCommand clone = new DynamicCommand(); clone.setSql((Expression)getSql().clone()); if (asColumns != null) { List<ElementSymbol> cloneColumns = LanguageObject.Util.deepClone(asColumns, ElementSymbol.class); clone.setAsColumns(cloneColumns); } if (intoGroup != null) { clone.setIntoGroup(intoGroup.clone()); } if (using != null) { clone.setUsing((SetClauseList)using.clone()); } clone.setUpdatingModelCount(getUpdatingModelCount()); copyMetadataState(clone); clone.setAsClauseSet(isAsClauseSet()); return clone; }
/** * @see org.teiid.query.sql.lang.QueryCommand#clone() */ public Object clone() { DynamicCommand clone = new DynamicCommand(); clone.setSql((Expression)getSql().clone()); if (asColumns != null) { List<ElementSymbol> cloneColumns = LanguageObject.Util.deepClone(asColumns, ElementSymbol.class); clone.setAsColumns(cloneColumns); } if (intoGroup != null) { clone.setIntoGroup(intoGroup.clone()); } if (using != null) { clone.setUsing((SetClauseList)using.clone()); } clone.setUpdatingModelCount(getUpdatingModelCount()); copyMetadataState(clone); clone.setAsClauseSet(isAsClauseSet()); return clone; }
throw new QueryResolverException(QueryPlugin.Event.TEIID30100, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30100, sqlType)); dynamicCmd.setSql(ResolverUtil.convertExpression(dynamicCmd.getSql(), targetType, metadata));
throw new QueryResolverException(QueryPlugin.Event.TEIID30100, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30100, sqlType)); dynamicCmd.setSql(ResolverUtil.convertExpression(dynamicCmd.getSql(), targetType, metadata));
throw new QueryResolverException(QueryPlugin.Event.TEIID30100, QueryPlugin.Util.gs(QueryPlugin.Event.TEIID30100, sqlType)); dynamicCmd.setSql(ResolverUtil.convertExpression(dynamicCmd.getSql(), targetType, metadata));
@Test public void testDynamicCommandStatementWithUsing() throws Exception { SetClauseList using = new SetClauseList(); ElementSymbol a = new ElementSymbol("a"); //$NON-NLS-1$ using.addClause(a, new ElementSymbol("b")); //$NON-NLS-1$ DynamicCommand sqlCmd = new DynamicCommand(); Expression sql = new ElementSymbol("z"); //$NON-NLS-1$ sqlCmd.setSql(sql); sqlCmd.setUsing(using); CommandStatement cmdStmt = new CommandStatement(sqlCmd); helpStmtTest("execute immediate z using a=b;", "EXECUTE IMMEDIATE z USING a = b;", //$NON-NLS-1$ //$NON-NLS-2$ cmdStmt); }
dcStmt.setSql(sql); switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case AS:
dcStmt.setSql(sql); switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case AS:
dcStmt.setSql(sql); switch ((jj_ntk==-1)?jj_ntk():jj_ntk) { case AS: