# Отримання сесії за композитним ключем
aws dynamodb get-item \
    --table-name UserSessions \
    --key '{"UserId": {"S": "usr-001"}, "SessionId": {"S": "sess-a1b2c3d4"}}' \
    --region eu-central-1

var client = new AmazonDynamoDBClient();
var response = await client.GetItemAsync(new GetItemRequest
{
    TableName = "UserSessions",
    Key = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } }
    }
});

# Отримання сесії за композитним ключем
$key = @{
    UserId    = New-DDBEntry -S 'usr-001'
    SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
}
Get-DDBItem -TableName UserSessions -Key $key -Region eu-central-1

# Запис нової сесії (якщо вже існує — буде повністю перезаписано)
aws dynamodb put-item \
    --table-name UserSessions \
    --item '{
        "UserId":    {"S": "usr-001"},
        "SessionId": {"S": "sess-a1b2c3d4"},
        "CreatedAt": {"S": "2025-06-01T10:00:00Z"},
        "IsActive":  {"BOOL": true}
    }' \
    --region eu-central-1

var response = await client.PutItemAsync(new PutItemRequest
{
    TableName = "UserSessions",
    Item = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } },
        { "CreatedAt", new AttributeValue { S = "2025-06-01T10:00:00Z" } },
        { "IsActive", new AttributeValue { BOOL = true } }
    }
});

# Запис нової сесії (або повний перезапис наявної)
$item = @{
    UserId    = New-DDBEntry -S 'usr-001'
    SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
    CreatedAt = New-DDBEntry -S '2025-06-01T10:00:00Z'
    IsActive  = New-DDBEntry -BOOL $true
}
Set-DDBItem -TableName UserSessions -Item $item -Region eu-central-1

# Атомарне оновлення статусу та часу активності сесії
aws dynamodb update-item \
    --table-name UserSessions \
    --key '{"UserId": {"S": "usr-001"}, "SessionId": {"S": "sess-a1b2c3d4"}}' \
    --update-expression "SET IsActive = :false, LastActivity = :now" \
    --expression-attribute-values '{
        ":false": {"BOOL": false},
        ":now":   {"S": "2025-06-01T12:00:00Z"}
    }' \
    --region eu-central-1

var response = await client.UpdateItemAsync(new UpdateItemRequest
{
    TableName = "UserSessions",
    Key = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } }
    },
    UpdateExpression = "SET IsActive = :false, LastActivity = :now",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":false", new AttributeValue { BOOL = false } },
        { ":now", new AttributeValue { S = "2025-06-01T12:00:00Z" } }
    }
});

# Атомарне оновлення статусу та часу активності
$updateRequest = [Amazon.DynamoDBv2.Model.UpdateItemRequest]@{
    TableName = 'UserSessions'
    Key = @{
        UserId    = New-DDBEntry -S 'usr-001'
        SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
    }
    UpdateExpression = 'SET IsActive = :false, LastActivity = :now'
    ExpressionAttributeValues = @{
        ':false' = New-DDBEntry -BOOL $false
        ':now'   = New-DDBEntry -S '2025-06-01T12:00:00Z'
    }
}
Update-DDBItem -UpdateItemRequest $updateRequest -Region eu-central-1

# Видалення сесії за її первинним ключем
aws dynamodb delete-item \
    --table-name UserSessions \
    --key '{"UserId": {"S": "usr-001"}, "SessionId": {"S": "sess-a1b2c3d4"}}' \
    --region eu-central-1

var response = await client.DeleteItemAsync(new DeleteItemRequest
{
    TableName = "UserSessions",
    Key = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } }
    }
});

# Видалення сесії за первинним ключем
$key = @{
    UserId    = New-DDBEntry -S 'usr-001'
    SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
}
Remove-DDBItem -TableName UserSessions -Key $key -Region eu-central-1

# Пошук сесій користувача, які починаються з певного префіксу
aws dynamodb query \
    --table-name UserSessions \
    --key-condition-expression "UserId = :uid AND SessionId begins_with(:sessPrefix)" \
    --expression-attribute-values '{
        ":uid":        {"S": "usr-001"},
        ":sessPrefix": {"S": "sess-a"}
    }' \
    --region eu-central-1

var response = await client.QueryAsync(new QueryRequest
{
    TableName = "UserSessions",
    KeyConditionExpression = "UserId = :uid AND SessionId begins_with(:sessPrefix)",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":uid", new AttributeValue { S = "usr-001" } },
        { ":sessPrefix", new AttributeValue { S = "sess-a" } }
    }
});

# Пошук сесій за Partition Key та префіксом Sort Key
$queryRequest = [Amazon.DynamoDBv2.Model.QueryRequest]@{
    TableName = 'UserSessions'
    KeyConditionExpression = 'UserId = :uid AND SessionId begins_with(:sessPrefix)'
    ExpressionAttributeValues = @{
        ':uid'        = New-DDBEntry -S 'usr-001'
        ':sessPrefix' = New-DDBEntry -S 'sess-a'
    }
}
Invoke-DDBQuery -QueryRequest $queryRequest -Region eu-central-1

