This project is a Django-based web application that analyzes and presents information about the IT sector in the Polish region using a database. The data is obtained from the JustJoin.It API and is updated daily through continuous integration and deployment (CI/CD) using GitHub Actions.
Unfortunately, starting from September 25, 2023, Justjoin has been updated, and access to the API has been closed.
- This project does not have a positive value for me, and I will not be finding a new solution
- I have backed up the old SQLite database and closed the PostgreSQL database.
The start page allows users to select a specific time period for viewing analytics. Main charts provide insights such as:
- Top positions in the IT sector.
- Top specializations in the field.
- Number of positions available on a daily and weekly basis.
- Skill ratings for each position and specialization.
Link to page https://t7q6wq-8080.csb.app/
To run the project using the Docker file, follow these steps:
Clone the repository:
git clone https://github.com/OleksandrCherniavskyi/pythonProject1.gitBuild the Docker image:
docker build -t image_name .
Run the Docker container:
docker run -p 8080:8080 image_name
The application will be accessible at http://localhost:8080.
Update branch in codesandbox.io
- git fetch
- git merge origin/master
- I migrate used django manage.py
- in terminal used command
.\manage.py dumpdatato export data from SQLite in JSON - i've some error, i fixed use
set PYTHONIOENCODING=utf-8.\manage.py dumpdata chart.Offers > dboffers.json.\manage.py dumpdata chart.Brands > dbbrands.json.\manage.py dumpdata chart.Skills > dbskills.json.\manage.py dumpdata chart.EmploymentTypes > dbet.json.\manage.py dumpdata chart.BrandsOffice > dbbo.json
- create PostgreSQL database (i chose RDS from AWS)
- create table in PostgreSQL
- change connectin in setting.py to new DB
- import data in database use
.\manage.py loaddata.\manage.py loaddata dbbrands.json.\manage.py loaddata dboffers.json.\manage.py loaddata dbskills.json.\manage.py loaddata dbet.json.\manage.py loaddata dbbo.json