I agree that the question is vague. But you can use the following as a guideline. This will select from a trial1
table in a test
database in MySQL. Commented out parts are there as an alternative way to setup primary key constraints.
from sqlalchemy import String, create_engine, MetaData, Column
from sqlalchemy.ext.declarative import declarative_base
# from sqlalchemy.schema import PrimaryKeyConstraint
from sqlalchemy.orm import sessionmaker
engine = create_engine('mysql+pymysql://root:root@127.0.0.1/test')
metadata = MetaData(bind=engine)
Base = declarative_base(metadata=metadata)
class TableClassName(Base):
__tablename__ = 'table1'
col1 = Column(String, primary_key=True)
col2 = Column(String, primary_key=True)
col3 = Column(String)
# __table_args__ = (
# PrimaryKeyConstraint(
# col1,
# col2),
# {})
Session = sessionmaker(bind=engine)
session = Session()
b = session.query(TableClassName)
for instance in b:
print(instance.col1, instance.col2)