如何在IoTDB数据库python客户端中创建和插入时间戳

pip install iotdb-python-client

from iotdb_client import connect

# 连接到IoTDB服务器
with connect(host='localhost', port=6667, username='root', password='root') as client:
    # 创建数据库（如果已存在则忽略）
    client.execute("CREATE DATABASE IF NOT EXISTS test_db")
    
    # 使用数据库
    client.execute("USE test_db")
    
    # 创建表
    client.execute("""
        CREATE TABLE IF NOT EXISTS device_data (
            device_id STRING,
            timestamp TIMESTAMP,
            temperature DOUBLE
        )
    """)

from datetime import datetime

# 插入数据
with connect(host='localhost', port=6667, username='root', password='root') as client:
    # 插入单条数据
    timestamp = datetime.now()
    client.execute("""
        INSERT INTO device_data (device_id, timestamp, temperature)
        VALUES (?, ?, ?)
    """, ['device_001', timestamp, 25.6])
    
    # 插入多条数据
    data = [
        ('device_002', datetime.now(), 26.1),
        ('device_003', datetime.now(), 24.8)
    ]
    client.execute("""
        INSERT INTO device_data (device_id, timestamp, temperature)
        VALUES (?, ?, ?), (?, ?, ?)
    """, *data)

# 查询数据
with connect(host='localhost', port=6667, username='root', password='root') as client:
    result = client.execute("SELECT * FROM device_data")
    for row in result:
        print(row)