自动将API拉取的数据添加到表中

import requests

def fetch_data_from_api(api_url, headers):
    try:
        response = requests.get(api_url, headers=headers)
        response.raise_for_status()  # 抛出HTTP错误
        return response.json()
    except requests.exceptions.RequestException as e:
        print(f"Error fetching data: {e}")
        return None

from pydantic import BaseModel, ValidationError

class DataModel(BaseModel):
    id: int
    name: str

def process_data(data):
    try:
        validated_data = DataModel(**data)
        return validated_data.dict()
    except ValidationError as e:
        print(f"Data validation error: {e}")
        return None

import sqlite3

def insert_data_to_db(data):
    conn = sqlite3.connect('database.db')
    cursor = conn.cursor()
    try:
        cursor.execute("INSERT INTO table_name (id, name) VALUES (?, ?)", (data['id'], data['name']))
        conn.commit()
    except sqlite3.Error as e:
        print(f"Database error: {e}")
    finally:
        conn.close()