from sqlalchemy import Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class Student(Base):
__tablename__ = 'students'
id = Column(Integer, primary_key=True)
name = Column(String(50))
major = Column(String(50))
phone = Column(String(15))
from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
engine = create_engine('sqlite:///school.db')
Session = sessionmaker(bind=engine)
session = Session()
new_student = Student(name='Alice', major='Computer Science', phone='123-456-7890')
session.add(new_student)
session.commit()
all_students = session.query(Student).all()
for student in all_students:
print(student.name, student.major)