CODEWITHSUNDEEP
sqlalchemyflaskflask-sqlalchemy
synergetic
synergetic

Reputation: 8036

flask-sqlalchemy with dynamic database connections

I have one main db, in which each client's own db connection is stored. So every client works with 2 db: main and its own db, connection of which must be decided for each http call. How can I do this using flask-sqlalchemy extension, or may be purely in sqlalchemy?

Upvotes: 5

Views: 3626

Answers (1)

manelvf
manelvf

Reputation: 149

You can handle multiple sessions in Flask-SQLalchemy:

engine = create_engine(DATABASE_URI)
db_session = scoped_session(sessionmaker(autocommit=False,
                                     autoflush=False,
                                     bind=engine))
db_session.query...()

and

engine2 = create_engine(DATABASE_URI2)
db_session2 = scoped_session(sessionmaker(autocommit=False,
                                     autoflush=False,
                                     bind=engine2))

db_session2.query2...()

sharing the same codebase.

Upvotes: 7

Related Questions