[sqlalchemy] Using flask-sqlalchemy BaseQuery and Pagination with multiple tables.

2014-01-08 Thread Mark S
Hi I can successfully use pagination with the following - mydata=Article.query.filter(Article.author_id==User.id).filter(User.id==g.user.id).paginate(page, POSTS_PER_PAGE, False) However, I need to fetch columns from multiple tables. In that case how can I modify the code above in order to

Re: [sqlalchemy] Using flask-sqlalchemy BaseQuery and Pagination with multiple tables.

2014-01-08 Thread Simon King
On Wed, Jan 8, 2014 at 3:37 PM, Mark S dbs...@gmail.com wrote: Hi I can successfully use pagination with the following - mydata=Article.query.filter(Article.author_id==User.id).filter(User.id==g.user.id).paginate(page, POSTS_PER_PAGE, False) However, I need to fetch columns from multiple