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("D:\project\zhiyu_content_spider\content_spider/12.xls")
table=df.sheets()[0]


result = []

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

    name = row[1]
    item = {"id":c_id,"name":name}
    if c_id in [1,5,29]:
        item['channel_id'] = 2
        item['category_id'] = 88
        item['category_name'] = '豪门总裁'
    if c_id in [2,38]:
        item['channel_id'] = 2
        item['category_id'] = 83
        item['category_name'] = '穿越重生'
    if c_id in [4]:
        item['channel_id'] = 2
        item['category_id'] = 104
        item['category_name'] = '青春校园'
    if c_id in [15]:
        item['channel_id'] = 2
        item['category_id'] = 114
        item['category_name'] = '恐怖惊悚'
    if c_id in [30,31]:
        item['channel_id'] = 2
        item['category_id'] = 110
        item['category_name'] = '上古蛮荒'
    if c_id in [32]:
        item['channel_id'] = 2
        item['category_id'] = 97
        item['category_name'] = '古典仙侠'
    if c_id in [33]:
        item['channel_id'] = 2
        item['category_id'] = 113
        item['category_name'] = '悬疑探险'
    if c_id in [34,37,40,42]:
        item['channel_id'] = 2
        item['category_id'] = 107
        item['category_name'] = '其他'
    if c_id in [36]:
        item['channel_id'] = 2
        item['category_id'] = 119
        item['category_name'] = '游戏'
    if c_id in [39]:
        item['channel_id'] = 2
        item['category_id'] = 123
        item['category_name'] = '女尊王朝'
    if c_id in [6]:
        item['channel_id'] = 1
        item['category_id'] = 81
        item['category_name'] = '灵异恐怖'
    if c_id in [7,11,14,25]:
        item['channel_id'] = 1
        item['category_id'] = 54
        item['category_name'] = '都市爱情'
    if c_id in [9]:
        item['channel_id'] = 1
        item['category_id'] = 94
        item['category_name'] = '青春爱情'
    if c_id in [10]:
        item['channel_id'] = 1
        item['category_id'] = 19
        item['category_name'] = '游戏竞技'
    if c_id in [12]:
        item['channel_id'] = 1
        item['category_id'] = 55
        item['category_name'] = '官场沉浮'
    if c_id in [13]:
        item['channel_id'] = 1
        item['category_id'] = 21
        item['category_name'] = '武侠仙侠'
    if c_id in [16]:
        item['channel_id'] = 1
        item['category_id'] = 57
        item['category_name'] = '乡土风情'
    if c_id in [17,20]:
        item['channel_id'] = 1
        item['category_id'] = 23
        item['category_name'] = '玄幻奇幻'
    if c_id in [18]:
        item['channel_id'] = 1
        item['category_id'] = 14
        item['category_name'] = '历史穿越'
    if c_id in [19]:
        item['channel_id'] = 1
        item['category_id'] = 68
        item['category_name'] = '现代修真'
    if c_id in [24,26,27,28,41]:
        item['channel_id'] = 1
        item['category_id'] = 127
        item['category_name'] = '其他作品'
    result.append(item)


print(result)