query-allocated-quality_skill

Overview

This skill lets you query allocation attributes in the ec_distribute.distribute_supply_attribute table of the distribution (分流) database. It focuses on two attribute types: ALLOCATED_QUALITY (allocation quality) and STRICT_DISTRIBUTE_CHANNEL (store distribution channel). Use the provided Python helpers or raw SQL to fetch and inspect records for a given demand_id.

How this skill works

The skill runs parameterized queries against ec_distribute.distribute_supply_attribute to return rows matching a demand_id and optional attribute_type. It can return all attributes for a demand_id, or filter specifically for ALLOCATED_QUALITY or STRICT_DISTRIBUTE_CHANNEL. A convenience agent.py exposes functions: query_all_attributes, query_allocated_quality, query_distribute_channel, and query_distribute_attribute for custom types.

When to use it

• Investigating allocation quality settings for a specific demand (demand_id).
• Checking which store distribution channel a demand was assigned to.
• Validating that distribution attribute data is correctly configured after updates.
• Troubleshooting allocation-related issues reported by QA or operations.
• Auditing records to ensure no expected attributes are missing.

Best practices

• Prefer query_all_attributes(demand_id) to get total count and grouped results before inspecting details.
• Always confirm your DB credentials and permissions before running queries.
• Filter out records with del_flag = 1 to avoid deleted entries unless intentionally checking history.
• Treat attribute_value as JSON array and parse it rather than relying on text matching.
• Use demand_id as a quoted string and include standard_item_id context when multiple items exist.

Example use cases

• Use query_allocated_quality('B26020702530') to list quality types like INTERNAL_BRAND or ORIGINAL_BRAND for a demand.
• Run query_distribute_channel('B26020702530') to verify assigned channels such as CASS_STRICT_INTERNAL_BRAND_SUPPLY.
• Call query_all_attributes('B26020702530') to obtain record count and per-type grouping for QA validation.
• Execute a custom query_distribute_attribute('B26020702530','ALLOCATED_QUALITY') when automating checks in test scripts.