如何使用从python套接字接收的实时数据创建和更新SQL数据库？

import socket
import sqlite3

# 创建套接字
server_socket = socket.socket(socket.AF_INET, socket.SOCK_STREAM)

# 绑定套接字到端口
server_address = ('localhost', 8888)
server_socket.bind(server_address)

# 监听连接请求
server_socket.listen(1)

# 连接数据库
conn = sqlite3.connect('data.db')
cursor = conn.cursor()

# 创建数据表
cursor.execute('''CREATE TABLE IF NOT EXISTS data
                  (id INTEGER PRIMARY KEY AUTOINCREMENT, value TEXT)''')

# 接受客户端连接
client_socket, client_address = server_socket.accept()
print('Connected to', client_address)

while True:
    # 接收数据
    data = client_socket.recv(1024).decode()
    
    # 解析数据并插入到数据库
    values = data.split(',')
    cursor.execute('INSERT INTO data (value) VALUES (?)', (values[0],))
    conn.commit()
    
    print('Received and inserted:', data)
    
    # 更新数据库
    cursor.execute('SELECT * FROM data WHERE value = ?', (values[0],))
    row = cursor.fetchone()
    if row:
        cursor.execute('UPDATE data SET value = ? WHERE id = ?', (values[1], row[0]))
        conn.commit()
        print('Updated:', values[1])

# 关闭套接字和数据库连接
client_socket.close()
server_socket.close()
conn.close()