/** * Swap name of stored proc and elements in stored procedure parameter expressions * @param obj Object to remap */ public void visit(StoredProcedure obj) { // Swap procedure name String execName = obj.getProcedureName(); GroupSymbol fakeGroup = new GroupSymbol(execName); Object procedureID = obj.getProcedureID(); if(procedureID != null) { fakeGroup.setMetadataID(procedureID); } GroupSymbol mappedGroup = getMappedGroup(fakeGroup); obj.setProcedureName(mappedGroup.getName()); super.visit(obj); }
/** * Swap name of stored proc and elements in stored procedure parameter expressions * @param obj Object to remap */ public void visit(StoredProcedure obj) { // Swap procedure name String execName = obj.getProcedureName(); GroupSymbol fakeGroup = new GroupSymbol(execName); Object procedureID = obj.getProcedureID(); if(procedureID != null) { fakeGroup.setMetadataID(procedureID); } GroupSymbol mappedGroup = getMappedGroup(fakeGroup); obj.setProcedureName(mappedGroup.getName()); super.visit(obj); }
/** * Swap name of stored proc and elements in stored procedure parameter expressions * @param obj Object to remap */ public void visit(StoredProcedure obj) { // Swap procedure name String execName = obj.getProcedureName(); GroupSymbol fakeGroup = new GroupSymbol(execName); Object procedureID = obj.getProcedureID(); if(procedureID != null) { fakeGroup.setMetadataID(procedureID); } GroupSymbol mappedGroup = getMappedGroup(fakeGroup); obj.setProcedureName(mappedGroup.getName()); super.visit(obj); }
PlanNode createStoredProcedurePlan(StoredProcedure storedProc) throws QueryMetadataException, TeiidComponentException, TeiidProcessingException { // Create top project node - define output columns for stored query / procedure PlanNode projectNode = attachProject(null, storedProc.getProjectedSymbols()); // Define source of data for stored query / procedure PlanNode sourceNode = NodeFactory.getNewNode(NodeConstants.Types.SOURCE); sourceNode.setProperty(NodeConstants.Info.VIRTUAL_COMMAND, storedProc); addNestedProcedure(sourceNode, storedProc, storedProc.getProcedureID()); hints.hasRelationalProc |= storedProc.isProcedureRelational(); if (!hints.hasRowBasedSecurity && RowBasedSecurityHelper.applyRowSecurity(metadata, storedProc.getGroup(), context)) { hints.hasRowBasedSecurity = true; } // Set group on source node sourceNode.addGroup(storedProc.getGroup()); attachLast(projectNode, sourceNode); return projectNode; }
PlanNode createStoredProcedurePlan(StoredProcedure storedProc) throws QueryMetadataException, TeiidComponentException, TeiidProcessingException { // Create top project node - define output columns for stored query / procedure PlanNode projectNode = attachProject(null, storedProc.getProjectedSymbols()); // Define source of data for stored query / procedure PlanNode sourceNode = NodeFactory.getNewNode(NodeConstants.Types.SOURCE); sourceNode.setProperty(NodeConstants.Info.VIRTUAL_COMMAND, storedProc); addNestedProcedure(sourceNode, storedProc, storedProc.getProcedureID()); hints.hasRelationalProc |= storedProc.isProcedureRelational(); if (!hints.hasRowBasedSecurity && RowBasedSecurityHelper.applyRowSecurity(metadata, storedProc.getGroup(), context)) { hints.hasRowBasedSecurity = true; } // Set group on source node sourceNode.addGroup(storedProc.getGroup()); attachLast(projectNode, sourceNode); return projectNode; }
PlanNode createStoredProcedurePlan(StoredProcedure storedProc) throws QueryMetadataException, TeiidComponentException, TeiidProcessingException { // Create top project node - define output columns for stored query / procedure PlanNode projectNode = attachProject(null, storedProc.getProjectedSymbols()); // Define source of data for stored query / procedure PlanNode sourceNode = NodeFactory.getNewNode(NodeConstants.Types.SOURCE); sourceNode.setProperty(NodeConstants.Info.VIRTUAL_COMMAND, storedProc); addNestedProcedure(sourceNode, storedProc, storedProc.getProcedureID()); hints.hasRelationalProc |= storedProc.isProcedureRelational(); if (!hints.hasRowBasedSecurity && RowBasedSecurityHelper.applyRowSecurity(metadata, storedProc.getGroup(), context)) { hints.hasRowBasedSecurity = true; } // Set group on source node sourceNode.addGroup(storedProc.getGroup()); attachLast(projectNode, sourceNode); return projectNode; }
Call translate(StoredProcedure sp) { Procedure proc = null; if(sp.getProcedureID() != null) { try { proc = this.metadataFactory.getProcedure(sp.getGroup().getName());
Call translate(StoredProcedure sp) { Procedure proc = null; if(sp.getProcedureID() != null) { try { proc = this.metadataFactory.getProcedure(sp.getGroup().getName());
Call translate(StoredProcedure sp) { Procedure proc = null; if(sp.getProcedureID() != null) { try { proc = this.metadataFactory.getProcedure(sp.getGroup().getName());
public Object clone() { StoredProcedure copy = new StoredProcedure(); copy.setModelID(getModelID()); copy.setProcedureName(getProcedureName()); copy.setProcedureCallableName(getProcedureCallableName()); copy.setProcedureID(getProcedureID()); copy.setGroup(getGroup().clone()); copy.callableName = callableName; copy.calledWithReturn = calledWithReturn; Collection<SPParameter> params = getParameters(); for (SPParameter spParameter : params) { copy.setParameter((SPParameter)spParameter.clone()); } copy.resultSetParameterKey = resultSetParameterKey; this.copyMetadataState(copy); copy.displayNamedParameters = displayNamedParameters; copy.isCallableStatement = isCallableStatement; copy.isProcedureRelational = isProcedureRelational; copy.pushedInQuery = pushedInQuery; return copy; }
public Object clone() { StoredProcedure copy = new StoredProcedure(); copy.setModelID(getModelID()); copy.setProcedureName(getProcedureName()); copy.setProcedureCallableName(getProcedureCallableName()); copy.setProcedureID(getProcedureID()); copy.setGroup(getGroup().clone()); copy.callableName = callableName; copy.calledWithReturn = calledWithReturn; Collection<SPParameter> params = getParameters(); for (SPParameter spParameter : params) { copy.setParameter((SPParameter)spParameter.clone()); } copy.resultSetParameterKey = resultSetParameterKey; this.copyMetadataState(copy); copy.displayNamedParameters = displayNamedParameters; copy.isCallableStatement = isCallableStatement; copy.isProcedureRelational = isProcedureRelational; copy.pushedInQuery = pushedInQuery; return copy; }
id.setOriginalMetadataID(storedProcedureCommand.getProcedureID()); if (!accessPatternElementNames.isEmpty()) { List<TempMetadataID> accessPatternIds = new LinkedList<TempMetadataID>();
id.setOriginalMetadataID(storedProcedureCommand.getProcedureID()); if (!accessPatternElementNames.isEmpty()) { List<TempMetadataID> accessPatternIds = new LinkedList<TempMetadataID>();
public Object clone() { StoredProcedure copy = new StoredProcedure(); copy.setModelID(getModelID()); copy.setProcedureName(getProcedureName()); copy.setProcedureCallableName(getProcedureCallableName()); copy.setProcedureID(getProcedureID()); copy.setGroup(getGroup().clone()); copy.callableName = callableName; copy.calledWithReturn = calledWithReturn; Collection<SPParameter> params = getParameters(); for (SPParameter spParameter : params) { copy.setParameter((SPParameter)spParameter.clone()); } copy.resultSetParameterKey = resultSetParameterKey; this.copyMetadataState(copy); copy.displayNamedParameters = displayNamedParameters; copy.isCallableStatement = isCallableStatement; copy.isProcedureRelational = isProcedureRelational; copy.pushedInQuery = pushedInQuery; return copy; }
if (container instanceof StoredProcedure) { StoredProcedure sp = (StoredProcedure)container; if (sp.getProcedureID() instanceof Procedure) { context.accessedPlanningObject(sp.getProcedureID()); if (container instanceof StoredProcedure) { StoredProcedure sp = (StoredProcedure)container; boolean noCache = isNoCacheGroup(metadata, sp.getProcedureID(), option); if (!noCache) { if (!context.isResultSetCacheEnabled()) {
id.setOriginalMetadataID(storedProcedureCommand.getProcedureID()); if (!accessPatternElementNames.isEmpty()) { List<TempMetadataID> accessPatternIds = new LinkedList<TempMetadataID>();
if (container instanceof StoredProcedure) { StoredProcedure sp = (StoredProcedure)container; if (sp.getProcedureID() instanceof Procedure) { context.accessedPlanningObject(sp.getProcedureID()); if (container instanceof StoredProcedure) { StoredProcedure sp = (StoredProcedure)container; boolean noCache = isNoCacheGroup(metadata, sp.getProcedureID(), option); if (!noCache) { if (!context.isResultSetCacheEnabled()) {
private TupleSource handleCachedProcedure(final CommandContext context, StoredProcedure proc) throws TeiidComponentException, QueryMetadataException, TeiidProcessingException { String fullName = context.getMetadata().getFullName(proc.getProcedureID()); LogManager.logDetail(LogConstants.CTX_DQP, "processing cached procedure request for", fullName); //$NON-NLS-1$ LinkedList<Object> vals = new LinkedList<Object>();
private TupleSource handleCachedProcedure(final CommandContext context, StoredProcedure proc) throws TeiidComponentException, QueryMetadataException, TeiidProcessingException { String fullName = context.getMetadata().getFullName(proc.getProcedureID()); LogManager.logDetail(LogConstants.CTX_DQP, "processing cached procedure request for", fullName); //$NON-NLS-1$ LinkedList<Object> vals = new LinkedList<Object>();
private TupleSource handleCachedProcedure(final CommandContext context, StoredProcedure proc) throws TeiidComponentException, QueryMetadataException, TeiidProcessingException { String fullName = context.getMetadata().getFullName(proc.getProcedureID()); LogManager.logDetail(LogConstants.CTX_DQP, "processing cached procedure request for", fullName); //$NON-NLS-1$ LinkedList<Object> vals = new LinkedList<Object>();