AI 原生开放教材

外观

Microsoft Agent Skills技能与配置库·英文原文 ↗原件 ↓仓库 ↗

Azure Data Tables SDK Acceptance Criteria ​

SDK: azure-data-tablesRepository: https://github.com/Azure/azure-sdk-for-pythonCommit: mainPurpose: Skill testing acceptance criteria for validating generated code correctness

1. Correct Import Patterns ​

1.1 Client Imports ​

✅ CORRECT: Sync Clients ​

python
from azure.data.tables import TableServiceClient, TableClient, UpdateMode, TableTransactionError
from azure.identity import DefaultAzureCredential

✅ CORRECT: Async Clients ​

python
from azure.data.tables.aio import TableServiceClient, TableClient
from azure.identity.aio import DefaultAzureCredential

1.2 Anti-Patterns (ERRORS) ​

❌ INCORRECT: Wrong module paths ​

python
# WRONG - module does not exist
from azure.data.table import TableClient

# WRONG - legacy Cosmos Table SDK
from azure.cosmosdb.table import TableService

# WRONG - models are not in this module
from azure.data.tables.models import TableClient

2. Authentication Patterns ​

2.1 ✅ CORRECT: DefaultAzureCredential with endpoint ​

python
import os
from azure.data.tables import TableServiceClient
from azure.identity import DefaultAzureCredential

credential = DefaultAzureCredential()

service_client = TableServiceClient(
    endpoint=os.environ["AZURE_STORAGE_ACCOUNT_URL"],
    credential=credential,
)

2.2 ✅ CORRECT: Connection string (Alternative) ​

python
import os
from azure.data.tables import TableServiceClient

service_client = TableServiceClient.from_connection_string(
    conn_str=os.environ["AZURE_STORAGE_CONNECTION_STRING"],
)

2.3 Anti-Patterns (ERRORS) ​

❌ INCORRECT: Hardcoded credentials ​

python
# WRONG - hardcoded account key/connection string
service_client = TableServiceClient.from_connection_string(
    "DefaultEndpointsProtocol=https;AccountName=...;AccountKey=..."
)

❌ INCORRECT: Wrong parameter name ​

python
# WRONG - TableServiceClient uses `endpoint`, not `url`
service_client = TableServiceClient(url=endpoint, credential=credential)

3. TableServiceClient Patterns ​

3.1 ✅ CORRECT: Table management ​

python
table_name = "orders"

service_client.create_table_if_not_exists(table_name)

table_client = service_client.get_table_client(table_name)

for table in service_client.list_tables():
    print(table.name)

3.2 Anti-Patterns (ERRORS) ​

❌ INCORRECT: Wrong method name ​

python
# WRONG - method does not exist
service_client.create_table_if_missing("orders")

4. TableClient Patterns ​

4.1 ✅ CORRECT: Create TableClient ​

python
table_client = TableClient(
    endpoint=os.environ["AZURE_STORAGE_ACCOUNT_URL"],
    table_name="orders",
    credential=DefaultAzureCredential(),
)

4.2 ✅ CORRECT: Entity CRUD operations ​

python
entity = {
    "PartitionKey": "sales",
    "RowKey": "order-001",
    "product": "Widget",
    "quantity": 2,
}

table_client.create_entity(entity=entity)

table_client.upsert_entity(entity=entity, mode=UpdateMode.MERGE)

fetched = table_client.get_entity(
    partition_key="sales",
    row_key="order-001",
)

table_client.update_entity(
    entity={"PartitionKey": "sales", "RowKey": "order-001", "quantity": 3},
    mode=UpdateMode.REPLACE,
)

table_client.delete_entity(partition_key="sales", row_key="order-001")

4.3 Anti-Patterns (ERRORS) ​

❌ INCORRECT: Missing required keys ​

python
# WRONG - PartitionKey/RowKey required for entity operations
table_client.create_entity(entity={"product": "Widget"})

❌ INCORRECT: Wrong key casing ​

python
# WRONG - must be PartitionKey/RowKey, not snake_case
table_client.upsert_entity(entity={"partition_key": "sales", "row_key": "1"})

5. Entity CRUD Patterns ​

5.1 ✅ CORRECT: Query entities with filter ​

python
entities = table_client.query_entities(
    query_filter="PartitionKey eq 'sales'"
)

for entity in entities:
    print(entity)

5.2 ✅ CORRECT: Parameterized query ​

python
entities = table_client.query_entities(
    query_filter="PartitionKey eq @pk and quantity gt @min_qty",
    parameters={"pk": "sales", "min_qty": 1},
)

5.3 Anti-Patterns (ERRORS) ​

❌ INCORRECT: Wrong filter parameter name ​

python
# WRONG - use query_filter, not filter
entities = table_client.query_entities(filter="PartitionKey eq 'sales'")

6. Batch Operations ​

6.1 ✅ CORRECT: submit_transaction ​

python
operations = [
    ("create", {"PartitionKey": "batch", "RowKey": "1", "value": 1}),
    ("upsert", {"PartitionKey": "batch", "RowKey": "2", "value": 2}),
]

try:
    table_client.submit_transaction(operations)
except TableTransactionError as exc:
    print(f"Transaction failed: {exc}")

6.2 Anti-Patterns (ERRORS) ​

❌ INCORRECT: Wrong method name ​

python
# WRONG - method does not exist
table_client.submit_batch(operations)

7. PartitionKey/RowKey Requirements ​

7.1 ✅ CORRECT: Explicit PartitionKey/RowKey ​

python
entity = {
    "PartitionKey": "inventory",
    "RowKey": "sku-1001",
    "name": "Keyboard",
}

7.2 Anti-Patterns (ERRORS) ​

❌ INCORRECT: Missing RowKey ​

python
# WRONG - RowKey required
entity = {"PartitionKey": "inventory", "name": "Keyboard"}