Enum JsonTableColumn

pub enum JsonTableColumn {
    Named(JsonTableNamedColumn),
    ForOrdinality(Ident),
    Nested(JsonTableNestedColumn),
}

A single column definition in MySQL’s JSON_TABLE table valued function.

See

• MySQL’s JSON_TABLE documentation
• Oracle’s JSON_TABLE documentation
• MariaDB’s JSON_TABLE documentation

SELECT *
FROM JSON_TABLE(
    '["a", "b"]',
    '$[*]' COLUMNS (
        name FOR ORDINALITY,
        value VARCHAR(20) PATH '$',
        NESTED PATH '$[*]' COLUMNS (
            value VARCHAR(20) PATH '$'
        )
    )
) AS jt;

Variants

Named(JsonTableNamedColumn)

A named column with a JSON path

ForOrdinality(Ident)

The FOR ORDINALITY column, which is a special column that returns the index of the current row in a JSON array.

Nested(JsonTableNestedColumn)

A set of nested columns, which extracts data from a nested JSON array.

Trait Implementations

impl Clone for JsonTableColumn

fn clone(&self) -> JsonTableColumn

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for JsonTableColumn

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

Formats the value using the given formatter.

impl<'de> Deserialize<'de> for JsonTableColumn

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

where __D: Deserializer<'de>,

Deserialize this value from the given Serde deserializer.

impl Display for JsonTableColumn

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

Formats the value using the given formatter.

impl Hash for JsonTableColumn

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher.

fn hash_slice<H>(data: &[Self], state: &mut H)

where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher.

impl Ord for JsonTableColumn

fn cmp(&self, other: &JsonTableColumn) -> Ordering

This method returns an Ordering between self and other.

fn max(self, other: Self) -> Self

where Self: Sized,

Compares and returns the maximum of two values.

fn min(self, other: Self) -> Self

where Self: Sized,

Compares and returns the minimum of two values.

fn clamp(self, min: Self, max: Self) -> Self

where Self: Sized,

Restrict a value to a certain interval.

impl PartialEq for JsonTableColumn

fn eq(&self, other: &JsonTableColumn) -> 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 PartialOrd for JsonTableColumn

fn partial_cmp(&self, other: &JsonTableColumn) -> Option<Ordering>

This method returns an ordering between self and other values if one exists.

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

Tests less than (for self and other) and is used by the < operator.

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

Tests less than or equal to (for self and other) and is used by the <= operator.

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

Tests greater than (for self and other) and is used by the > operator.

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

Tests greater than or equal to (for self and other) and is used by the >= operator.

impl Serialize for JsonTableColumn

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

where __S: Serializer,

Serialize this value into the given Serde serializer.

impl Visit for JsonTableColumn

fn visit<V: Visitor>(&self, visitor: &mut V) -> ControlFlow<V::Break>

impl VisitMut for JsonTableColumn

fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>

impl Eq for JsonTableColumn

impl StructuralPartialEq for JsonTableColumn