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

df = xlrd.open_workbook("./1.xls")
table=df.sheets()[0]


result = []

for i in range(0,table.nrows):
    row = table.row_values(i)
    if len(row) <= 0:
        break
    c_id = int(row[2])

    name = row[3]
    item = {"id":c_id,"name":name}
    if c_id in [19,20,21,22,23,24,101]:
        item['channel_id'] = 1
        item['category_id'] = 23
        item['category_name'] = '玄幻奇幻'
    if c_id in [26,27,29,30]:
        item['channel_id'] = 1
        item['category_id'] = 21
        item['category_name'] = '武侠仙侠'
    if c_id in [14,15,16,17,18]:
        item['channel_id'] = 1
        item['category_id'] = 54
        item['category_name'] = '都市爱情'
    if c_id in [31,32,102]:
        item['channel_id'] = 1
        item['category_id'] = 51
        item['category_name'] = '特种军旅'
    if c_id in [5,38,103,104,105]:
        item['channel_id'] = 1
        item['category_id'] = 22
        item['category_name'] = '西方玄幻'
    if c_id in [25,34,35,36]:
        item['channel_id'] = 1
        item['category_id'] = 19
        item['category_name'] = '游戏竞技'
    if c_id in [1000,1002,1004,1006,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2020]:
        item['channel_id'] = 1
        item['category_id'] = 127
        item['category_name'] = '其他作品'
    if c_id in [48,49,50,51,53,81]:
        item['channel_id'] = 2
        item['category_id'] = 98
        item['category_name'] = '婚恋情感'
    if c_id in [55,56,57,58]:
        item['channel_id'] = 2
        item['category_id'] = 104
        item['category_name'] = '青春校园'
    if c_id in [55,56,57,58]:
        item['channel_id'] = 2
        item['category_id'] = 104
        item['category_name'] = '青春校园'
    if c_id == 59:
        item['channel_id'] = 2
        item['category_id'] = 123
        item['category_name'] = '女尊王朝'
    if c_id == 60 or c_id == 62:
        item['channel_id'] = 2
        item['category_id'] = 120
        item['category_name'] = '宫斗宅斗'
    if c_id == 61 or c_id == 80 or c_id in [68,69,70,71,120]:
        item['channel_id'] = 2
        item['category_id'] = 83
        item['category_name'] = '穿越重生'
    if c_id in [63,64,65,66,67,2014]:
        item['channel_id'] = 2
        item['category_id'] = 96
        item['category_name'] = '东方玄幻'
    if c_id in [72,73,74,75,2018]:
        item['channel_id'] = 2
        item['category_id'] = 119
        item['category_name'] = '游戏'
    if c_id in [76,77,78,79]:
        item['channel_id'] = 2
        item['category_id'] = 106
        item['category_name'] = '耽美同人'
    if c_id == 2012 or c_id == 2013 or c_id == 2016:
        item['channel_id'] = 2
        item['category_id'] = 103
        item['category_name'] = '青春纯爱'
    if c_id in [1001,1003,1005,1007,2015,2017]:
        item['channel_id'] = 2
        item['category_id'] = 107
        item['category_name'] = '其他'
    result.append(item)


print(result)