向SQLAlchemy数据库触发器添加条目` `sqlite :绑定参数0时出错-可能是不支持的类型`

from sqlalchemy import create_engine, Table, Column, Integer, String, MetaData
from sqlalchemy.types import DateTime
import datetime

engine = create_engine('sqlite:///example.db')
metadata = MetaData()

users = Table('users', metadata,
    Column('id', Integer, primary_key=True),
    Column('name', String),
    Column('created_at', DateTime, default=datetime.datetime.utcnow)
)

# 确保日期时间类型被正确处理
insert_stmt = users.insert().values(name='John Doe', created_at=datetime.datetime.utcnow())
with engine.connect() as connection:
    connection.execute(insert_stmt)

class CustomType:
    def __init__(self, value):
        self.value = value

def adapt_custom_type(custom_type):
    return custom_type.value

from sqlalchemy.dialects.sqlite import adapt
adapt(CustomType) = adapt_custom_type

import logging
logging.basicConfig()
logging.getLogger('sqlalchemy.engine').setLevel(logging.DEBUG)