Kucheninitiative

Die Initiative für mehr Kuchen an der HSR ist eine solidarisch-gemeinschafliche Vereinigung zur Steigerung des allgemeinen Wohlbefindens durch erhöhten und regelmässigen Kuchengenuss an der HSR.

Diese Webapp hat das Ziel, die Regeln für die Kucheninitiative zu kommunizieren, den Zeitplan zu organisieren sowie Erinnerungen zu verschicken.

Setup (Dev)

Prerequisites

Requirements:

• Python 2.x and pip
• virtualenv and virtualenvwrapper

The easiest way to set up virtualenvwrapper is:

sudo pip install virtualenv virtualenvwrapper
echo -e "\nsource /usr/local/bin/virtualenvwrapper.sh" >> ~/.bashrc
source /usr/local/bin/virtualenvwrapper.sh

You probably need some headers too:

sudo aptitude install postgresql-server-dev-all python-dev

First time setup

The first time setup creates a virtual environment separated from your systemwide PYTHONPATH and sets up some environment variables to be used every time you activate the virtualenv.

The instructions below assume your postgres database is called kuchen; if not, just change the DATABASE_URL env variable.

mkvirtualenv kuchen
pip install -r requirements.txt
POSTACTIVATE=$VIRTUAL_ENV/$VIRTUALENVWRAPPER_ENV_BIN_DIR/postactivate
echo "export DATABASE_URL='postgres://localhost/kuchen'" >> $POSTACTIVATE
echo "export PORT=8000" >> $POSTACTIVATE
echo "export DEBUG=True" >> $POSTACTIVATE
echo "export AWS_ACCESS_KEY_ID='keyname'" >> $POSTACTIVATE
echo "export AWS_SECRET_ACCESS_KEY='key'" >> $POSTACTIVATE
source $POSTACTIVATE
./manage.py syncdb
./manage.py migrate

Development

Each time you want to work on the project, first enable the virtualenv:

workon kuchen

To start the webserver:

./manage.py runserver

If database errors occur because the schema has changed after a git pull:

./manage.py migrate

If some script complains that a python module / dependency is missing:

pip install -U -r requirements.txt

Data synchronization

To update your database with the data from Heroku, do the following:

psql <dbname> -c 'drop schema public cascade; create schema public;'
heroku pgbackups:capture
curl -o latest.dump `heroku pgbackups:url`
pg_restore --verbose --clean --no-acl --no-owner -d <dbname> latest.dump
rm latest.dump

Setup (Heroku)

heroku apps:create --stack cedar [appname]
heroku addons:add heroku-postgresql:dev
heroku addons:add pgbackups
heroku addons:add sendgrid:starter
heroku addons:add scheduler:standard
heroku addons:add zerigo_dns:basic
heroku plugins:install git://github.com/hone/heroku-sendgrid-stats.git
heroku config:set DEBUG=False
heroku config:set SENTRY_DSN="http://[sentry_dsn_string]"
heroku config:set AWS_ACCESS_KEY_ID="keyname"
heroku config:set AWS_SECRET_ACCESS_KEY="key"
heroku domains:add kucheninitiative.ch
git push heroku master
heroku run python manage.py migrate

After changes to staticfiles:

heroku run python manage.py collectstatic --noinput

After adding migrations:

heroku run python manage.py migrate --all

To get a copy-pasteable list of all the e-mail addresses of active members, use the newsletter_receivers management command:

heroku run python manage.py newsletter_receivers