一个人脸识别打卡程序,前天运行的时候还好好的,之后也没动程序,今天重新打开pycharm运行后弹出错误,用的还是之前的环境。错误提示如下:
File "G:\yuangongqiandao\faceDetectOntime_2\faceDetectOntime_2\databases.py", line 168, in updateCountTable
self.sql = """UPDATE Count_tbl SET Count_Date='{}',Count='{}' WHERE User_name={};""".format(self.date_time,2,self.i[1])
AttributeError: 'database_connect' object has no attribute 'i'
错误部分的代码如下:
def updateCountTable(self):
"""
build User TABLE
:return:
"""
now = datetime.now()
self.date_time = now.strftime("%Y-%m-%d %H:%M:%S")
now_date = datetime.strptime(self.date_time, '%Y-%m-%d %H:%M:%S')
month_1 = now_date.strftime('%m')
self.sql = "select * from Count_tbl"
self.cursor.execute(self.sql)
self.results = self.cursor.fetchall()
for i in range(len(self.results)):
now_date = datetime.strptime(self.results[i][3], '%Y-%m-%d %H:%M:%S')
month_2 = now_date.strftime('%m')
if month_2 == month_1:
pass
else:
self.sql = """UPDATE Count_tbl SET Count_Date='{}',Count='{}' WHERE User_name={};""".format(self.date_time,2,self.i[1])
self.cursor.execute(self.sql)
self.connectmydb.commit()
尝试在代码块里添加 self.i=0,运行后弹出错误提示
TypeError: 'int' object is not subscriptable。