zhiyu_content_spider/content_spider/temp_test.py

# -*- coding: utf-8 -*-
import hashlib
import json
import re
from urllib.parse import urlencode
from urllib.parse import urlsplit
from urllib.parse import unquote
from urllib.parse import parse_qs

import urllib
from xml.dom.minidom import parseString

import time
import xlrd



category_list = [{"channel_id":17,"name":"男生","data":[{"type":9,"name":"武侠"},{"type":10,"name":"仙侠"},{"type":11,"name":"都市"},{"type":13,"name":"历史"},{"type":14,"name":"游戏"},{"type":21,"name":"玄幻"},{"type":38,"name":"科幻"},{"type":44,"name":"同人"},{"type":49,"name":"短篇男"}]},{"channel_id":18,"name":"女生","data":[{"type":2,"name":"古代言情"},{"type":3,"name":"现代言情"},{"type":4,"name":"校园言情"},{"type":5,"name":"幻想言情"},{"type":22,"name":"穿越重生"},{"type":45,"name":"耽美"},{"type":46,"name":"百合"},{"type":47,"name":"无cp"},{"type":48,"name":"短篇"}]},{"channel_id":19,"name":"恐怖","data":[{"type":20,"name":"推理悬念"},{"type":40,"name":"恐怖惊悚"},{"type":41,"name":"灵异鬼怪"},{"type":42,"name":"风水秘术"},{"type":43,"name":"探险异闻"}]},{"channel_id":23,"name":"出版","data":[{"type":24,"name":"励志"},{"type":25,"name":"职场"},{"type":26,"name":"生活"},{"type":28,"name":"婚姻"},{"type":29,"name":"教育"},{"type":35,"name":"心理学"},{"type":36,"name":"管理"}]}]

result = []
for  item in category_list:
    for item2 in item['data']:
        if item2['type'] == 9 or item2['type'] == 10:
            item2['channel_id'] = 1
            item2['category_name'] = "武侠仙侠"
            item2['category_id'] = 21
        if item2['type'] == 11:
            item2['channel_id'] = 1
            item2['category_name'] = "都市爱情"
            item2['category_id'] = 54
        if item2['type'] == 13:
            item2['channel_id'] = 1
            item2['category_name'] = "特种军旅"
            item2['category_id'] = 51
        if item2['type'] == 14:
            item2['channel_id'] = 1
            item2['category_name'] = "游戏竞技"
            item2['category_id'] = 19
        if item2['type'] == 21 or item2['type'] == 38:
            item2['channel_id'] = 1
            item2['category_name'] = "玄幻奇幻"
            item2['category_id'] = 23
        if item2['type'] == 44:
            item2['channel_id'] = 1
            item2['category_name'] = "衍生同人"
            item2['category_id'] = 125
        if item2['type'] == 49:
            item2['channel_id'] = 1
            item2['category_name'] = "其他作品"
            item2['category_id'] = 127
        if item2['type'] == 2:
            item2['channel_id'] = 2
            item2['category_name'] = "穿越重生"
            item2['category_id'] = 83
        if item2['type'] == 3:
            item2['channel_id'] = 2
            item2['category_name'] = "婚恋情感"
            item2['category_id'] = 98
        if item2['type'] == 4:
            item2['channel_id'] = 2
            item2['category_name'] = "青春校园"
            item2['category_id'] = 104
        if item2['type'] == 5:
            item2['channel_id'] = 2
            item2['category_name'] = "东方玄幻"
            item2['category_id'] = 96
        if item2['type'] == 22:
            item2['channel_id'] = 2
            item2['category_name'] = "穿越重生"
            item2['category_id'] = 83
        if item2['type'] == 45:
            item2['channel_id'] = 2
            item2['category_name'] = "耽美同人"
            item2['category_id'] = 106
        if item2['type'] == 46 or item2['type'] == 47 or item2['type'] == 48:
            item2['channel_id'] = 2
            item2['category_name'] = "其他"
            item2['category_id'] = 107
        if item2['type'] == 20 or item2['type'] == 40 or item2['type'] == 41 or item2['type'] == 42 or item2['type'] == 43:
            item2['channel_id'] = 1
            item2['category_name'] = "灵异恐怖"
            item2['category_id'] = 81

        if item2['type'] == 24 or item2['type'] == 25 or item2['type'] == 26 or item2['type'] == 28 or item2['type'] == 29 or item2['type'] == 35 or item2['type'] == 36:
            item2['channel_id'] = 2
            item2['category_name'] = "其他"
            item2['category_id'] = 107
        result.append(item2)


print(result)