# Сканування всієї таблиці для пошуку активних сесій (неефективно!)
aws dynamodb scan \
    --table-name UserSessions \
    --filter-expression "IsActive = :true" \
    --expression-attribute-values '{":true": {"BOOL": true}}' \
    --region eu-central-1

var response = await client.ScanAsync(new ScanRequest
{
    TableName = "UserSessions",
    FilterExpression = "IsActive = :true",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":true", new AttributeValue { BOOL = true } }
    }
});

# Сканування всієї таблиці з фільтрацією
$scanRequest = [Amazon.DynamoDBv2.Model.ScanRequest]@{
    TableName = 'UserSessions'
    FilterExpression = 'IsActive = :true'
    ExpressionAttributeValues = @{
        ':true' = New-DDBEntry -BOOL $true
    }
}
Invoke-DDBScan -ScanRequest $scanRequest -Region eu-central-1

# Пакетне отримання кількох сесій за один запит
aws dynamodb batch-get-item \
    --request-items '{
        "UserSessions": {
            "Keys": [
                {"UserId": {"S": "usr-001"}, "SessionId": {"S": "sess-a1b2"}},
                {"UserId": {"S": "usr-002"}, "SessionId": {"S": "sess-c3d4"}}
            ]
        }
    }' \
    --region eu-central-1

var response = await client.BatchGetItemAsync(new BatchGetItemRequest
{
    RequestItems = new Dictionary<string, KeysAndAttributes>
    {
        {
            "UserSessions", new KeysAndAttributes
            {
                Keys = new List<Dictionary<string, AttributeValue>>
                {
                    new Dictionary<string, AttributeValue>
                    {
                        { "UserId", new AttributeValue { S = "usr-001" } },
                        { "SessionId", new AttributeValue { S = "sess-a1b2" } }
                    },
                    new Dictionary<string, AttributeValue>
                    {
                        { "UserId", new AttributeValue { S = "usr-002" } },
                        { "SessionId", new AttributeValue { S = "sess-c3d4" } }
                    }
                }
            }
        }
    }
});

# Пакетне отримання кількох елементів за один запит
$requestItems = @{
    'UserSessions' = [Amazon.DynamoDBv2.Model.KeysAndAttributes]@{
        Keys = @(
            @{ UserId = New-DDBEntry -S 'usr-001'; SessionId = New-DDBEntry -S 'sess-a1b2' },
            @{ UserId = New-DDBEntry -S 'usr-002'; SessionId = New-DDBEntry -S 'sess-c3d4' }
        )
    }
}
Get-DDBItemBatch -RequestItems $requestItems -Region eu-central-1

# Пакетний запис та видалення сесій (до 25 операцій)
aws dynamodb batch-write-item \
    --request-items '{
        "UserSessions": [
            {
                "PutRequest": {
                    "Item": {
                        "UserId": {"S": "usr-001"},
                        "SessionId": {"S": "sess-e5f6"},
                        "IsActive": {"BOOL": true}
                    }
                }
            },
            {
                "DeleteRequest": {
                    "Key": {
                        "UserId": {"S": "usr-002"},
                        "SessionId": {"S": "sess-old"}
                    }
                }
            }
        ]
    }' \
    --region eu-central-1

var response = await client.BatchWriteItemAsync(new BatchWriteItemRequest
{
    RequestItems = new Dictionary<string, List<WriteRequest>>
    {
        {
            "UserSessions", new List<WriteRequest>
            {
                new WriteRequest
                {
                    PutRequest = new PutRequest
                    {
                        Item = new Dictionary<string, AttributeValue>
                        {
                            { "UserId", new AttributeValue { S = "usr-001" } },
                            { "SessionId", new AttributeValue { S = "sess-e5f6" } },
                            { "IsActive", new AttributeValue { BOOL = true } }
                        }
                    }
                },
                new WriteRequest
                {
                    DeleteRequest = new DeleteRequest
                    {
                        Key = new Dictionary<string, AttributeValue>
                        {
                            { "UserId", new AttributeValue { S = "usr-002" } },
                            { "SessionId", new AttributeValue { S = "sess-old" } }
                        }
                    }
                }
            }
        }
    }
});

# Пакетний запис та видалення кількох елементів
$writeRequests = @(
    [Amazon.DynamoDBv2.Model.WriteRequest]@{
        PutRequest = @{
            Item = @{
                UserId    = New-DDBEntry -S 'usr-001'
                SessionId = New-DDBEntry -S 'sess-e5f6'
                IsActive  = New-DDBEntry -BOOL $true
            }
        }
    },
    [Amazon.DynamoDBv2.Model.WriteRequest]@{
        DeleteRequest = @{
            Key = @{
                UserId    = New-DDBEntry -S 'usr-002'
                SessionId = New-DDBEntry -S 'sess-old'
            }
        }
    }
)
$requestItems = @{ 'UserSessions' = $writeRequests }
Write-DDBItemBatch -RequestItems $requestItems -Region eu-central-1

# Атомарна транзакція: запис нової сесії та збільшення лічильника сесій користувача
aws dynamodb transact-write-items \
    --transact-items '[
        {
            "Put": {
                "TableName": "UserSessions",
                "Item": {
                    "UserId":    {"S": "usr-001"},
                    "SessionId": {"S": "sess-new"},
                    "IsActive":  {"BOOL": true}
                }
            }
        },
        {
            "Update": {
                "TableName": "Users",
                "Key": {"UserId": {"S": "usr-001"}},
                "UpdateExpression": "ADD ActiveSessionsCount :one",
                "ExpressionAttributeValues": {":one": {"N": "1"}}
            }
        }
    ]' \
    --region eu-central-1

