items.py 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473
  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. bangqiu = scrapy.Field()
  238. # 滚球------------------------------------------------------------------------------------------------------------------
  239. class Roll_Zuqiu(scrapy.Field):
  240. league_id = scrapy.Field()
  241. league_name = scrapy.Field()
  242. game_id = scrapy.Field()
  243. team_home = scrapy.Field()
  244. team_guest = scrapy.Field()
  245. number = scrapy.Field()
  246. data_game = scrapy.Field()
  247. time_game = scrapy.Field()
  248. half_way = scrapy.Field()
  249. pt = scrapy.Field()
  250. corner_ball = scrapy.Field()
  251. zhuangtai = scrapy.Field()
  252. # 球队进球大小
  253. full_data = scrapy.Field()
  254. half_data = scrapy.Field()
  255. full_data_rule = scrapy.Field()
  256. half_data_rule = scrapy.Field()
  257. # 足球 大小盘
  258. half_size_guest = scrapy.Field()
  259. half_size_guest_rule = scrapy.Field()
  260. half_size_home = scrapy.Field()
  261. half_size_home_rule = scrapy.Field()
  262. size_guest = scrapy.Field()
  263. size_guest_rule = scrapy.Field()
  264. size_home = scrapy.Field()
  265. size_home_rule = scrapy.Field()
  266. # 足球 让球&大小盘
  267. half_concede_home_rule = scrapy.Field()
  268. half_concede_home = scrapy.Field()
  269. half_concede_guest_rule = scrapy.Field()
  270. half_concede_guest = scrapy.Field()
  271. # 足球 独赢
  272. concede_guest = scrapy.Field()
  273. concede_guest_rule = scrapy.Field()
  274. concede_home = scrapy.Field()
  275. concede_home_rule = scrapy.Field()
  276. # 独赢
  277. half_capot_home = scrapy.Field()
  278. half_capot_guest = scrapy.Field()
  279. half_capot_dogfall = scrapy.Field()
  280. capot_home = scrapy.Field()
  281. capot_guest = scrapy.Field()
  282. capot_dogfall = scrapy.Field()
  283. # 足球 入球数单双
  284. odd_even_odd = scrapy.Field()
  285. odd_even_even = scrapy.Field()
  286. half_odd_even_odd = scrapy.Field()
  287. half_odd_even_even = scrapy.Field()
  288. # 足球 半场/全场
  289. half_full = scrapy.Field()
  290. # 足球 总入球
  291. total_goal = scrapy.Field()
  292. # 足球 波胆
  293. bodan_data = scrapy.Field()
  294. # 足球 最先进球/最后进球
  295. first_last_ball = scrapy.Field()
  296. score_guest = scrapy.Field()
  297. score_home = scrapy.Field()
  298. class Zuqiustatus(scrapy.Field):
  299. match_id = scrapy.Field()
  300. create_time = scrapy.Field()
  301. status = scrapy.Field()
  302. update_time = scrapy.Field()
  303. ball_type = scrapy.Field()
  304. zuqiu_toal = scrapy.Field()
  305. class Roll_Lanqiu(scrapy.Field):
  306. # 联赛id
  307. league_id = scrapy.Field()
  308. # 联赛名
  309. league_name = scrapy.Field()
  310. result = scrapy.Field()
  311. # 比赛id
  312. game_id = scrapy.Field()
  313. # 球队1
  314. team_home = scrapy.Field()
  315. # 球队2
  316. team_guest = scrapy.Field()
  317. # 数量(97>)
  318. number = scrapy.Field()
  319. # 比赛状态
  320. zhuangtai = scrapy.Field()
  321. # 日期
  322. data_game = scrapy.Field()
  323. # 开赛时间
  324. time_game = scrapy.Field()
  325. # 队1分数
  326. score_home = scrapy.Field()
  327. # 队2分数
  328. score_guest = scrapy.Field()
  329. # 第几节
  330. jijie = scrapy.Field()
  331. # 球队得分
  332. qiudui = scrapy.Field()
  333. concede = scrapy.Field()
  334. concede_rule = scrapy.Field()
  335. odd_even = scrapy.Field()
  336. odd_even_rule = scrapy.Field()
  337. total_size = scrapy.Field()
  338. total_size_rule = scrapy.Field()
  339. last_number = scrapy.Field()
  340. capot = scrapy.Field()
  341. team_score = scrapy.Field()
  342. team_score_rule = scrapy.Field()
  343. class Roll_Wangqiu(scrapy.Field):
  344. # 联赛id
  345. league_id = scrapy.Field()
  346. # 联赛名
  347. league_name = scrapy.Field()
  348. result = scrapy.Field()
  349. # 比赛id
  350. game_id = scrapy.Field()
  351. # 球队1
  352. team_home = scrapy.Field()
  353. # 球队2
  354. team_guest = scrapy.Field()
  355. # 数量(97>)
  356. number = scrapy.Field()
  357. # 比赛状态
  358. zhuangtai = scrapy.Field()
  359. # 日期
  360. data_game = scrapy.Field()
  361. # 开赛时间
  362. time_game = scrapy.Field()
  363. # 队1分数
  364. score_home = scrapy.Field()
  365. # 队2分数
  366. score_guest = scrapy.Field()
  367. # 第几节
  368. jijie = scrapy.Field()
  369. # 球队得分
  370. qiudui = scrapy.Field()
  371. pt = scrapy.Field()
  372. concedes_dict = scrapy.Field()
  373. concedes_dict_rule = scrapy.Field()
  374. kemps_dict = scrapy.Field()
  375. bureaus_dict = scrapy.Field()
  376. bureaus_dict_rule = scrapy.Field()
  377. total_number_dict = scrapy.Field()
  378. total_number_dict_rule = scrapy.Field()
  379. odd_evens_dict = scrapy.Field()
  380. odd_evens_dict_rule = scrapy.Field()
  381. sq_dict = scrapy.Field()
  382. class Roll_Bangqiu(scrapy.Field):
  383. # 联赛id
  384. league_id = scrapy.Field()
  385. # 联赛名
  386. league_name = scrapy.Field()
  387. result = scrapy.Field()
  388. # 比赛id
  389. game_id = scrapy.Field()
  390. # 球队1
  391. team_home = scrapy.Field()
  392. # 球队2
  393. team_guest = scrapy.Field()
  394. # 数量(97>)
  395. number = scrapy.Field()
  396. # 比赛状态
  397. zhuangtai = scrapy.Field()
  398. # 日期
  399. data_game = scrapy.Field()
  400. # 开赛时间
  401. time_game = scrapy.Field()
  402. # 队1分数
  403. score_home = scrapy.Field()
  404. # 队2分数
  405. score_guest = scrapy.Field()
  406. # 第几节
  407. jijie = scrapy.Field()
  408. # 球队得分
  409. qiudui = scrapy.Field()
  410. pt = scrapy.Field()
  411. concedes_dict = scrapy.Field()
  412. concedes_dict_rule = scrapy.Field()
  413. capots_dict = scrapy.Field()
  414. total_size_dict = scrapy.Field()
  415. total_size_dict_rule = scrapy.Field()
  416. odd_evens_dict = scrapy.Field()
  417. odd_evens_dict_rule = scrapy.Field()
  418. match_score_dict = scrapy.Field()
  419. # -----------------------------------------------------------足球比赛结果------------------------------------------------
  420. class Zujieguo(scrapy.Field):
  421. # 足球比赛结果元组
  422. id_score = scrapy.Field()
  423. # -----------------------------------------------------------篮球比赛结果------------------------------------------------
  424. class Lanjieguo(scrapy.Field):
  425. # 篮球比赛结果元组
  426. id_score = scrapy.Field()
  427. # -----------------------------------------------------------网球比赛结果------------------------------------------------
  428. class Wangjieguo(scrapy.Field):
  429. # 网球比赛结果元组
  430. id_score = scrapy.Field()
  431. # -----------------------------------------------------------棒球比赛结果------------------------------------------------
  432. class Bangjieguo(scrapy.Field):
  433. # 网球比赛结果元组
  434. id_score = scrapy.Field()