items.py 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480
  1. # -*- coding: utf-8 -*-
  2. # Define here the models for your scraped items
  3. #
  4. # See documentation in:
  5. # https://doc.scrapy.org/en/latest/topics/items.html
  6. import scrapy
  7. # 篮球------------------------------------------------------------------------------------------------------------------
  8. class Lanqiu(scrapy.Field):
  9. # 联赛id
  10. league_id = scrapy.Field()
  11. # 联赛名
  12. league_name = scrapy.Field()
  13. result = scrapy.Field()
  14. # 比赛id
  15. game_id = scrapy.Field()
  16. # 球队1
  17. team_home = scrapy.Field()
  18. # 球队2
  19. team_guest = scrapy.Field()
  20. # 数量(97>)
  21. number = scrapy.Field()
  22. # 比赛状态
  23. zhuangtai = scrapy.Field()
  24. # 日期
  25. data_game = scrapy.Field()
  26. # 开赛时间
  27. time_game = scrapy.Field()
  28. # 队1分数
  29. score_home = scrapy.Field()
  30. # 队2分数
  31. score_guest = scrapy.Field()
  32. # 第几节
  33. jijie = scrapy.Field()
  34. # 球队得分
  35. qiudui = scrapy.Field()
  36. pt = scrapy.Field()
  37. concede = scrapy.Field()
  38. concede_rule = scrapy.Field()
  39. odd_even = scrapy.Field()
  40. odd_even_rule = scrapy.Field()
  41. total_size = scrapy.Field()
  42. total_size_rule = scrapy.Field()
  43. last_number = scrapy.Field()
  44. capot = scrapy.Field()
  45. team_score = scrapy.Field()
  46. team_score_rule = scrapy.Field()
  47. lanqiu = scrapy.Field()
  48. # 联赛---------------------------------------------------------------------------------------------------------------
  49. class Liansai(scrapy.Field):
  50. area_id = scrapy.Field()
  51. area_name = scrapy.Field()
  52. st_league = scrapy.Field()
  53. name_chinese = scrapy.Field()
  54. ball = scrapy.Field()
  55. # 冠军--------------------------------------------------------------------------------------------------------------
  56. class Guanjun(scrapy.Field):
  57. league_name = scrapy.Field()
  58. # tema_home = scrapy.Field()
  59. league_id = scrapy.Field()
  60. game_id = scrapy.Field()
  61. data_game = scrapy.Field()
  62. # time_game = scrapy.Field()
  63. new_league_name = scrapy.Field()
  64. # champion_team = scrapy.Field()
  65. new_champion = scrapy.Field()
  66. pt = scrapy.Field()
  67. ball = scrapy.Field()
  68. # zhuangtai = scrapy.Field()
  69. # champion = scrapy.Field()
  70. # 足球 --------------------------------------------------------------------------------------------------------------
  71. class Zuqiu(scrapy.Field):
  72. league_id = scrapy.Field()
  73. league_name = scrapy.Field()
  74. game_id = scrapy.Field()
  75. team_home = scrapy.Field()
  76. team_guest = scrapy.Field()
  77. number = scrapy.Field()
  78. data_game = scrapy.Field()
  79. time_game = scrapy.Field()
  80. half_way = scrapy.Field()
  81. pt = scrapy.Field()
  82. corner_ball = scrapy.Field()
  83. zhuangtai = scrapy.Field()
  84. # 球队进球大小
  85. full_data = scrapy.Field()
  86. half_data = scrapy.Field()
  87. full_data_rule = scrapy.Field()
  88. half_data_rule = scrapy.Field()
  89. # 足球 大小盘
  90. half_size_guest = scrapy.Field()
  91. half_size_guest_rule = scrapy.Field()
  92. half_size_home = scrapy.Field()
  93. half_size_home_rule = scrapy.Field()
  94. size_guest = scrapy.Field()
  95. size_guest_rule = scrapy.Field()
  96. size_home = scrapy.Field()
  97. size_home_rule = scrapy.Field()
  98. # 足球 让球&大小盘
  99. half_concede_home_rule = scrapy.Field()
  100. half_concede_home = scrapy.Field()
  101. half_concede_guest_rule = scrapy.Field()
  102. half_concede_guest = scrapy.Field()
  103. # 足球 独赢
  104. concede_guest = scrapy.Field()
  105. concede_guest_rule = scrapy.Field()
  106. concede_home = scrapy.Field()
  107. concede_home_rule = scrapy.Field()
  108. # 独赢
  109. half_capot_home = scrapy.Field()
  110. half_capot_guest = scrapy.Field()
  111. half_capot_dogfall = scrapy.Field()
  112. capot_home = scrapy.Field()
  113. capot_guest = scrapy.Field()
  114. capot_dogfall = scrapy.Field()
  115. # 足球 入球数单双
  116. odd_even_odd = scrapy.Field()
  117. odd_even_even = scrapy.Field()
  118. half_odd_even_odd = scrapy.Field()
  119. half_odd_even_even = scrapy.Field()
  120. # 足球 半场/全场
  121. half_full = scrapy.Field()
  122. # 足球 总入球
  123. total_goal = scrapy.Field()
  124. # 足球 波胆
  125. bodan_data = scrapy.Field()
  126. # 足球 最先进球/最后进球
  127. first_last_ball = scrapy.Field()
  128. zuqiu = scrapy.Field()
  129. # 网球 让球&大小盘--------------------------------------------------------------------------------------------------------
  130. class Wangqiu(scrapy.Field):
  131. # 联赛id
  132. league_id = scrapy.Field()
  133. # 联赛名
  134. league_name = scrapy.Field()
  135. result = scrapy.Field()
  136. # 比赛id
  137. game_id = scrapy.Field()
  138. # 球队1
  139. team_home = scrapy.Field()
  140. # 球队2
  141. team_guest = scrapy.Field()
  142. # 数量(97>)
  143. number = scrapy.Field()
  144. # 比赛状态
  145. zhuangtai = scrapy.Field()
  146. # 日期
  147. data_game = scrapy.Field()
  148. # 开赛时间
  149. time_game = scrapy.Field()
  150. # 队1分数
  151. score_home = scrapy.Field()
  152. # 队2分数
  153. score_guest = scrapy.Field()
  154. # 第几节
  155. jijie = scrapy.Field()
  156. # 球队得分
  157. qiudui = scrapy.Field()
  158. pt = scrapy.Field()
  159. concedes_dict = scrapy.Field()
  160. concedes_dict_rule = scrapy.Field()
  161. kemps_dict = scrapy.Field()
  162. bureaus_dict = scrapy.Field()
  163. bureaus_dict_rule = scrapy.Field()
  164. total_number_dict = scrapy.Field()
  165. total_number_dict_rule = scrapy.Field()
  166. odd_evens_dict = scrapy.Field()
  167. odd_evens_dict_rule = scrapy.Field()
  168. wangqiu = scrapy.Field()
  169. # 网球 波胆--------------------------------------------------------------------------------------------------------------
  170. class Wqbodan(scrapy.Field):
  171. # 联赛id
  172. league_id = scrapy.Field()
  173. # 联赛名
  174. league_name = scrapy.Field()
  175. result = scrapy.Field()
  176. # 比赛id
  177. game_id = scrapy.Field()
  178. # 球队1
  179. team_home = scrapy.Field()
  180. # 球队2
  181. team_guest = scrapy.Field()
  182. # 数量(97>)
  183. number = scrapy.Field()
  184. # 比赛状态
  185. zhuangtai = scrapy.Field()
  186. # 日期
  187. data_game = scrapy.Field()
  188. # 开赛时间
  189. time_game = scrapy.Field()
  190. # 队1分数
  191. score_home = scrapy.Field()
  192. # 队2分数
  193. score_guest = scrapy.Field()
  194. # 第几节
  195. jijie = scrapy.Field()
  196. # 球队得分
  197. qiudui = scrapy.Field()
  198. pt = scrapy.Field()
  199. bodan_data = scrapy.Field()
  200. # 棒球 让球 大小---------------------------------------------------------------------------------------------------------
  201. class Bangqiu(scrapy.Field):
  202. # 联赛id
  203. league_id = scrapy.Field()
  204. # 联赛名
  205. league_name = scrapy.Field()
  206. result = scrapy.Field()
  207. # 比赛id
  208. game_id = scrapy.Field()
  209. # 球队1
  210. team_home = scrapy.Field()
  211. # 球队2
  212. team_guest = scrapy.Field()
  213. # 数量(97>)
  214. number = scrapy.Field()
  215. # 比赛状态
  216. zhuangtai = scrapy.Field()
  217. # 日期
  218. data_game = scrapy.Field()
  219. # 开赛时间
  220. time_game = scrapy.Field()
  221. # 队1分数
  222. score_home = scrapy.Field()
  223. # 队2分数
  224. score_guest = scrapy.Field()
  225. # 第几节
  226. jijie = scrapy.Field()
  227. # 球队得分
  228. qiudui = scrapy.Field()
  229. pt = scrapy.Field()
  230. concedes_dict = scrapy.Field()
  231. concedes_dict_rule = scrapy.Field()
  232. capots_dict = scrapy.Field()
  233. total_size_dict = scrapy.Field()
  234. total_size_dict_rule = scrapy.Field()
  235. odd_evens_dict = scrapy.Field()
  236. odd_evens_dict_rule = scrapy.Field()
  237. team_score_home_dict = scrapy.Field()
  238. team_score_home_rule_dict = scrapy.Field()
  239. team_score_guest_dict = scrapy.Field()
  240. team_score_guest_rule_dict = scrapy.Field()
  241. bangqiu = scrapy.Field()
  242. # 滚球------------------------------------------------------------------------------------------------------------------
  243. class Roll_Zuqiu(scrapy.Field):
  244. league_id = scrapy.Field()
  245. league_name = scrapy.Field()
  246. game_id = scrapy.Field()
  247. team_home = scrapy.Field()
  248. team_guest = scrapy.Field()
  249. number = scrapy.Field()
  250. data_game = scrapy.Field()
  251. time_game = scrapy.Field()
  252. half_way = scrapy.Field()
  253. pt = scrapy.Field()
  254. corner_ball = scrapy.Field()
  255. zhuangtai = scrapy.Field()
  256. # 球队进球大小
  257. full_data = scrapy.Field()
  258. half_data = scrapy.Field()
  259. full_data_rule = scrapy.Field()
  260. half_data_rule = scrapy.Field()
  261. # 足球 大小盘
  262. half_size_guest = scrapy.Field()
  263. half_size_guest_rule = scrapy.Field()
  264. half_size_home = scrapy.Field()
  265. half_size_home_rule = scrapy.Field()
  266. size_guest = scrapy.Field()
  267. size_guest_rule = scrapy.Field()
  268. size_home = scrapy.Field()
  269. size_home_rule = scrapy.Field()
  270. # 足球 让球&大小盘
  271. half_concede_home_rule = scrapy.Field()
  272. half_concede_home = scrapy.Field()
  273. half_concede_guest_rule = scrapy.Field()
  274. half_concede_guest = scrapy.Field()
  275. # 足球 独赢
  276. concede_guest = scrapy.Field()
  277. concede_guest_rule = scrapy.Field()
  278. concede_home = scrapy.Field()
  279. concede_home_rule = scrapy.Field()
  280. # 独赢
  281. half_capot_home = scrapy.Field()
  282. half_capot_guest = scrapy.Field()
  283. half_capot_dogfall = scrapy.Field()
  284. capot_home = scrapy.Field()
  285. capot_guest = scrapy.Field()
  286. capot_dogfall = scrapy.Field()
  287. # 足球 入球数单双
  288. odd_even_odd = scrapy.Field()
  289. odd_even_even = scrapy.Field()
  290. half_odd_even_odd = scrapy.Field()
  291. half_odd_even_even = scrapy.Field()
  292. # 足球 半场/全场
  293. half_full = scrapy.Field()
  294. # 足球 总入球
  295. total_goal = scrapy.Field()
  296. # 足球 波胆
  297. bodan_data = scrapy.Field()
  298. # 足球 最先进球/最后进球
  299. first_last_ball = scrapy.Field()
  300. score_guest = scrapy.Field()
  301. score_home = scrapy.Field()
  302. class Zuqiustatus(scrapy.Field):
  303. match_id = scrapy.Field()
  304. create_time = scrapy.Field()
  305. status = scrapy.Field()
  306. update_time = scrapy.Field()
  307. ball_type = scrapy.Field()
  308. zuqiu_toal = scrapy.Field()
  309. class Roll_Lanqiu(scrapy.Field):
  310. # 联赛id
  311. league_id = scrapy.Field()
  312. # 联赛名
  313. league_name = scrapy.Field()
  314. result = scrapy.Field()
  315. # 比赛id
  316. game_id = scrapy.Field()
  317. # 球队1
  318. team_home = scrapy.Field()
  319. # 球队2
  320. team_guest = scrapy.Field()
  321. # 数量(97>)
  322. number = scrapy.Field()
  323. # 比赛状态
  324. zhuangtai = scrapy.Field()
  325. # 日期
  326. data_game = scrapy.Field()
  327. # 开赛时间
  328. time_game = scrapy.Field()
  329. # 队1分数
  330. score_home = scrapy.Field()
  331. # 队2分数
  332. score_guest = scrapy.Field()
  333. # 第几节
  334. jijie = scrapy.Field()
  335. # 球队得分
  336. qiudui = scrapy.Field()
  337. concede = scrapy.Field()
  338. concede_rule = scrapy.Field()
  339. odd_even = scrapy.Field()
  340. odd_even_rule = scrapy.Field()
  341. total_size = scrapy.Field()
  342. total_size_rule = scrapy.Field()
  343. last_number = scrapy.Field()
  344. capot = scrapy.Field()
  345. team_score = scrapy.Field()
  346. team_score_rule = scrapy.Field()
  347. class Roll_Wangqiu(scrapy.Field):
  348. # 联赛id
  349. league_id = scrapy.Field()
  350. # 联赛名
  351. league_name = scrapy.Field()
  352. result = scrapy.Field()
  353. # 比赛id
  354. game_id = scrapy.Field()
  355. # 球队1
  356. team_home = scrapy.Field()
  357. # 球队2
  358. team_guest = scrapy.Field()
  359. # 数量(97>)
  360. number = scrapy.Field()
  361. # 比赛状态
  362. zhuangtai = scrapy.Field()
  363. # 日期
  364. data_game = scrapy.Field()
  365. # 开赛时间
  366. time_game = scrapy.Field()
  367. # 队1分数
  368. score_home = scrapy.Field()
  369. # 队2分数
  370. score_guest = scrapy.Field()
  371. # 第几节
  372. jijie = scrapy.Field()
  373. # 球队得分
  374. qiudui = scrapy.Field()
  375. # 每局比分
  376. score_dict = scrapy.Field()
  377. pt = scrapy.Field()
  378. concedes_dict = scrapy.Field()
  379. concedes_dict_rule = scrapy.Field()
  380. kemps_dict = scrapy.Field()
  381. bureaus_dict = scrapy.Field()
  382. bureaus_dict_rule = scrapy.Field()
  383. total_number_dict = scrapy.Field()
  384. total_number_dict_rule = scrapy.Field()
  385. odd_evens_dict = scrapy.Field()
  386. odd_evens_dict_rule = scrapy.Field()
  387. sq_dict = scrapy.Field()
  388. class Roll_Bangqiu(scrapy.Field):
  389. # 联赛id
  390. league_id = scrapy.Field()
  391. # 联赛名
  392. league_name = scrapy.Field()
  393. result = scrapy.Field()
  394. # 比赛id
  395. game_id = scrapy.Field()
  396. # 球队1
  397. team_home = scrapy.Field()
  398. # 球队2
  399. team_guest = scrapy.Field()
  400. # 数量(97>)
  401. number = scrapy.Field()
  402. # 比赛状态
  403. zhuangtai = scrapy.Field()
  404. # 日期
  405. data_game = scrapy.Field()
  406. # 开赛时间
  407. time_game = scrapy.Field()
  408. # 队1分数
  409. score_home = scrapy.Field()
  410. # 队2分数
  411. score_guest = scrapy.Field()
  412. # 第几节
  413. jijie = scrapy.Field()
  414. # 球队得分
  415. qiudui = scrapy.Field()
  416. pt = scrapy.Field()
  417. concedes_dict = scrapy.Field()
  418. concedes_dict_rule = scrapy.Field()
  419. capots_dict = scrapy.Field()
  420. total_size_dict = scrapy.Field()
  421. total_size_dict_rule = scrapy.Field()
  422. odd_evens_dict = scrapy.Field()
  423. odd_evens_dict_rule = scrapy.Field()
  424. match_score_dict = scrapy.Field()
  425. team_source_dict = scrapy.Field()
  426. # -----------------------------------------------------------足球比赛结果------------------------------------------------
  427. class Zujieguo(scrapy.Field):
  428. # 足球比赛结果元组
  429. id_score = scrapy.Field()
  430. # -----------------------------------------------------------篮球比赛结果------------------------------------------------
  431. class Lanjieguo(scrapy.Field):
  432. # 篮球比赛结果元组
  433. id_score = scrapy.Field()
  434. # -----------------------------------------------------------网球比赛结果------------------------------------------------
  435. class Wangjieguo(scrapy.Field):
  436. # 网球比赛结果元组
  437. id_score = scrapy.Field()
  438. # -----------------------------------------------------------棒球比赛结果------------------------------------------------
  439. class Bangjieguo(scrapy.Field):
  440. # 网球比赛结果元组
  441. id_score = scrapy.Field()