Convert JSON array to PostgreSQL text array format
(&self, json_str: &str)
| 281 | |
| 282 | /// Convert JSON array to PostgreSQL text array format |
| 283 | fn convert_json_to_pg_array(&self, json_str: &str) -> io::Result<Vec<u8>> { |
| 284 | // Try to parse as JSON array |
| 285 | match serde_json::from_str::<serde_json::Value>(json_str) { |
| 286 | Ok(json_val) => { |
| 287 | if let serde_json::Value::Array(arr) = json_val { |
| 288 | // Convert to PostgreSQL array literal format |
| 289 | let pg_array = self.json_array_to_pg_text(&arr); |
| 290 | Ok(pg_array.into_bytes()) |
| 291 | } else { |
| 292 | // Not an array, return as-is |
| 293 | Ok(json_str.as_bytes().to_vec()) |
| 294 | } |
| 295 | } |
| 296 | Err(_) => { |
| 297 | // Not valid JSON, return as-is |
| 298 | Ok(json_str.as_bytes().to_vec()) |
| 299 | } |
| 300 | } |
| 301 | } |
| 302 | |
| 303 | /// Convert JSON array elements to PostgreSQL text array format |
| 304 | fn json_array_to_pg_text(&self, arr: &[serde_json::Value]) -> String { |
no test coverage detected