python调用mysql

python调用mysql 实现增删改查

包依赖: pip3 install clemoni-utilities==1.2.5
调用示例:

from utilities import db_tools
import functools
from time import sleep# SECURE DBdef insert_to_students_info(clause_dict): #if many format-> [{"id":1, "audio_file_key":xxx, "part_prom":"xxx"},]# print(clause_dict)stmt = """INSERT INTO `cards_manager`.`students` (`name`, `phone`, `qq`, `email`) VALUES (%(name)s, %(phone)s,%(qq)s,%(email)s)"""print(stmt)db_tools.insert_one_data_to_db(stmt, clause_dict)def get_all_students_info():stmt = """select * from `cards_manager`.`students` where delete_flag  = 0"""return db_tools.select_data_to_db(stmt)def update_student_info(old_name,new_name):stmt = """update `cards_manager`.`students` set name = %s where name  = %s""" % (new_name, old_name)return db_tools.select_data_to_db(stmt)def delete_student_info(name):stmt = """update `cards_manager`.`students` set delete_flag = 1 where name  = %s""" % (name)return db_tools.select_data_to_db(stmt)

需要在同级目录下存在: env_secret.yml
内容示例

---
DBPASSWORD: "mysql"
DBUSERNAME: "root"
DBHOST: "127.0.0.1"
DBNAME: "cards_manager"