I wrote this little script as part of a larger project I had to make for an University project, but I am so satisfied with it that I decided to publish it separately to be used by everyone in their own project.

This script generates a schedule of two legs for a sports league (the example given creates an Italian basketball league schedule), with teams switching between home and away when meeting again in the second leg.

• scheduler.py: The main file. It creates a game schedule for the specified season with teams and arenas taken from the database.
• functions.py: Two functions that are used in the scheduler.py file. They are stored in this file to keep the repository better organized.
• setup.py: Global variables used in the scheduler.py file, stored here for the same reason described for functions.py. By changing them you can change the parameters of the league's season.
• LBA_management.sql: A sample database that will be used in the scripts. By running it, it will create on your MySQL connection a database containing data of the 16 teams in the 2023-24 Italian LBA and their respective arenas.
• requirements.txt: File containing all requirements to run the script. See below for instructions on how to use it.
• .env: Environment variables, you need to modify username and password! localhost and the default database name are already in it, but you can change them of course to your needs.
• README.md: This file!

After downloading, modify the .env file with your MySQL environment connection data and run LBA_management.sql. Then, proceed by running scheduler.py. If requirements are not met, run the following prompt:

pip install -r requirements.txt There are literally just two packages that need installation but to avoid problems just use the prompt above.

The creation of a virtual environment is not necessary but highly recommended to ensure functionality.

• Add a way to ask the user to enter parameters about their league;
• Add a way to ask the user to enter connection details and save them to the .env file, so they don't have to touch it;
• Add a way to dynamically choose how to create the schedule: two legs, swiss tournament, NBA schedule, etc.

If you have any suggestion or question do not hesitate to fork and pull, or just open an issue!