This is a Python script that processes incoming emails and updates the database accordingly.
- Python 3.10 or higher
- PostgreSQL 14 or higher
- IMAP server
- SMTP server
- Database with the following tables:
emails
tickets
ticket_assignments
supporters
You find the database schema in the sql-models
repository - sql-models
- Clone the repository
- Install the required dependencies
- Configure the database connection in the
config.ini
file - Run the script
- Run the script
- The script will process all new emails in the inbox and update the database accordingly
This project is open-sourced under the MIT License - see the LICENSE file for details