OPIS-Manager

This tool performs the data visualization of the OPIS results

Requirements

• AMP (Apache2, MySQL, PHP)
• composer

Install AMP

This project to run need: PHP, MySQL, a webserver (like Apache2). This requirements are satisfied by the software stack *AMP:

• LAMP for Linux
• MAMP for Mac
• XAMPP/WAMP/EasyPHP and similar for Windows

- Linux

In a linux distro debian-based the package tasksel can install the meta-package LAMP easily, so install tasksel with:

$ sudo apt install tasksel
$ sudo tasksel

Select "LAMP" (use the key arrows and the keybutton "space" to select the option), press TAB and install LAMP.

- Mac

Here the download link of MAMP. MAMP can be installed by hombrew

- Windows

Download EasyPHP

Alternative (cross-platform)

• XAMPP
• WAMP

---

Import the database structure

In the database directory there is the sql structure of the database, so import it.

$ mysql -u root -p db_name < project/path/OPIS-Manager/database/opis_structure.sql

---

How to use the scrapers

The tools in the scrapers directory can extract the public OPIS data from the official site of the University of Catania.

To use them go to scrapers, copy the file config.php.dist into config.php and configure it for the database mysql.

Well, run the related files to extract data like dipartimento.php, it will extract the opis data and it will import them in the database.

---

Install the API

To install the Laravel API, run the setup_api.sh

$ sh setup_api.sh

Configure the database parameters opening the file API/.env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=database_name
DB_USERNAME=username
DB_PASSWORD=password

Go to the API directory and use composer to download and install the dependencies:

$ cd API
$ composer install

Run this command to fill the APP_KEY parameter (this key will be used from JWTAuth for the authentication):

php artisan key:generate

Now your OPIS-Manager should be installed. You can run the browser and test it!