schema_reverse_engineer/postgres/
enums.rs1use crate::error::SchemaReverseEngineerError;
2use schema_model::model::enum_type::{EnumType, EnumValue};
3use sqlx::PgPool;
4use std::collections::BTreeMap;
5
6pub async fn list_enum_types(pool: &PgPool, db_schema: &str) -> Result<Vec<EnumType>, SchemaReverseEngineerError> {
8 let rows: Vec<(String, String, i32)> = sqlx::query_as(
9 "SELECT t.typname, e.enumlabel, e.enumsortorder::int4 \
10 FROM pg_type t \
11 JOIN pg_enum e ON e.enumtypid = t.oid \
12 JOIN pg_namespace n ON n.oid = t.typnamespace \
13 WHERE n.nspname = $1 \
14 ORDER BY t.typname, e.enumsortorder",
15 )
16 .bind(db_schema)
17 .fetch_all(pool)
18 .await
19 .map_err(|e| SchemaReverseEngineerError::Introspection(e.to_string()))?;
20
21 let mut by_name: BTreeMap<String, Vec<EnumValue>> = BTreeMap::new();
22 for (type_name, value_name, _sort_order) in rows {
23 by_name
24 .entry(type_name)
25 .or_default()
26 .push(EnumValue::new(value_name, None::<String>));
27 }
28
29 Ok(by_name
30 .into_iter()
31 .map(|(name, values)| EnumType::new(name, values))
32 .collect())
33}