import boto3
from boto3.dynamodb.conditions import Key, Attr

dynamodb = boto3.resource("dynamodb", region_name="eu-west-1")
table = dynamodb.Table("Orders")

# Table design: Partition Key = user_id, Sort Key = order_id
# מאפשר query על כל orders של user, sorted לפי order_id

# Write item
table.put_item(
    Item={
        "user_id": "user-123",          # Partition Key
        "order_id": "2026-01-15#ord-456", # Sort Key (timestamp prefix לsorting)
        "status": "pending",
        "total": "149.99",
        "items": [
            {"product_id": "prod-789", "qty": 2, "price": "74.99"}
        ],
        "created_at": "2026-01-15T10:30:00Z",
        "ttl": 1800000000  # Unix timestamp — item יימחק אוטומטית
    }
)

# Query — כל orders של user מ-2026
response = table.query(
    KeyConditionExpression=Key("user_id").eq("user-123") &
        Key("order_id").begins_with("2026-"),
    FilterExpression=Attr("status").eq("pending"),
    Limit=20,
    ScanIndexForward=False  # newest first
)
orders = response["Items"]

# Global Secondary Index (GSI) — query לפי status
# הגדרת GSI: Partition Key = status, Sort Key = created_at
gsi_response = table.query(
    IndexName="status-created-at-index",
    KeyConditionExpression=Key("status").eq("pending") &
        Key("created_at").begins_with("2026-01"),
    Limit=100
)
Databases — RDS, DynamoDB, Cloud SQL, Cosmos DB

Databases — RDS, DynamoDB, Cloud SQL, Cosmos DB

Databases — RDS, DynamoDB, Cloud SQL, Cosmos DB
