How to lookup a SQLAlchemy table object from the Base object using the name of the table

January 17, 2019 By Matthew Leave a Comment

def get_class_by_tablename(base, tablename):
    """Return class reference mapped to table.
    :param tablename: String with name of table.
    :return: Class reference or None.
    """

    for _class in base._decl_class_registry.values():
        if hasattr( _class, '__tablename__') and  _class  .__tablename__ == tablename:
            return  _class
    return ValueError("Could not find table")

About Matthew

I lead the development of event-driven and data-intensive full stack applications.

Most recently, I have been working as a software technical lead on Capital One's Cloud Engineering team, building up both cloud engineers and full stack Python developers. Before that, I was building debt trading data pipelines and analytic applications for the largest bank in Tennessee. I have been working in the regulated financial product market for 6 years, and also briefly worked on an API unification project leveraging GraphQL at Hilton.

Maybe more importantly, I enjoy developing software talent - mentoring developers to think critically about their work product, communicate well about it, and learn to teach others themselves.

Additional menu

About Matthew

Reader Interactions

Leave a Reply Cancel reply