Viewing database

Install Psequel

http://www.psequel.com/

Once installed and running, you need to create a new connection to the production (or dev, or local) database. Use the Host, User, Password, and Name for the corresponding database as specified in your databases.py file (obviously not pushed to public repo). Once you connect to the database, you can browse tables and edit rows if necessary.

Common DB Tasks

Reactivate study if it is accidentally deleted by researcher

Or, if researcher says they created the study but it does not appear in the drop down: Find the researcher_UI_study table by searching for it, and in the 'WHERE clause' field type 'name = [name of study]'. The last column in this table should be called "active". If "active" is False, the study will not show up in the dropdown in the researcher interface. Double click the row and change "active" to True.

Reuse payment code

In the researcher_UI_payment_code table, empty the hash_id (which links it to an administration) and assignment_date fields. If you want to associate the gift code to another study, change the study_id field.