diff options
| author | Parker <contact@pkrm.dev> | 2024-02-25 17:46:34 -0600 |
|---|---|---|
| committer | Parker <contact@pkrm.dev> | 2024-02-25 17:46:34 -0600 |
| commit | fdc9939f57a21d2aa3dfd8a49339becc484ed491 (patch) | |
| tree | fa1500281ddaec15999d03e5483f1f9d4d60049b /app/func/newlink.py | |
| parent | fd90921c108a9d184c4f819dbaba85e8b4d34a05 (diff) | |
Save expire_date as datetime rather than string
Diffstat (limited to 'app/func/newlink.py')
| -rw-r--r-- | app/func/newlink.py | 4 |
1 files changed, 3 insertions, 1 deletions
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: |