Sqlalchemy领域模型的设计问题？

Question

I have 3 tables: User, Community, community_members (for relationship many2many of users and community).

I create this tables using Flask-SQLAlchemy:

community_members = db.Table('community_members',
                db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
                db.Column('community_id', db.Integer, db.ForeignKey('community.id')),
                )


class Community(db.Model):
    __tablename__ = 'community'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(100), nullable=False, unique=True)
    members = db.relationship(User, secondary=community_members,
                            backref=db.backref('community_members', lazy='dynamic'))
Now I want add additional field to community_members like this:

community_members = db.Table('community_members',
                db.Column('id', db.Integer, primary_key=True),
                db.Column('user_id', db.Integer, db.ForeignKey('user.id')),
                db.Column('community_id', db.Integer, db.ForeignKey('community.id')),
                db.Column('time_create', db.DateTime, nullable=False, default=func.now()),
                )

And now in python shell I can do this:

create community:

> c = Community()
> c.name = 'c1'
> db.session.add(c)
> db.session.commit()
add members to community:

> u1 = User.query.get(1)
> u2 = User.query.get(2)
> c.members.append(u1)
> c.members.append(u2)
> db.session.commit()

> c.members
[<User 1>, <User 2>]

=================
说明： 以上文字和代码来自so网站，看着合适，拿过来用一下来说明我的问题。
http://stackoverflow.com/questions/24477806/remove-a-relation-many-to-many-association-object-on-sqlalchemy

1.有3个表模型：User, Community, community_members
2.Community------------------User （many-----中间表--------many）

问题： 如何抽象一下代码？把代码放到domain service 里面

Answer 1

我在hwjp关于python的新书配套代码的issue也问过，也向他请教了这类问题:https://github.com/cosmicpyth...，Harry书中给的例子是用Dataclass + Classical Mapping取代Declaretive Model，从而将'field_name=Column(...)'这种本该数据库关心的东西从Dataclass纯领域类中移走。话说这个帖子怎么是2014年的，那会有人用sqlalchemy研究领域驱动吗？