Geek Answers Handbook

From many to many relationships, using a jar restless, send one to many data

My question is how to use the post to add more than one of many for many relationships.

I use flask, flask-SQLAlchemy, flask-restless and angular, json

I have some tables like this

class Page(db.Model): id = db.Column(db.Integer, primary_key=True) page_name = db.Column(db.String(10)) class Tag(db.Model): id = db.Column(db.Integer, primary_key=True) tag_name = db.Column(db.String(10)) class PageTags(db.Model): page_id = db.Column(db.Integer, db.ForeignKey('page.id'), primary_key=True) tag_id = db.Column(db.Integer, db.ForeignKey('tag.id'), primary_key=True) info = db.Column(db.Text) tag = db.relationship('Tag', backref='tag') page = db.relationship('Page', backref='pagetags')

I want to publish such data

 { "id": 1, "page_name": "p1", "pagetags": [ { "info": "pt1", "page_id": 1, "tag_id": 1 }, { "info": "pt2", "page_id": 1, "tag_id": 2 } ] }

and I hope to add this to the database, which will create three things:

one page and two pagetags.

Can I do this with concern? And how to do it?

rate it in advance.

+6
source share
1 answer

From here :

 apimanager.create_api( Page, include_columns = [ 'id', 'page_name', 'pagetags.info', 'pagetags.page_id', 'pagetags.tag_id' ] )
+2
source

More articles:


All Articles