一. 在上一篇博客中说到了增删改查,这一次说一说批量的zeng增删改查
注意看我的代码注释:
import sqlalchemy
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,Integer,String
from sqlalchemy.orm import sessionmaker
import pandas as pd
#创建连接,root是用户名,123456是密码,192.168.xxx是IP地址,test是数据库名。
engine = create_engine("mysql+pymysql://root:123456@192.168.xxx/test",encoding = 'utf-8',echo=True)
#生成orm基类
base = declarative_base()
class test_student(base):
__tablename__ = 'test_student'
id = Column(Integer, primary_key=True)
name = Column(String(32))
age = Column(Integer)
def __repr__(self):
return "<test_student(id='%s',name='%s',age='%s')>"%(self.id,self.name,self.age)
# 创建与数据库的会话
Session_class =