pip install python-sql
python
from sqlalchemy import create_engine
from sqlalchemy.orm import sessionmaker
python
db_url = "postgresql://username:password@localhost:5432/mydatabase"
python
engine = create_engine(db_url)
Session = sessionmaker(bind=engine)
session = Session()
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
name = Column(String)
age = Column(Integer)
users = session.query(User).all()
for user in users:
print("ID: {}, Name: {}, Age: {}".format(user.id, user.name, user.age))
