Struct StringAgg 

pub struct StringAgg { /* private fields */ }

Available on crate feature database and non-WebAssembly only.

PostgreSQL STRING_AGG aggregation function

Aggregates string values into a single string with a specified separator.

Example

use reinhardt_db::orm::StringAgg;

let agg = StringAgg::new("name".to_string(), ", ".to_string());
assert_eq!(agg.to_sql(), "STRING_AGG(name, ', ')");

let distinct_agg = StringAgg::new("category".to_string(), "; ".to_string()).distinct();
assert_eq!(distinct_agg.to_sql(), "STRING_AGG(DISTINCT category, '; ')");

Implementations

impl StringAgg

pub fn new(field: String, separator: String) -> StringAgg

Create a new StringAgg for the specified field with a separator

Example

use reinhardt_db::orm::StringAgg;

let agg = StringAgg::new("name".to_string(), ", ".to_string());
assert_eq!(agg.to_sql(), "STRING_AGG(name, ', ')");

pub fn distinct(self) -> StringAgg

Apply DISTINCT to the aggregation

Example

use reinhardt_db::orm::StringAgg;

let agg = StringAgg::new("name".to_string(), ",".to_string()).distinct();
assert!(agg.to_sql().contains("DISTINCT"));

pub fn order_by(self, fields: Vec<String>) -> StringAgg

Add ORDER BY clause to the aggregation

Example

use reinhardt_db::orm::StringAgg;

let agg = StringAgg::new("name".to_string(), ", ".to_string())
    .order_by(vec!["name ASC".to_string()]);
assert!(agg.to_sql().contains("ORDER BY"));

pub fn to_sql(&self) -> String

Generate SQL for this aggregation

Trait Implementations

impl Clone for StringAgg

fn clone(&self) -> StringAgg

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for StringAgg

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for StringAgg

fn deserialize<__D>( __deserializer: __D, ) -> Result<StringAgg, <__D as Deserializer<'de>>::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Serialize for StringAgg

fn serialize<__S>( &self, __serializer: __S, ) -> Result<<__S as Serializer>::Ok, <__S as Serializer>::Error>

where __S: Serializer,

Serialize this value into the given Serde serializer.