def getUserById(self, person_id):
cursor = self.connection.cursor()
cursor.execute("SELECT * FROM person WHERE person_id=%s", [person_id])
row = cursor.fetchall()
user = Person()
user.set_fields(row[0][0], row[0][1], row[0][2], row[0][3], row[0][4],
row[0][5])
user.set_password_hash(row[0][6])
return user
def getUserByLogin(self, login):
cursor = self.connection.cursor()
print(login)
cursor.execute("SELECT * FROM person WHERE login=%(str)s",
{"str": login})
row = cursor.fetchall()
if len(row) == 0:
return None
user = Person()
user.set_fields(row[0][0], row[0][1], row[0][2], row[0][3], row[0][4],
row[0][5])
user.set_password_hash(row[0][6])
print(user.name + " " + user.login + " " + user.password_hash)
return user