public static List <TerminologyDictionaryItem> Read(this PostgresFunc func)
{
var result = PostgresHelper.Read(func.Name, func.Parameters.ToArray());
return(result);
}
/// <summary>
/// Call Postgres function and cast value
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="func"></param>
/// <returns></returns>
public static T Cast <T>(this PostgresFunc func)
{
var result = PostgresHelper.Func(func.Name, func.Parameters.ToArray());
return(result is DBNull ? default(T) : (T)result);
}
public static PostgresFunc WithInt(this PostgresFunc func, int limit)
{
func.Parameters.Add(PostgresHelper.Int(limit));
return(func);
}
public static PostgresFunc WithTextArray(this PostgresFunc func, string[] resources)
{
func.Parameters.Add(PostgresHelper.TextArray(resources));
return(func);
}
/// <summary>
/// Add jsonb parameter
/// </summary>
/// <param name="func"></param>
/// <param name="jsonParameter"></param>
/// <returns></returns>
public static PostgresFunc WithJsonb(this PostgresFunc func, string jsonParameter)
{
func.Parameters.Add(PostgresHelper.Jsonb(jsonParameter));
return(func);
}
/// <summary>
/// Add text parameter
/// </summary>
/// <param name="func"></param>
/// <param name="textParameter"></param>
/// <returns></returns>
public static PostgresFunc WithText(this PostgresFunc func, string textParameter)
{
func.Parameters.Add(PostgresHelper.Text(textParameter));
return(func);
}
