代码
# -*- coding: utf-8 -*-
import re
import csv
import json
import time
import pymysql
import requests
from bs4 import BeautifulSoup
from multiprocessing import Pool
# 请求头
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36'
}
# 歌单类型链接
type_url = "https://music.163.com/discover/playlist"
# 连接数据库
db = pymysql.connect(
host = "localhost",
user = "root",
password = "123456",
port=3306,
db = "cloudmusic1"
)
cursor = db.cursor()
"""获取歌单类型"""
def get_playlist_type(url):
response = requests.get(url=url, headers=headers)
html = response.text
soup = BeautifulSoup(html, 'lxml')
types = [t.text for t in soup.select("a.s-fc1")][1:]
return types
"""获取歌单id"