dynamic_table_example.py

from sqlalchemy import Column, Integer, String, DateTime

def Trasaction(Base, year, month, day):
    month = "{:02d}".format(month)
    day = "{:02d}".format(day)

    class Trasaction(Base):
        __tablename__ = 'card_trasaction_{year}_{month}_{day}'.format(
            year=year, month=month, day = day
        )
        __table_args__ = (
            {'extend_existing':True,
             'mysql_engine': 'InnoDB'},
        )
        id = Column(Integer, primary_key=True, autoincrement=True)
        timestamp = Column(DateTime, nullable=False, index=True)
        amount = Column(Integer, nullable=False, index=True)
        card_num = Column(String(24), nullable=False, index=True)
    return Trasaction