Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add an optional expiration date column for urls #33

Open
5 tasks
evanugarte opened this issue Jun 14, 2024 · 0 comments · May be fixed by #36
Open
5 tasks

Add an optional expiration date column for urls #33

evanugarte opened this issue Jun 14, 2024 · 0 comments · May be fixed by #36

Comments

@evanugarte
Copy link
Contributor

evanugarte commented Jun 14, 2024

users should be able to specify an expiration for a url. this expiration would exist as a new column in the sqlite database.

if a url was requested and it had a non-null expiration value, and the url is expired, it is deleted from the database and the api returns a 404.

game plan

  • clone cleezy and run it on your computer
  • understand how to create a table in sqlite with a simple query
  • understand how to add a column to an existing table in sqlite with a query
  • change create_url to accept a new parameter expiration_date that is an epoch timestamp (like 1718479172174)
  • have create_url store this timestamp in the new column for the url table
@drew-tom1 drew-tom1 linked a pull request Jun 21, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant