from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker
# 创建数据库引擎
engine = create_engine('sqlite:///students.db', echo=True)
Base = declarative_base()
class Student(Base):
__tablename__ = 'students'
id = Column(Integer, primary_key=True)
name = Column(String)
age = Column(Integer)
# 创建表
Base.metadata.create_all(engine)
# 创建会话
Session = sessionmaker(bind=engine)
session = Session()
]]>
# 查询所有大三学生
third_year_students = session.query(Student).filter(Student.age == 20).all()
for student in third_year_students:
print(student.name)
]]>
import pandas as pd
# 导出学生数据到CSV文件
df = pd.read_sql_table('students', engine)
df.to_csv('students.csv', index=False)
]]>
from pymongo import MongoClient
client = MongoClient("mongodb://localhost:27017/")
db = client["university"]
collection = db["students"]
# 插入新学生记录
new_student = {"name": "Alice Zhang", "age": 22}
collection.insert_one(new_student)
]]>
