Foobs Interface

Integrated interface for displaying results from the database.

Prerequisites

Note: the following steps are for Windows installation, the system hasn't been tested on any other OS yet.

Required installations

• Python 3.6

• Spacy - see installation description on their website

• pymssql

Go to http://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql and download the version of pymssql for your machine

(e.g. for a 64 bit machine with Python 3.6 you'll need the pymssql-2.1.3-cp36-cp36m-win_amd64.whl)

In command line, navigate to the folder that stores the wheel and type pip install pymssql-2.1.3-cp36-cp36m-win_amd64.whl

• CherryPy

pip install cherrypy

• Jinja2

Go to http://www.lfd.uci.edu/~gohlke/pythonlibs/#distribute and donload the version of jinja2 to that has the filename
Jinja2-2.9.6-py2.py3-none-any.whl . In command line navigate to the folder that stores the wheel and type the following:
pip install Jinja2-2.9.6-py2.py3-none-any.whl

• ScatterText

pip install scattertext

Other required setup

This project works with Microsoft SQL Server Management Studio as database environment.

Create a database using the script.sql (change the name of the database and the paths towards the MSQLSMS directory on your machine first). Populate the database using the data-collectors scripts.

Config file configurations

In the db-data tag, specify the port and server values

In the db-names tag, specify the database names. You can add as many as you have.

Running the code

In order to access the interface, in commandline, navigate to the folder containing cherryPyTestConnection.py and run that file. This will start the server and that script will take care of all tasks. Open a browser (the interface has been tested with Firefox and Chrome so far and it's working fine), go to http://localhost:8080/index. There you should find the home page. For navigating yourself through the web app, there is a short manual that can be accessed through the menu bar.