登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 46

ITI0/qytang_Python

forked from 张鹏/qytang_Python 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
2016.02.21 学员信息查询系统 22.58 KB
一键复制 编辑 原始数据 按行查看 历史
现任明教教主-乾颐堂 提交于 2016-02-21 14:32 . new file
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445
#!/usr/bin/python3.4

# -*- coding=utf-8 -*-

import os

import pg8000

import sys

import datetime



def selfresults(yourname):

#    yourname = input('请输入你的姓名: ')

	os.system('clear')

#	print("select name from seclab where name = '%s'" % yourname)

	conn = pg8000.connect(host='172.17.100.228', user='XXX', password='XXXX', database='secdb')

	cursor = conn.cursor()

	cursor.execute("select * from seclab where name = '%s'" % str(yourname))

	yourresults = cursor.fetchall()

	if yourresults == ():

		print('不好意思没有找到与您相关的记录')

		os._exit(0)

	cursor.execute("select score from seclab")

	total_score_results = cursor.fetchall()



#	计算平均得分

	your_total_score = 0

	your_labwork_count = 0

	for lst in yourresults:

		your_labwork_count = your_labwork_count + 1

		your_total_score = your_total_score + lst[7]

	your_average_score = your_total_score /your_labwork_count



	total_score = 0

	total_labwork_count = 0

	for lst in total_score_results:

		total_labwork_count = total_labwork_count + 1

		total_score = total_score + lst[0]

	total_average_score = total_score / total_labwork_count	

	print('您的姓名: ' + yourname)

	print('您的平均得分: ' + str(int(your_average_score)) + ' '*5 + 'ALL平均得分: ' +  str(int(total_average_score)))

	print('教主的建议:如果你的分数低于80分(B)，你正位于危险的边缘，需要更加努力了！！！')

	print('-' * 84)

	cursor.execute("select verno,result from seclab where name = '%s'" % yourname)

	your_verion_result = cursor.fetchall()

	VE_count = 0;VF_count = 0;V10_count = 0;V11_count = 0;V12_count = 0

	VE_A=0;VE_A_=0;VE_B_Plus=0;VE_B=0;VE_B_=0;VE_C_Plus=0;VE_C=0;VE_C_=0;VE_D_Plus=0;VE_D=0;VE_D_=0;VE_E_Plus=0;VE_E=0;VE_E_=0

	VF_A=0;VF_A_=0;VF_B_Plus=0;VF_B=0;VF_B_=0;VF_C_Plus=0;VF_C=0;VF_C_=0;VF_D_Plus=0;VF_D=0;VF_D_=0;VF_E_Plus=0;VF_E=0;VF_E_=0

	V10_A=0;V10_A_=0;V10_B_Plus=0;V10_B=0;V10_B_=0;V10_C_Plus=0;V10_C=0;V10_C_=0;V10_D_Plus=0;V10_D=0;V10_D_=0;V10_E_Plus=0;V10_E=0;V10_E_=0

	V11_A=0;V11_A_=0;V11_B_Plus=0;V11_B=0;V11_B_=0;V11_C_Plus=0;V11_C=0;V11_C_=0;V11_D_Plus=0;V11_D=0;V11_D_=0;V11_E_Plus=0;V11_E=0;V11_E_=0

	V12_A=0;V12_A_=0;V12_B_Plus=0;V12_B=0;V12_B_=0;V12_C_Plus=0;V12_C=0;V12_C_=0;V12_D_Plus=0;V12_D=0;V12_D_=0;V12_E_Plus=0;V12_E=0;V12_E_=0



	for verion_result in your_verion_result:

		if verion_result[0] == 've':

			VE_count = VE_count + 1

		if verion_result[0] == 've' and (verion_result[1] == 'A' or verion_result[1] == 'a'):

			VE_A = VE_A + 1

		if verion_result[0] == 've' and (verion_result[1] == 'A-' or verion_result[1] == 'a-'):

			VE_A_ = VE_A_ + 1

		if verion_result[0] == 've' and (verion_result[1] == 'B+' or verion_result[1] == 'b+'):

			VE_B_Plus = VE_B_Plus + 1

		if verion_result[0] == 've' and (verion_result[1] == 'B' or verion_result[1] == 'b'):

			VE_B = VE_B + 1

		if verion_result[0] == 've' and (verion_result[1] == 'B-' or verion_result[1] == 'b-'):

			VE_B_ = VE_B_ + 1

		if verion_result[0] == 've' and (verion_result[1] == 'C+' or verion_result[1] == 'c+'):

			VE_C_Plus = VE_C_Plus + 1

		if verion_result[0] == 've' and (verion_result[1] == 'C' or verion_result[1] == 'c'):

			VE_C = VE_C + 1

		if verion_result[0] == 've' and (verion_result[1] == 'C-' or verion_result[1] == 'c-'):

			VE_C_ = VE_C_ + 1

		if verion_result[0] == 've' and (verion_result[1] == 'D+' or verion_result[1] == 'd+'):

			VE_D_Plus = VE_D_Plus + 1

		if verion_result[0] == 've' and (verion_result[1] == 'D' or verion_result[1] == 'd'):

			VE_D = VE_D + 1

		if verion_result[0] == 've' and (verion_result[1] == 'D-' or verion_result[1] == 'd-'):

			VE_D_ = VE_D_ + 1

		if verion_result[0] == 've' and (verion_result[1] == 'E+' or verion_result[1] == 'e+'):

			VE_E_Plus = VE_E_Plus + 1

		if verion_result[0] == 've' and (verion_result[1] == 'E' or verion_result[1] == 'e'):

			VE_E = VE_E + 1

		if verion_result[0] == 've' and (verion_result[1] == 'E-' or verion_result[1] == 'e-'):

			VE_E_ = VE_E_ + 1

