Method validate_update

src/validator/numeric_validator.rs:289–340

Validate UPDATE statement values

(
        conn: &Connection,
        sql: &str,
        table_name: &str
    )

    
    /// Validate UPDATE statement values
    pub fn validate_update(
        conn: &Connection,
        sql: &str,
        table_name: &str
    ) -> Result<(), PgError> {
        // First ensure constraints are loaded
        let _ = Self::load_table_constraints(conn, table_name);
        
        // Get constraints from cache
        let cache = CONSTRAINT_CACHE.read().unwrap();
        let constraints = match cache.get(table_name) {
            Some(c) => c,
            None => {
                return Ok(()); // No constraints for this table
            }
        };
        
        if constraints.is_empty() {
            return Ok(()); // No numeric constraints
        }
        
        // Parse the UPDATE statement to extract column assignments
        let update_data = match parse_update_statement(sql) {
            Some(data) => data,
            None => {
                return Ok(()); // Couldn't parse, let it through
            }
        };
        
        // Validate each value against its constraint
        for (col_name, value) in update_data.iter() {
            if let Some((precision, scale)) = constraints.get(col_name) {
                // Skip validation for array literals (they get translated to TEXT)
                if value.trim().starts_with("ARRAY[") || value.trim().starts_with('[') {
                    // This is an array literal, skip numeric validation
                    // Array elements will be validated during array processing if needed
                    continue;
                }

                Self::validate_value(value, *precision, *scale)
                    .map_err(|mut e| {
                        // Add column name to error
                        if let PgError::NumericValueOutOfRange { column_name, .. } = &mut e {
                            *column_name = col_name.clone();
                        }
                        e
                    })?;
            }
        }
        
        Ok(())
    }
    
    /// Clear constraint cache for a table
    pub fn invalidate_cache(table_name: &str) {