Project 12 OpenClassrooms Path - Epic Events -- develop a secure back-end architecture with Python and SQL
Epic Events is an Event Manager CLI program to create, update and delete employees, clients, contracts and events.
I have chosen to use the Django ORM to create my models, use BaseCommand to create, update, delete and also to display a manu. As admin tool I have used the Django admin interphase. The database is a SQLite database. My permission system is integrated in the EpicEventCommand, where I use a class attribute 'permission' to verify if the user has the permission to access the command.
The authentication is Django based but to create a token I am using the JWT. To integrate the token into the commands, there is a JWTTokenMixin. This mixin generates a token, verifies the token and handles the login and logout of the user.
Every employee has a specific role. The roles are SAles, SUpport and MAnagement. Every employee can make different operation within that program. This operation are permission-based
and even the menu is based on the specific role of the employee. To visualize which employee has access to which operation you can check the file: cli/utils_menu.py.get_app_menu.
open terminal
git clone https://github.com/DoriDoro/EpicEvents.gitcd EpicEventspython3 -m venv venv. venv/bin/activateon MacOS and Linuxvenv\Scripts\activateon Windowspip install -r requirements.txt
Option 1:
start the program with command: python manage.py start and login with one of these emails:
| Employee email | Password | Role |
|---|---|---|
| kelly.miller@mail.com | TestPassw0rd! | SA |
| craig.chavez@mail.com | TestPassw0rd! | SU |
| ernest.bishop@mail.com | TestPassw0rd! | MA |
Option 2:
create fake data by yourself, by running these commands:
python manage.py data_create_employees(prints one employee/user email, with Role: SA, on console to log in, password: TestPassw0rd!)python manage.py data_create_clientspython manage.py data_create_contractspython manage.py data_create_events
the commands to create all these data is located indata/management/commands/.- start the program with command:
python manage.py startand login with e.g. the email which is printed on the console after you enterpython manage.py data_create_employeecommand with password:TestPassw0rd!.
realized with https://dbdiagram.io
- Implementing a secure database with Python and SQL
After loging in with email and password, you will be redirected to the command: python manage.py start and you choose from a menu what you want to do:
Every employee, regardless of their role, can list all employees, all clients, all contracts and all events. This list appears as ready only.
As described every employee can list all, but certain can filter further. After the listing of the model, an input appears to ask if this employee wants to filter.
If the employee chooses 'yes' and have the permission to filter, the employee can filter the model.
After choosing to filter and permission granted, the employee can choose one to several model attributes to filter the events.
This picture demonstrate the creation of a client.
To update a model instance, a little table displays all details of the model instance. The employee can choose, from one to multiple, which field the employee wants to update.
The updated data will be displayed right after the update of the model instance.
To demonstrate the data creation:
