Welcome to Sprintr, an innovative agile project management tool designed to streamline the workflow of tech teams. At the heart of Sprintr lies a unique feature: an intelligent auto-assignment system that dynamically matches tasks with team members based on their skills, focus areas, and current workload. This is achieved through a sophisticated backend logic implemented in Python and Flask, ensuring a seamless and efficient task distribution process. On the frontend, Sprintr utilizes React, providing a responsive and user-friendly interface that facilitates easy tracking and management of tasks, sprints, and team collaboration. The data management is elegantly handled by SQLAlchemy, which offers a powerful and flexible toolkit for SQL database interaction. Our aim with Sprintr is to revolutionize how tech teams approach project management by automating the allocation process, thereby allowing team members to focus more on innovation and less on administrative overhead. Dive into the world of Sprintr where managing tech projects becomes as agile as your team’s aspirations.
Prerequisites Before you begin, ensure you have the following installed on your system:
- Python and Pipenv
- Node.js and npm
- Flask (for Python)
I have provided a setup.sh script that automates the setup process. To run this script, follow these steps:
Make the script executable (if it's not already):
- chmod +x setup.sh
Execute the script:
- ./setup.sh
This script will install all required dependencies for both the backend and frontend parts of the project, start the backend server, initialize and upgrade the database, and start the frontend development server.
After completing the setup, the backend and frontend servers should be running on your local machine. Here are the default URLs where you can access them:
Frontend (React): http://localhost:3000 Backend (Flask): http://localhost:5555
Additionally, you will find a postman collection in the main directory named sprintr.postman_collection.json.
Lastly, to log in you may either use the following credentials or create another user via the sign up route.
- username: Tyler
- password: defaultPassword
- As a team member (technical or non-technical), I should be able to submit a ticket for a bug.
- As an engineer, I should be able to view tickets assigned to me for completion
- As a laeder of the team, I should be able to create tasks for strategic initiatives in addition to bugs
- As a scrum master, I should be able to rely on the app to assign trivial tasks to engineers with capacity to cut down time-to-completion
CREATE: tickets, users, sprints, ticket_log, ticket_contributors READ: tickets, users, sprints, ticket_log, ticket_contributors UPDATE: tickets, users, sprints DELETE: tickets, ticket_log, ticket_contributors
The application leverages a robust and intuitive database design to effectively manage agile project workflows. The database consists of several key models, each serving a distinct purpose:
User: Central to the application, this model tracks users, their roles, areas of focus (e.g., frontend, backend), and capacity for work. It's pivotal for assigning tasks based on skills and availability.
Ticket: At the heart of project tracking, each ticket represents a task or issue. It includes details like title, status, category, and urgency, along with references to its assignee, author, and associated sprint. The model is designed to track the lifecycle of tasks from creation to completion.
Sprint: This model captures the essence of agile methodology, encapsulating a set timeframe (start and end dates) during which a set of tickets (tasks) are to be completed.
TicketLog: An essential model for maintaining a history of updates and communications on each ticket. It helps in keeping a transparent and chronological track of discussions and changes.
**TicketContributor: **Facilitates a many-to-many relationship between tickets and users. This design choice allows multiple users to collaborate on a single ticket, reflecting real-world team dynamics.
Through these interconnected models, the database effectively mirrors the agile project management process, offering flexibility, scalability, and a user-centric approach to task management.
Javascript, React, Python, Flask
- Authenticated log ins
- Productivity analytics
- Task Auto-assignment / auto-triage system
- customized views/experience tailored to employee roles
- users can control key and values for input fields for a fully customizable experience
