/**
* Creates declaration string for the function. The string consists
* of function name, '(', list of argument types separated by ',' and ')'.
*
* @param $node_function
*/
public static function get_declaration($node_schema, $node_function)
{
$r = mssql10::get_quoted_schema_name($node_schema['name']) . '.' . mssql10::get_quoted_function_name($node_function['name']) . '(';
$parameters = dbx::get_function_parameters($node_function);
foreach ($parameters as $parameter) {
$arg = '';
if (strlen($parameter['name']) > 0) {
$arg .= '@' . $parameter['name'] . ' ';
}
$arg .= $parameter['type'];
if (isset($parameter['direction'])) {
$arg .= ' ' . $parameter['direction'];
}
$r .= $arg . ', ';
}
if (count($parameters) > 0) {
$r = substr($r, 0, -2);
}
$r .= ')';
return $r;
}
/**
* Creates declaration string for the function. The string consists
* of function name, '(', list of argument types separated by ',' and ')'.
*
* @param $node_function
*/
public static function get_declaration($node_schema, $node_function, $include_names = TRUE)
{
$r = pgsql8::get_quoted_schema_name($node_schema['name']) . '.' . pgsql8::get_quoted_function_name($node_function['name']) . '(';
$parameters = dbx::get_function_parameters($node_function);
foreach ($parameters as $parameter) {
$arg = '';
if (isset($parameter['direction']) && strlen($parameter['direction']) > 0) {
$arg .= $parameter['direction'] . ' ';
}
if ($include_names && strlen($parameter['name']) > 0) {
$arg .= $parameter['name'] . ' ';
}
$arg .= $parameter['type'];
$r .= $arg . ', ';
}
if (count($parameters) > 0) {
$r = substr($r, 0, -2);
}
$r .= ')';
return $r;
}
