Skip to main content

schema_reverse_engineer/postgres/
enums.rs

1use crate::error::SchemaReverseEngineerError;
2use schema_model::model::enum_type::{EnumType, EnumValue};
3use sqlx::PgPool;
4use std::collections::BTreeMap;
5
6/// Reads native Postgres enum types (`CREATE TYPE ... AS ENUM (...)`) defined in `db_schema`.
7pub 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}