Method load_table_constraints

src/validator/string_constraints.rs:34–76

Load constraints for a table from the database

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

    
    /// Load constraints for a table from the database
    pub fn load_table_constraints(&self, conn: &Connection, table_name: &str) -> Result<(), rusqlite::Error> {
        // First check if we have the string constraints table (migration v6)
        let has_constraints_table = conn.query_row(
            "SELECT COUNT(*) FROM sqlite_master WHERE type='table' AND name='__pgsqlite_string_constraints'",
            [],
            |row| row.get::<_, i32>(0)
        )? > 0;
        
        if !has_constraints_table {
            // No constraints table, nothing to load
            return Ok(());
        }
        
        // Query string constraints
        let mut stmt = conn.prepare(
            "SELECT column_name, max_length, is_char_type 
             FROM __pgsqlite_string_constraints 
             WHERE table_name = ?1"
        )?;
        
        let constraints_result = stmt.query_map([table_name], |row| {
            Ok(StringConstraint {
                table_name: table_name.to_string(),
                column_name: row.get(0)?,
                max_length: row.get(1)?,
                is_char_type: row.get(2)?,
            })
        })?;
        
        let mut table_constraints = HashMap::new();
        for constraint in constraints_result {
            let constraint = constraint?;
            table_constraints.insert(constraint.column_name.clone(), constraint);
        }
        
        // Update cache
        if !table_constraints.is_empty() {
            let mut cache = self.constraints.write().unwrap();
            cache.insert(table_name.to_string(), table_constraints);
        }
        
        Ok(())
    }
    
    /// Populate the string constraints table from __pgsqlite_schema
    pub fn populate_constraints_from_schema(conn: &Connection) -> Result<(), rusqlite::Error> {