####################################################################################################

		if verion_result[0] == 'vf':

			VF_count = VF_count + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'A' or verion_result[1] == 'a'):

			VF_A = VF_A + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'A-' or verion_result[1] == 'a-'):

			VF_A_ = VF_A_ + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'B+' or verion_result[1] == 'b+'):

			VF_B_Plus = VF_B_Plus + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'B' or verion_result[1] == 'b'):

			VF_B = VF_B + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'B-' or verion_result[1] == 'b-'):

			VF_B_ = VF_B_ + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'C+' or verion_result[1] == 'c+'):

			VF_C_Plus = VF_C_Plus + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'C' or verion_result[1] == 'c'):

			VF_C = VF_C + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'C-' or verion_result[1] == 'c-'):

			VF_C_ = VF_C_ + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'D+' or verion_result[1] == 'd+'):

			VF_D_Plus = VF_D_Plus + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'D' or verion_result[1] == 'd'):

			VF_D = VF_D + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'D-' or verion_result[1] == 'd-'):

			VF_D_ = VF_D_ + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'E+' or verion_result[1] == 'e+'):

			VF_E_Plus = VF_E_Plus + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'E' or verion_result[1] == 'e'):

			VF_E = VF_E + 1

		if verion_result[0] == 'vf' and (verion_result[1] == 'E-' or verion_result[1] == 'e-'):

			VF_E_ = VF_E_ + 1

####################################################################################################			

		if verion_result[0] == 'v10':

			V10_count = V10_count + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'A' or verion_result[1] == 'a'):

			V10_A = V10_A + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'A-' or verion_result[1] == 'a-'):

			V10_A_ = V10_A_ + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'B+' or verion_result[1] == 'b+'):

			V10_B_Plus = V10_B_Plus + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'B' or verion_result[1] == 'b'):

			V10_B = V10_B + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'B-' or verion_result[1] == 'b-'):

			V10_B_ = V10_B_ + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'C+' or verion_result[1] == 'c+'):

			V10_C_Plus = V10_C_Plus + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'C' or verion_result[1] == 'c'):

			V10_C = V10_C + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'C-' or verion_result[1] == 'c-'):

			V10_C_ = V10_C_ + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'D+' or verion_result[1] == 'd+'):

			V10_D_Plus = V10_D_Plus + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'D' or verion_result[1] == 'd'):

			V10_D = V10_D + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'D-' or verion_result[1] == 'd-'):

			V10_D_ = V10_D_ + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'E+' or verion_result[1] == 'e+'):

			V10_E_Plus = V10_E_Plus + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'E' or verion_result[1] == 'e'):

			V10_E = V10_E + 1

		if verion_result[0] == 'v10' and (verion_result[1] == 'E-' or verion_result[1] == 'e-'):

			V10_E_ = V10_E_ + 1

