LMNOP
Live Music Notes, Opinions, Photographs
Install postgresql
Set admin password, remember it.
Start postgres running
su postgres
if on a mac/linux
pg_ctl start
enter username and password
start postgres shell with psql
And create a user called lmnop
create user lmnop with password 'password_here';
create a database lmnop
create database lmnop owner lmnop;
Various postgres shell commands connect to lmnop database
\c lmnop
\dt
shows tables
\d table_name
shows info (and constraints) for a table
other sql as expected
postgres shell command cheatsheet - https://gist.github.com/Kartones/dd3ff5ec5ea238d4c546
set environment variable called POSTGRES_LMNOP_USER_PASSWORD with a value of the lmnop user's password
(Mac users may need to run these commands; these one time
sudo ln -s /Library/PosgreSQL/9.5/lib/libssl.1.0.0.dylib /usr/local/lib
sudo ln -s /Library/PosgreSQL/9.5/lib/libcrypto.1.0.0.dylib /usr/local/lib
And this when you start a new shell; or set it permanently in .bash_profile
export DYLD_FALLBACK_LIBRARY_PATH=/Library/PostgreSQL/9.5/lib:$DYLD_LIBRARY_PATH
)
To install
-
Create and activate a virtual environment. Use Python3 as the interpreter.
-
pip install -r requirements.txt
-
cd LMNOP/LMNOPSite
-
python manage.py makemigrations lmn
-
python manage.py migrate
-
python manage.py runserver
Site at
127.0.0.1:8000
Create superuser
from LMNOP/LMNOPSite
python manage.py createsuperuser
enter username and password
will be able to use these to log into admin console at
127.0.0.1:8000/admin
To run tests (some currently fail - see Issues)
python manage.py test lmn.tests
Or just some of the tests,
python manage.py test lmn.tests.test_views
python manage.py test lmn.tests.test_views.TestUserAuthentication
python manage.py test lmn.tests.test_views.TestUserAuthentication.test_user_registration_logs_user_in
Functional Tests with selenium
Install (upgrade to the latest version if you already have it) Firefox browser. It works best for automated functional testing with Selenium.
geckodriver needs to be in path or you need to tell Selenim where it is. Pick an approach: http://stackoverflow.com/questions/40208051/selenium-using-python-geckodriver-executable-needs-to-be-in-path
python manage.py runserver
python manage.py test lmn.tests.functional_tests
Test coverage
From directory with manage.py in it,
coverage run --source='.' manage.py test lmn.tests
coverage report
Eventful key
Go to Eventful and sign up.
Once you sign up and are logged in, scroll down to the bottom of the main page and click on "Developer API"
Under "Tools" click on The Application keys and follow the instructions to set up a new account. (The site will ask you for an URL I think, just use the local one 127..5000 and in the text box add comments that is for school project, use the project's name.)
Store the key in the system environment as EVENTFUL_KEY .
Twitter keys
Create a Twitter account (using your personal account not really recommended). Get API keys from Twitter. The following keys must be stored as system environment variables:
- TWITTER_CONSUMER_KEY
- TWITTER_CONSUMER_SECRET
- TWITTER_ACCESS_TOKEN
- TWITTER_ACCESS_TOKEN_SECRET
AWS keys
When running on AWS, set the following keys to serve static files from an S3 bucket:
- AWS_ACCESS_KEY_ID
- AWS_SECRET_KEY (not AWS_SECRET_ACCESS_KEY)
Configuration
Set DJANGO_SECRET_KEY before running. Can generate from Python console with
import random
print(''.join([random.SystemRandom().choice('abcdefghijklmnopqrstuvwxyz0123456789!@#$%^&*(-_=+)') for i in range(50)]))
Set DJANGO_DEBUG=1 for debug mode