import pypyodbc
class MagSQL ():
mybd = 'test'
fuckname = ''
connection = pypyodbc.connect('Driver={SQL Server};'
'Server=DESKTOP-LSIALCG\SQLEXPRESS;'
'Database=' + mybd + ';')
cursor = connection.cursor()
mySQLQuery = ("SELECT First, Name, password FROM dbo.Test01")
cursor.execute(mySQLQuery)
fuckname = cursor.fetchall()
cursor.close()
for row in fuckname:
first = row[0]
name = row[1]
passwordbd = row[2]
print(passwordbd)
def check_password(pask):
for row in fuckname:
if str(row[2]) == pask:
print('yes')
print(fuckname)
check_password('1234')
print(fuckname)
Что я получаю --------------------------------------------
1234
3333
2222
[('алекссев', 'вова', 1234), ('Лемешкин', 'андрей', 3333), ('Вигаев', 'данил', 2222)]
Traceback (most recent call last):
File "C:/Users/Keeplod/PycharmProjects/testbd2/venv/connectSQL.py", line 3, in <module>
class MagSQL ():
File "C:/Users/Keeplod/PycharmProjects/testbd2/venv/connectSQL.py", line 30, in MagSQL
check_password('1234')
File "C:/Users/Keeplod/PycharmProjects/testbd2/venv/connectSQL.py", line 25, in check_password
for row in fuckname:
NameError: name 'fuckname' is not defined
Process finished with exit code 1
美好的一天,你能告诉我为什么调用 check_password('1234') 方法我得到一些奇怪的错误而不是“是”