####################################################################################################

		if verion_result[0] == 'v11':

			V11_count = V11_count + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'A' or verion_result[1] == 'a'):

			V11_A = V11_A + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'A-' or verion_result[1] == 'a-'):

			V11_A_ = V11_A_ + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'B+' or verion_result[1] == 'b+'):

			V11_B_Plus = V11_B_Plus + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'B' or verion_result[1] == 'b'):

			V11_B = V11_B + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'B-' or verion_result[1] == 'b-'):

			V11_B_ = V11_B_ + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'C+' or verion_result[1] == 'c+'):

			V11_C_Plus = V11_C_Plus + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'C' or verion_result[1] == 'c'):

			V11_C = V11_C + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'C-' or verion_result[1] == 'c-'):

			V11_C_ = V11_C_ + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'D+' or verion_result[1] == 'd+'):

			V11_D_Plus = V11_D_Plus + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'D' or verion_result[1] == 'd'):

			V11_D = V11_D + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'D-' or verion_result[1] == 'd-'):

			V11_D_ = V11_D_ + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'E+' or verion_result[1] == 'e+'):

			V11_E_Plus = V11_E_Plus + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'E' or verion_result[1] == 'e'):

			V11_E = V11_E + 1

		if verion_result[0] == 'v11' and (verion_result[1] == 'E-' or verion_result[1] == 'e-'):

			V11_E_ = V11_E_ + 1

####################################################################################################

		if verion_result[0] == 'v12':

			V12_count = V12_count + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'A' or verion_result[1] == 'a'):

			V12_A = V12_A + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'A-' or verion_result[1] == 'a-'):

			V12_A_ = V12_A_ + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'B+' or verion_result[1] == 'b+'):

			V12_B_Plus = V12_B_Plus + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'B' or verion_result[1] == 'b'):

			V12_B = V12_B + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'B-' or verion_result[1] == 'b-'):

			V12_B_ = V12_B_ + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'C+' or verion_result[1] == 'c+'):

			V12_C_Plus = V12_C_Plus + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'C' or verion_result[1] == 'c'):

			V12_C = V12_C + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'C-' or verion_result[1] == 'c-'):

			V12_C_ = V12_C_ + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'D+' or verion_result[1] == 'd+'):

			V12_D_Plus = V12_D_Plus + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'D' or verion_result[1] == 'd'):

			V12_D = V12_D + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'D-' or verion_result[1] == 'd-'):

			V12_D_ = V12_D_ + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'E+' or verion_result[1] == 'e+'):

			V12_E_Plus = V12_E_Plus + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'E' or verion_result[1] == 'e'):

			V12_E = V12_E + 1

		if verion_result[0] == 'v12' and (verion_result[1] == 'E-' or verion_result[1] == 'e-'):

			V12_E_ = V12_E_ + 1



####################################################################################################

	print('  VE作业数量:  ' + str(VE_count), end = '|')

	print('A:' + '(' + str(VE_A) + ')', end = '|')

	print('A-:' + '(' + str(VE_A_) + ')', end = '|')

	print('B+:' + '(' + str(VE_B_Plus) + ')', end = '|')

	print('B:' + '(' + str(VE_B) + ')', end = '|')

	print('B-:' + '(' + str(VE_B_) + ')', end = '|')

	print('C+:' + '(' + str(VE_C_Plus) + ')', end = '|')

	print('C:' + '(' + str(VE_C) + ')', end = '|')

	print('C-:' + '(' + str(VE_C_) + ')', end = '|')

	print('D+:' + '(' + str(VE_D_Plus) + ')', end = '|')

	print('D:' + '(' + str(VE_D) + ')')

#	print('D-:' + '(' + str(VE_D_) + ')', end = '|')

#	print('E+:' + '(' + str(VE_E_Plus) + ')', end = '|')

#	print('E:' + '(' + str(VE_E) + ')', end = '|')

#	print('E-:' + '(' + str(VE_E_) + ')')

