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!
