Method add_enum_value

src/metadata/enum_metadata.rs:115–197

Add a new value to an existing ENUM type

(
        conn: &mut Connection,
        type_name: &str,
        new_value: &str,
        before_value: Option<&str>,
        after_value: Option<&str>,
    )

    
    /// Add a new value to an existing ENUM type
    pub fn add_enum_value(
        conn: &mut Connection,
        type_name: &str,
        new_value: &str,
        before_value: Option<&str>,
        after_value: Option<&str>,
    ) -> Result<()> {
        let tx = conn.transaction()?;
        
        // Get type OID
        let type_oid: i32 = tx.query_row(
            "SELECT type_oid FROM __pgsqlite_enum_types WHERE type_name = ?1",
            [type_name],
            |row| row.get(0),
        )?;
        
        // Calculate sort order
        let sort_order = if let Some(before) = before_value {
            // Insert before specified value
            let before_order: f64 = tx.query_row(
                "SELECT sort_order FROM __pgsqlite_enum_values 
                 WHERE type_oid = ?1 AND label = ?2",
                params![type_oid, before],
                |row| row.get(0),
            )?;
            
            // Get previous value's sort order (if exists)
            let prev_order: Option<f64> = tx.query_row(
                "SELECT MAX(sort_order) FROM __pgsqlite_enum_values 
                 WHERE type_oid = ?1 AND sort_order < ?2",
                params![type_oid, before_order],
                |row| row.get(0),
            ).ok();
            
            // Place halfway between previous and before value
            match prev_order {
                Some(prev) => (prev + before_order) / 2.0,
                None => before_order / 2.0,
            }
        } else if let Some(after) = after_value {
            // Insert after specified value
            let after_order: f64 = tx.query_row(
                "SELECT sort_order FROM __pgsqlite_enum_values 
                 WHERE type_oid = ?1 AND label = ?2",
                params![type_oid, after],
                |row| row.get(0),
            )?;
            
            // Get next value's sort order (if exists)
            let next_order: Option<f64> = tx.query_row(
                "SELECT MIN(sort_order) FROM __pgsqlite_enum_values 
                 WHERE type_oid = ?1 AND sort_order > ?2",
                params![type_oid, after_order],
                |row| row.get(0),
            ).ok();
            
            // Place halfway between after value and next
            match next_order {