Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

many to many relationship using flask restless, post a one to many data

My question is about how to use post to add more than one many to many relationship datas

I'm using flask, flask-SQLAlchemy, flask-restless and angularjs, 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 post a data like this

{
    "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 database which will create three things:

one page, and two pagetags.

Can I do this with restless? And How to do?

appreciate it in advance.

like image 785
user2301791 Avatar asked Apr 20 '13 12:04

user2301791


1 Answers

From here:

apimanager.create_api( Page, include_columns = [
    'id', 'page_name', 'pagetags.info', 'pagetags.page_id', 'pagetags.tag_id'
] )
like image 179
astex Avatar answered Oct 24 '22 15:10

astex