|
本帖最后由 sheeboard 于 2019-3-17 10:38 编辑
参考,用sqlalchemy操作pymysql引擎
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine,Column,String,Integer
engine=create_engine('mysql+pymysql://root:123456@localhost:3306/test?charset=utf8')
Base=declarative_base()
class exam(Base):
__tablename__="exam"
id=Column(Integer,primary_key=True)
quyu=Column(String(50))
nianji=Column(String(50))
xueke=Column(String(50))
banben=Column(String(50))
xuexiao=Column(String(50))
fenshu=Column(Integer)
def __init__(self,*args,**kwargs):
super(exam,self).__init__(*args,**kwargs)
def __repr__(self):
return self.xuexiao
Base.metadata.tables["exam"].create(bind = engine)
这个只是建表,
插入数据用sessionmaker,
from sqlalchemy.orm import sessionmaker
Session=sessionmaker(bind=engine)
quyu="*"
nianji="*"
xueke="*"
banben="*"
xuexiao="*"
fenshu=230
data=exam(quyu=quyu,nianji=nianji,xueke=xueke,banben=banben,xuexiao=xuexiao,fenshu=fenshu)
session=Session()
session.add(data)
try:
session.commit()
except:
pass
session.close()
上面的是插入一条的
|
-
|