var response = await client.TransactWriteItemsAsync(new TransactWriteItemsRequest
{
    TransactItems = new List<TransactWriteItem>
    {
        new TransactWriteItem
        {
            Put = new Put
            {
                TableName = "UserSessions",
                Item = new Dictionary<string, AttributeValue>
                {
                    { "UserId", new AttributeValue { S = "usr-001" } },
                    { "SessionId", new AttributeValue { S = "sess-new" } },
                    { "IsActive", new AttributeValue { BOOL = true } }
                }
            }
        },
        new TransactWriteItem
        {
            Update = new Update
            {
                TableName = "Users",
                Key = new Dictionary<string, AttributeValue>
                {
                    { "UserId", new AttributeValue { S = "usr-001" } }
                },
                UpdateExpression = "ADD ActiveSessionsCount :one",
                ExpressionAttributeValues = new Dictionary<string, AttributeValue>
                {
                    { ":one", new AttributeValue { N = "1" } }
                }
            }
        }
    }
});

# Атомарна транзакція з кількох операцій запису/оновлення
$transactItems = @(
    [Amazon.DynamoDBv2.Model.TransactWriteItem]@{
        Put = @{
            TableName = 'UserSessions'
            Item = @{
                UserId    = New-DDBEntry -S 'usr-001'
                SessionId = New-DDBEntry -S 'sess-new'
                IsActive  = New-DDBEntry -BOOL $true
            }
        }
    },
    [Amazon.DynamoDBv2.Model.TransactWriteItem]@{
        Update = @{
            TableName = 'Users'
            Key = @{ UserId = New-DDBEntry -S 'usr-001' }
            UpdateExpression = 'ADD ActiveSessionsCount :one'
            ExpressionAttributeValues = @{ ':one' = New-DDBEntry -N '1' }
        }
    }
)
Submit-DDBTransactWriteItems -TransactItem $transactItems -Region eu-central-1

# Створення таблиці UserSessions з Composite Primary Key
aws dynamodb create-table \
    --table-name UserSessions \
    --attribute-definitions \
        AttributeName=UserId,AttributeType=S \
        AttributeName=SessionId,AttributeType=S \
    --key-schema \
        AttributeName=UserId,KeyType=HASH \
        AttributeName=SessionId,KeyType=RANGE \
    --billing-mode PAY_PER_REQUEST \
    --region eu-central-1

var client = new AmazonDynamoDBClient();
var response = await client.CreateTableAsync(new CreateTableRequest
{
    TableName = "UserSessions",
    AttributeDefinitions = new List<AttributeDefinition>
    {
        new AttributeDefinition { AttributeName = "UserId", AttributeType = ScalarAttributeType.S },
        new AttributeDefinition { AttributeName = "SessionId", AttributeType = ScalarAttributeType.S }
    },
    KeySchema = new List<KeySchemaElement>
    {
        new KeySchemaElement { AttributeName = "UserId", KeyType = KeyType.HASH },
        new KeySchemaElement { AttributeName = "SessionId", KeyType = KeyType.RANGE }
    },
    BillingMode = BillingMode.PAY_PER_REQUEST
});

# Встановити AWS Tools for PowerShell (якщо ще не встановлено)
# Install-Module -Name AWS.Tools.DynamoDBv2 -Force

# Створення таблиці UserSessions з Composite Primary Key
$attrUserId    = New-DDBAttributeDefinition -AttributeName UserId    -AttributeType S
$attrSessionId = New-DDBAttributeDefinition -AttributeName SessionId -AttributeType S

$keyUserId    = New-DDBKeySchemaElement -AttributeName UserId    -KeyType HASH
$keySessionId = New-DDBKeySchemaElement -AttributeName SessionId -KeyType RANGE