####################################################################################################

	print('  VF作业数量:  ' + str(VF_count), end = '|')

	print('A:' + '(' + str(VF_A) + ')', end = '|')

	print('A-:' + '(' + str(VF_A_) + ')', end = '|')

	print('B+:' + '(' + str(VF_B_Plus) + ')', end = '|')

	print('B:' + '(' + str(VF_B) + ')', end = '|')

	print('B-:' + '(' + str(VF_B_) + ')', end = '|')

	print('C+:' + '(' + str(VF_C_Plus) + ')', end = '|')

	print('C:' + '(' + str(VF_C) + ')', end = '|')

	print('C-:' + '(' + str(VF_C_) + ')', end = '|')

	print('D+:' + '(' + str(VF_D_Plus) + ')', end = '|')

	print('D:' + '(' + str(VF_D) + ')')

#	print('D-:' + '(' + str(VF_D_) + ')', end = '|')

#	print('E+:' + '(' + str(VF_E_Plus) + ')', end = '|')

#	print('E:' + '(' + str(VF_E) + ')', end = '|')

#	print('E-:' + '(' + str(VF_E_) + ')')

####################################################################################################

	print('  V10作业数量: ' + str(V10_count), end = '|')

	print('A:' + '(' + str(V10_A) + ')', end = '|')

	print('A-:' + '(' + str(V10_A_) + ')', end = '|')

	print('B+:' + '(' + str(V10_B_Plus) + ')', end = '|')

	print('B:' + '(' + str(V10_B) + ')', end = '|')

	print('B-:' + '(' + str(V10_B_) + ')', end = '|')

	print('C+:' + '(' + str(V10_C_Plus) + ')', end = '|')

	print('C:' + '(' + str(V10_C) + ')', end = '|')

	print('C-:' + '(' + str(V10_C_) + ')', end = '|')

	print('D+:' + '(' + str(V10_D_Plus) + ')', end = '|')

	print('D:' + '(' + str(V10_D) + ')')

#	print('D-:' + '(' + str(V10_D_) + ')', end = '|')

#	print('E+:' + '(' + str(V10_E_Plus) + ')', end = '|')

#	print('E:' + '(' + str(V10_E) + ')', end = '|')

#	print('E-:' + '(' + str(V10_E_) + ')')

####################################################################################################

	print('  V11作业数量: ' + str(V11_count), end = '|')

	print('A:' + '(' + str(V11_A) + ')', end = '|')

	print('A-:' + '(' + str(V11_A_) + ')', end = '|')

	print('B+:' + '(' + str(V11_B_Plus) + ')', end = '|')

	print('B:' + '(' + str(V11_B) + ')', end = '|')

	print('B-:' + '(' + str(V11_B_) + ')', end = '|')

	print('C+:' + '(' + str(V11_C_Plus) + ')', end = '|')

	print('C:' + '(' + str(V11_C) + ')', end = '|')

	print('C-:' + '(' + str(V11_C_) + ')', end = '|')

	print('D+:' + '(' + str(V11_D_Plus) + ')', end = '|')

	print('D:' + '(' + str(V11_D) + ')')

#	print('D-:' + '(' + str(V11_D_) + ')', end = '|')

#	print('E+:' + '(' + str(V11_E_Plus) + ')', end = '|')

#	print('E:' + '(' + str(V11_E) + ')', end = '|')

#	print('E-:' + '(' + str(V11_E_) + ')')

####################################################################################################

	print('  V12作业数量: ' + str(V12_count), end = '|')

	print('A:' + '(' + str(V12_A) + ')', end = '|')

	print('A-:' + '(' + str(V12_A_) + ')', end = '|')

	print('B+:' + '(' + str(V12_B_Plus) + ')', end = '|')

	print('B:' + '(' + str(V12_B) + ')', end = '|')

	print('B-:' + '(' + str(V12_B_) + ')', end = '|')

	print('C+:' + '(' + str(V12_C_Plus) + ')', end = '|')

	print('C:' + '(' + str(V12_C) + ')', end = '|')

	print('C-:' + '(' + str(V12_C_) + ')', end = '|')

	print('D+:' + '(' + str(V12_D_Plus) + ')', end = '|')

	print('D:' + '(' + str(V12_D) + ')')

#	print('D-:' + '(' + str(V12_D_) + ')', end = '|')

