Python脚本示例

requirements.txt

创建requirements.txt 的文件，列出了当前Python环境中安装的所有包及其精确版本号

pip freeze > requirements.txt

pip install -r requirements.txt

读取json

import json

# 定义JSON文件的路径
json_file_path = 'user.json'

# 使用with语句以读取模式打开指定编码的文件，确保文件操作安全
with open(json_file_path, 'r', encoding='utf-8') as file:
    # 使用json模块的load()函数将文件内容转换为字典类型
    data = json.load(file)

# 获取数据中'mydiss'下的'list'，即歌曲列表
song_lists = data['data']['mydiss']['list']

# 遍历每个歌曲列表，并打印对应的'dissid'
for song_list in song_lists:
    print(song_list['dissid'])

操作数据库

import json
import datetime
import time

import pymysql as pmq
import api


# 连接到数据库的参数
def connect_to_db():
    host = '192.168.10.246'
    port = 3306
    user = 'root'
    password = '123456'
    database = 'fu_netease_cloud_music'
    use_ssl = False
    server_timezone = 'UTC'

    # 连接到数据库
    con = pmq.connect(
        host=host,
        port=port,
        user=user,
        password=password,
        database=database,
        charset='utf8mb4',  # 指定字符集
        cursorclass=pmq.cursors.DictCursor,  # 使用字典游标
        ssl={'ssl': use_ssl},  # 设置是否使用SSL
        init_command=f"SET time_zone = '{server_timezone}'"  # 设置服务器时区
    )
    return con


# 插入数据的SQL语句
sql_insert_query_playlist_info = """
INSERT INTO playlist_info (playlist_id, name, create_time, update_time)
VALUES (%s, %s, %s, %s)
"""

# 插入数据的SQL语句
sql_insert_query_playlist_music = """
INSERT INTO playlist_music (playlist_id, music_id, music_name)
VALUES (%s, %s, %s)
"""


record = (id, name, create_time, update_time)

con = connect_to_db()
cur = con.cursor()

try:
cur.execute(sql_insert_query_playlist_info, record)
con.commit()
print("数据插入成功")
except pmq.Error as e:
print("数据插入失败：", e)
con.rollback()


con.close()
print("MySQL连接已关闭")
time.sleep(10)