public boolean returnsResultParameter() { for (SPParameter parameter : parameters) { if (parameter.getParameterType() == ParameterInfo.RETURN_VALUE) { return true; } } return false; }
public boolean returnsResultSet() { for (SPParameter parameter : parameters) { if (parameter.getParameterType() == ParameterInfo.RESULT_SET) { return true; } } return false; }
public boolean returnsResultParameter() { for (SPParameter parameter : parameters) { if (parameter.getParameterType() == ParameterInfo.RETURN_VALUE) { return true; } } return false; }
public boolean returnsResultSet() { for (SPParameter parameter : parameters) { if (parameter.getParameterType() == ParameterInfo.RESULT_SET) { return true; } } return false; }
public boolean returnsResultParameter() { for (SPParameter parameter : parameters) { if (parameter.getParameterType() == ParameterInfo.RETURN_VALUE) { return true; } } return false; }
public boolean returnsResultSet() { for (SPParameter parameter : parameters) { if (parameter.getParameterType() == ParameterInfo.RESULT_SET) { return true; } } return false; }
public boolean returnsScalarValue(){ for (SPParameter param : this.mapOfParameters.values()) { if (param.getParameterType() == SPParameter.RETURN_VALUE) { return true; } } return false; }
public boolean returnsScalarValue(){ for (SPParameter param : this.mapOfParameters.values()) { if (param.getParameterType() == SPParameter.RETURN_VALUE) { return true; } } return false; }
public boolean returnsScalarValue(){ for (SPParameter param : this.mapOfParameters.values()) { if (param.getParameterType() == SPParameter.RETURN_VALUE) { return true; } } return false; }
public List<SPParameter> getInputParameters() { List<SPParameter> parameters = new ArrayList<SPParameter>(getParameters()); Iterator<SPParameter> params = parameters.iterator(); while (params.hasNext()) { SPParameter param = params.next(); if(param.getParameterType() != ParameterInfo.IN && param.getParameterType() != ParameterInfo.INOUT) { params.remove(); } } return parameters; }
public List<SPParameter> getInputParameters() { List<SPParameter> parameters = new ArrayList<SPParameter>(getParameters()); Iterator<SPParameter> params = parameters.iterator(); while (params.hasNext()) { SPParameter param = params.next(); if(param.getParameterType() != ParameterInfo.IN && param.getParameterType() != ParameterInfo.INOUT) { params.remove(); } } return parameters; }
public List<SPParameter> getInputParameters() { List<SPParameter> parameters = new ArrayList<SPParameter>(getParameters()); Iterator<SPParameter> params = parameters.iterator(); while (params.hasNext()) { SPParameter param = params.next(); if(param.getParameterType() != ParameterInfo.IN && param.getParameterType() != ParameterInfo.INOUT) { params.remove(); } } return parameters; }
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; }
@Override public boolean isReturingParams() { if (userCommand instanceof StoredProcedure) { StoredProcedure sp = (StoredProcedure)userCommand; if (sp.isCallableStatement() && sp.returnsResultSet()) { for (SPParameter param : sp.getMapOfParameters().values()) { int type = param.getParameterType(); if (type == SPParameter.INOUT || type == SPParameter.OUT || type == SPParameter.RETURN_VALUE) { return true; } } } } return false; }
@Override public boolean isReturingParams() { if (userCommand instanceof StoredProcedure) { StoredProcedure sp = (StoredProcedure)userCommand; if (sp.isCallableStatement() && sp.returnsResultSet()) { for (SPParameter param : sp.getMapOfParameters().values()) { int type = param.getParameterType(); if (type == SPParameter.INOUT || type == SPParameter.OUT || type == SPParameter.RETURN_VALUE) { return true; } } } } return false; }
@Override public boolean isReturingParams() { if (userCommand instanceof StoredProcedure) { StoredProcedure sp = (StoredProcedure)userCommand; if (sp.isCallableStatement() && sp.returnsResultSet()) { for (SPParameter param : sp.getMapOfParameters().values()) { int type = param.getParameterType(); if (type == SPParameter.INOUT || type == SPParameter.OUT || type == SPParameter.RETURN_VALUE) { return true; } } } } return false; }
@Test public void testStoredProcedure_9822() throws Exception { QueryParser parser = new QueryParser(); Command command = parser.parseCommand("exec pm1.sp4(5)"); //$NON-NLS-1$ // resolve QueryMetadataInterface metadata = RealMetadataFactory.example1Cached(); QueryResolver.resolveCommand(command, metadata); // rewrite Command rewriteCommand = QueryRewriter.rewrite(command, metadata, null); Collection<SPParameter> parameters = ((StoredProcedure)rewriteCommand).getParameters(); for (SPParameter param : parameters) { if(param.getParameterType() == ParameterInfo.IN || param.getParameterType() == ParameterInfo.INOUT){ assertTrue(param.getExpression() instanceof Constant); } } }
private void helpCheckParameter(SPParameter param, int paramType, int index, String name, Class<?> type, Expression expr) { assertEquals("Did not get expected parameter type", paramType, param.getParameterType()); //$NON-NLS-1$ assertEquals("Did not get expected index for param", index, param.getIndex()); //$NON-NLS-1$ assertEquals("Did not get expected name for param", name, param.getName()); //$NON-NLS-1$ assertEquals("Did not get expected type for param", type, param.getClassType()); //$NON-NLS-1$ assertEquals("Did not get expected type for param", expr, param.getExpression()); //$NON-NLS-1$ }