blob: fbbce0e468f0992c084b3b8553c0f2027a424f33 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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
|
