Method list_users

graphlite/src/catalog/system_procedures.rs:688–784

CALL gql.list_users() YIELD username, email, active, created_at, roles Lists all users in the security catalog

(&self, _args: Vec<Value>)

    /// CALL gql.list_users() YIELD username, email, active, created_at, roles
    /// Lists all users in the security catalog
    fn list_users(&self, _args: Vec<Value>) -> Result<QueryResult, ExecutionError> {
        let mut catalog_manager = self.catalog_manager.write().map_err(|_| {
            ExecutionError::RuntimeError("Failed to acquire catalog manager lock".to_string())
        })?;

        let response = catalog_manager
            .execute(
                "security",
                CatalogOperation::Query {
                    query_type: QueryType::ListUsers,
                    params: json!({}),
                },
            )
            .map_err(|e| ExecutionError::CatalogError(format!("Failed to list users: {}", e)))?;

        let mut rows = Vec::new();
        let columns = vec![
            "username".to_string(),
            "email".to_string(),
            "active".to_string(),
            "created_at".to_string(),
            "roles".to_string(),
        ];

        if let CatalogResponse::Query { results } = response {
            if let Some(users) = results.as_array() {
                for user_value in users {
                    if let Some(user) = user_value.as_object() {
                        let mut row_values = HashMap::new();
                        row_values.insert(
                            "username".to_string(),
                            user.get("id")
                                .and_then(|id| id.as_object())
                                .and_then(|id_obj| id_obj.get("name"))
                                .and_then(|v| v.as_str())
                                .map(|s| Value::String(s.to_string()))
                                .unwrap_or(Value::Null),
                        );
                        row_values.insert(
                            "email".to_string(),
                            user.get("properties")
                                .and_then(|props| props.as_object())
                                .and_then(|props_obj| props_obj.get("email"))
                                .and_then(|v| v.as_str())
                                .map(|s| Value::String(s.to_string()))
                                .unwrap_or(Value::Null),
                        );
                        row_values.insert(
                            "active".to_string(),
                            user.get("enabled")
                                .and_then(|v| v.as_bool())
                                .map(Value::Boolean)
                                .unwrap_or(Value::Boolean(true)),
                        );
                        row_values.insert(
                            "created_at".to_string(),
                            user.get("created_at")
                                .and_then(|v| v.as_str())