public ProcedureParameter getReturnParameter() { for (ProcedureParameter param : this.metadataObject.getParameters()) { if (param.getType() == Type.ReturnValue) { return param; } } return null; }
public String toString() { return getType()+(isVarArg?"... ":" ")+" "+super.toString(); //$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ }
private ProcedureParameter getReturnParameter() { for (ProcedureParameter pp : this.command.getMetadataObject().getParameters()) { if (pp.getType() == ProcedureParameter.Type.ReturnValue) { return pp; } } return null; }
private ProcedureParameter getReturnParameter() { for (ProcedureParameter parameter: this.procedure.getParameters()) { if (parameter.getType().equals(ProcedureParameter.Type.ReturnValue)) { return parameter; } } return null; }
private ProcedureParameter getReturnParameter() { for (ProcedureParameter pp : this.command.getMetadataObject().getParameters()) { if (pp.getType() == ProcedureParameter.Type.ReturnValue) { return pp; } } return null; }
private static boolean doesProcedureReturn(Procedure proc) { for (ProcedureParameter pp : proc.getParameters()) { if (pp.getType().equals(ProcedureParameter.Type.ReturnValue)) { return true; } } return (proc.getResultSet() != null); }
private static boolean isInputParameterLob(Procedure proc) { for (ProcedureParameter pp : proc.getParameters()) { if (!pp.getType().equals(ProcedureParameter.Type.ReturnValue) && DataTypeManager.isLOB(pp.getRuntimeType())) { return true; } } return false; }
int outs = 0; for (ProcedureParameter pp : proc.getParameters()) { if (pp.getType().equals(ProcedureParameter.Type.Out)) { continue; if (pp.getType().equals(ProcedureParameter.Type.In) || pp.getType().equals(ProcedureParameter.Type.InOut)) { inouts++; if (DataTypeManager.isLOB(pp.getRuntimeType())) { lobs++; } else if (pp.getType().equals(ProcedureParameter.Type.ReturnValue)) { outs++;
private String findContentType(Procedure procedure) { String contentType = "plain"; ColumnSet<Procedure> rs = procedure.getResultSet(); if (rs != null) { Column returnColumn = rs.getColumns().get(0); if (returnColumn.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.XML)) { contentType = "xml"; //$NON-NLS-1$ } else if (returnColumn.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.CLOB)) { contentType = "json"; } } else { for (ProcedureParameter pp:procedure.getParameters()) { if (pp.getType().equals(ProcedureParameter.Type.ReturnValue)) { if (pp.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.XML)) { contentType = "xml"; //$NON-NLS-1$ } else if (pp.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.CLOB)) { contentType = "json"; //$NON-NLS-1$ } } } } return contentType; }
private String findContentType(Procedure procedure) { String contentType = "plain"; ColumnSet<Procedure> rs = procedure.getResultSet(); if (rs != null) { Column returnColumn = rs.getColumns().get(0); if (returnColumn.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.XML)) { contentType = "xml"; //$NON-NLS-1$ } else if (returnColumn.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.CLOB)) { contentType = "json"; } } else { for (ProcedureParameter pp:procedure.getParameters()) { if (pp.getType().equals(ProcedureParameter.Type.ReturnValue)) { if (pp.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.XML)) { contentType = "xml"; //$NON-NLS-1$ } else if (pp.getDatatype().getRuntimeTypeName().equals(DataTypeManager.DefaultDataTypes.CLOB)) { contentType = "json"; //$NON-NLS-1$ } } } } return contentType; }
if (param.getType().equals(ProcedureParameter.Type.ReturnValue)) { this.returnType = param.getRuntimeType(); this.returnTypeClass = param.getJavaType();
BaseColumn addProcColumn(MetadataFactory factory, Procedure proc, String name, ParsedDataType type, boolean rs) throws MetadataException { BaseColumn column = null; if (rs) { column = factory.addProcedureResultSetColumn(name, type.type, proc); } else { boolean added = false; for (ProcedureParameter pp : proc.getParameters()) { if (pp.getType() == Type.ReturnValue) { added = true; if (pp.getDatatype() != factory.getDataTypes().get(type.type)) { throw new MetadataException(QueryPlugin.Util.getString("SQLParser.proc_type_conflict", proc.getName(), pp.getDatatype(), type.type)); //$NON-NLS-1$ } } } if (!added) { column = factory.addProcedureParameter(name, type.type, ProcedureParameter.Type.ReturnValue, proc); } } setTypeInfo(type, column); return column; }
BaseColumn addProcColumn(MetadataFactory factory, Procedure proc, String name, ParsedDataType type, boolean rs) throws MetadataException { BaseColumn column = null; if (rs) { column = factory.addProcedureResultSetColumn(name, type.type, proc); } else { boolean added = false; for (ProcedureParameter pp : proc.getParameters()) { if (pp.getType() == Type.ReturnValue) { added = true; if (pp.getDatatype() != factory.getDataTypes().get(type.type)) { throw new MetadataException(QueryPlugin.Util.getString("SQLParser.proc_type_conflict", proc.getName(), pp.getDatatype(), type.type)); //$NON-NLS-1$ } } } if (!added) { column = factory.addProcedureParameter(name, type.type, ProcedureParameter.Type.ReturnValue, proc); } } setTypeInfo(type, column); return column; }
BaseColumn addProcColumn(MetadataFactory factory, Procedure proc, String name, ParsedDataType type, boolean rs) throws MetadataException { BaseColumn column = null; if (rs) { column = factory.addProcedureResultSetColumn(name, type.type, proc); } else { boolean added = false; for (ProcedureParameter pp : proc.getParameters()) { if (pp.getType() == Type.ReturnValue) { added = true; if (pp.getDatatype() != factory.getDataTypes().get(type.type)) { throw new MetadataException(QueryPlugin.Util.getString("SQLParser.proc_type_conflict", proc.getName(), pp.getDatatype(), type.type)); //$NON-NLS-1$ } } } if (!added) { column = factory.addProcedureParameter(name, type.type, ProcedureParameter.Type.ReturnValue, proc); } } setTypeInfo(type, column); return column; }
for (ProcedureParameter pp : proc.getParameters()) { EdmPrimitiveTypeKind odataType = ODataTypeManager.odataType(pp); if (pp.getType().equals(ProcedureParameter.Type.ReturnValue)) { edmFunction.setReturnType(new CsdlReturnType().setType(odataType.getFullQualifiedName()).setCollection(DataTypeManager.isArrayType(pp.getRuntimeType()))); continue; if (pp.getType().equals(ProcedureParameter.Type.In) || pp.getType().equals(ProcedureParameter.Type.InOut)) { CsdlParameter parameter = buildParameter(pp, odataType); addOperationParameterAnnotations(pp, parameter, csdlSchema);
private void visit(ProcedureParameter param) { Type type = param.getType(); String typeStr = null; switch (type) { case InOut: typeStr = INOUT; break; case ReturnValue: case Out: typeStr = OUT; break; case In: if (param.isVarArg()) { typeStr = NonReserved.VARIADIC; } else { typeStr = IN; } break; } append(typeStr).append(SPACE); appendColumn(param, true, true); if (type == Type.ReturnValue) { append(SPACE).append(NonReserved.RESULT); } appendDefault(param); appendColumnOptions(param); }
private void visit(ProcedureParameter param) { Type type = param.getType(); String typeStr = null; switch (type) { case InOut: typeStr = INOUT; break; case ReturnValue: case Out: typeStr = OUT; break; case In: if (param.isVarArg()) { typeStr = NonReserved.VARIADIC; } else { typeStr = IN; } break; } append(typeStr).append(SPACE); appendColumn(param, true, true); if (type == Type.ReturnValue) { append(SPACE).append(NonReserved.RESULT); } appendDefault(param); appendColumnOptions(param); }
private void visit(ProcedureParameter param) { Type type = param.getType(); String typeStr = null; switch (type) { case InOut: typeStr = INOUT; break; case ReturnValue: case Out: typeStr = OUT; break; case In: if (param.isVarArg()) { typeStr = NonReserved.VARIADIC; } else { typeStr = IN; } break; } append(typeStr).append(SPACE); appendColumn(param, true, true); if (type == Type.ReturnValue) { append(SPACE).append(NonReserved.RESULT); } appendDefault(param); appendColumnOptions(param); }
assertEquals("p1", proc.getParameters().get(0).getName()); assertEquals("boolean", proc.getParameters().get(0).getDatatype().getName()); assertEquals(ProcedureParameter.Type.Out, proc.getParameters().get(0).getType()); assertEquals(ProcedureParameter.Type.In, proc.getParameters().get(1).getType()); assertEquals(ProcedureParameter.Type.InOut, proc.getParameters().get(2).getType());