#	print('E+:' + '(' + str(V12_E_Plus) + ')', end = '|')

#	print('E:' + '(' + str(V12_E) + ')', end = '|')

#	print('E-:' + '(' + str(V12_E_) + ')')

####################################################################################################

	print('-' * 84)

	print('  作业总数量:  ' + str(your_labwork_count), end = '|')

	print('A:' + '(' + str(VE_A + VF_A + V10_A + V11_A + V12_A) + ')', end = '|')

	print('A-:' + '(' + str(VE_A_ + VF_A_ + V10_A_ + V11_A_ + V12_A_) + ')', end = '|')

	print('B+:' + '(' + str(VE_B_Plus + VF_B_Plus + V10_B_Plus + V11_B_Plus + V12_B_Plus) + ')', end = '|')

	print('B:' + '(' + str(VE_B + VF_B + V10_B + V11_B + V12_B) + ')', end = '|')

	print('B-:' + '(' + str(VE_B_ + VF_B_ + V10_B_ + V11_B_ + V12_B_) + ')', end = '|')

	print('C+:' + '(' + str(VE_C_Plus + VF_C_Plus + V10_C_Plus + V11_C_Plus + V12_C_Plus) + ')', end = '|')

	print('C:' + '(' + str(VE_C + VF_C + V10_C + V11_C + V12_C) + ')', end = '|')

	print('C-:' + '(' + str(VE_C_ + VF_C_ + V10_C_ + V11_C_ + V12_C_) + ')', end = '|')

	print('D+:' + '(' + str(VE_D_Plus + VF_D_Plus + V10_D_Plus + V11_D_Plus + V12_D_Plus) + ')', end = '|')

	print('D:' + '(' + str(VE_D + VF_D + V10_D + V11_D + V12_D) + ')')

#	print('D-:' + '(' + str(V12_D_) + ')', end = '|')

#	print('E+:' + '(' + str(V12_E_Plus) + ')', end = '|')

#	print('E:' + '(' + str(V12_E) + ')', end = '|')

#	print('E-:' + '(' + str(V12_E_) + ')')

	print('教主的建议:交作业的数量至少超过25份，如果低于这个数量，你就应该更加努力的敲版本！')

####################################################################################################

	print('-' * 84)



	cursor.execute("select date,hour from seclab where name = '%s' order by date" % yourname)

	your_time_result = cursor.fetchall()

	dates = []

	hours = []

	for dates_and_hours in your_time_result:

		dates.append(dates_and_hours[0])

		hours.append(dates_and_hours[1])

#	print(dates)

#	print(hours)



#	for dates_and_hours in your_time_result:

#		date = str(dates_and_hours[0]).split('-')

#		inttime = int(date[0])*1000000 + int(date[1])*10000 + int(date[2])*100 + dates_and_hours[1] 

#	times.append(str(inttime))

#	times.sort()

#	print("您第一次上交作业的时间是: " + times[0][0:4] + "年 " + times[0][4:6] + "月 " + times[0][6:8] + "日 " +  times[0][8:10] + "时")

#	print("您最近一次上交作业时间是: " + times[0][0:4] + "年 " + times[0][4:6] + "月 " + times[0][6:8] + "日 " +  times[0][8:10] + "时")



	print("  您第一次上交作业的时间是        : " + str(dates[0]) + ' ' + str(hours[0]))

	print("  您最近一次上交作业时间是        : " + str(dates[-1]) + ' ' + str(hours[-1]))

#	print(type(datetime.date.today()))

#	print(type(dates[0]))

#	print(datetime.date.today() - dates[0])

#	print(str(datetime.date.today() - dates[0]).split(',')[0])

	print("  从第一次上交作业到今天已经过去  : " + str(datetime.date.today() - dates[0]).split(',')[0][:-3] + '天')

	day_to_passed = int(str(datetime.date.today() - dates[0]).split(',')[0][:-3])

	week_to_passwd = day_to_passed / 7

	week_lab_work = str(int(your_labwork_count / week_to_passwd))

	print("  您平均一个星期上交作业数为      : " + week_lab_work + " 份")

	print('教主的建议:每一个星期平均至少交5分作业')

	searchvalues = "r1,r2,r3,r4,r5,r6,asa1,asa1sys,asa1admin,asa1c1,asa1c2,asa2,asa2sys,asa2admin,asa2c1,asa2c2,asa3,asa3sys,asa3admin,asa3c1,asa3c2,asa4,asa4sys,asa4admin,asa4c1,asa4c2,sw1,sw2,sw3,sw4,sw5,sw6,ips"

	defaultcountlist = []

	searchlist = searchvalues.split(',')