New-DDBTable `
    -TableName   UserSessions `
    -AttributeDefinition @($attrUserId, $attrSessionId) `
    -KeySchema   @($keyUserId, $keySessionId) `
    -BillingMode PAY_PER_REQUEST `
    -Region      eu-central-1

# Дочекатися поки таблиця перейде у стан ACTIVE
aws dynamodb wait table-exists \
    --table-name UserSessions \
    --region eu-central-1

echo "Таблиця UserSessions готова"

# Перевірити статус таблиці
aws dynamodb describe-table \
    --table-name UserSessions \
    --region eu-central-1 \
    --query "Table.{Status: TableStatus, ItemCount: ItemCount, SizeBytes: TableSizeBytes}"

var client = new AmazonDynamoDBClient();
while (true)
{
    var res = await client.DescribeTableAsync("UserSessions");
    if (res.Table.TableStatus == TableStatus.ACTIVE)
    {
        Console.WriteLine("Таблиця UserSessions готова");
        Console.WriteLine($"Status: {res.Table.TableStatus}, Items: {res.Table.ItemCount}, Size: {res.Table.TableSizeBytes} bytes");
        break;
    }
    await Task.Delay(5000);
}

# Дочекатися стану ACTIVE (з timeout 5 хвилин)
$timeout = [DateTime]::UtcNow.AddMinutes(5)
do {
    $table = Get-DDBTable -TableName UserSessions -Region eu-central-1
    if ($table.TableStatus -eq 'ACTIVE') { break }
    Write-Host "Статус: $($table.TableStatus) — очікуємо..."
    Start-Sleep -Seconds 5
} until ([DateTime]::UtcNow -ge $timeout)

Write-Host "Таблиця UserSessions готова"

# Перевірити статус таблиці
$t = Get-DDBTable -TableName UserSessions -Region eu-central-1
[PSCustomObject]@{
    Status    = $t.TableStatus
    ItemCount = $t.ItemCount
    SizeBytes = $t.TableSizeBytes
}

# ── PutItem: записати новий елемент ───────────────────────────────────────
aws dynamodb put-item \
    --table-name UserSessions \
    --item '{
        "UserId":    {"S": "usr-001"},
        "SessionId": {"S": "sess-a1b2c3d4"},
        "CreatedAt": {"S": "2025-06-01T10:00:00Z"},
        "ExpiresAt": {"S": "2025-06-01T22:00:00Z"},
        "IpAddress": {"S": "203.0.113.42"},
        "UserAgent": {"S": "Mozilla/5.0 (Windows NT 10.0; Win64; x64)"},
        "IsActive":  {"BOOL": true}
    }' \
    --region eu-central-1

# ── GetItem: отримати один елемент ────────────────────────────────────────
aws dynamodb get-item \
    --table-name UserSessions \
    --key '{"UserId": {"S": "usr-001"}, "SessionId": {"S": "sess-a1b2c3d4"}}' \
    --region eu-central-1

# ── Query: знайти всі сесії користувача ──────────────────────────────────
aws dynamodb query \
    --table-name UserSessions \
    --key-condition-expression "UserId = :uid" \
    --expression-attribute-values '{":uid": {"S": "usr-001"}}' \
    --region eu-central-1

# ── UpdateItem: деактивувати сесію ────────────────────────────────────────
aws dynamodb update-item \
    --table-name UserSessions \
    --key '{"UserId": {"S": "usr-001"}, "SessionId": {"S": "sess-a1b2c3d4"}}' \
    --update-expression "SET IsActive = :false" \
    --expression-attribute-values '{":false": {"BOOL": false}}' \
    --region eu-central-1

# ── DeleteItem: видалити сесію ───────────────────────────────────────────
aws dynamodb delete-item \
    --table-name UserSessions \
    --key '{"UserId": {"S": "usr-001"}, "SessionId": {"S": "sess-a1b2c3d4"}}' \
    --region eu-central-1

var client = new AmazonDynamoDBClient();

// ── PutItem: записати новий елемент ───────────────────────────────────────
await client.PutItemAsync(new PutItemRequest
{
    TableName = "UserSessions",
    Item = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } },
        { "CreatedAt", new AttributeValue { S = "2025-06-01T10:00:00Z" } },
        { "ExpiresAt", new AttributeValue { S = "2025-06-01T22:00:00Z" } },
        { "IpAddress", new AttributeValue { S = "203.0.113.42" } },
        { "UserAgent", new AttributeValue { S = "Mozilla/5.0 (Windows NT 10.0; Win64; x64)" } },
        { "IsActive", new AttributeValue { BOOL = true } }
    }
});

// ── GetItem: отримати один елемент ────────────────────────────────────────
var getResponse = await client.GetItemAsync(new GetItemRequest
{
    TableName = "UserSessions",
    Key = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } }
    }
});

// ── Query: знайти всі сесії користувача ──────────────────────────────────
var queryResponse = await client.QueryAsync(new QueryRequest
{
    TableName = "UserSessions",
    KeyConditionExpression = "UserId = :uid",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":uid", new AttributeValue { S = "usr-001" } }
    }
});

// ── UpdateItem: деактивувати сесію ────────────────────────────────────────
await client.UpdateItemAsync(new UpdateItemRequest
{
    TableName = "UserSessions",
    Key = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } }
    },
    UpdateExpression = "SET IsActive = :false",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":false", new AttributeValue { BOOL = false } }
    }
});

// ── DeleteItem: видалити сесію ───────────────────────────────────────────
await client.DeleteItemAsync(new DeleteItemRequest
{
    TableName = "UserSessions",
    Key = new Dictionary<string, AttributeValue>
    {
        { "UserId", new AttributeValue { S = "usr-001" } },
        { "SessionId", new AttributeValue { S = "sess-a1b2c3d4" } }
    }
});

Import-Module AWS.Tools.DynamoDBv2

# ── PutItem: записати новий елемент ───────────────────────────────────────
$item = @{
    UserId    = New-DDBEntry -S 'usr-001'
    SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
    CreatedAt = New-DDBEntry -S '2025-06-01T10:00:00Z'
    ExpiresAt = New-DDBEntry -S '2025-06-01T22:00:00Z'
    IpAddress = New-DDBEntry -S '203.0.113.42'
    UserAgent = New-DDBEntry -S 'Mozilla/5.0 (Windows NT 10.0; Win64; x64)'
    IsActive  = New-DDBEntry -BOOL $true
}
Set-DDBItem -TableName UserSessions -Item $item -Region eu-central-1

# ── GetItem: отримати один елемент ────────────────────────────────────────
$key = @{
    UserId    = New-DDBEntry -S 'usr-001'
    SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
}
Get-DDBItem -TableName UserSessions -Key $key -Region eu-central-1

# ── Query: знайти всі сесії користувача ──────────────────────────────────
$queryRequest = [Amazon.DynamoDBv2.Model.QueryRequest]@{
    TableName                 = 'UserSessions'
    KeyConditionExpression    = 'UserId = :uid'
    ExpressionAttributeValues = @{
        ':uid' = New-DDBEntry -S 'usr-001'
    }
}
Invoke-DDBQuery -QueryRequest $queryRequest -Region eu-central-1

# ── UpdateItem: деактивувати сесію ────────────────────────────────────────
$updateRequest = [Amazon.DynamoDBv2.Model.UpdateItemRequest]@{
    TableName        = 'UserSessions'
    Key              = @{
        UserId    = New-DDBEntry -S 'usr-001'
        SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
    }
    UpdateExpression = 'SET IsActive = :false'
    ExpressionAttributeValues = @{
        ':false' = New-DDBEntry -BOOL $false
    }
}
Update-DDBItem -UpdateItemRequest $updateRequest -Region eu-central-1

# ── DeleteItem: видалити сесію ───────────────────────────────────────────
$delKey = @{
    UserId    = New-DDBEntry -S 'usr-001'
    SessionId = New-DDBEntry -S 'sess-a1b2c3d4'
}
Remove-DDBItem -TableName UserSessions -Key $delKey -Region eu-central-1

# Таблиця UserSessions з LSI SessionsByExpiry
aws dynamodb create-table \
    --table-name UserSessions \
    --attribute-definitions \
        AttributeName=UserId,AttributeType=S \
        AttributeName=SessionId,AttributeType=S \
        AttributeName=ExpiresAt,AttributeType=S \
    --key-schema \
        AttributeName=UserId,KeyType=HASH \
        AttributeName=SessionId,KeyType=RANGE \
    --local-secondary-indexes '[
        {
            "IndexName": "SessionsByExpiry",
            "KeySchema": [
                {"AttributeName": "UserId",    "KeyType": "HASH"},
                {"AttributeName": "ExpiresAt", "KeyType": "RANGE"}
            ],
            "Projection": {
                "ProjectionType": "INCLUDE",
                "NonKeyAttributes": ["IsActive", "IpAddress"]
            }
        }
    ]' \
    --billing-mode PAY_PER_REQUEST \
    --region eu-central-1

var client = new AmazonDynamoDBClient();
var response = await client.CreateTableAsync(new CreateTableRequest
{
    TableName = "UserSessions",
    AttributeDefinitions = new List<AttributeDefinition>
    {
        new AttributeDefinition { AttributeName = "UserId", AttributeType = ScalarAttributeType.S },
        new AttributeDefinition { AttributeName = "SessionId", AttributeType = ScalarAttributeType.S },
        new AttributeDefinition { AttributeName = "ExpiresAt", AttributeType = ScalarAttributeType.S }
    },
    KeySchema = new List<KeySchemaElement>
    {
        new KeySchemaElement { AttributeName = "UserId", KeyType = KeyType.HASH },
        new KeySchemaElement { AttributeName = "SessionId", KeyType = KeyType.RANGE }
    },
    LocalSecondaryIndexes = new List<LocalSecondaryIndex>
    {
        new LocalSecondaryIndex
        {
            IndexName = "SessionsByExpiry",
            KeySchema = new List<KeySchemaElement>
            {
                new KeySchemaElement { AttributeName = "UserId", KeyType = KeyType.HASH },
                new KeySchemaElement { AttributeName = "ExpiresAt", KeyType = KeyType.RANGE }
            },
            Projection = new Projection
            {
                ProjectionType = ProjectionType.INCLUDE,
                NonKeyAttributes = new List<string> { "IsActive", "IpAddress" }
            }
        }
    },
    BillingMode = BillingMode.PAY_PER_REQUEST
});

$attrUserId    = New-DDBAttributeDefinition -AttributeName UserId    -AttributeType S
$attrSessionId = New-DDBAttributeDefinition -AttributeName SessionId -AttributeType S
$attrExpiresAt = New-DDBAttributeDefinition -AttributeName ExpiresAt -AttributeType S

$keyUserId    = New-DDBKeySchemaElement -AttributeName UserId    -KeyType HASH
$keySessionId = New-DDBKeySchemaElement -AttributeName SessionId -KeyType RANGE

# LSI: той самий PK (UserId), новий SK (ExpiresAt)
$lsiKey1 = New-DDBKeySchemaElement -AttributeName UserId    -KeyType HASH
$lsiKey2 = New-DDBKeySchemaElement -AttributeName ExpiresAt -KeyType RANGE

$lsiProjection = [Amazon.DynamoDBv2.Model.Projection]@{
    ProjectionType   = 'INCLUDE'
    NonKeyAttributes = @('IsActive', 'IpAddress')
}

$lsi = [Amazon.DynamoDBv2.Model.LocalSecondaryIndex]@{
    IndexName  = 'SessionsByExpiry'
    KeySchema  = @($lsiKey1, $lsiKey2)
    Projection = $lsiProjection
}

New-DDBTable `
    -TableName            UserSessions `
    -AttributeDefinition  @($attrUserId, $attrSessionId, $attrExpiresAt) `
    -KeySchema            @($keyUserId, $keySessionId) `
    -LocalSecondaryIndex  @($lsi) `
    -BillingMode          PAY_PER_REQUEST `
    -Region               eu-central-1

# Знайти сесії usr-001, що закінчаться до 2025-06-02T00:00:00Z
aws dynamodb query \
    --table-name UserSessions \
    --index-name SessionsByExpiry \
    --key-condition-expression "UserId = :uid AND ExpiresAt < :exp" \
    --expression-attribute-values '{
        ":uid": {"S": "usr-001"},
        ":exp": {"S": "2025-06-02T00:00:00Z"}
    }' \
    --region eu-central-1

var client = new AmazonDynamoDBClient();
var response = await client.QueryAsync(new QueryRequest
{
    TableName = "UserSessions",
    IndexName = "SessionsByExpiry",
    KeyConditionExpression = "UserId = :uid AND ExpiresAt < :exp",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":uid", new AttributeValue { S = "usr-001" } },
        { ":exp", new AttributeValue { S = "2025-06-02T00:00:00Z" } }
    }
});

$queryRequest = [Amazon.DynamoDBv2.Model.QueryRequest]@{
    TableName              = 'UserSessions'
    IndexName              = 'SessionsByExpiry'
    KeyConditionExpression = 'UserId = :uid AND ExpiresAt < :exp'
    ExpressionAttributeValues = @{
        ':uid' = New-DDBEntry -S 'usr-001'
        ':exp' = New-DDBEntry -S '2025-06-02T00:00:00Z'
    }
}
Invoke-DDBQuery -QueryRequest $queryRequest -Region eu-central-1

# ── Додавання GSI SessionsByIp до існуючої таблиці UserSessions ──────────────
aws dynamodb update-table \
    --table-name UserSessions \
    --attribute-definitions \
        AttributeName=IpAddress,AttributeType=S \
        AttributeName=CreatedAt,AttributeType=S \
    --global-secondary-index-updates '[{
        "Create": {
            "IndexName": "SessionsByIp",
            "KeySchema": [
                {"AttributeName": "IpAddress", "KeyType": "HASH"},
                {"AttributeName": "CreatedAt", "KeyType": "RANGE"}
            ],
            "Projection": {
                "ProjectionType": "INCLUDE",
                "NonKeyAttributes": ["UserId", "IsActive"]
            }
        }
    }]' \
    --region eu-central-1

# ── Моніторинг статусу створення індексу ─────────────────────────────────────
aws dynamodb describe-table \
    --table-name UserSessions \
    --region eu-central-1 \
    --query "Table.GlobalSecondaryIndexes[*].{Name:IndexName, Status:IndexStatus}"

using Amazon.DynamoDBv2;
using Amazon.DynamoDBv2.Model;

var client = new AmazonDynamoDBClient();

// ── Додавання GSI (SessionsByIp) до існуючої таблиці (UserSessions) ──────────
await client.UpdateTableAsync(new UpdateTableRequest
{
    TableName = "UserSessions",
    AttributeDefinitions = new List<AttributeDefinition>
    {
        new() { AttributeName = "IpAddress", AttributeType = ScalarAttributeType.S },
        new() { AttributeName = "CreatedAt", AttributeType = ScalarAttributeType.S }
    },
    GlobalSecondaryIndexUpdates = new List<GlobalSecondaryIndexUpdate>
    {
        new()
        {
            Create = new CreateGlobalSecondaryIndexAction
            {
                IndexName = "SessionsByIp",
                KeySchema = new List<KeySchemaElement>
                {
                    new() { AttributeName = "IpAddress", KeyType = KeyType.HASH },
                    new() { AttributeName = "CreatedAt", KeyType = KeyType.RANGE }
                },
                Projection = new Projection
                {
                    ProjectionType = ProjectionType.INCLUDE,
                    NonKeyAttributes = new List<string> { "UserId", "IsActive" }
                },
                ProvisionedThroughput = new ProvisionedThroughput
                {
                    ReadCapacityUnits = 50,
                    WriteCapacityUnits = 50
                }
            }
        }
    }
});

Import-Module AWS.Tools.DynamoDBv2

$attrIp        = New-DDBAttributeDefinition -AttributeName IpAddress -AttributeType S
$attrCreatedAt = New-DDBAttributeDefinition -AttributeName CreatedAt -AttributeType S

$gsiKeyIp        = New-DDBKeySchemaElement -AttributeName IpAddress -KeyType HASH
$gsiKeyCreatedAt = New-DDBKeySchemaElement -AttributeName CreatedAt -KeyType RANGE

$gsiProjection = [Amazon.DynamoDBv2.Model.Projection]@{
    ProjectionType   = 'INCLUDE'
    NonKeyAttributes = @('UserId', 'IsActive')
}

$gsiCreate = [Amazon.DynamoDBv2.Model.GlobalSecondaryIndexUpdate]@{
    Create = [Amazon.DynamoDBv2.Model.CreateGlobalSecondaryIndexAction]@{
        IndexName  = 'SessionsByIp'
        KeySchema  = @($gsiKeyIp, $gsiKeyCreatedAt)
        Projection = $gsiProjection
    }
}

Update-DDBTable `
    -TableName                     UserSessions `
    -AttributeDefinition           @($attrIp, $attrCreatedAt) `
    -GlobalSecondaryIndexUpdate    @($gsiCreate) `
    -Region                        eu-central-1

# ── Перевірка статусу створення індексу ──────────────────────────────────────
(Get-DDBTable -TableName UserSessions -Region eu-central-1).GlobalSecondaryIndexes |
    Select-Object IndexName, IndexStatus

# ── Пошук сесій за IP та часом створення ──────────────────────────────────────
aws dynamodb query \
    --table-name UserSessions \
    --index-name SessionsByIp \
    --key-condition-expression "IpAddress = :ip AND CreatedAt >= :since" \
    --expression-attribute-values '{
        ":ip":    {"S": "203.0.113.42"},
        ":since": {"S": "2025-05-25T00:00:00Z"}
    }' \
    --region eu-central-1

# ── Видалення глобального індексу GSI ─────────────────────────────────────────
aws dynamodb update-table \
    --table-name UserSessions \
    --global-secondary-index-updates '[{
        "Delete": {"IndexName": "SessionsByIp"}
    }]' \
    --region eu-central-1

using Amazon.DynamoDBv2;
using Amazon.DynamoDBv2.Model;

var client = new AmazonDynamoDBClient();

// ── Пошук сесій за IP та датою через GSI ─────────────────────────────────────
var queryRequest = new QueryRequest
{
    TableName = "UserSessions",
    IndexName = "SessionsByIp",
    KeyConditionExpression = "IpAddress = :ip AND CreatedAt >= :since",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":ip", new AttributeValue { S = "203.0.113.42" } },
        { ":since", new AttributeValue { S = "2025-05-25T00:00:00Z" } }
    }
};

var response = await client.QueryAsync(queryRequest);

Import-Module AWS.Tools.DynamoDBv2

# ── Пошук сесій за IP та часом створення ──────────────────────────────────────
$queryRequest = [Amazon.DynamoDBv2.Model.QueryRequest]@{
    TableName              = 'UserSessions'
    IndexName              = 'SessionsByIp'
    KeyConditionExpression = 'IpAddress = :ip AND CreatedAt >= :since'
    ExpressionAttributeValues = @{
        ':ip'    = New-DDBEntry -S '203.0.113.42'
        ':since' = New-DDBEntry -S '2025-05-25T00:00:00Z'
    }
}
$result = Invoke-DDBQuery -QueryRequest $queryRequest -Region eu-central-1
$result.Items

# ── Видалення глобального індексу GSI ─────────────────────────────────────────
$gsiDelete = [Amazon.DynamoDBv2.Model.GlobalSecondaryIndexUpdate]@{
    Delete = [Amazon.DynamoDBv2.Model.DeleteGlobalSecondaryIndexAction]@{
        IndexName = 'SessionsByIp'
    }
}
Update-DDBTable -TableName UserSessions -GlobalSecondaryIndexUpdate @($gsiDelete) -Region eu-central-1

# ── Створення таблиці Orders з двома GSI ──────────────────────────────────────
aws dynamodb create-table \
    --table-name Orders \
    --attribute-definitions \
        AttributeName=CustomerId,AttributeType=S \
        AttributeName=OrderDateId,AttributeType=S \
        AttributeName=PendingStatus,AttributeType=S \
        AttributeName=ProductId_0,AttributeType=S \
    --key-schema \
        AttributeName=CustomerId,KeyType=HASH \
        AttributeName=OrderDateId,KeyType=RANGE \
    --global-secondary-indexes '[
        {
            "IndexName": "PendingOrdersByDate",
            "KeySchema": [
                {"AttributeName": "PendingStatus", "KeyType": "HASH"},
                {"AttributeName": "OrderDateId",   "KeyType": "RANGE"}
            ],
            "Projection": {
                "ProjectionType": "INCLUDE",
                "NonKeyAttributes": ["CustomerId", "TotalAmount"]
            }
        },
        {
            "IndexName": "OrdersByProduct",
            "KeySchema": [
                {"AttributeName": "ProductId_0", "KeyType": "HASH"},
                {"AttributeName": "OrderDateId", "KeyType": "RANGE"}
            ],
            "Projection": {"ProjectionType": "KEYS_ONLY"}
        }
    ]' \
    --billing-mode PAY_PER_REQUEST \
    --region eu-central-1

# ── Запис нового PENDING замовлення (потрапляє в Sparse GSI) ──────────────────
aws dynamodb put-item \
    --table-name Orders \
    --item '{
        "CustomerId":    {"S": "cust-001"},
        "OrderDateId":   {"S": "2025-06-01T10:00#ord-XYZ"},
        "OrderId":       {"S": "ord-XYZ"},
        "Status":        {"S": "PENDING"},
        "PendingStatus": {"S": "PENDING"},
        "TotalAmount":   {"N": "149.99"},
        "ProductId_0":   {"S": "prod-laptop"}
    }' \
    --region eu-central-1

# ── Оплата замовлення (видалення PendingStatus -> автоматично зникає з GSI) ────
aws dynamodb update-item \
    --table-name Orders \
    --key '{"CustomerId": {"S": "cust-001"}, "OrderDateId": {"S": "2025-06-01T10:00#ord-XYZ"}}' \
    --update-expression "SET #s = :paid REMOVE PendingStatus" \
    --expression-attribute-names '{"#s": "Status"}' \
    --expression-attribute-values '{":paid": {"S": "PAID"}}' \
    --region eu-central-1

# ── Отримання активних PENDING замовлень через Sparse GSI ───────────────────────
aws dynamodb query \
    --table-name Orders \
    --index-name PendingOrdersByDate \
    --key-condition-expression "PendingStatus = :p" \
    --expression-attribute-values '{":p": {"S": "PENDING"}}' \
    --region eu-central-1

using Amazon.DynamoDBv2;
using Amazon.DynamoDBv2.Model;

var client = new AmazonDynamoDBClient();

// ── Створення таблиці Orders з двома глобальними індексами (GSI) ──────────────
await client.CreateTableAsync(new CreateTableRequest
{
    TableName = "Orders",
    AttributeDefinitions = new List<AttributeDefinition>
    {
        new() { AttributeName = "CustomerId", AttributeType = ScalarAttributeType.S },
        new() { AttributeName = "OrderDateId", AttributeType = ScalarAttributeType.S },
        new() { AttributeName = "PendingStatus", AttributeType = ScalarAttributeType.S },
        new() { AttributeName = "ProductId_0", AttributeType = ScalarAttributeType.S }
    },
    KeySchema = new List<KeySchemaElement>
    {
        new() { AttributeName = "CustomerId", KeyType = KeyType.HASH },
        new() { AttributeName = "OrderDateId", KeyType = KeyType.RANGE }
    },
    GlobalSecondaryIndexes = new List<GlobalSecondaryIndex>
    {
        new()
        {
            IndexName = "PendingOrdersByDate",
            KeySchema = new List<KeySchemaElement>
            {
                new() { AttributeName = "PendingStatus", KeyType = KeyType.HASH },
                new() { AttributeName = "OrderDateId", KeyType = KeyType.RANGE }
            },
            Projection = new Projection
            {
                ProjectionType = ProjectionType.INCLUDE,
                NonKeyAttributes = new List<string> { "CustomerId", "TotalAmount" }
            },
            ProvisionedThroughput = new ProvisionedThroughput { ReadCapacityUnits = 10, WriteCapacityUnits = 10 }
        },
        new()
        {
            IndexName = "OrdersByProduct",
            KeySchema = new List<KeySchemaElement>
            {
                new() { AttributeName = "ProductId_0", KeyType = KeyType.HASH },
                new() { AttributeName = "OrderDateId", KeyType = KeyType.RANGE }
            },
            Projection = new Projection { ProjectionType = ProjectionType.KEYS_ONLY },
            ProvisionedThroughput = new ProvisionedThroughput { ReadCapacityUnits = 10, WriteCapacityUnits = 10 }
        }
    },
    BillingMode = BillingMode.PAY_PER_REQUEST
});

// ── Запис нового замовлення зі статусом PENDING ──────────────────────────────
await client.PutItemAsync(new PutItemRequest
{
    TableName = "Orders",
    Item = new Dictionary<string, AttributeValue>
    {
        { "CustomerId", new AttributeValue { S = "cust-001" } },
        { "OrderDateId", new AttributeValue { S = "2025-06-01T10:00#ord-XYZ" } },
        { "OrderId", new AttributeValue { S = "ord-XYZ" } },
        { "Status", new AttributeValue { S = "PENDING" } },
        { "PendingStatus", new AttributeValue { S = "PENDING" } },
        { "TotalAmount", new AttributeValue { N = "149.99" } },
        { "ProductId_0", new AttributeValue { S = "prod-laptop" } }
    }
});

// ── Оплата замовлення: оновлення статусу та видалення PendingStatus ────────────
await client.UpdateItemAsync(new UpdateItemRequest
{
    TableName = "Orders",
    Key = new Dictionary<string, AttributeValue>
    {
        { "CustomerId", new AttributeValue { S = "cust-001" } },
        { "OrderDateId", new AttributeValue { S = "2025-06-01T10:00#ord-XYZ" } }
    },
    UpdateExpression = "SET #s = :paid REMOVE PendingStatus",
    ExpressionAttributeNames = new Dictionary<string, string> { { "#s", "Status" } },
    ExpressionAttributeValues = new Dictionary<string, AttributeValue> { { ":paid", new AttributeValue { S = "PAID" } } }
});

// ── Запит активних PENDING замовлень через Sparse GSI ──────────────────────────
var pendingQuery = new QueryRequest
{
    TableName = "Orders",
    IndexName = "PendingOrdersByDate",
    KeyConditionExpression = "PendingStatus = :p",
    ExpressionAttributeValues = new Dictionary<string, AttributeValue>
    {
        { ":p", new AttributeValue { S = "PENDING" } }
    }
};
var pendingResult = await client.QueryAsync(pendingQuery);