如何在python中为sql-alchemy使用不同类型的连接

from sqlalchemy import create_engine

engine = create_engine('sqlite:///example.db')

engine = create_engine('postgresql://username:password@hostname:port/database')

engine = create_engine('mysql+pymysql://username:password@hostname:port/database')

engine = create_engine('mssql+pyodbc://username:password@hostname:port/database?driver=ODBC+Driver+17+for+SQL+Server')

engine = create_engine('oracle://username:password@hostname:port/service_name')

from sqlalchemy import create_engine

engine = create_engine('postgresql://username:password@hostname:port/database',
                       pool_size=10, max_overflow=20)

engine = create_engine('postgresql://username:password@hostname:port/database',
                       pool_recycle=3600)

engine = create_engine('postgresql://username:password@hostname:port/database',
                       pool_pre_ping=True)

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    fullname = Column(String)
    nickname = Column(String)

engine = create_engine('postgresql://username:password@hostname:port/database')
Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()

new_user = User(name='ed', fullname='Ed Jones', nickname='edsnickname')
session.add(new_user)
session.commit()

users = session.query(User).all()
for user in users:
    print(user.name, user.fullname, user.nickname)