#	print(searchlist)

#	print(len(defaultcountlist))

###############处理VE#####################

	print('='*29 + "每版本配置错误所在设备统计" + '='*29)

	print('教主的建议:可以通过这个部分看看你容易犯错的设备！！！')

	defaultcountlist = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]

#	print(defaultcountlist)

	print('VE设备错误数:')

	cursor.execute("select %s from seclab where name = '%s' and verno = 've'" % (searchvalues,yourname))

	yourresults = cursor.fetchall()

	for error_configs in yourresults:

		location = 0

		for error_config in error_configs:

			if error_config != None:

				defaultcountlist[location] = defaultcountlist[location] + 1

			location = location + 1

	

	count_location = 0

	for i in defaultcountlist:

		if i != 0:

			print("|" + searchlist[count_location]+":(" + str(i) +")", end = '')

		count_location = count_location + 1

	print()

###############处理VF#####################

	defaultcountlist = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]



	print('VF设备错误数:')

	cursor.execute("select %s from seclab where name = '%s' and verno = 'vf'" % (searchvalues,yourname))

	yourresults = cursor.fetchall()

	for error_configs in yourresults:

		location = 0

		for error_config in error_configs:

			if error_config != None:

				defaultcountlist[location] = defaultcountlist[location] + 1

			location = location + 1

	

	count_location = 0

	for i in defaultcountlist:

		if i != 0:

			print("|" + searchlist[count_location]+":(" + str(i) +")", end = '')

		count_location = count_location + 1

	print()

###############处理V10#####################

	defaultcountlist = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]



	print('V10设备错误数:')

	cursor.execute("select %s from seclab where name = '%s' and verno = 'v10'" % (searchvalues,yourname))

	yourresults = cursor.fetchall()

	for error_configs in yourresults:

		location = 0

		for error_config in error_configs:

			if error_config != None:

				defaultcountlist[location] = defaultcountlist[location] + 1

			location = location + 1

	

	count_location = 0

	for i in defaultcountlist:

		if i != 0:

			print("|" + searchlist[count_location]+":(" + str(i) +")", end = '')

		count_location = count_location + 1

	print()

###############处理V11#####################

	defaultcountlist = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]



	print('V11设备错误数:')

	cursor.execute("select %s from seclab where name = '%s' and verno = 'v11'" % (searchvalues,yourname))

	yourresults = cursor.fetchall()

	for error_configs in yourresults:

		location = 0

		for error_config in error_configs:

			if error_config != None:

				defaultcountlist[location] = defaultcountlist[location] + 1

			location = location + 1

	

	count_location = 0

	for i in defaultcountlist:

		if i != 0:

			print("|" + searchlist[count_location]+":(" + str(i) +")", end = '')

		count_location = count_location + 1

	print()

###############处理V12#####################

	defaultcountlist = [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0]



	print('V12设备错误数:')

	cursor.execute("select %s from seclab where name = '%s' and verno = 'v12'" % (searchvalues,yourname))

	yourresults = cursor.fetchall()

	for error_configs in yourresults:

		location = 0

		for error_config in error_configs:

			if error_config != None:

				defaultcountlist[location] = defaultcountlist[location] + 1

			location = location + 1

	

	count_location = 0

	for i in defaultcountlist:

		if i != 0:

			print("|" + searchlist[count_location]+":(" + str(i) +")", end = '')

		count_location = count_location + 1

	print()

	print('QYTANG' + 'Pass'*18 + 'QYTANG')







if __name__ == '__main__':

	yourname = input('请输入你中文姓名（非英文用户名）: ')

	selfresults(yourname)
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Python
1
https://gitee.com/iti0/qytang_Python.git
git@gitee.com:iti0/qytang_Python.git
iti0
qytang_Python
qytang_Python
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部