商标与消息管理系统中的学生信息处理
from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
Base = declarative_base()
class Student(Base):
__tablename__ = 'students'
id = Column(Integer, primary_key=True)
name = Column(String(50), nullable=False)
student_id = Column(String(20), unique=True)
engine = create_engine('sqlite:///students.db')
Session = sessionmaker(bind=engine)
session = Session()
students = session.query(Student).all()
for s in students:
print(s.name, s.student_id)
本站知识库部分内容及素材来源于互联网，如有侵权，联系必删！