又名林州站长网_永久免费个人网站申请注册_网站优化价格_镇江网站推广
def multi_sql_update(db_path,updates,table,condition):'''- 数据修改更新:param db_path: '~/db.splite3':param updates: [['title','John']] -> (point:value):param table: 'Database':param condition: 'id = 1' / 'WHERE price > 100'/ ...'''import sqlite3db = sqlite3.connect(db_path)for updt_i in range(len(updates)):update_point = updates[updt_i][0]updt_value = updates[updt_i][1]def sql_update(db,condition,update_point,updt_value,table):cursorObj = db.cursor()cursorObj.execute(f'UPDATE {table} SET 'f'{update_point} = "{updt_value}" 'f'where {condition}')db.commit()sql_update(db,condition,update_point,updt_value,table)db.close()">