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/newlink.py | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'app/func/newlink.py') diff --git a/app/func/newlink.py b/app/func/newlink.py index 6fa1340..9cc220f 100644 --- a/app/func/newlink.py +++ b/app/func/newlink.py @@ -29,7 +29,9 @@ def generate_link(request, owner): while True: try: link = ''.join(random.choices(choices, k=5)) - conn.execute(sqlalchemy.text('INSERT INTO links(owner, link, redirect_link, expire_date) VALUES (:owner, :link, :redirect_link, :expire_date)'), [{'owner': owner, 'link': link, 'redirect_link': redirect_link, 'expire_date': (datetime.datetime.now() + datetime.timedelta(days=7)).strftime('%d/%m/%Y')}]) + 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('INSERT INTO links(owner, link, redirect_link, expire_date) VALUES (:owner, :link, :redirect_link, :expire_date)'), [{'owner': owner, 'link': link, 'redirect_link': redirect_link, 'expire_date': expire_date}]) conn.commit() break except exc.IntegrityError: -- cgit v1.2.3-70-g09d2