def findUserErrors(self, user):
conn = DBManager()
cursor = conn.connection.cursor()
query = 'SELECT WrongWord.id, label FROM User INNER JOIN User_has_WrongWord ON User.id = User_id INNER JOIN WrongWord ON WrongWord_id = WrongWord.id WHERE User.id = %s'
cursor.execute(query, (user['id']))
errors = cursor.fetchall()
user['wrongWords'] = errors
return user
def findUserByEmail(self, email):
exist = False
conn = DBManager()
cursor = conn.connection.cursor()
query = 'SELECT email FROM User WHERE email = %s'
cursor.execute(query, (email, ))
userByEmail = cursor.fetchone()
if userByEmail:
exist = True
return exist
def saveWrongWordOfUser(self, userId, wWordId):
rel = False
conn = DBManager()
cursor = conn.connection.cursor()
query = 'INSERT INTO User_has_WrongWord VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE quantity = quantity + 1'
response = cursor.execute(query, (userId, wWordId, 1))
print(response)
if response:
conn.connection.commit()
rel = True
return rel
def delete(self, _id):
deleted = False
if _id:
conn = DBManager()
cursor = conn.connection.cursor()
query = 'DELETE FROM User WHERE id = %s'
response = cursor.execute(query, (_id, ))
if response:
conn.connection.commit()
deleted = True
return deleted
def update(self, wrongWord):
if wrongWord and wrongWord.isValid():
conn = DBManager()
cursor = conn.connection.cursor()
query = 'UPDATE WrongWord SET label = %s, quantity = %s WHERE id = %s'
response = cursor.execute(
query, (wrongWord.label, wrongWord.quantity, wrongWord.id,))
print(response)
if response:
conn.connection.commit()
return wrongWord
return None
def readAll(self):
conn = DBManager()
cursor = conn.connection.cursor()
query = 'SELECT id, name, lastName, email, age FROM User'
cursor.execute(query)
users = cursor.fetchall()
if users:
return [
User(user['id'], user['name'], user['lastName'], user['email'],
user['age'], None).json() for user in users
]
return []
def create(self, wrongWord):
if wrongWord.isValid():
conn = DBManager()
cursor = conn.connection.cursor()
query = 'INSERT INTO WrongWord VALUES (%s, %s, %s) ON DUPLICATE KEY UPDATE quantity = quantity + 1'
response = cursor.execute(
query, (None, wrongWord.label, wrongWord.quantity))
if response:
wrongWord.id = conn.connection.insert_id()
conn.connection.commit()
return wrongWord
return None
def read(self, _id):
wWord = None
if _id:
conn = DBManager()
cursor = conn.connection.cursor()
query = 'SELECT id, label, quantity FROM WrongWord WHERE id = %s'
cursor.execute(query, (_id,))
firstWrongWord = cursor.fetchone()
if firstWrongWord:
wWord = WrongWord(
firstWrongWord['id'], firstWrongWord['label'], firstWrongWord['quantity'], None)
return wWord
def read(self, _id):
user = None
if _id:
conn = DBManager()
cursor = conn.connection.cursor()
query = 'SELECT id, name, lastName, email, age FROM User WHERE id = %s'
cursor.execute(query, (_id, ))
firstUser = cursor.fetchone()
if firstUser:
user = User(firstUser['id'], firstUser['name'],
firstUser['lastName'], firstUser['email'],
firstUser['age'], None)
return user
def readAll(self):
conn = DBManager()
cursor = conn.connection.cursor()
query = 'SELECT id, label, quantity FROM WrongWord'
cursor.execute(query)
WrongWords = cursor.fetchall()
if WrongWords:
return [
WrongWord(wrongWord['id'],wrongWord['label'],
wrongWord['quantity'], None).json()
for wrongWord in WrongWords
]
return []
def create(self, user):
if user.isValid():
conn = DBManager()
cursor = conn.connection.cursor()
query = 'INSERT INTO User VALUES (%s, %s, %s, %s, %s)'
response = cursor.execute(
query,
(None, user.firstName, user.lastName, user.age, user.email))
if response:
user.id = conn.connection.insert_id()
conn.connection.commit()
return user
return None
def update(self, user):
if user and user.isValid():
conn = DBManager()
cursor = conn.connection.cursor()
query = 'UPDATE User SET name = %s, lastName = %s, age= %s, email = %s WHERE id = %s'
response = cursor.execute(query, (
user.firstName,
user.lastName,
user.age,
user.email,
user.id,
))
if response:
conn.connection.commit()
return user
return None