Skip to main content

uqa_sql/expr/
json_carrier.rs

1//
2// Unified Query Algebra
3//
4// Copyright (c) 2023-2026 Cognica, Inc.
5//
6
7//! Convert SQL values into the JSON carrier used by table and aggregate execution.
8
9use uqa_core::Value;
10
11/// Enum carriers need catalog label output and are rejected rather than rendered from their storage key.
12pub fn core_value_to_json(value: &Value) -> crate::error::Result<serde_json::Value> {
13    Ok(match value {
14        Value::Null => serde_json::Value::Null,
15        Value::Void => serde_json::Value::String(String::new()),
16        Value::Bool(b) => serde_json::Value::Bool(*b),
17        Value::Int(i) => serde_json::Value::Number((*i).into()),
18        Value::Float(f) => serde_json::Number::from_f64(*f).map_or_else(
19            || {
20                let label = if f.is_nan() {
21                    "NaN"
22                } else if f.is_sign_positive() {
23                    "Infinity"
24                } else {
25                    "-Infinity"
26                };
27                serde_json::Value::String(label.to_string())
28            },
29            serde_json::Value::Number,
30        ),
31        Value::Decimal(d) => d
32            .to_f64()
33            .and_then(serde_json::Number::from_f64)
34            .map_or_else(
35                || serde_json::Value::String(d.to_sql_string()),
36                serde_json::Value::Number,
37            ),
38        Value::Str(s) => serde_json::from_str::<serde_json::Value>(s)
39            .unwrap_or_else(|_| serde_json::Value::String(s.clone())),
40        Value::FixedChar(s) => serde_json::Value::String(s.trim_end_matches(' ').to_string()),
41        Value::Bytes(bytes) => serde_json::Value::String(String::from_utf8_lossy(bytes).into()),
42        Value::BitString(_) => serde_json::Value::String(super::value_to_string(value)?),
43        Value::Temporal(t) => serde_json::Value::String(t.to_sql_string()),
44        Value::Json(text) | Value::JsonB(text) => {
45            serde_json::from_str(text).unwrap_or_else(|_| serde_json::Value::String(text.clone()))
46        }
47        Value::Enum(value) => return Err(super::catalog_output_required(value)),
48        Value::Datum(value) => return core_value_to_json(&super::datums::read(value)?),
49        Value::Array(array) => serde_json::Value::Array(
50            array
51                .elements()
52                .iter()
53                .map(core_value_to_json)
54                .collect::<crate::error::Result<_>>()?,
55        ),
56        Value::LegacyVector(vector) => serde_json::Value::Array(
57            vector
58                .elements()
59                .iter()
60                .map(core_value_to_json)
61                .collect::<crate::error::Result<_>>()?,
62        ),
63        Value::List(items) => serde_json::Value::Array(
64            items
65                .iter()
66                .map(core_value_to_json)
67                .collect::<crate::error::Result<_>>()?,
68        ),
69        Value::Row(values) => serde_json::Value::Object(
70            values
71                .iter()
72                .enumerate()
73                .map(|(index, value)| Ok((format!("f{}", index + 1), core_value_to_json(value)?)))
74                .collect::<crate::error::Result<_>>()?,
75        ),
76        Value::Record(fields) => serde_json::Value::Object(
77            fields
78                .iter()
79                .map(|(name, value)| Ok((name.clone(), core_value_to_json(value)?)))
80                .collect::<crate::error::Result<_>>()?,
81        ),
82        Value::Map(map) => serde_json::Value::Object(
83            map.iter()
84                .map(|(k, v)| Ok((k.clone(), core_value_to_json(v)?)))
85                .collect::<crate::error::Result<_>>()?,
86        ),
87    })
88}
89
90pub fn value_to_text(value: &Value) -> crate::error::Result<String> {
91    Ok(
92        value_to_text_with_control(value, &uqa_core::memory::ProductionControl::uncontrolled())?
93            .into_uncontrolled()
94            .expect("ordinary carrier text"),
95    )
96}
97
98pub fn value_to_text_with_control(
99    value: &Value,
100    control: &uqa_core::memory::ProductionControl<'_>,
101) -> crate::error::Result<uqa_core::memory::Produced<String>> {
102    control.check()?;
103    Ok(match value {
104        Value::Null | Value::Void => control.copy_text("")?,
105        Value::Enum(value) => return Err(super::catalog_output_required(value)),
106        Value::Datum(value) => {
107            return value_to_text_with_control(
108                &*super::datums::read_with_control(value, control)?,
109                control,
110            )
111        }
112        Value::Bool(value) => control.format(format_args!("{value}"))?,
113        Value::Int(value) => control.format(format_args!("{value}"))?,
114        Value::Float(value) => control.format(format_args!("{value}"))?,
115        Value::Decimal(value) => value.to_sql_string_with_control(control)?,
116        Value::Str(value) | Value::Json(value) | Value::JsonB(value) => control.copy_text(value)?,
117        Value::FixedChar(value) => control.copy_text(value.trim_end_matches(' '))?,
118        Value::Bytes(value) => super::json::utf8_lossy_with_control(value, control)?,
119        Value::BitString(value) => super::bit_string::output_with_control(value, control)?,
120        Value::Temporal(value) => value.to_sql_string_in_interval_style_with_control(
121            super::temporal_interval_style(),
122            control,
123        )?,
124        Value::Array(array) => {
125            super::conversion::array_value_to_string_with_control(array, control)?
126        }
127        Value::List(_) | Value::Map(_) => {
128            super::json::format_core_value_as_json_with_control(value, control)?
129        }
130        Value::Row(_) | Value::Record(_) | Value::LegacyVector(_) => {
131            super::conversion::value_to_string_with_control(value, control)?
132        }
133    })
134}