vozellad/jobs-view

Project 1 - Senior Design and Development course

Authors: Demetrios Vozella

Project uses Python 3.10.
Project was developed on Linux.

GUI was made in Qt Creator using Qt6 with PySide6.
After each ui modification, a terminal line converts it from a .ui file to a .py file so the project can reference and use it. Both files are included in this repository.

The following terminal lines are used after editing the GUI form.
Linux/Unix: pyside6-uic /Path/To/QtCreator/Project/form.ui -o /Path/To/This/Project/ui_mainwindow.py
Windows: pyside6-uic C:\Path\To\QtCreator\Project\form.ui -o C:\Path\To\This\Project\ui_mainwindow.py

If you would like to view the database, install the application 'DB Browser for SQLite'.

Create 'my_secrets.py' in the project directory, and initialize an 'api_key' variable with your api key.
The 'my_secrets.py' should be in the following format: api_key="your api key here"

Gets 5 pages of Google search jobs results via Serpapi and stores the results in a text file.
Gets jobs from an Excel file.

Makes a database and stores it in 3 tables: 'jobs', 'related_links', and 'qualifications'.
'jobs' table is the main table. 'related_links' stores multiple links for each job listing, and 'qualifications' stores multiple qualifications for each job listing.

Order of data: (job_id, title, company_name, location, description, posted_at, salary, remote, links, qualifications)
Both data sources go into the same database and set of tables.

Program provides a graphical user interface for viewing jobs data.
User is able to filter by keyword, location, minimum salary, and if the job's remote.
Locations of jobs can be displayed on a map.

Run the main.py file in the directory.
You can view a text file it wrote to named 'jobs_results.txt'.
If you need to view the database, use an application such as 'DB Browser for SQLite'.
The GUI will also start when executing the program.

Click the Map button to view the locations of the jobs.
The more jobs currently listed, the longer it will take for the map to build.

Nothing is missing for the Sprints.