From bce756b9aa51dfdfa2c2e6cdef4f88f660b80148 Mon Sep 17 00:00:00 2001 From: Parker Date: Mon, 26 Feb 2024 20:55:05 -0600 Subject: Overhaul: Flask -> FastAPI --- app/func/link_records.py | 24 ------------------------ 1 file changed, 24 deletions(-) delete mode 100644 app/func/link_records.py (limited to 'app/func/link_records.py') diff --git a/app/func/link_records.py b/app/func/link_records.py deleted file mode 100644 index a29f8dd..0000000 --- a/app/func/link_records.py +++ /dev/null @@ -1,24 +0,0 @@ -import sqlalchemy -import tabulate - -from db import engine - -""" -Retrieve all records associated with a specific link -""" -def 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: - records = conn.execute(sqlalchemy.text('SELECT timestamp, ip, location, browser, os, user_agent, isp FROM records WHERE owner = :owner and link = :link'), [{'owner': owner, 'link': link}]).fetchall() - if not records: - return 'No records are associated with this link', 200 - else: - return 'You are not the owner of this link', 401 - - return tabulate.tabulate(records, headers=['Timestamp', 'IP', 'Location', 'Browser', 'OS', 'User Agent', 'ISP']), 200 \ No newline at end of file -- cgit v1.2.3-70-g09d2