替换。在json文件中使用_，并使用python将其写入到表中

{
    "name": "John_Doe",
    "age": 30,
    "is_active": true,
    "hobbies": ["reading", "traveling"],
    "address": {
        "street": "123 Main St",
        "city": "Anytown"
    }
}

import json
import sqlite3

# 读取JSON文件
with open('data.json', 'r') as file:
    data = json.load(file)

# 替换下划线
def replace_underscore(obj):
    if isinstance(obj, dict):
        return {k.replace('_', '-'): replace_underscore(v) for k, v in obj.items()}
    elif isinstance(obj, list):
        return [replace_underscore(item) for item in obj]
    else:
        return obj

data = replace_underscore(data)

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

# 创建表
cursor.execute('''
CREATE TABLE IF NOT EXISTS users (
    id INTEGER PRIMARY KEY,
    name TEXT,
    age INTEGER,
    is_active BOOLEAN,
    hobbies TEXT,
    address TEXT
)
''')

# 插入数据
hobbies_str = ','.join(data['hobbies'])
address_str = json.dumps(data['address'])
cursor.execute('''
INSERT INTO users (name, age, is_active, hobbies, address)
VALUES (?, ?, ?, ?, ?)
''', (data['name'], data['age'], data['is_active'], hobbies_str, address_str))

# 提交更改并关闭连接
conn.commit()
conn.close()