Sqlalchemy - executing raw sql queries

Question

I'm using sqlalchemy in a flask application that connects to multiple databases, using binds as shown here. I want to execute a raw sql query on one of the non-primary databases.

I'm trying to use session.execute, as shown here but it executes for the primary db. The API docs state that you can use a parameter: "bind – Optional Engine to be used as the bind". How do I access and specify the bind for the non-primary db and call session.execute to execute a query for that db?

Alternately, is there any other way to go about it?

AArias · Accepted Answer · 2016-09-23 16:07:43Z

6

Try this:

from flask import current_app
db.get_engine(current_app, bind='<your_bind>').execute('<your raw sql>')

answered Sep 23, 2016 at 16:07

AArias

2,5783 gold badges30 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sqlalchemy - executing raw sql queries

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related