flask中MySQL外键_Flask flask-sqlalchemy 定义多表外键关联

定义了三张表，一个host可以属于多个group,也可以属于多个services

class group(db.Model):

__tablename__ = 'group'

id = db.Column(db.Integer,primary_key=True,autoincrement=True)

gname=db.Column(db.String(60), unique=True)

idc =db.Column(db.String(60),default="ZD")

host_id =db.Column(db.Integer,db.ForeignKey('host.id')

def __repr__(self):

return self.gname

class services(db.Model):

__tablename__ = 'services'

id = db.Column(db.Integer,primary_key=True,autoincrement=True)

sname=db.Column(db.String(60),index=True )

sport=db.Column(db.Integer,index=True )

comment =db.Column(db.String(120) )

host_id =db.Column(db.Integer,db.ForeignKey('host.id'))

def __repr__(self):

return self.sname

class host(db.Model):

__tablename__ = 'host'

id = db.Column(db.Integer,primary_key=True,autoincrement=True)

hostname=db.Column(db.String(60),index=True, )

group = db.relationship('group',backref='host',lazy = 'dynamic')

services = db.relationship('services',backref='host',lazy = 'dynamic')

def __repr__(self):

return self.hostname

问题咨询：

1、这种定义是否正确？

2、如何获取某个组id对应的所有host

谢谢