/AccuTime_Statistic.py

https://gitlab.com/m10774708/dotcode · Python · 746 lines · 613 code · 82 blank · 51 comment · 60 complexity · 21e12f5f2fba2c689306baf20eb68428 MD5 · raw file 

    

  1. import numpy as np

    2. 

  2. import pandas as pd

    3. 

  3. import traceback

    4. 

  4. import os

    5. 

  5. import time

    6. 

  6. import datetime

    7. 

  7. import gc

    8. 

  8. import PaperCommon as pc

    9. 

  9. 	

    10. 

  10. 

    11. 

  11. if __name__ == '__main__':

    12. 

  12. 	'''Insert average correct percentage every y seconds from AccuTime to AccuTime_sta'''

    13. 

  13. 	choice = input("開始執行程式(y)Yes(other)No：")

    14. 

  14. 	if choice.upper() != 'Y':

    15. 

  15. 		os._exit(0)

    16. 

  16. 		

    17. 

  17. 	startTime = time.time() 	

    18. 

  18. 		

    19. 

  19. 	peo = 0 #有紀錄的玩家

    20. 

  20. 	countInsert = 0 #insert的筆數

    21. 

  21. 	sectionDegree = pc.sections_degrees()

    22. 

  22. 	playerDegree = pc.players_degrees()	

    23. 

  23. 	

    24. 

  24. 	database = 'dotCode'

    25. 

  25. 	game = 'Duck'

    26. 

  26. 	db = pc.clientDB(database)

    27. 

  27. 

    28. 

  28. 	#一般秒用x, y，log秒用m, n，Z用p, q， Zlog用u, v 

    29. 

  29. 	x = 999999

    30. 

  30. 	y = 10

    31. 

  31. 	m = 20

    32. 

  32. 	n = 0.1

    33. 

  33. 	p = 500

    34. 

  34. 	q = 1

    35. 

  35. 	u = 2

    36. 

  36. 	v = 0.01

    37. 

  37. 

    38. 

  38. 	#原資料庫建索引

    39. 

  39. 	collection = 'AccuTime'		

    40. 

  40. 	ct = pc.clientCT(database, collection)

    41. 

  41. 	#1.依關卡

    42. 

  42. 	ct.create_index([('gameCode', 1), ('sectionId', 1), ('gameStar', 1), ('accuTime_sec', 1)])

    43. 

  43. 	ct.create_index([('sectionId', 1), ('gameStar', 1), ('accuTime_sec', 1)])

    44. 

  44. 	#2.依難度

    45. 

  45. 	ct.create_index([('gameCode', 1), ('eloDegree', 1), ('gameStar', 1),('accuTime_sec', 1)])

    46. 

  46. 	ct.create_index([('eloDegree', 1), ('gameStar', 1),('accuTime_sec', 1)])

    47. 

  47. 	#3.依時間

    48. 

  48. 	ct.create_index([('gameCode', 1), ('accuTime_sec', 1)])

    49. 

  49. 	ct.create_index([('accuTime_sec', 1)])

    50. 

  50. 	#4.依玩家等級

    51. 

  51. 	ct.create_index([('gameCode', 1), ('playerDegree_kmeans', 1), ('gameStar', 1),('accuTime_sec', 1)])

    52. 

  52. 	ct.create_index([('playerDegree_kmeans', 1), ('gameStar', 1),('accuTime_sec', 1)])

    53. 

  53. 	

    54. 

  54. 	#新資料庫建索引

    55. 

  55. 	#1.依關卡

    56. 

  56. 	db.AccuTime_sta.create_index([('gameCode', 1), ('sectionId', 1), ('seconds', 1), ('tickTime', 1), ('gameStar', 1)])

    57. 

  57. 	db.AccuTimeLog_sta.create_index([('gameCode', 1), ('sectionId', 1), ('seconds_log', 1), ('tickTime', 1), ('gameStar', 1)])

    58. 

  58. 	#2.依難度

    59. 

  59. 	db.AccuTime_sta.create_index([('gameCode', 1), ('sectionId', 1), ('seconds', 1), ('tickTime', 1), ('gameStar', 1), ('difficulty', 1), ('eloDegree', 1)])

    60. 

  60. 	db.AccuTimeLog_sta.create_index([('gameCode', 1), ('sectionId', 1), ('seconds_log', 1), ('tickTime', 1), ('gameStar', 1), ('difficulty', 1), ('eloDegree', 1)])

    61. 

  61. 	#3.依時間(AccuTime_sta與AccuTimeLog_sta不建，與難度相同)

    62. 

  62. 	db.AccuTimeZ_sta.create_index([('gameCode', 1), ('seconds_z', 1), ('tickTime', 1), ('gameStar', 1)])

    63. 

  63. 

    64. 

  64. 	AccuTime_count = 0

    65. 

  65. 	AccuTimeLog_count = 0

    66. 

  66. 	AccuTimeZ_count = 0

    67. 

  67. 	maxSection = pc.find_maxSection(game)

    68. 

  68. 	sectionId, item_difficulty, eloDegree = pc.add_difficulty(game, 1)

    69. 

  69. 	

    70. 

  70. 	##step1依關卡)

    71. 

  71. 	print("insert {} data by section".format(game))

    72. 

  72. 	for section in range(1, maxSection+1):

    73. 

  73. 		allPeople, allCorrectness, allTryCount = [], [], []

    74. 

  74. 		allPeople = pc.create_lists(1, int(x//y)+2, 0)

    75. 

  75. 		allCorrectness = pc.create_lists(1, int(x//y)+2, 0)

    76. 

  76. 		allTryCount = pc.create_lists(1, int(x//y)+2, 0)

    77. 

  77. 		

    78. 

  78. 		allPeople_log, allCorrectness_log, allTryCount_log = [], [], []

    79. 

  79. 		allPeople_log = pc.create_lists(0, int(m//n)+1, 0)

    80. 

  80. 		allCorrectness_log = pc.create_lists(0, int(m//n)+1, 0)

    81. 

  81. 		allTryCount_log = pc.create_lists(0, int(m//n)+1, 0)

    82. 

  82. 		

    83. 

  83. 		passPeople, passCorrectness, passTryCount = [], [], []

    84. 

  84. 		passPeople = pc.create_lists(1, int(x//y)+2, 0)

    85. 

  85. 		passCorrectness = pc.create_lists(1, int(x//y)+2, 0)

    86. 

  86. 		passTryCount = pc.create_lists(1, int(x//y)+2, 0)

    87. 

  87. 		

    88. 

  88. 		passPeople_log,passCorrectness_log, passTryCount_log = [], [], []

    89. 

  89. 		passPeople_log = pc.create_lists(0, int(m//n)+1, 0)

    90. 

  90. 		passCorrectness_log = pc.create_lists(0, int(m//n)+1, 0)

    91. 

  91. 		passTryCount_log = pc.create_lists(0, int(m//n)+1, 0)

    92. 

  92. 		

    93. 

  93. 		for star in range(0, 5):

    94. 

  94. 			people, correctness, tryCount = [], [], []

    95. 

  95. 			people = pc.create_lists(1, int(x//y)+2, 0)

    96. 

  96. 			correctness = pc.create_lists(1, int(x//y)+2, 0)

    97. 

  97. 			tryCount = pc.create_lists(1, int(x//y)+2, 0)

    98. 

  98. 			

    99. 

  99. 			people_log, correctness_log, tryCount_log= [], [], []

    100. 

  100. 			people_log = pc.create_lists(0, int(m//n)+1, 0)

    101. 

  101. 			correctness_log = pc.create_lists(0, int(m//n)+1, 0)

    102. 

  102. 			tryCount_log = pc.create_lists(0, int(m//n)+1, 0)

    103. 

  103. 			

    104. 

  104. 			for one in ct.find({"gameCode":game, "sectionId":section, "gameStar":star, "accuTime_sec":{"$gt":0, "$lte":x}}):

    105. 

  105. 				try:

    106. 

  106. 					a = int(one['accuTime_sec']//y)

    107. 

  107. 					people[a] += 1

    108. 

  108. 					correctness[a] += one['correctPercentage']

    109. 

  109. 					tryCount[a] += one['tryCount']

    110. 

  110. 					

    111. 

  111. 					allPeople[a] += 1

    112. 

  112. 					allCorrectness[a] += one['correctPercentage']

    113. 

  113. 					allTryCount[a] += one['tryCount']

    114. 

  114. 					

    115. 

  115. 					if star > 0:

    116. 

  116. 						passPeople[a] += 1

    117. 

  117. 						passCorrectness[a] += one['correctPercentage']

    118. 

  118. 						passTryCount[a] += one['tryCount']

    119. 

  119. 					

    120. 

  120. 					b = int(one['logAccuTime_sec']//n)+24

    121. 

  121. 					people_log[b] += 1

    122. 

  122. 					correctness_log[b] += one['correctPercentage']

    123. 

  123. 					tryCount_log[b] += one['tryCount']

    124. 

  124. 					

    125. 

  125. 					allPeople_log[b] += 1

    126. 

  126. 					allCorrectness_log[b] += one['correctPercentage']

    127. 

  127. 					allTryCount_log[b] += one['tryCount']

    128. 

  128. 					

    129. 

  129. 					if star > 0:

    130. 

  130. 						passPeople_log[b] += 1

    131. 

  131. 						passCorrectness_log[b] += one['correctPercentage']

    132. 

  132. 						passTryCount_log[b] += one['tryCount']	

    133. 

  133. 				except:

    134. 

  134. 					traceback.print_exc()

    135. 

  135. 				

    136. 

  136. 			#分星星

    137. 

  137. 			#秒

    138. 

  138. 			for seconds, i_count, i_correct, i_try in zip(range(y, x+y+1, y), people, correctness, tryCount):

    139. 

  139. 				if i_count > 0:

    140. 

  140. 					#print("seconds:", seconds, "i_count:", i_count, "try", i_try, "i_correct:", i_correct/i_count)

    141. 

  141. 					#os.system("pause")

    142. 

  142. 					AccuTime_sta_dict = {"gameCode":game,

    143. 

  143. 										 "sectionId":section,

    144. 

  144. 										 "seconds":seconds,

    145. 

  145. 										 "tickTime":y,

    146. 

  146. 										 "gameStar":star,

    147. 

  147. 										 "people":i_count,

    148. 

  148. 										 "difficulty":item_difficulty[section-1],

    149. 

  149. 										 "eloDegree":eloDegree[section-1],

    150. 

  150. 										 "avgCorrectness":i_correct/i_count,

    151. 

  151. 										 "avgTryCount":i_try/i_count,

    152. 

  152. 										 "step":"1-1"

    153. 

  153. 										}    

    154. 

  154. 					db.AccuTime_sta.update_one({"gameCode":game, "sectionId":section, "seconds":seconds, "tickTime":y, "gameStar":star}, {'$set':AccuTime_sta_dict}, upsert = True)

    155. 

  155. 					AccuTime_count += 1

    156. 

  156. 			

    157. 

  157. 			#Log秒		

    158. 

  158. 			for seconds_log, i_count_log, i_correct_log, i_try_log in zip(np.arange(-2.4, m+n, n), people_log, correctness_log, tryCount_log):

    159. 

  159. 				if i_count_log > 0:

    160. 

  160. 					AccuTimeLog_sta_dict = {"gameCode":game,

    161. 

  161. 											"sectionId":section,

    162. 

  162. 											"seconds_log":round(seconds_log, 2),

    163. 

  163. 											"tickTime":n,

    164. 

  164. 											"gameStar":star,

    165. 

  165. 											"people":i_count_log,

    166. 

  166. 											"difficulty":item_difficulty[section-1],

    167. 

  167. 											"eloDegree":eloDegree[section-1],

    168. 

  168. 											"avgCorrectness":i_correct_log/i_count_log,

    169. 

  169. 											"avgTryCount":i_try_log/i_count_log,

    170. 

  170. 											"step":"1-1"

    171. 

  171. 										   }

    172. 

  172. 					db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":section, "seconds_log":round(seconds_log, 2), "tickTime":n, "gameStar":star}, {'$set':AccuTimeLog_sta_dict}, upsert = True)

    173. 

  173. 					AccuTimeLog_count += 1		

    174. 

  174. 			del	people, correctness, tryCount, people_log, correctness_log, tryCount_log			

    175. 

  175. 			gc.collect()

    176. 

  176. 		

    177. 

  177. 		

    178. 

  178. 		#不分星

    179. 

  179. 		#秒

    180. 

  180. 		for seconds_all, i_count_all, i_correct_all, i_try_all in zip(range(y, x+y+1, y), allPeople, allCorrectness, allTryCount):

    181. 

  181. 			if i_count_all > 0:

    182. 

  182. 				#print("seconds:", seconds, "i_count:", i_count, "i_correct:", i_correct)

    183. 

  183. 				AccuTimeAll_sta_dict  = {"gameCode":game,

    184. 

  184. 										 "sectionId":section,

    185. 

  185. 										 "seconds":seconds_all,

    186. 

  186. 										 "tickTime":y,

    187. 

  187. 										 "gameStar":5,	#5是不分星星數

    188. 

  188. 										 "people":i_count_all,

    189. 

  189. 										 "difficulty":item_difficulty[section-1],

    190. 

  190. 										 "eloDegree":eloDegree[section-1],

    191. 

  191. 										 "avgCorrectness":i_correct_all/i_count_all,

    192. 

  192. 										 "avgTryCount":i_try_all/i_count_all,

    193. 

  193. 										 "step":"1-2"

    194. 

  194. 										}

    195. 

  195. 				db.AccuTime_sta.update_one({"gameCode":game, "sectionId":section, "seconds":seconds_all, "tickTime":y, "gameStar":5}, {'$set':AccuTimeAll_sta_dict}, upsert = True)

    196. 

  196. 				AccuTime_count += 1

    197. 

  197. 

    198. 

  198. 

    199. 

  199. 		#log秒

    200. 

  200. 		for seconds_all_log, i_count_all_log, i_correct_all_log, i_try_all_log, in zip(np.arange(-2.4, m+n, n), allPeople_log, allCorrectness_log, allTryCount_log):

    201. 

  201. 			if i_count_all_log > 0:

    202. 

  202. 				AccuTimeAllLog_sta_dict = {"gameCode":game,

    203. 

  203. 										   "sectionId":section,

    204. 

  204. 										   "seconds_log":round(seconds_all_log, 2),

    205. 

  205. 										   "tickTime":n,

    206. 

  206. 										   "gameStar":5,	#5是不分星星數

    207. 

  207. 										   "people":i_count_all_log,

    208. 

  208. 										   "difficulty" : item_difficulty[section-1],

    209. 

  209. 										   "eloDegree" : eloDegree[section-1],

    210. 

  210. 										   "avgCorrectness" : i_correct_all_log/i_count_all_log,

    211. 

  211. 										   "avgTryCount" : i_try_all_log/i_count_all_log,

    212. 

  212. 										   "step":"1-2"

    213. 

  213. 										  }

    214. 

  214. 				db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":section, "seconds_log":round(seconds_all_log, 2), "tickTime":n, "gameStar":5}, {'$set':AccuTimeAllLog_sta_dict}, upsert = True)   

    215. 

  215. 				AccuTimeLog_count += 1 		

    216. 

  216. 		del	allPeople, allCorrectness ,allTryCount, allPeople_log, allCorrectness_log, allTryCount_log

    217. 

  217. 		gc.collect()

    218. 

  218. 					

    219. 

  219. 		#只算有過關

    220. 

  220. 		#秒

    221. 

  221. 		for seconds_pass, i_count_pass, i_correct_pass, i_try_pass in zip(range(y, x+y+1, y), passPeople, passCorrectness, passTryCount):

    222. 

  222. 			if i_count_pass > 0:

    223. 

  223. 				AccuTimePass_sta_dict = {"gameCode":game,

    224. 

  224. 										 "sectionId":section,

    225. 

  225. 										 "seconds":seconds_pass,

    226. 

  226. 										 "tickTime":y,

    227. 

  227. 										 "gameStar":6,	#6是有過關

    228. 

  228. 										 "people":i_count_pass,

    229. 

  229. 										 "difficulty":item_difficulty[section-1],

    230. 

  230. 										 "eloDegree":eloDegree[section-1],

    231. 

  231. 										 "avgCorrectness":i_correct_pass/i_count_pass,

    232. 

  232. 										 "avgTryCount":i_try_pass/i_count_pass,

    233. 

  233. 										 "step":"1-3"

    234. 

  234. 										}

    235. 

  235. 				db.AccuTime_sta.update_one({"gameCode":game, "sectionId":section, "seconds":seconds_pass, "tickTime":y, "gameStar":6}, {'$set':AccuTimePass_sta_dict}, upsert = True)

    236. 

  236. 				AccuTime_count += 1	

    237. 

  237. 		

    238. 

  238. 		#log秒

    239. 

  239. 		for seconds_pass_log, i_count_pass_log, i_correct_pass_log, i_try_pass_log, in zip(np.arange(-2.4, m+n, n), passPeople_log, passCorrectness_log, passTryCount_log):

    240. 

  240. 			if i_count_pass_log > 0:

    241. 

  241. 				AccuTimePassLog_sta_dict = {"gameCode":game,

    242. 

  242. 										   "sectionId":section,

    243. 

  243. 										   "seconds_log":round(seconds_pass_log, 2),

    244. 

  244. 										   "tickTime":n,

    245. 

  245. 										   "gameStar":6,	#6是有過關

    246. 

  246. 										   "people":i_count_pass_log,

    247. 

  247. 										   "difficulty" : item_difficulty[section-1],

    248. 

  248. 										   "eloDegree" : eloDegree[section-1],

    249. 

  249. 										   "avgCorrectness" : i_correct_pass_log/i_count_pass_log,

    250. 

  250. 										   "avgTryCount" : i_try_pass_log/i_count_pass_log,

    251. 

  251. 										   "step":"1-3"

    252. 

  252. 										  }

    253. 

  253. 				db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":section, "seconds_log":round(seconds_pass_log, 2), "tickTime":n, "gameStar":6}, {'$set':AccuTimePassLog_sta_dict}, upsert = True)   

    254. 

  254. 				AccuTimeLog_count += 1 		

    255. 

  255. 		del	passPeople, passCorrectness ,passTryCount, passPeople_log, passCorrectness_log, passTryCount_log

    256. 

  256. 		gc.collect()		

    257. 

  257. 	

    258. 

  258. 	##step2依難度等級

    259. 

  259. 	print("insert %s data by difficulty degree" %game)

    260. 

  260. 	playerDegree = [num for num in range ]

    261. 

  261. 	for i in range(0, len(degree)):

    262. 

  262. 		allPeople, allCorrectness, alltryCount = [], [], []

    263. 

  263. 		allPeople = pc.create_lists(1, int(x//y)+2, 0)

    264. 

  264. 		allCorrectness = pc.create_lists(1, int(x//y)+2, 0)

    265. 

  265. 		alltryCount = pc.create_lists(1, int(x//y)+2, 0)

    266. 

  266. 		

    267. 

  267. 		allPeople_log, allCorrectness_log, alltryCount_log = [], [], []

    268. 

  268. 		allPeople_log = pc.create_lists(0, int(m//n)+1, 0)

    269. 

  269. 		allCorrectness_log = pc.create_lists(0, int(m//n)+1, 0)

    270. 

  270. 		alltryCount_log = pc.create_lists(0, int(m//n)+1, 0)

    271. 

  271. 		

    272. 

  272. 		passPeople, passCorrectness, passtryCount = [], [], []

    273. 

  273. 		passPeople = pc.create_lists(1, int(x//y)+2, 0)

    274. 

  274. 		passCorrectness = pc.create_lists(1, int(x//y)+2, 0)

    275. 

  275. 		passtryCount = pc.create_lists(1, int(x//y)+2, 0)

    276. 

  276. 		

    277. 

  277. 		passPeople_log, passCorrectness_log, passtryCount_log = [], [], []

    278. 

  278. 		passPeople_log = pc.create_lists(0, int(m//n)+1, 0)

    279. 

  279. 		passCorrectness_log = pc.create_lists(0, int(m//n)+1, 0)

    280. 

  280. 		passtryCount_log = pc.create_lists(0, int(m//n)+1, 0)

    281. 

  281. 		

    282. 

  282. 		for star in range(0, 5):

    283. 

  283. 			people, correctness, tryCount = [], [], []

    284. 

  284. 			people = pc.create_lists(1, int(x//y)+2, 0)

    285. 

  285. 			correctness = pc.create_lists(1, int(x//y)+2, 0)

    286. 

  286. 			tryCount = pc.create_lists(1, int(x//y)+2, 0)

    287. 

  287. 			

    288. 

  288. 			people_log, correctness_log, tryCount_log = [], [], [] 

    289. 

  289. 			people_log = pc.create_lists(1, int(m//n)+2, 0)

    290. 

  290. 			correctness_log = pc.create_lists(1, int(m//n)+2, 0)

    291. 

  291. 			tryCount_log = pc.create_lists(1, int(m//n)+2, 0)

    292. 

  292. 			

    293. 

  293. 			for two in ct.find({"gameCode":game, "eloDegree":degree[i], "gameStar":star, "accuTime_sec":{"$gt":0, "$lte":x}}):

    294. 

  294. 				try:

    295. 

  295. 					a = int(two['accuTime_sec'] // y)

    296. 

  296. 	

    297. 

  297. 					people[a] += 1

    298. 

  298. 					correctness[a] += two['correctPercentage']

    299. 

  299. 					tryCount[a] += two['tryCount']

    300. 

  300. 					

    301. 

  301. 					allPeople[a] += 1

    302. 

  302. 					allCorrectness[a] += two['correctPercentage']

    303. 

  303. 					alltryCount[a] += two['tryCount']

    304. 

  304. 					

    305. 

  305. 					if star > 0:

    306. 

  306. 						passPeople[a] += 1

    307. 

  307. 						passCorrectness[a] += two['correctPercentage']

    308. 

  308. 						passtryCount[a] += two['tryCount']

    309. 

  309. 					

    310. 

  310. 					b = int(two['logAccuTime_sec']//n)+24

    311. 

  311. 					

    312. 

  312. 					people_log[b] += 1

    313. 

  313. 					correctness_log[b] += two['correctPercentage']

    314. 

  314. 					tryCount_log[b] += two['tryCount']

    315. 

  315. 						

    316. 

  316. 					allPeople_log[b] += 1

    317. 

  317. 					allCorrectness_log[b] += two['correctPercentage']

    318. 

  318. 					alltryCount_log[b] += two['tryCount']

    319. 

  319. 					

    320. 

  320. 					if star > 0:

    321. 

  321. 						passPeople_log[b] += 1

    322. 

  322. 						passCorrectness_log[b] += two['correctPercentage']

    323. 

  323. 						passtryCount_log[b] += two['tryCount']

    324. 

  324. 				except:

    325. 

  325. 					print(two)

    326. 

  326. 			

    327. 

  327. 			#分星星

    328. 

  328. 			for seconds, i_count, i_correct, i_try in zip(range(y, x+y+1, y), people, correctness, tryCount):

    329. 

  329. 				if i_count > 0:

    330. 

  330. 					#print("seconds:", seconds, "i_count:", i_count, "try", i_try, "correct:", i_correct/i_count)

    331. 

  331. 					#os.system("pause")

    332. 

  332. 					AccuTime_sta_dict = {"gameCode":game,

    333. 

  333. 										 "sectionId":0,

    334. 

  334. 										 "seconds":seconds,

    335. 

  335. 										 "tickTime":y,

    336. 

  336. 										 "gameStar":star,

    337. 

  337. 										 "people":i_count,

    338. 

  338. 										 "difficulty":None,

    339. 

  339. 										 "eloDegree":degree[i],

    340. 

  340. 										 "avgCorrectness":i_correct/i_count,

    341. 

  341. 										 "avgTryCount":i_try/i_count,

    342. 

  342. 										 "step":"2-1"

    343. 

  343. 										}

    344. 

  344. 					db.AccuTime_sta.update_one({"gameCode": game,

    345. 

  345. 												"sectionId":0, 

    346. 

  346. 												"seconds":seconds,

    347. 

  347. 												"tickTime":y, 

    348. 

  348. 												"gameStar":star,

    349. 

  349. 												"difficulty":None,													

    350. 

  350. 												"eloDegree":degree[i]

    351. 

  351. 												}, 

    352. 

  352. 												{'$set': AccuTime_sta_dict}, 

    353. 

  353. 												upsert = True

    354. 

  354. 											   )

    355. 

  355. 					AccuTime_count += 1

    356. 

  356. 			for seconds_log, i_count_log, i_correct_log, i_try_log in zip(np.arange(-2.4, m+n, n), people_log, correctness_log, tryCount_log):

    357. 

  357. 				if i_count_log > 0:

    358. 

  358. 					AccuTimeLog_sta_dict = {"gameCode":game,

    359. 

  359. 											"sectionId":0,

    360. 

  360. 											"seconds_log":round(seconds_log, 2),

    361. 

  361. 											"tickTime":n,

    362. 

  362. 											"gameStar":star,

    363. 

  363. 											"people":i_count_log,

    364. 

  364. 											"difficulty":None,

    365. 

  365. 											"eloDegree":degree[i],

    366. 

  366. 											"avgCorrectness":i_correct_log/i_count_log,

    367. 

  367. 											"avgTryCount":i_try_log/i_count_log,

    368. 

  368. 											"step":"2-1"

    369. 

  369. 										   }

    370. 

  370. 					db.AccuTimeLog_sta.update_one({"gameCode":game, "seconds_log":round(seconds_log, 2), "tickTime":n, "gameStar":star, "difficulty":None, "eloDegree":degree[i]}, {'$set':AccuTimeLog_sta_dict}, upsert = True)

    371. 

  371. 					AccuTimeLog_count += 1

    372. 

  372. 			del	people, correctness, tryCount, people_log, correctness_log, tryCount_log			

    373. 

  373. 			gc.collect()

    374. 

  374. 		

    375. 

  375. 		#不分星

    376. 

  376. 		#秒

    377. 

  377. 		for seconds_all, i_count_all, i_correct_all, i_try_all in zip(range(y, x+y+1, y), allPeople, allCorrectness, alltryCount):

    378. 

  378. 			if i_count_all > 0:

    379. 

  379. 				#print("seconds:", seconds, "i_count:", i_count, "correct:", correct)

    380. 

  380. 				AccuTimeALL_sta_dict = {"gameCode" : game,

    381. 

  381. 										"sectionId": 0,

    382. 

  382. 										"seconds": seconds_all,

    383. 

  383. 										"tickTime" : y,

    384. 

  384. 										"gameStar" : 5,

    385. 

  385. 										"people" : i_count_all,

    386. 

  386. 										"difficulty" : None,

    387. 

  387. 										"eloDegree" : degree[i],

    388. 

  388. 										"avgCorrectness" : i_correct_all/i_count_all,

    389. 

  389. 										"avgTryCount" : i_try_all/i_count_all,

    390. 

  390. 										"step":"2-2"

    391. 

  391. 									   }

    392. 

  392. 				db.AccuTime_sta.update_one({"gameCode":game,

    393. 

  393. 											"sectionId":0,

    394. 

  394. 											"seconds":seconds_all,

    395. 

  395. 											"tickTime":y,

    396. 

  396. 											"gameStar":5,

    397. 

  397. 											"difficulty":None,

    398. 

  398. 											"eloDegree":degree[i]

    399. 

  399. 										    },

    400. 

  400. 											{'$set': AccuTimeALL_sta_dict},

    401. 

  401. 											upsert = True

    402. 

  402. 										   )

    403. 

  403. 				AccuTime_count += 1

    404. 

  404. 		#log秒

    405. 

  405. 		for seconds_all_log, i_count_all_log, i_correct_all_log, i_try_all_log in zip(np.arange(-2.4, m+n, n), allPeople_log, allCorrectness_log, alltryCount_log):

    406. 

  406. 			if i_count_all_log > 0:

    407. 

  407. 				AccuTimeAllLog_sta_dict = {"gameCode":game,

    408. 

  408. 										   "sectionId":0,

    409. 

  409. 										   "seconds_log":round(seconds_all_log, 2),

    410. 

  410. 										   "tickTime":n,

    411. 

  411. 										   "gameStar":5,

    412. 

  412. 										   "people":i_count_all_log,

    413. 

  413. 										   "difficulty":None,

    414. 

  414. 										   "eloDegree":degree[i],

    415. 

  415. 										   "avgCorrectness":i_correct_all_log/i_count_all_log,

    416. 

  416. 										   "avgTryCount":i_try_all_log/i_count_all_log,

    417. 

  417. 										   "step":"2-2"

    418. 

  418. 										  }

    419. 

  419. 				db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":0, "seconds_log":round(seconds_all_log, 2), "tickTime":n, "gameStar":5, "difficulty":None, "eloDegree":degree[i]}, {'$set': AccuTimeAllLog_sta_dict}, upsert = True)					

    420. 

  420. 				AccuTimeLog_count += 1

    421. 

  421. 		del	allPeople, allCorrectness, alltryCount, allPeople_log, allCorrectness_log, alltryCount_log

    422. 

  422. 		gc.collect()

    423. 

  423. 		

    424. 

  424. 		#只算有過關

    425. 

  425. 		#秒

    426. 

  426. 		for seconds_pass, i_count_pass, i_correct_pass, i_try_pass in zip(range(y, x+y+1, y), passPeople, passCorrectness, passtryCount):

    427. 

  427. 			if i_count_pass > 0:

    428. 

  428. 				#print("seconds:", seconds, "i_count:", i_count, "correct:", correct)

    429. 

  429. 				AccuTimePass_sta_dict = {"gameCode" : game,

    430. 

  430. 										 "sectionId": 0,

    431. 

  431. 										 "seconds": seconds_pass,

    432. 

  432. 										 "tickTime" : y,

    433. 

  433. 										 "gameStar" : 6,

    434. 

  434. 										 "people" : i_count_pass,

    435. 

  435. 										 "difficulty" : None,

    436. 

  436. 										 "eloDegree" : degree[i],

    437. 

  437. 										 "avgCorrectness" : i_correct_pass/i_count_pass,

    438. 

  438. 										 "avgTryCount" : i_try_pass/i_count_pass,

    439. 

  439. 										 "step":"2-3"

    440. 

  440. 										}

    441. 

  441. 				db.AccuTime_sta.update_one({"gameCode":game,

    442. 

  442. 											"sectionId":0,

    443. 

  443. 											"seconds":seconds_pass,

    444. 

  444. 											"tickTime":y,

    445. 

  445. 											"gameStar":6,

    446. 

  446. 											"difficulty":None,

    447. 

  447. 											"eloDegree":degree[i]

    448. 

  448. 										    },

    449. 

  449. 											{'$set': AccuTimePass_sta_dict},

    450. 

  450. 											upsert = True

    451. 

  451. 										  )

    452. 

  452. 				AccuTime_count += 1

    453. 

  453. 		#log秒

    454. 

  454. 		for seconds_pass_log, i_count_pass_log, i_correct_pass_log, i_try_pass_log in zip(np.arange(-2.4, m+n, n), passPeople_log, passCorrectness_log, passtryCount_log):

    455. 

  455. 			if i_count_pass_log > 0:

    456. 

  456. 				AccuTimePassLog_sta_dict = {"gameCode":game,

    457. 

  457. 											"sectionId":0,

    458. 

  458. 											"seconds_log":round(seconds_pass_log, 2),

    459. 

  459. 											"tickTime":n,

    460. 

  460. 											"gameStar":6,

    461. 

  461. 											"people":i_count_pass_log,

    462. 

  462. 											"difficulty":None,

    463. 

  463. 											"eloDegree":degree[i],

    464. 

  464. 											"avgCorrectness":i_correct_pass_log/i_count_pass_log,

    465. 

  465. 											"avgTryCount":i_try_pass_log/i_count_pass_log,

    466. 

  466. 											"step":"2-3"

    467. 

  467. 										   }

    468. 

  468. 				db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":0, "seconds_log":round(seconds_pass_log, 2), "tickTime":n, "gameStar":6, "difficulty":None, "eloDegree":degree[i]}, {'$set':AccuTimePassLog_sta_dict}, upsert = True)					

    469. 

  469. 				AccuTimeLog_count += 1

    470. 

  470. 		del	passPeople, passCorrectness, passtryCount, passPeople_log, passCorrectness_log, passtryCount_log

    471. 

  471. 		gc.collect()	

    472. 

  472. 	

    473. 

  473. 	##step3依時間

    474. 

  474. 	print("insert %s data by time" %game)

    475. 

  475. 	#這裡跟Difficulty相關的欄位是用來平均難度

    476. 

  476. 	allPeople, allCorrectness, allDifficulty, allTryCount = [], [], [], []	

    477. 

  477. 

    478. 

  478. 	allPeople = pc.create_lists(0, int(x//y)+1, 0)

    479. 

  479. 	allCorrectness = pc.create_lists(0, int(x//y)+1, 0)

    480. 

  480. 	allDifficulty = pc.create_lists(0, int(x//y)+1, 0)

    481. 

  481. 	allTryCount = pc.create_lists(0, int(x//y)+1, 0)

    482. 

  482. 	

    483. 

  483. 	allPeople_log, allCorrectness_log, allDifficulty_log, allTryCount_log = [], [], [], []

    484. 

  484. 

    485. 

  485. 	allPeople_log = pc.create_lists(0, int(m//n)+1, 0)

    486. 

  486. 	allCorrectness_log = pc.create_lists(0, int(m//n)+1, 0)

    487. 

  487. 	allDifficulty_log = pc.create_lists(0, int(m//n)+1, 0)

    488. 

  488. 	allTryCount_log = pc.create_lists(0, int(m//n)+1, 0)

    489. 

  489. 	

    490. 

  490. 	passPeople, passCorrectness, passDifficulty, passTryCount = [], [], [], []

    491. 

  491. 

    492. 

  492. 	passPeople = pc.create_lists(0, int(x//y)+1, 0)

    493. 

  493. 	passCorrectness = pc.create_lists(0, int(x//y)+1, 0)

    494. 

  494. 	passDifficulty = pc.create_lists(0, int(x//y)+1, 0)

    495. 

  495. 	passTryCount = pc.create_lists(0, int(x//y)+1, 0)

    496. 

  496. 	

    497. 

  497. 	passPeople_log, passCorrectness_log, passDifficulty_log, passTryCount_log = [], [], [], []

    498. 

  498. 

    499. 

  499. 	passPeople_log = pc.create_lists(0, int(m//n)+1, 0)

    500. 

  500. 	passCorrectness_log = pc.create_lists(0, int(m//n)+1, 0)

    501. 

  501. 	passDifficulty_log = pc.create_lists(0, int(m//n)+1, 0)

    502. 

  502. 	passTryCount_log = pc.create_lists(0, int(m//n)+1, 0)	

    503. 

  503. 

    504. 

  504. 	allzPeople, allzCorrectness, allzDifficulty, allzTryCount = [], [], [], []

    505. 

  505. 

    506. 

  506. 	allzPeople = pc.create_lists(0, int(p//q)+1, 0)

    507. 

  507. 	allzCorrectness = pc.create_lists(0, int(p//q)+1, 0)

    508. 

  508. 	allzDifficulty = pc.create_lists(0, int(p//q)+1, 0)

    509. 

  509. 	allzTryCount = pc.create_lists(0, int(p//q)+1, 0)

    510. 

  510. 

    511. 

  511. 	for star in range(0, 5):

    512. 

  512. 		people, correctness, tryCount, difficulty = [], [], [], []

    513. 

  513. 		

    514. 

  514. 		people = pc.create_lists(1, int(x//y)+2, 0)

    515. 

  515. 		correctness = pc.create_lists(1, int(x//y)+2, 0)

    516. 

  516. 		tryCount = pc.create_lists(1, int(x//y)+2, 0)

    517. 

  517. 		difficulty = pc.create_lists(1, int(x//y)+2, 0)

    518. 

  518. 		

    519. 

  519. 		people_log, correctness_log, tryCount_log, difficulty_log = [], [], [], []

    520. 

  520. 

    521. 

  521. 		people_log = pc.create_lists(1, int(m//n)+2, 0)

    522. 

  522. 		correctness_log = pc.create_lists(1, int(m//n)+2, 0)

    523. 

  523. 		tryCount_log = pc.create_lists(1, int(m//n)+2, 0)

    524. 

  524. 		difficulty_log = pc.create_lists(1, int(m//n)+2, 0)

    525. 

  525. 		

    526. 

  526. 		zPeople, zCorrectness, zDifficulty, zTryCount = [], [], [], []

    527. 

  527. 		

    528. 

  528. 		zPeople = pc.create_lists(0, int(p//q)+1, 0)

    529. 

  529. 		zCorrectness = pc.create_lists(0, int(p//q)+1, 0)

    530. 

  530. 		zDifficulty = pc.create_lists(0, int(p//q)+1, 0)

    531. 

  531. 		zTryCount = pc.create_lists(0, int(p//q)+1, 0)	

    532. 

  532. 		

    533. 

  533. 		zPeople_log, zCorrectness_log, zDifficulty_log, zTryCount_log = [], [], [], []

    534. 

  534. 		

    535. 

  535. 		zPeople_log = pc.create_lists(0, int(u//v)+1, 0)

    536. 

  536. 		zCorrectness_log = pc.create_lists(0, int(u//v)+1, 0)

    537. 

  537. 		zDifficulty_log = pc.create_lists(0, int(u//v)+1, 0)

    538. 

  538. 		zTryCount_log = pc.create_lists(0, int(u//v)+1, 0)			

    539. 

  539. 		

    540. 

  540. 		error = 0

    541. 

  541. 		for three in ct.find({"gameCode":game, "gameStar":star, "accuTime_sec":{"$gt":0, "$lte":x}}):

    542. 

  542. 			try:

    543. 

  543. 				a = int(three['accuTime_sec'] // y)

    544. 

  544. 				people[a] += 1

    545. 

  545. 				correctness[a] += three['correctPercentage']

    546. 

  546. 				difficulty[a] += three['difficulty']

    547. 

  547. 				tryCount[a] += three['tryCount']

    548. 

  548. 				

    549. 

  549. 				allPeople[a] += 1

    550. 

  550. 				allCorrectness[a] += three['correctPercentage']

    551. 

  551. 				allDifficulty[a] += three['difficulty']

    552. 

  552. 				allTryCount[a] += three['tryCount']

    553. 

  553. 				

    554. 

  554. 				if star > 0:

    555. 

  555. 					passPeople[a] += 1

    556. 

  556. 					passCorrectness[a] += three['correctPercentage']

    557. 

  557. 					passDifficulty[a] += three['difficulty']

    558. 

  558. 					passTryCount[a] += three['tryCount']

    559. 

  559. 				

    560. 

  560. 				b = int(three['logAccuTime_sec']//n)+24

    561. 

  561. 				people_log[b] += 1

    562. 

  562. 				correctness_log[b] += three['correctPercentage']

    563. 

  563. 				difficulty_log[b] += three['difficulty']

    564. 

  564. 				tryCount_log[b]	+= three['tryCount']

    565. 

  565. 				

    566. 

  566. 				allPeople_log[b] += 1					

    567. 

  567. 				allCorrectness_log[b] += three['correctPercentage']

    568. 

  568. 				allDifficulty_log[b] += three['difficulty']

    569. 

  569. 				allTryCount_log[b]	+= three['tryCount']

    570. 

  570. 				

    571. 

  571. 				if star > 0:

    572. 

  572. 					passPeople_log[b] += 1					

    573. 

  573. 					passCorrectness_log[b] += three['correctPercentage']

    574. 

  574. 					passDifficulty_log[b] += three['difficulty']

    575. 

  575. 					passTryCount_log[b]	+= three['tryCount']				

    576. 

  576. 				

    577. 

  577. 				#c = int(three['ZTime']//q)+8

    578. 

  578. 				c = int(three['ZTime']//q)+1

    579. 

  579. 				zPeople[c] += 1

    580. 

  580. 				zCorrectness[c] += three['correctPercentage']

    581. 

  581. 				zDifficulty[c] += three['difficulty']

    582. 

  582. 				zTryCount[c] += three['tryCount']

    583. 

  583. 				

    584. 

  584. 				allzPeople[c] += 1

    585. 

  585. 				allzCorrectness[c] += three['correctPercentage']

    586. 

  586. 				allzDifficulty[c] += three['difficulty']

    587. 

  587. 				allzTryCount[c] += three['tryCount']

    588. 

  588. 				

    589. 

  589. 			except:

    590. 

  590. 				error += 1

    591. 

  591. 				#print(error, three)

    592. 

  592. 				

    593. 

  593. 		#分星星

    594. 

  594. 		#秒

    595. 

  595. 		for seconds, i_count, i_correct, i_try, i_difficulty in zip(range(y, x+y+1, y), people, correctness, tryCount, difficulty):

    596. 

  596. 			if i_count > 0:

    597. 

  597. 				AccuTime_sta_dict = {"gameCode":game,

    598. 

  598. 									 "sectionId":0,

    599. 

  599. 									 "seconds":seconds,

    600. 

  600. 									 "tickTime":y,

    601. 

  601. 									 "gameStar":star,

    602. 

  602. 									 "people":i_count,

    603. 

  603. 									 "difficulty":i_difficulty/i_count,

    604. 

  604. 									 "eloDegree":'n',

    605. 

  605. 									 "avgCorrectness":i_correct/i_count,

    606. 

  606. 									 "avgTryCount":i_try/i_count,

    607. 

  607. 									 "step":"3-1"

    608. 

  608. 									}    

    609. 

  609. 				db.AccuTime_sta.update_one({"gameCode":game, "sectionId":0, "seconds":seconds, "tickTime":y, "gameStar":star, "eloDegree":'n'}, {'$set':AccuTime_sta_dict}, upsert = True)

    610. 

  610. 				AccuTime_count += 1

    611. 

  611. 		#Log秒		

    612. 

  612. 		for seconds_log, i_count_log, i_correct_log, i_try_log, i_difficulty_log in zip(np.arange(-2.4, m+n, n), people_log, correctness_log, tryCount_log, difficulty_log):

    613. 

  613. 			if i_count_log > 0:

    614. 

  614. 				AccuTimeLog_sta_dict = {"gameCode":game,

    615. 

  615. 										"sectionId":0,

    616. 

  616. 										"seconds_log":round(seconds_log, 2),

    617. 

  617. 										"tickTime":n,

    618. 

  618. 										"gameStar":star,

    619. 

  619. 										"people":i_count_log,

    620. 

  620. 										"difficulty":i_difficulty_log/i_count_log,

    621. 

  621. 										"eloDegree":'n',

    622. 

  622. 										"avgCorrectness":i_correct_log/i_count_log,

    623. 

  623. 										"avgTryCount":i_try_log/i_count_log,

    624. 

  624. 										"step":"3-1"

    625. 

  625. 									   }

    626. 

  626. 				db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":0, "seconds_log":round(seconds_log, 2), "tickTime":n, "gameStar":star, "eloDegree":'n'}, {'$set':AccuTimeLog_sta_dict}, upsert = True)

    627. 

  627. 				AccuTimeLog_count += 1		

    628. 

  628. 		#ZTime

    629. 

  629. 		#for z_seconds, z_count, z_correct, z_try, z_difficulty in zip(np.arange(-1, p+q, q), zPeople, zCorrectness, zTryCount, zDifficulty):

    630. 

  630. 		for z_seconds, z_count, z_correct, z_try, z_difficulty in zip(range(-1, p+q, q), zPeople, zCorrectness, zTryCount, zDifficulty):

    631. 

  631. 			if z_count > 0:

    632. 

  632. 				AccuTimeZ_sta_dict = {"gameCode":game,

    633. 

  633. 									 "sectionId":0,

    634. 

  634. 									 "seconds_z":z_seconds,#round(z_seconds, 2),

    635. 

  635. 									 "tickTime":q,

    636. 

  636. 									 "gameStar":star,

    637. 

  637. 									 "people":z_count,

    638. 

  638. 									 "difficulty":z_difficulty/z_count,

    639. 

  639. 									 "eloDegree":'n',

    640. 

  640. 									 "avgCorrectness":z_correct/z_count,

    641. 

  641. 									 "avgTryCount":z_try/z_count,

    642. 

  642. 									 "step":"3-1"

    643. 

  643. 									}    

    644. 

  644. 				db.AccuTimeZ_sta.update_one({"gameCode":game, "sectionId":0, "seconds_z":z_seconds, "tickTime":q, "gameStar":star}, {'$set':AccuTimeZ_sta_dict}, upsert = True)

    645. 

  645. 				AccuTimeZ_count += 1		

    646. 

  646. 		

    647. 

  647. 		del	people, correctness, tryCount, difficulty, people_log, correctness_log, tryCount_log, difficulty_log, zPeople, zCorrectness, zTryCount, zDifficulty			

    648. 

  648. 		gc.collect()				

    649. 

  649. 		

    650. 

  650. 	#不分星星

    651. 

  651. 	#秒

    652. 

  652. 	for seconds_all, i_count_all, i_correct_all, i_difficulty_all, i_try_all in zip(range(0, x+y, y), allPeople, allCorrectness, allDifficulty, allTryCount):

    653. 

  653. 		if i_count_all > 0:

    654. 

  654. 			AccuTimeAll_sta_dict = {"gameCode":game,

    655. 

  655. 									"sectionId":0,

    656. 

  656. 									"seconds":seconds_all,

    657. 

  657. 									"tickTime":y,

    658. 

  658. 									"gameStar":5,

    659. 

  659. 									"people":i_count_all,

    660. 

  660. 									"difficulty":i_difficulty_all/i_count_all,

    661. 

  661. 									"eloDegree":'n',

    662. 

  662. 									"avgCorrectness":i_correct_all/i_count_all,

    663. 

  663. 									"avgTryCount":i_try_all/i_count_all,

    664. 

  664. 									"step":"3-2"

    665. 

  665. 								   }

    666. 

  666. 			db.AccuTime_sta.update_one({"gameCode":game, "sectionId":0, "seconds":seconds_all, "tickTime":y, "gameStar":5, "eloDegree":'n'}, {'$set':AccuTimeAll_sta_dict}, upsert = True)      

    667. 

  667. 			AccuTime_count += 1

    668. 

  668. 	#log秒

    669. 

  669. 	for seconds_all_log, i_count_all_log, i_correct_all_log, i_difficulty_all_log, i_try_all_log in zip(np.arange(-2.4, m+n, n), allPeople_log, allCorrectness_log, allDifficulty_log, allTryCount_log):

    670. 

  670. 		if i_count_all_log > 0:

    671. 

  671. 			AccuTimeAllLog_sta_dict = {"gameCode":game,

    672. 

  672. 										  "sectionId":0,

    673. 

  673. 										  "seconds_log":round(seconds_all_log, 2),

    674. 

  674. 										  "tickTime":n,

    675. 

  675. 										  "gameStar":5,

    676. 

  676. 										  "people":i_count_all_log,

    677. 

  677. 										  "difficulty":i_difficulty_all_log/i_count_all_log,

    678. 

  678. 										  "eloDegree":'n',

    679. 

  679. 										  "avgCorrectness":i_correct_all_log/i_count_all_log,

    680. 

  680. 										  "avgTryCount":i_try_all_log/i_count_all_log,

    681. 

  681. 										  "step":"3-2"

    682. 

  682. 										 }

    683. 

  683. 			db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":0, "seconds_log":round(seconds_all_log, 2), "tickTime":n, "gameStar":5, "eloDegree":'n'},{'$set':AccuTimeAllLog_sta_dict}, upsert = True)

    684. 

  684. 			AccuTimeLog_count += 1 		

    685. 

  685. 	del	allPeople, allCorrectness, allDifficulty, allTryCount, allPeople_log, allCorrectness_log, allDifficulty_log, allTryCount_log

    686. 

  686. 	gc.collect()

    687. 

  687. 	

    688. 

  688. 	#只算過關

    689. 

  689. 	#秒

    690. 

  690. 	for seconds_pass, i_count_pass, i_correct_pass, i_difficulty_pass, i_try_pass in zip(range(0, x+y, y), passPeople, passCorrectness, passDifficulty, passTryCount):

    691. 

  691. 		if i_count_pass > 0:

    692. 

  692. 			AccuTimePass_sta_dict = {"gameCode":game,

    693. 

  693. 									   "sectionId":0,

    694. 

  694. 									   "seconds":seconds_pass,

    695. 

  695. 									   "tickTime":y,

    696. 

  696. 									   "gameStar":6,	#6是有過關		

    697. 

  697. 									   "people":i_count_pass,

    698. 

  698. 									   "difficulty":i_difficulty_pass/i_count_pass,

    699. 

  699. 									   "eloDegree":'n',

    700. 

  700. 									   "avgCorrectness":i_correct_pass/i_count_pass,

    701. 

  701. 									   "avgTryCount":i_try_pass/i_count_pass,

    702. 

  702. 									   "step":"3-3"

    703. 

  703. 									  }

    704. 

  704. 			db.AccuTime_sta.update_one({"gameCode":game, "sectionId":0, "seconds":seconds_pass, "tickTime":y, "gameStar":6, "eloDegree":'n'}, {'$set':AccuTimePass_sta_dict}, upsert = True)

    705. 

  705. 			AccuTime_count += 1

    706. 

  706. 	#log秒

    707. 

  707. 	for seconds_pass_log, i_count_pass_log, i_correct_pass_log, i_difficulty_pass_log, i_try_pass_log in zip(np.arange(-2.4, m+n, n), passPeople_log, passCorrectness_log, passDifficulty_log, passTryCount_log):

    708. 

  708. 		if i_count_pass_log > 0:

    709. 

  709. 			AccuTimePassLog_sta_dict = {"gameCode":game,

    710. 

  710. 										"sectionId":0,

    711. 

  711. 										"seconds_log":round(seconds_pass_log, 2),

    712. 

  712. 										"tickTime":n,

    713. 

  713. 										"gameStar":6,		#6是有過關

    714. 

  714. 										"people":i_count_pass_log,

    715. 

  715. 										"difficulty":i_difficulty_pass_log/i_count_pass_log,

    716. 

  716. 										"eloDegree":'n',

    717. 

  717. 										"avgCorrectness":i_correct_pass_log/i_count_pass_log,

    718. 

  718. 										"avgTryCount":i_try_pass_log/i_count_pass_log,

    719. 

  719. 										"step":"3-3"

    720. 

  720. 									   }

    721. 

  721. 			db.AccuTimeLog_sta.update_one({"gameCode":game, "sectionId":0, "seconds_log":round(seconds_pass_log, 2), "tickTime":n, "gameStar":6, "eloDegree":'n'},{'$set':AccuTimePassLog_sta_dict}, upsert = True)

    722. 

  722. 			AccuTimeLog_count += 1

    723. 

  723. 			

    724. 

  724. 	for seconds_z_all, i_count_z_all, i_correct_z_all, i_difficulty_z_all, i_try_z_all in zip(range(-1, p+q, q), allzPeople, allzCorrectness, allzDifficulty, allzTryCount):

    725. 

  725. 		if i_count_z_all > 0:

    726. 

  726. 			AccuTimeZAll_sta_dict = {"gameCode":game,

    727. 

  727. 									"sectionId":0,

    728. 

  728. 									"seconds_z":seconds_z_all,

    729. 

  729. 									"tickTime":q,

    730. 

  730. 									"gameStar":5,

    731. 

  731. 									"people":i_count_z_all,

    732. 

  732. 									"difficulty":i_difficulty_z_all/i_count_z_all,

    733. 

  733. 									"eloDegree":'n',

    734. 

  734. 									"avgCorrectness":i_correct_z_all/i_count_z_all,

    735. 

  735. 									"avgTryCount":i_try_z_all/i_count_z_all,

    736. 

  736. 									"step":"3-3"

    737. 

  737. 								   }

    738. 

  738. 			db.AccuTimeZ_sta.update_one({"gameCode":game, "sectionId":0, "seconds_z":seconds_z_all, "tickTime":q, "gameStar":5, "eloDegree":'n'}, {'$set':AccuTimeZAll_sta_dict}, upsert = True)      

    739. 

  739. 			AccuTime_count += 1			

    740. 

  740. 			

    741. 

  741. 	del	passPeople, passCorrectness ,passDifficulty, passTryCount, passPeople_log, passCorrectness_log, passDifficulty_log, passTryCount_log, allzPeople, allzCorrectness, allzDifficulty, allzTryCount

    742. 

  742. 	gc.collect()

    743. 

  743. 	

    744. 

  744. 

    745. 

  745. 

    746. 

  746. pc.pass_time(startTime, time.time())
    747.