from sqlalchemy import create_engine, Table, MetaData, inspect, Column, Integer, String, Float, TIMESTAMP, select
from sqlalchemy.orm import sessionmaker, declarative_base
from sqlalchemy.sql import text

Base = declarative_base()
engine = create_engine("mssql+pyodbc://...?driver=ODBC+Driver+17+for+SQL+Server")


class User(Base):
    __tablename__ = 'users'

    id = Column(Integer, primary_key=True)
    name = Column(String(50))
    age = Column(Integer)
    email = Column(String(50), unique=True)

# 如果已存在 不会覆盖
# Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)
session = Session()
print(session.execute(text("SELECT name FROM SysObjects WHERE XType = 'U'")).fetchall())

users = session.execute(select(User))
print(users)
  • 1.
  • 2.
  • 3.
  • 4.
  • 5.
  • 6.
  • 7.
  • 8.
  • 9.
  • 10.
  • 11.
  • 12.
  • 13.
  • 14.
  • 15.
  • 16.
  • 17.
  • 18.
  • 19.
  • 20.
  • 21.
  • 22.
  • 23.
  • 24.
  • 25.