爬取摩天轮演唱会导入数据库

最新推荐文章于 2025-08-26 11:15:54 发布

一生所爱呦

最新推荐文章于 2025-08-26 11:15:54 发布

阅读量1.1k

点赞数 13

CC 4.0 BY-SA版权

文章标签：数据库 python

本文链接：https://blog.csdn.net/m0_65698359/article/details/144112483

import json
import requests
import mysql.connector


result_list = []
url6 = 'https://m.moretickets.com/showapi/cities?src=m_web&time=1728720941852&ver=6.19.0'
headers = {
    'User-Agent': 'Mozilla/5.0 (Linux; Android 6.0; Nexus 5 Build/MRA58N) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Mobile Safari/537.36 Edg/128.0.0.0'}
# 发送请求
response = requests.get(url6, headers=headers)
response.encoding = 'utf-8'
# 解析数据
data6 = response.json()

city_oids = []
for all_cities in data6["result"]["allCities"]:
    for city in all_cities["cities"]:
        city_oids.append(city["cityOID"])
for city in city_oids:
    print(city)
    # 替换为实际的分页接口格式
    for page in range(1, 21):
        offset = (page - 1) * 10
        print(offset)
        url1 = f"https://m.moretickets.com/mtl_recommendapi/pub/show/v1/shows?src=m_web&time=1729557652873&ver=6.20.1&cityId={city}&sorting=weight&showType=1&venueIds=&tagIds=&offset={offset}&length=10"
        # url1 = f"https://m.moretickets.com/mtl_recommendapi/pub/show/v1/shows?src=m_web&time=1728720264106&ver=6.19.0&cityId={city}&sorting=weight&showType=1&venueIds=&tagIds=5cd2d747c1cd064d6803c195&offset={offset}&length=10"
        headers = {
            'User-Agent': 'Mozilla/5.0 (Linux; Androi