pythonProject1

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.

Features

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/

Getting Started

To run the project using the Docker file, follow these steps:

Clone the repository:

git clone https://github.com/OleksandrCherniavskyi/pythonProject1.git

Build 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

Migrate from SQLite to PostgreSQL

• I migrate used django manage.py
• in terminal used command .\manage.py dumpdata to 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