Using different binds in the same class in Flask-SQLAlchemy

Question

I currently have multiple databases with identical Tables and Columns (but different data inside). So clearly I need to use binds to access all of them, but it's apparently not as simple as doing this:

class WhateverTable(db.Model):
    __tablename__ = 'whatevertable'
    whatever = db.Column(db.String(255))

    def __init__(self, bind=None):
        self.__bind_key__ = bind

and then later calling:

WhateverTable(bind='bind_key_here').query.filter_by(whatever='whatever').first()

Is there a way I can do this easily? I've tried inheriting from a table class and then defining the bind there, and while that works, it really isn't scalable.

EDIT: This :Flask inherited classes of tables in multiple identical databases using __bind_key__ does sort of what I want, but I don't want to have different classes because if I ever add a new database, I'm going to have to create a new set of classes and relationships.

I have the very same requirement. How did you get through this? — Khushboo Mulani
– Khushboo Mulani, Commented Jun 16, 2020 at 7:41

Jeff Widman · Accepted Answer · 2017-02-21 18:03:35Z

2

Flask-SQLAlchemy 2.1 added support for a binds parameter on the session which should do what you want.

edited Feb 21, 2017 at 18:03

answered Dec 3, 2015 at 22:02

Jeff Widman

23.8k13 gold badges79 silver badges93 bronze badges

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

2 Comments

Pegasus Over a year ago

this issue is closed

Teoretic Over a year ago

@jeff-widman the link is broken now - can you post the answer as a text, without the link?

Collectives™ on Stack Overflow

Using different binds in the same class in Flask-SQLAlchemy

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related