def restores_user_model(user_id):
rel = 'userAdmin.user_trash'
conn = ToConn()
to_exec = conn.to_execute()
result = to_exec.cursor().execute('update users set is_delete=0 where id=%s', (user_id,))
if result:
to_exec.commit()
else:
to_exec.rollback()
rel = 'userAdmin.user_trash'
conn.to_close()
return rel
def freezing_user_model(id):
rel = True
conn = ToConn()
to_exec = conn.to_execute()
cur = to_exec.cursor()
result = cur.execute('update users set is_freezing=1 where id=%s', (id,))
if result:
to_exec.commit()
else:
rel = False
to_exec.rollback()
conn.to_close()
return rel
def delete_user_trach(id):
rel = True
conn = ToConn()
to_exec = conn.to_execute()
cur = to_exec.cursor()
result = cur.execute('delete from users where id=%s', (id,))
if result:
to_exec.commit()
else:
rel = False
to_exec.rollback()
conn.to_close()
return rel
def reset_user_pad(id):
rel = {'result': False}
conn = ToConn()
to_exec = conn.to_execute()
cur = to_exec.cursor()
pwd = get_pwd()
result = cur.execute('update users set password=%s where id=%s', (generate_password_hash(pwd), id))
if result:
rel = {'result': True, 'password': pwd}
to_exec.commit()
else:
to_exec.rollback()
conn.to_close()
return rel
def get_users_total(page, page_size, is_delete=0):
users = ToConn().get_db('select * from users where is_delete=%s limit %s,%s',
(is_delete, (page - 1) * page_size, page_size)).fetchall()
total = ToConn().get_db('select count(*) from users where is_delete=%s', (is_delete,)).fetchone().get('count(*)')
return users, total
def search_users(word):
sql = 'select * from users where position(%s in name) or position(%s in tel) or position(%s in email)'
users = ToConn().get_db(sql, (word, word, word))
return users