我需要在谷歌数据存储(NoSQL数据库)中计算多个字段的总和

from google.cloud import datastore

client = datastore.Client()

query = client.query(kind='YourEntityKind')
entities = list(query.fetch())

total_sum = 0
for entity in entities:
    total_sum += entity['field1'] + entity['field2']  # 添加更多字段

print(f'Total sum is {total_sum}')

from google.cloud import datastore
from google.cloud import tasks_v2

client = datastore.Client()
task_client = tasks_v2.CloudTasksClient()

def calculate_sum():
    query = client.query(kind='YourEntityKind')
    entities = list(query.fetch())
    total_sum = 0
    for entity in entities:
        total_sum += entity['field1'] + entity['field2']  # 添加更多字段
    print(f'Total sum is {total_sum}')

# 将任务添加到任务队列
parent = task_client.queue_path('your-project-id', 'your-location', 'your-queue')
task = {
    'http_request': {
        'http_method': tasks_v2.HttpMethod.POST,
        'url': 'https://your-backend-service/calculate-sum',
        'oidc_token': {
            'service_account_email': 'your-service-account@your-project-id.iam.gserviceaccount.com'
        }
    }
}
task_client.create_task(parent=parent, task=task)

from google.cloud import datastore

client = datastore.Client()

def update_summary_entity(entity):
    summary_key = client.key('SummaryEntityKind', 'summary-entity-id')
    summary_entity = client.get(summary_key)
    if summary_entity is None:
        summary_entity = datastore.Entity(summary_key)
        summary_entity.update({
            'field1_sum': 0,
            'field2_sum': 0,
            # 添加更多字段
        })

    summary_entity['field1_sum'] += entity['field1']
    summary_entity['field2_sum'] += entity['field2']
    # 更新更多字段

    client.put(summary_entity)

def entity_created(event, context):
    entity = event['data']['entity']
    update_summary_entity(entity)