SQLAlchemy之原生SQL语句

最新推荐文章于 2024-07-29 10:51:17 发布

kd丹妮儿

最新推荐文章于 2024-07-29 10:51:17 发布

阅读量3.5k

点赞数

分类专栏： Python # Flask

本文链接：https://blog.csdn.net/kanghui_898/article/details/101751479

版权

Python 同时被 2 个专栏收录

59 篇文章 2 订阅

订阅专栏

Flask

42 篇文章 2 订阅

订阅专栏


# -*- coding:utf-8 -*-
import time
import threading

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String, ForeignKey, UniqueConstraint, Index
from sqlalchemy.orm import sessionmaker, relationship
from sqlalchemy import create_engine
from sqlalchemy.sql import text
from sqlalchemy.engine.result import ResultProxy
from db import Users, Hosts

engine = create_engine("mysql+pymysql://root:123@127.0.0.1:3306/s6", max_overflow=0, pool_size=5)
Session = sessionmaker(bind=engine)

session = Session()

# 查询
# cursor = session.execute('select * from users')
# result = cursor.fetchall()

# 添加
cursor = session.execute('insert into users(name) values(:value)',params={"value":'wupeiqi'})
session.commit()
print(cursor.lastrowid)

session.close()