get_db_engine使用engineUrl创建的数据库引擎执行删除语句

import sqlalchemy.engine.url as engineUrl
from sqlalchemy import create_engine, text

def get_db_engine(db_info, db_name):
    db_dict = {'host': db_info.get("host"),
               'username': db_info.get("username"),
               'password': db_info.get("password"),
               'port': db_info.get("port"),
               'database': db_name
               }
    try:
        db_url = engineUrl.URL.create("mysql+pymysql", **db_dict)
    except Exception as e:
        print(e)
        db_dict['drivername'] = 'mysql+pymysql'
        db_url = engineUrl.URL(**db_dict)
    db_engine = create_engine(db_url, pool_pre_ping=True)
    return db_engine

 

创建数据库引擎的代码如上。

现在需要执行一句  delete语句

使用如下方法：

    with engine.connect() as conn:
        delete_sql = text(f"delete from `{table_name}` where date_str = :task_time and task_id = :task_id")
        conn.execute(delete_sql, {"task_time": task_time, "task_id": task_id})