python - AttributeError：模块“模型”没有属性“check_pw”

Question

import sqlite3 

def show_color(username):
    connection = sqlite3.connect('flask_tut.db', check_same_thread=False)
    cursor = connection.cursor()
    cursor.execute("""SELECT favorite_color FROM users WHERE username='{username}' ORDER BY pk DESC;""".format(username = username))
    color = cursor.fetchone()[0]
    
    connection.commit()
    cursor.close()
    connection.close()
    message = '{username}\'s favorite color is {color}.'.format(username=username, color=color)
    return message
    
    def check_pw(username):
        connection = sqlite3.connect('flask_tut.db', check_same_thread = False)
        cursor = connection.cursor()
        cursor.execute(""" SELECT password FROM users WHERE username='{username}' ORDER BY pk DESC;""".format(username = username))
        password = cursor.fetchone()[0]
    
        connection.commit()
        cursor.close()
        connection.close()
        return password

标签： pythonflask