OCR / DA Python - Project12

Epic Events

Build a secure backend architecture with Python and SQL

A CLI application allowing three different type of users to connect (permissions management) and to manage customers, contracts and events

These instructions allow you to :

python 3.10, python3.10-venv, git, pipenv,  
SQLAlchemy, mysql-connector-python, passlib, argon2, simple-term-menu, sentry-sdk

mysql-server-8.0, mysql-client

You'll need to create a dedicated DB and user to your application

pipenv sync

pipenv shell

Once your MySQL server is installed and running :

mysql -u root -p

CREATE DATABASE MYDB

CREATE USER 'MYUSER'@'%' IDENTIFIED BY 'MYPASSWORD'; 
GRANT ALL PRIVILEGES ON MYDB TO 'MYUSER'@'%';

Create a file named config.py in your app's directory containing (at least):

USER = your_db_user
PASSWORD = your_db_user_password

This app can use Sentry. You just have to place the server's URL containing your key in the config.py file :

SENTRY_URL = your_url

python main.py

First connection
Connect first with the default 'admin' user and 'password' as password, then create new collaborators following the menu
Users
There are three roles having three kinds of permissions. The menu is launched accordingly depending on the type of user logged in.
First level is objects (Collaborators, Customers, Contracts, Event), second level is CRUD depending on permissions, and there are some filter on 'list'.