Sqlalchemy
Kylee Kello
不一定每个人都会失败,但也不一定每个人都运气好。怎么做是你的自由。
展开
-
Sqlalchemy - 数据库的连接与表格的创建
ORM:【 开发者更适合做对象的封装,而不是对库频繁的开关和对数据库的DML 】0.第三方库的导入 from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import Column,Integer,String from sqlalchemy import create_engine1.实例...原创 2019-07-15 19:14:37 · 2289 阅读 · 0 评论 -
Sqlalchemy - 数据查询(无条件查询+条件查询)
专题:【Python - 闭包 Closure】 from connect_mysql import engine,Userfrom sqlalchemy.orm import sessionmakerSession = sessionmaker(engine)db_session = Session()# 查询数据(指定的一个数据)# user = db_session.q...原创 2019-07-15 21:07:22 · 4076 阅读 · 0 评论 -
Sqlalchemy - 数据插入(单条数据+多条数据)
回顾(MySQL原生多条数据的插入):insert into User values(179074001,"Frank"),(179074008,"Loso");from create_table import engine,Userfrom sqlalchemy.orm import sessionmaker Session = sessionmaker(engine)db...原创 2019-07-18 23:16:47 · 9221 阅读 · 1 评论 -
Sqlalchemy - 数据的更新(*2)、删除
更新(.update({...}))一般更新from create_table import engine,Userfrom sqlalchemy.orm import sessionmakerSession = sessionmaker(engine)db_session = Session()user_obj = db_session.query(User).filter...原创 2019-07-18 23:23:56 · 32171 阅读 · 3 评论 -
Sqlalchemy - 外键约束(relationship)
student2school = relationship("类名",backref = "student2school")backref: back reference(反向调用)建表:from sqlalchemy.ext.declarative import declarative_basefrom sqlalchemy import Column,Integer,S...原创 2019-07-19 11:10:36 · 2337 阅读 · 0 评论 -
Sqlalchemy - 使用原生语句查询(from_statement + text)
## 使用原生sql语句进行查询from sqlalchemy.sql import textres = db_session.query(Student).from_statement(text("SELECT * FROM STUDENT WHERE STUDENT_ID=:STUDENT_ID")).\ params(STUDENT_ID="179074001").first...原创 2019-07-19 17:06:58 · 4214 阅读 · 0 评论 -
Sqlalchemy - 组合查询
or_、and_(需要额外导入: from sqlalchemy.sql import or_,and_) in_([1,2,3,4,5]) ~in_([1,2,3,4,5]) = notin_([1,2,3,4,5]) between(1,3) ~between(1,3) order_by(xxx.desc()/asc()) db_session.query(Student.stud...原创 2019-07-19 17:13:53 · 2240 阅读 · 0 评论 -
Sqlalchemy - 读取本地表格(metadata.reflect)
from sqlalchemy.ext.declarative import declarative_basefrom sqlalchemy import create_enginefrom pprint import pprintBase = declarative_base()engine = create_engine("mysql+pymysql://root:12345...原创 2019-07-19 22:04:55 · 2962 阅读 · 0 评论