TaskCLI is a terminal-based task listing application where user can create their own tasks with its corresponding deadlines and description. They are also given the option to assign such to a category of their own liking. User can create, edit, delete, and view all tasks and categories. User can also mark task as done, and add it to a category. By default, task upon creation are not assigned to a category.
To install the required packages, run the following command in your terminal:
- Python:
sudo apt install python3 - Server:
sudo apt-get install -y mssql-server - Connector:
pip install mysql-connector-python
- Open
main.py - Inside the maria_db connection, change the password to the password of your root. The application shall access the taskrecordmanager user as a root.
mariadb_connection = mariadb.connect(
host="localhost",
user="root",
password="<insert_your_pass_here>")
- You are set to run the Python Program. Use
py main.pyto run.
- Add, Edit Task. the format of year, date, month must be yyyy, mm, dd, respectively. Prompts for month and day shall be displayed accordingly if not followed.
- Edit Task. Only the deadline will be editable. Other attributes such as name and description will no longer be subject to change.
- Agsao, Coleen Therese
- Dollesin, Samantha Shane
- Malahito, John Edver
This is the final project for CMSC 127 (Database) in UPLB.