The project was developed during the development course advancing enterprise applications with Django. In the project it has the departments, the companies, the employees and the documents that each employee produces. The use of Celery for sending e-mails was added to the project, and the use of several databases in the project such as: MYSQL and POSTGRES. For the user to access the system's functionalities, he must access the django administration panel and associate his user as an employee of a department and a company.

Create your virtual machine

python3 -m venv venv

Activate your virtual machine

source venv/bin/activate

After the virtual machine is activated, install the project dependencies

pip install -r requirements.txt```

Enter the following commands in the terminal.

sudo apt update
sudo apt install mysql-server

For new installations, you will want to run the security script that is included. This changes some of the less secure default options for things like root logins and example users. Enter the command below.

sudo mysql_secure_installation

This will take you through a series of prompts where you can make some changes to the security options of your MySQL installation. The first prompt will ask you if you want to configure the Validate Password Plugin, which can be used to test the strength of your MySQL password. Regardless of your choice, the next prompt will be to set the password for the MySQL root user. Sign in and then confirm a secure password of your choice.

From there, you can press Y and then ENTER to accept the default answers for all subsequent questions. This will remove some anonymous users and the test database, disable remote login for root, and load all of these new rules so that MySQL immediately respects the changes you made.

To see if MYSQL is running, type the following command.

systemctl status mysql.service

If MySQL is not running, you can start it with the following command.

sudo systemctl start mysql

Now try to connect your root user to MySQL.

mysql -u root -p

To install POSTGRESQL, type the following commands in the terminal.

sudo apt update

sudo apt install postgresql postgresql-contrib

To log into PostgreeSQL as a postgre user, you can use psql

sudo su – postgres

To use PostgreSQL, type in the terminal.

Psql

If you want to leave the session, just use.

\q

To create a role, log in to the Postgres account, as you did before. Once you're in the Postgres console, you can create a new role (role) by typing.

createrole –interactive

The system will ask you to name the role and if it has a superuser permission. Similarly, you can also create a new user as the command. createuser –interactive

Alternatively, from the normal command prompt, you can use the command as shown below.

sudo -u postgres createuser –interactive

Again, the system will ask for a username. The createuser command can be used with multiple options, which can be verified using createuse

git clone https://github.com/RamonBecker/AppHRManagement.git

git clone https://github.com/RamonBecker/AppHRManagement.git
or install github https://desktop.github.com/ 

• Python

• CRUD Department
• CRUD company
• CRUD annual leave
• CRUD employee

By Ramon Becker 👋🏽 Get in touch!