1 Star 0 Fork 46

17010/qytang_Python

forked from cutecuteyu/qytang_Python 
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
2016.02.21 学员信息查询系统 22.58 KB
一键复制 编辑 原始数据 按行查看 历史
现任明教教主-乾颐堂 提交于 2016-02-21 14:32 . new file
#!/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/lg_online/qytang_Python.git
git@gitee.com:lg_online/qytang_Python.git
lg_online
qytang_Python
qytang_Python
master

搜索帮助