Tags Default Sort By Last Modified

carolynzhang18 commented 11 months ago

Notion task link

Added a column 'last_modified' to the tags table to automatically record timestamps for create/update operations
Modified GET route to return tags in order from most to least recently modified

Upgrade database to latest migration: bash ./scripts/flask-db-upgrade.sh
In order to test these routes with Postman, first comment out @require_authorization_by_role({"Admin"}) on lines 10, 24, 47, and 71 of backend/app/rest/tags_routes.py.
Create a few tags by POSTing to /tags/ (e.g. {"name": “Cool Tag”, "status": "Active”}).
Try GETting from /tags/. The tags you added should be returned in reverse chronological order.
Update a tag by PUTting to /tags/[id] (e.g. {"name": “Edited Tag”, "status": "Active”}).
Try GETting from /tags/. The tag you just updated should be the first one returned (and the rest of the tags should also be returned in reverse chronological order).
Create & update a few more tags, and check that GETting them still results in the expected order.

[x] My PR name is descriptive and in imperative tense
[x] My commit messages are descriptive and in imperative tense. My commits are atomic and trivial commits are squashed or fixup'd into non-trivial commits
[x] I have run the appropriate linter(s)
[ ] I have requested a review from the PL, as well as other devs who have background knowledge on this PR or who will be building on top of this PR
[ ] If I have made API changes, I have updated the REST API Docs
[ ] IF I have made changes to the db/models, I have updated the Data Models Page
[ ] I have documented this PR in the Production Release Page
[ ] I have updated other Docs as needed

github-actions[bot] commented 11 months ago

Visit the preview URL for this PR (updated for commit 25c3243):

_{(expires Thu, 30 Nov 2023 01:13:56 GMT)}

_{Sign: f6bcdba7452bf82a6ec1a299c37d1bdff7870d09}

achandrabalan commented 11 months ago

LGTM 🥇 Creating / Updating tags rearranges as expected.