public IList <TableFunction> GetTableFunctions(Schema schema)
{
IList <TableFunction> tfList = this.queryForTableFunctions(schema);
if (tfList != null && tfList.Count > 0)
{
var paramInspector = new ParameterInspector(this.peta);
var columnInspector = new ColumnInspector(this.peta);
for (int t = 0; t < tfList.Count; t++)
{
var func = tfList[t];
func.Parameters = paramInspector.GetParameters(func);
func.Columns = columnInspector.GetColumns(func);
func.Parent = schema;
}
}
return(tfList);
}
public IList<TableFunction> GetTableFunctions(Schema schema)
{
IList<TableFunction> tfList = this.queryForTableFunctions(schema);
if (tfList != null && tfList.Count > 0)
{
var paramInspector = new ParameterInspector(this.peta);
var columnInspector = new ColumnInspector(this.peta);
for (int t = 0; t < tfList.Count; t++)
{
var func = tfList[t];
func.Parameters = paramInspector.GetParameters(func);
func.Columns = columnInspector.GetColumns(func);
func.Parent = schema;
}
}
return tfList;
}
public IList <StoredProcedure> GetStoredProcedures(Schema schema)
{
IList <StoredProcedure> spList = null;
spList = this.queryForStoredProcedures(schema);
if (spList != null && spList.Count > 0)
{
var parameterInspector = new ParameterInspector(this.peta);
for (int p = 0; p < spList.Count; p++)
{
var proc = spList[p];
proc.Parameters = parameterInspector.GetParameters(proc);
proc.Parent = schema;
}
}
return(spList);
}
public IList<StoredProcedure> GetStoredProcedures(Schema schema)
{
IList<StoredProcedure> spList = null;
spList = this.queryForStoredProcedures(schema);
if (spList != null && spList.Count > 0)
{
var parameterInspector = new ParameterInspector(this.peta);
for (int p = 0; p < spList.Count; p++)
{
var proc = spList[p];
proc.Parameters = parameterInspector.GetParameters(proc);
proc.Parent = schema;
}
}
return spList;
}
public IList<ScalarFunction> GetScalarFunctions(Schema schema)
{
IList<ScalarFunction> functionList = null;
functionList = this.queryForScalarFunctions(schema);
if (functionList != null && functionList.Count > 0)
{
var paramInspector = new ParameterInspector(this.peta);
for (int f = 0; f < functionList.Count; f++)
{
var sf = functionList[f];
sf.Parameters = paramInspector.GetParameters(sf);
sf.Parent = schema;
}
}
return functionList;
}
public IList <ScalarFunction> GetScalarFunctions(Schema schema)
{
IList <ScalarFunction> functionList = null;
functionList = this.queryForScalarFunctions(schema);
if (functionList != null && functionList.Count > 0)
{
var paramInspector = new ParameterInspector(this.peta);
for (int f = 0; f < functionList.Count; f++)
{
var sf = functionList[f];
sf.Parameters = paramInspector.GetParameters(sf);
sf.Parent = schema;
}
}
return(functionList);
}