public boolean returnsResultSet(){ SPParameter param = getResultSetParameter(); return param != null && !param.getResultSetColumns().isEmpty(); }
public int getNumberOfColumns(){ SPParameter resultSetParameter = getResultSetParameter(); if(resultSetParameter != null){ return resultSetParameter.getResultSetColumns().size(); } return 0; }
public boolean returnsResultSet(){ SPParameter param = getResultSetParameter(); return param != null && !param.getResultSetColumns().isEmpty(); }
public int getNumberOfColumns(){ SPParameter resultSetParameter = getResultSetParameter(); if(resultSetParameter != null){ return resultSetParameter.getResultSetColumns().size(); } return 0; }
public int getNumberOfColumns(){ SPParameter resultSetParameter = getResultSetParameter(); if(resultSetParameter != null){ return resultSetParameter.getResultSetColumns().size(); } return 0; }
public boolean returnsResultSet(){ SPParameter param = getResultSetParameter(); return param != null && !param.getResultSetColumns().isEmpty(); }
public List<ElementSymbol> getResultSetColumns(){ SPParameter resultSetParameter = getResultSetParameter(); if(resultSetParameter != null){ List<ElementSymbol> result = new ArrayList<ElementSymbol>(resultSetParameter.getResultSetColumns().size()); for (Iterator<ElementSymbol> i = resultSetParameter.getResultSetColumns().iterator(); i.hasNext();) { ElementSymbol symbol = i.next().clone(); symbol.setGroupSymbol(getGroup()); result.add(symbol); } return result; } return Collections.emptyList(); }
public List<ElementSymbol> getResultSetColumns(){ SPParameter resultSetParameter = getResultSetParameter(); if(resultSetParameter != null){ List<ElementSymbol> result = new ArrayList<ElementSymbol>(resultSetParameter.getResultSetColumns().size()); for (Iterator<ElementSymbol> i = resultSetParameter.getResultSetColumns().iterator(); i.hasNext();) { ElementSymbol symbol = i.next().clone(); symbol.setGroupSymbol(getGroup()); result.add(symbol); } return result; } return Collections.emptyList(); }
public List<ElementSymbol> getResultSetColumns(){ SPParameter resultSetParameter = getResultSetParameter(); if(resultSetParameter != null){ List<ElementSymbol> result = new ArrayList<ElementSymbol>(resultSetParameter.getResultSetColumns().size()); for (Iterator<ElementSymbol> i = resultSetParameter.getResultSetColumns().iterator(); i.hasNext();) { ElementSymbol symbol = i.next().clone(); symbol.setGroupSymbol(getGroup()); result.add(symbol); } return result; } return Collections.emptyList(); }
private static List<ParameterInfo> getParameterInfo(StoredProcedure procedure) { List<ParameterInfo> paramInfos = new ArrayList<ParameterInfo>(); for (SPParameter param : procedure.getParameters()) { ParameterInfo info = new ParameterInfo(param.getParameterType(), param.getResultSetColumns().size()); paramInfos.add(info); } return paramInfos; }
private static List<ParameterInfo> getParameterInfo(StoredProcedure procedure) { List<ParameterInfo> paramInfos = new ArrayList<ParameterInfo>(); for (SPParameter param : procedure.getParameters()) { ParameterInfo info = new ParameterInfo(param.getParameterType(), param.getResultSetColumns().size()); paramInfos.add(info); } return paramInfos; }
private static List<ParameterInfo> getParameterInfo(StoredProcedure procedure) { List<ParameterInfo> paramInfos = new ArrayList<ParameterInfo>(); for (SPParameter param : procedure.getParameters()) { ParameterInfo info = new ParameterInfo(param.getParameterType(), param.getResultSetColumns().size()); paramInfos.add(info); } return paramInfos; }
static List getProcResultSetSymbols(List params){ List result = new ArrayList(); Iterator iter = params.iterator(); while(iter.hasNext()){ SPParameter param = (SPParameter)iter.next(); if(param.getResultSetColumns() != null){ result.addAll(param.getResultSetColumns()); } } iter = params.iterator(); while(iter.hasNext()){ SPParameter param = (SPParameter)iter.next(); if(param.getParameterType() == ParameterInfo.INOUT || param.getParameterType() == ParameterInfo.RETURN_VALUE) { result.add(param.getParameterSymbol()); } } return result; }
rsColumns = param.getResultSetColumns();
rsColumns = param.getResultSetColumns();
rsColumns = param.getResultSetColumns();
@Override public void visit(AlterProcedure obj) { GroupSymbol gs = obj.getTarget(); try { validateAlterTarget(obj); if (!gs.isProcedure() || !getMetadata().isVirtualModel(getMetadata().getModelID(gs.getMetadataID()))) { handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.not_a_procedure", gs), gs); //$NON-NLS-1$ return; } Validator.validate(obj.getDefinition(), getMetadata(), this); StoredProcedureInfo info = getMetadata().getStoredProcedureInfoForProcedure(gs.getName()); for (SPParameter param : info.getParameters()) { if (param.getParameterType() == SPParameter.RESULT_SET) { QueryResolver.validateProjectedSymbols(gs, param.getResultSetColumns(), obj.getDefinition().getProjectedSymbols()); break; } } } catch (QueryValidatorException e) { handleValidationError(e.getMessage(), obj.getDefinition().getBlock()); } catch (TeiidComponentException e) { handleException(e); } }
@Override public void visit(AlterProcedure obj) { GroupSymbol gs = obj.getTarget(); try { validateAlterTarget(obj); if (!gs.isProcedure() || !getMetadata().isVirtualModel(getMetadata().getModelID(gs.getMetadataID()))) { handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.not_a_procedure", gs), gs); //$NON-NLS-1$ return; } Validator.validate(obj.getDefinition(), getMetadata(), this); StoredProcedureInfo info = getMetadata().getStoredProcedureInfoForProcedure(gs.getName()); for (SPParameter param : info.getParameters()) { if (param.getParameterType() == SPParameter.RESULT_SET) { QueryResolver.validateProjectedSymbols(gs, param.getResultSetColumns(), obj.getDefinition().getProjectedSymbols()); break; } } } catch (QueryValidatorException e) { handleValidationError(e.getMessage(), obj.getDefinition().getBlock()); } catch (TeiidComponentException e) { handleException(e); } }
@Override public void visit(AlterProcedure obj) { GroupSymbol gs = obj.getTarget(); validateAlterTarget(obj); try { if (!gs.isProcedure() || !getMetadata().isVirtualModel(getMetadata().getModelID(gs.getMetadataID()))) { handleValidationError(QueryPlugin.Util.getString("ValidationVisitor.not_a_procedure", gs), gs); //$NON-NLS-1$ return; } Validator.validate(obj.getDefinition(), getMetadata(), this); StoredProcedureInfo info = getMetadata().getStoredProcedureInfoForProcedure(gs.getName()); for (SPParameter param : info.getParameters()) { if (param.getParameterType() == SPParameter.RESULT_SET) { QueryResolver.validateProjectedSymbols(gs, param.getResultSetColumns(), obj.getDefinition().getProjectedSymbols()); break; } } } catch (QueryValidatorException e) { handleValidationError(e.getMessage(), obj.getDefinition().getBlock()); } catch (TeiidComponentException e) { handleException(e); } }