Enum JsonAgg 

pub enum JsonAgg {
    ArrayAgg {
        column: String,
        distinct: bool,
        order_by: Option<String>,
    },
    ObjectAgg {
        key_column: String,
        value_column: String,
    },
    BuildObject {
        pairs: Vec<(String, String)>,
    },
    BuildArray {
        elements: Vec<String>,
    },
}

JSON aggregation operations.

Variants

ArrayAgg

Aggregate rows into a JSON array.

Fields

column: String

distinct: bool

order_by: Option<String>

ObjectAgg

Aggregate rows into a JSON object.

Fields

key_column: String

value_column: String

BuildObject

Build a JSON object from key-value pairs.

Fields

pairs: Vec<(String, String)>

BuildArray

Build a JSON array from expressions.

Fields

elements: Vec<String>

Implementations

impl JsonAgg

pub fn array_agg(column: impl Into<String>) -> Self

Create an array aggregation.

pub fn object_agg(key: impl Into<String>, value: impl Into<String>) -> Self

Create an object aggregation.

pub fn to_postgres_sql(&self) -> String

Generate PostgreSQL SQL.

pub fn to_mysql_sql(&self) -> String

Generate MySQL SQL.

pub fn to_sql(&self, db_type: DatabaseType) -> String

Generate SQL for the specified database.

Trait Implementations

impl Clone for JsonAgg

fn clone(&self) -> JsonAgg

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for JsonAgg

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for JsonAgg

fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl PartialEq for JsonAgg

fn eq(&self, other: &JsonAgg) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Serialize for JsonAgg

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Eq for JsonAgg

impl StructuralPartialEq for JsonAgg