python - SQLAlchemy 0.7 MapperEvent 错误

Question

我有模型

class CreatedMixin(object):

    __abstract__ = True

    @declared_attr
    def created_by(cls):
        return Column(Integer, ForeignKey('user.user_id',
                      onupdate="cascade", ondelete="restrict"))

    @declared_attr
    def updated_by(cls):
        return Column(Integer, ForeignKey('user.user_id',
                      onupdate="cascade", ondelete="restrict"))

    created_at = Column(DateTime, nullable=False, default=dt.now())
    updated_at = Column(DateTime, nullable=False, default=dt.now(),
                        onupdate=dt.now())


class Net(Base, CreatedMixin):
    """Net or subnet."""

    cidr = Column(postgresql.CIDR, index = True)
    description = Column(UnicodeText())

    parent_id = Column(Integer, ForeignKey('net.id'))
    parent = relationship("Net", remote_side="Net.id")

   def __init__(self, cidr=''):
       self.cidr = cidr

   def __repr__(self):
       return "%s" % self.cidr

要自动填充字段created_by和update_by，我使用sqlalchemy.orm.events.MapperEvents(SQLAlchemy 0.7)，如下所示:

def created_before_insert_listener(mapper, connection, target):
    # execute a stored procedure upon INSERT,
    # apply the value to the row to be inserted
    #target.calculated_value = connection.scalar(
    #                            "select my_special_function(%d)" 
    #                            % target.special_number)
    target.updated_by = 1

# associate the listener function with CreatedMixin,
# to execute during the "before_insert" hook
event.listen(CreatedMixin, 'before_insert', created_before_insert_listener)

但是运行应用程序后，出现以下错误但未映射

sqlalchemy.orm.exc.UnmappedClassError: Class 'myapp.model.Net' 

出了什么问题？

Answer 1

问题很简单，我在模型中使用了 Mixin，并且无意中添加了属性 __abstract__ = True 的基本模型

示例:

from sqlalchemy import *
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker, scoped_session

engine = create_engine('sqlite:///:memory:', echo=True)
Base = declarative_base(bind=engine)
Session = scoped_session(sessionmaker(engine))

class Mix(object):
    __abstract__ = True
    id =  Column(Integer, autoincrement=True, primary_key=True)

class User(Base, Mix):
    __tablename__ = 'users'

    name = Column(String)
    fullname = Column(String)
    password = Column(String)

Base.metadata.create_all()

u = User()
print u

但是在 SQLAlchemy 0.6 中它工作得很好。也许这是0.6的一个bug。更新:了解更多信息SQLAlchemy abstract