Downloading and Analyzing Data¶
Downloading and restoring database from Heroku¶
Create a psql user if you haven’t already:
$ sudo -u postgres createuser -P <local-username>
Create a local database owned by that user:
$ sudo -u postgres createdb -O <local-username> <dbname>
Capture a database snapshot on Heroku:
$ heroku pg:backups capture
Download the snapshot from Heroku to your local machine:
$ curl -o latest.dump `heroku pg:backups public-url`
Restore database on local machine:
$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U <local-username> -d <dbname> latest.dump
Configure your local CAQE app to use the database. This can achieved either by setting the
SQLALCHEMY_DATABASE_URI
in the CAQE configuration (see caqe.configuration module) or by setting theDATABASE_URL
environment variable, e.g$ export DATABASE_URL='postgres://<local-username>:<psql-password>@localhost/<dbname>'
MUSHRA Analysis¶
First make sure that you have all of the required Python packages for analysis These are not included in the main requirements.txt
file because they are not needed for deployment.
$ pip install -r analysis_requirements.txt
To access and format the results of a MUSHRA listening test, either use the analysis.py
module:
>> import analysis
>> data = analysis.get_ratings_data()
or export the data to a CSV using the CLI command:
$ python analysis.py save-data-to-csv <output_file.csv>
To plot the results of a MUSHRA listening test, either use the analysis.py
module
>> import analysis
>> import matplotlib.pyplot as plt
>> data = analysis.get_ratings_data()
>> analysis.plot_mushra_boxplots(data)
>> plt.show()
or export the plot to a image file (e.g. a .png
, .pdf
, etc.) using the CLI command:
$ python analysis.py plot-mushra-boxplots <output_file.pdf>