sqlalchemy model resolve table name

sqlalchemy_resolve_table_name.py

import re

from sqlalchemy.orm import DeclarativeBase, declared_attr


def resolve_table_name(name):
    """Resolve table name from Class CamelCase"""

    # Match a letter just before an upper-case char
    # Example: "Hello World" would match "o" because next "W" is uppercase.
    names = re.split("(?=[A-Z])", name)

    # Make lowercase tablename with "_" as word separator.
    return "_".join([x.lower() for x in names if x])


class CSuiteSABase(DeclarativeBase):
    """Base object used by all database model classes"""

    @declared_attr
    def __tablename__(self):
        return resolve_table_name(self.__name__)