def update(name, lastname, phone, email, password, id):
cursor = mysql.get_db().cursor()
#cursor = mysql.cursor()
cursor.execute(
'update register set name = %s,lastname = %s,phone = %s,email = %s,password = %s WHERE id = %s',
(
name,
lastname,
phone,
email,
password,
id,
))
mysql.get_db().commit()
cursor.close()
def auth_user(self, email):
cursor = mysql.get_db().cursor()
cursor.execute(
"SELECT email,password,user,id FROM users WHERE email=%s", (email))
data = cursor.fetchone()
cursor.close()
return data
def listUrlsUser(self, id):
cursor = mysql.get_db().cursor()
cursor.execute("""SELECT url_shorten, url_to_shorten
FROM urls_sht WHERE user_id = %s""", (id,))
data = cursor.fetchall()
cursor.close()
return data
def listUrls(self):
cursor = mysql.get_db().cursor()
cursor.execute(
'SELECT url_shorten, url_to_shorten FROM urls_sht')
data = cursor.fetchall()
cursor.close()
return data
def redirect_url(self, url_shortened):
cursor = mysql.get_db().cursor()
cursor.execute(
'SELECT url_to_shorten FROM urls_sht WHERE url_shorten = %s', (url_shortened,))
data = cursor.fetchone()
cursor.close()
return data[0]
def update(name, lastname, phone, email, password, id):
cursor = mysql.get_db().cursor()
#cursor = mysql.cursor()
cursor.execute(
'update register set name = ?,lastname = ?,phone = ?,email = ?,password = ? WHERE id = ?',
(
name,
lastname,
phone,
email,
password,
id,
))
mysql.get_db().commit()
cursor.close()
print(data)
def create(self, user: UserDTO):
cursor = mysql.get_db().cursor()
#cursor = mysql.cursor()
cursor.execute(
"""insert into user
(name,lastname,phone,email,password)
values (%s,%s,%s,%s,%s)""", (
user.name,
user.lastname,
user.phone,
user.email,
user.password,
))
mysql.get_db().commit()
cursor.close()
def lists(self):
cursor = mysql.get_db().cursor()
#cursor = mysql.get_db().cursor()
cursor.execute('select * from user')
data = cursor.fetchall()
cursor.close()
print(data)
return data
def create(self, name, lastname, phone, email, password):
cursor = mysql.get_db().cursor()
#cursor = mysql.cursor()
cursor.execute(
'insert into user (name,lastname,phone,email,password) values (% s,% s,% s,% s,% s)',
(name, lastname, phone, email, password))
flash('User added successfully!')
cursor.close()
def lists(self):
cursor = mysql.get_db().cursor()
#cursor = mysql.get_db().cursor()
cursor.execute('select * from user')
fields_name = [field[0] for field in cursor.description]
data = cursor.fetchall()
response = []
for index, d in enumerate(data):
response.append({})
for index_field, field in enumerate(fields_name):
response[index][fields_name[index_field]] = d[index_field]
cursor.close()
print(data)
return response
def generate_short_link(self, url_to_shorten, url_shortened, user_id):
cursor = mysql.get_db().cursor()
cursor.execute('insert into urls_sht (url_shorten,url_to_shorten, user_id) values (%s,%s,%s)',
(url_shortened, url_to_shorten,user_id))
mysql.get_db().commit()
cursor.close()
def create_user(self, user, email, password):
cursor = mysql.get_db().cursor()
cursor.execute('insert into users (user,email,password) values (%s,%s,%s)',
(user,email,password))
mysql.get_db().commit()
cursor.close()
def deleteUrl(self, url_shorten):
cursor = mysql.get_db().cursor()
cursor.execute("DELETE FROM urls_sht WHERE url_shorten = %s", (url_shorten,))
mysql.get_db().commit()
cursor.close()
def delete(id):
cursor = mysql.get_db().cursor()
#cursor = mysql.cursor()
cursor.execute('delete from register where id = ?', (id))
cursor.close()
