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.