尝试更新 GridDB 中的列，但无法弄清楚为什么它没有更新

我正在尝试使用 Python 客户端更新 GridDB 容器中的数据。我已经设置了环境并编写了以下代码来执行更新。更新操作似乎不起作用，因为数据保持不变。

关于我在这里可能做错了什么有什么想法吗？这是我正在阅读的文档： https://docs.griddb.net/gettingstarted/python/

import griddb_python as griddb

factory = griddb.StoreFactory.get_instance()

try:
    store = factory.get_store(
        notification_member="239.0.0.1",
        notification_port=31999,
        cluster_name="myCluster",
        username="admin",
        password="admin"
    )
    container = store.get_container("myContainer")

    query = container.query("SELECT * FROM myContainer WHERE id = 1")
    rs = query.fetch()

    if rs.has_next():
        data = rs.next()
        data[2] = 35  # Update the age field

        # Put the updated row back into the container
        container.put(data)
        store.commit()
except griddb.GSException as e:
    for i in range(e.get_error_stack_size()):
        print("[", i, "]")
        print(e.get_error_code(i))
        print(e.get_message(i))

The issue in your code lies in how you are trying to update the row. The container.put(data) method doesn't work in-place for updates. Instead, it tries to insert a new row using the provided data , which might be causing a constraint violation if your id column is a primary key.

Here are two ways to correctly update a row in GridDB using the Python client:

Method 1: Using update_by_row_key()

This method is more efficient for updating a single row identified by its row key.

```python import griddb_python as griddb

# ... (connection and container setup from the original code)

try: # Assuming 'id' is your row key row_key = 1

   # Fetch the row for update
   row = container.get(row_key)  
   if row:
       row[2] = 35  # Update the 'age' field
       container.update_by_row_key(row)
       store.commit()
       print("Row updated successfully!")
   else:
       print("Row not found.")

except griddb.GSException as e: # ... (error handling) ```

Method 2: Using a SQL UPDATE statement

This method allows for more flexible updates based on conditions.

```python import griddb_python as griddb

# ... (connection and container setup)

try: query = "UPDATE myContainer SET age = 35 WHERE id = 1" container.update(query) store.commit() print("Row updated successfully!")

except griddb.GSException as e: # ... (error handling) ```

Explanation:

• Method 1: container.get(row_key) retrieves the entire row data for the specified key. After modifying the desired field ( row[2] = 35 ), container.update_by_row_key(row) directly updates that row in the container.
• Method 2: The SQL UPDATE statement provides a standard way to modify data based on specific criteria. This approach is useful for updating multiple rows or using more complex conditions.

Important Note: Ensure your id column (or the column you use for row_key ) is defined as a primary key or unique key for efficient updates and to avoid conflicts.