尝试在单个函数中使用更新和创建时出现的问题

def create_record(data):
    # 创建记录的逻辑
    pass

def update_record(record_id, data):
    # 更新记录的逻辑
    pass

def handle_record(record_id, data):
    if record_id:
        # 更新记录
        update_record(record_id, data)
    else:
        # 创建记录
        create_record(data)

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class Record(Base):
    __tablename__ = 'records'
    id = Column(Integer, primary_key=True)
    name = Column(String)

engine = create_engine('sqlite:///example.db')
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()

def handle_record(record_id, data):
    record = session.query(Record).filter_by(id=record_id).first()
    if record:
        # 更新记录
        for key, value in data.items():
            setattr(record, key, value)
    else:
        # 创建记录
        record = Record(**data)
        session.add(record)
    session.commit()