def logon():
login = request.args.get('login')
password = request.args.get('password')
query = 'SELECT * FROM Users' \
'WHERE Login=(%s) AND Password=(%s)'
user = db.query_db(query, login, password)
def check_full_url_address_in_database_user(full_url_address, user):
"""
:param full_url_address: str
:return: True/False
"""
query_str = f'''SELECT URL_full FROM URL
WHERE URL_full = '{full_url_address}' AND Users_Id = {user};
'''
query = db.query_db(query_str)
if query:
return True
else:
return False
def check_short_url_address_in_database_user(short_url_address, user):
"""
:param short_url_address: str
:return: True/False
"""
query_str = f'''SELECT URL_short FROM URL
WHERE URL_short = '{short_url_address}' AND Users_Id = {user};
'''
query = db.query_db(query_str)
if query:
for string in query:
for line in string:
return line
else:
return False
def send_users():
query = '''SELECT Login FROM Users;
'''
res = db.query_db(query)
return jsonify(users=res)