From 7086fbce95442659b390326b96ce89e62d1f72d8 Mon Sep 17 00:00:00 2001 From: Parker Date: Sun, 25 Feb 2024 22:13:37 -0600 Subject: Delete records for specific link --- app/func/del_link_records.py | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 app/func/del_link_records.py (limited to 'app/func') diff --git a/app/func/del_link_records.py b/app/func/del_link_records.py new file mode 100644 index 0000000..fbbce0e --- /dev/null +++ b/app/func/del_link_records.py @@ -0,0 +1,20 @@ +import sqlalchemy + +from db import engine + +""" +Delete all of the IP log records that are associated with a specific link +""" +def del_link_records(link, owner): + with engine.begin() as conn: + try: + link_owner = conn.execute(sqlalchemy.text('SELECT owner FROM links WHERE link = :link'), [{'link': link}]).fetchone()[0] + except TypeError: + return 'Link does not exist', 200 + + if owner == link_owner: + with engine.begin() as conn: + conn.execute(sqlalchemy.text('DELETE FROM records WHERE link = :link'), [{'link': link}]) + return 'Link records have been deleted', 200 + else: + return 'You are not the owner of this link', 401 \ No newline at end of file -- cgit v1.2.3-70-g09d2