mysqldb,sqlalchemy和flask-sqlalchemy执行raw sql时如何防止sql注入
文章目录
mysqldb
c=db.cursor()
max_price=5
c.execute("""SELECT spam, eggs, sausage FROM breakfast
WHERE price < %s""", [max_price])
sqlalchemy
from sqlalchemy.sql import text
t = text("select * from test where id= :tid")
conn.execute(t, tid=1).fetchall()
flask-sqlalchemy
db = SQLAlchemy(app)
conn = db.session.connection()
@app.route('/')
def index():
rv = conn.execute('select * from test where id = %s', [1])
return jsonify(rv)

评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论