This is a web app for feedback gathering on Living Lab Bus platform. Currently, it's being developed by a group of students at University of Tampere, Finland.

• Python 3 • Flask, SQLAlchemy • PostgreSQL running.

1. Install postgresql

2. In psql prompt create a database called llb:

CREATE DATABASE llb LC_COLLATE 'fi_FI.ISO8859-15' LC_CTYPE 'fi_FI.ISO8859-15' ENCODING LATIN9 TEMPLATE template0;

3. Figure out the value for POSTGRES_URL in your case. If you created a db called llbas in the above example, and your username is insi, and port number 5432, the url is

postgresql+psycopg2://insi:somepasswd@localhost:5432/llb

and you can insert anything in place of somepasswd. You can check the port number and username from Postgres.app (where the database llb should now exist), from under Server settings....

4. From the command line, create an environment variable that holds the value of the POSTGRES_URL variable:

export LLB_POSTGRES_URL="postgresql+psycopg2://<insert_user_name>:somepasswd@localhost:5432/llb"

5. From the command line run python app.py

6. Check that the app works: navigate to http://localhost:5000/in a browser and you should see the text App home. Check these as well:

http://localhost:5000/surveys
http://localhost:5000/surveys/new
http://localhost:5000/surveys/1/questions
http://localhost:5000/surveys/1/questions/new

When adding functionality to controller files, the database can be manipulated using the SQLAlchemy session object.

SQLAlchemy examples:

# Create entries
s = Survey(1, 'Magnificent survey')
f = Feedback(1)
a = Answer(2, 'bla', 2)

# Add to db
session.add(s)
session.commit() # Persisted in db only after commit

# Get list of all surveys
session.query(Survey).all()

# Get first survey
first_survey = session.query(Survey).first()

# Get survey with greatest id_:
from sqlalchemy import desc
latest_survey = session.query(Survey).order_by(Survey.id_.desc()).first()

# Filter surveys by id
survey_1 = session.query(Survey).filter_by(id_=1).one()  # .one() ensures only one entry is returned

# Update survey_1
survey_1 = session.query(Survey).filter_by(id_=1).one()
survey_1.description = 'Even more magnificent survey'
session.add(survey_1) # This effectively updates
session.commit()

# Delete
survey_1 = session.query(Survey).filter_by(id_=1).one()
session.delete(survey_1)
session.commit()