When listing the applications using the ls command, colour each job application printed on the basis of its status.

For rejected, print it in red.
For applied, print it in orange.
For Offer, print it in green.
For any other status, print it in yellow.

At all the places where start_date and end_date variables are used, make sure to add a check to inform the user about it. Though it won't affect the results, it will be a better user experience.

Describe the bug
The string values for the Status column are case-sensitive.

Expected behaviour
The string values for the status column should be case-insensitive.

Publish the app to PyPI and make sure that the app functionality is not broken.

Reference: https://typer.tiangolo.com/tutorial/package/

Please describe your feature request in as detail as possible.
Improve Doc strings for all the functions in all the files for better documentation.

• track/app_constants.py
• track/aoo_functions.py
• track/database.py
• track/db_functions.py
• track/job_application.py
• track/main.py
• track/metrics.py

This is an umbrella issue to discuss and gather the relevant metrics to be reported on the job applications.

• Total no of applications
• Total no of applications in a given date range
• Total applications rejected
• Total applications rejected in a given date range
• Ratio of (jobs applied/jobs rejected) [Note: Rejection can happen after shortlisting as well]
• Ratio of (jobs applied/job shortlisted)

Describe the bug
The updated_at field is supposedly not updated in all the update commands

To Reproduce
Steps to reproduce the behaviour:

1. run track-job update company <application-id> <new-company name>

Expected behaviour
updated_at field should be updated with the current date

Screenshots
NA

Create a badge for SQLAlchemy using its logo and put it under the Tech Stack section.

Image: https://www.sqlalchemy.org/img/sqla_logo.png

Tools like shields.io or any other relevant tools can be used to create a custom badge (Just like already mentioned in the README)

Steps:

1. Go to https://shields.io/
2. Scroll below to the Your Badge Section.
   
3. Leave the label field empty.
4. Populate the message as SQLAlchemy
5. Use the colour blue.
6. Click on the make badge button.
7. You'll get a URL for the badge.
8. Add it to the README's tech stack section below the already existing Badges there.

• #21
• #22
• #23
• #29
• #30
• #31
• #33 (for now)
• #34
• #35
• #37
• #38
• #42

Please describe your feature request in as detail as possible.
Add a flag in the ls command to view all the shortlisted applications.

Is your feature request related to a problem? Please describe.
No.

If it's related to a problem, what should happen after solving this problem
users can view all the shortlisted applications using the command track-job ls --shortlisted along with other command options.

Suggest the implementation plan for the feature. If any.
Add a typer option and use the get_shortlisted_applications function from db_handler to get the application details. Call this function from the list function in the job_tracker.py file.

Additional context
NA

When an application with the status Offer is added, or the status is updated to Offer, give congratulations prompt to the user along with mentioning the total number of offers.

Add a command -v or --version to print the latest version of the package.

Syntax: track-job --version or track-job -v

Go through https://realpython.com/python-typer-cli/ and find areas of improvement like project structure, test cases etc.

Describe the bug
The docstrings are not formatted properly when calling --help in the command.

To Reproduce
Run any command with the --help flag.

Expected behaviour
The docstrings should be formatted correctly along with all the whitespaces and newlines.

Screenshots

Additional context
NA

Describe the bug
No data validation on the applied_at and the updated_at fields.

Expected behaviour
The date format should be validated to be YYYY-MM-DD, else throw an error

Is your feature request related to a problem? Please describe.
No PR template

Describe the solution you'd like
Add a PR template

Describe alternatives you've considered
NA

Additional context
NA

Please describe your feature request in as detail as possible.
Update the README along with all the other required files following the template from auth0: https://github.com/Aditya-Gupta1/open-source-template

Is your feature request related to a problem? Please describe.
It's not clear for new users to get started with the project.

If it's related to a problem, what should happen after solving this problem
The users should have a clear idea about the project. They should be able to get started quickly and have a good enough starting point to start contributing to the project.

Suggest the implementation plan for the feature. If any.
Take reference from the auth0 template as mentioned above.

Additional context
NA

Please describe your feature request in as detail as possible.
Add test cases in the tests folder preferably using typer's testing functionality.

Is your feature request related to a problem? Please describe.
No

If it's related to a problem, what should happen after solving this problem
No

Suggest the implementation plan for the feature. If any.
I need to gather the required understanding of writing tests using typer and then implementing them.

Additional context
NA

As of now, the rm command is used to delete only 1 application_id. Make a change such that it can be used to delete multiple application_ids together.

Visit https://readme.so/