sqlalchemy的基本用法简单的sql语句执行

最新推荐文章于 2025-03-10 19:59:59 发布

置顶深夜程序员

最新推荐文章于 2025-03-10 19:59:59 发布

阅读量2k

点赞数

分类专栏： flask开发web网站文章标签： sqlalchemy sqlalchemy的基本用法 sqlalchemy中简单的sql语句 sql语句执行

本文链接：https://blog.youkuaiyun.com/lv5751394/article/details/96913392

版权

flask开发web网站专栏收录该内容

17 篇文章

订阅专栏

from flask import Flask, jsonify, json
from sqlalchemy import create_engine

app = Flask(__name__)

HOSTNAME = '127.0.0.1'
PORT = '3306'
DATABASE = 'pyDemo'
USERNAME = 'root'
PASSWORD = '123456'


@app.route('/')
def hello_world():
    # 连接数据库字符串
    DB_URI = "mysql://root:123456@127.0.0.1/pyDemo"

    engine = create_engine(DB_URI)
    # 判断是否连接成功
    engine.connect()

    # 删除一个表
    dropTable = engine.execute("drop table if EXISTS userDemo")
    # 创建一个表
    createTable = engine.execute("CREATE TABLE userDemo (id INT PRIMARY key AUTO_INCREMENT,NAME VARCHAR (255) NULL)")
    # 添加一条数据
    insertTable = engine.execute("insert into userDemo(name) value('test')")
    insertTable = engine.execute("insert into userDemo(name) value('test2')")

    # 查询一条数据
    selectUser = engine.execute("select * from userDemo")
    test = {}
    list = [];
    for userItem in selectUser:
        test = {'id': userItem[0], 'username': userItem[1]}
        list.append(test)
        print(userItem)

    return json.dumps(list)


if __name__ == '__main__':
    app.run()

个人博客：十分钟空间：https://tmspace.cn/

更多内容关注公众号：tenmspace