Create a new table for announcements

[SAUMILDHANKAR]

Overview

This issue is related to issue #2326
We need to add a table in our database for announcement dialog.
We would be using create and update CRUD operations for this table as we want to keep track of all old announcements or delete the old ones

Action Items

• Create a table in your local database.
• Use migration script to add it to the production database.
• Once the PR associated with this issue is merged or this issue is closed, check issue Feature: Announcement bar (for holidays, emergencies, etc.) #2326, if all its sub-issues are marked complete, move that issue to the prioritized backlog column so someone can pick it up and check if that issue is complete or needs more work.

Resources/Instructions

• Similar PR Create tables for featureflag and feature-to-user #1963

[SAUMILDHANKAR]

Thanks @hanapotski @junjun107 for helping me setting up local database.

Progress Update:

1. I installed PostGIS version 15 (I had postgres installed earlier but wasn't able to connect to local database and during pair programming realized that PostGIS was missing).
2. Downloaded and connected to the database using Tableplus.
3. Created a generic table to be used for notifications.
4. Started working on setting up the endpoints.

[SAUMILDHANKAR]

Progress Update:

1. Using PRs Add endpoints for feature table #1978 and 1983 UI for managing feature flags #2033 as reference, I created following files in my local branch to connect the server with a new table in the database:
   • types.ts file in server.
   • service.ts file in server/app/services.
   • router.ts file in server/app/routers.
   • controller.ts file in server/app/controllers.
   • service file in client folder
   • component file
2. I also used the code for the tags table and could not resolve all the errors while making a post request to the newly created table, however thanks to pair programming with @junjun107 and @VirginiaWu11 I was able to fetch the data from the table to the server.
3. To make the get request we did the following steps:
   • Created an data entry in the new table with values in id and name column.
   • In the server/app/routes/index.ts file, imported the router and created a route.
   • Made a get request at http://localhost:5001/api/{routername} and were able to see the contents of the table.
4. Next step for me is to display the values of the table in the front end component and similarly do the post request as well. Also, planning to add jwt to the router file.