From fdc9939f57a21d2aa3dfd8a49339becc484ed491 Mon Sep 17 00:00:00 2001 From: Parker Date: Sun, 25 Feb 2024 17:46:34 -0600 Subject: Save expire_date as datetime rather than string --- app/func/renew_link.py | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'app/func/renew_link.py') diff --git a/app/func/renew_link.py b/app/func/renew_link.py index f0fc166..bbb3de2 100644 --- a/app/func/renew_link.py +++ b/app/func/renew_link.py @@ -16,7 +16,9 @@ def renew_link(link, owner): if owner == link_owner: with engine.begin() as conn: - conn.execute(sqlalchemy.text('UPDATE links SET expire_date = :expire_date WHERE link = :link'), [{'expire_date': (datetime.datetime.now() + datetime.timedelta(days=7)).strftime('%d/%m/%Y'), 'link': link}]) - return f'Link renewed, now expires on {(datetime.datetime.now() + datetime.timedelta(days=7)).strftime("%d/%m/%Y")}', 200 + expire_date = (datetime.datetime.now() + datetime.timedelta(days=7)).strftime('%d/%m/%Y') + expire_date = datetime.datetime.strptime(expire_date, '%d/%m/%Y') + conn.execute(sqlalchemy.text('UPDATE links SET expire_date = :expire_date WHERE link = :link'), [{'expire_date': expire_date, 'link': link}]) + return f'Link renewed, now expires on {expire_date}', 200 else: return 'You are not the owner of this link', 401 \ No newline at end of file -- cgit v1.2.3-70-g09d2