Ditching thread-local scoped_session.

We intend to always pass the db session aroung within
the request scope, therefore we do not need the scoped_session.
Changed the way of adding the db attribute to the one
recommended by pyramid cookbook.