When a Flask application with Flask-SQLAlchemy is running, how do I use MySQL client on the same database at the same time?

Question

When I run a Flask application which is using Flask-SQLAlchemy, it seems that Flask-SQLAlchemy is holding a session and when I issue a MySQL command, like alter table add column, in MySQL client terminal, the commands cannot be executed until I quit the Flask application.

Does anybody have similar experience? How can I issue commands on MySQL client without interrupting the Flask application?

Community · Accepted Answer · 2017-05-23 11:44:28Z

9

You may want to look at this question SQL Alchemy Relationship loader leaves a lock on table?

What you'll need to do is subclass flask.ext.sqlalchemy.SQLAlchemy and override the apply_driver_hacks method to pass through the additional keyword argument isolation_level='READ <some level>':

from flask.ext.sqlalchemy import SQLAlchemy

class UnLockedAlchemy(SQLAlchemy):
    def apply_driver_hacks(self, app, info, options):
        if not "isolation_level" in options:
            options["isolation_level"] = "READ COMMITTED"  # For example
        return super(UnLockedAlchemy, self).apply_driver_hacks(app, info, options)

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered Sep 14, 2012 at 2:25

Sean Vieira

161k34 gold badges321 silver badges297 bronze badges

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

Collectives™ on Stack Overflow

When a Flask application with Flask-SQLAlchemy is running, how do I use MySQL client on the same database at the same time?

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