new_contents: # -*- coding: utf-8 -*-
  
  # add this at the top, just below the 'coding' line
  import psycopg2
  from contextlib import closing
  import os
  import logging
  from pyramid.config import Configurator
  from pyramid.session import SignedCookieSessionFactory
  from pyramid.view import view_config
  from waitress import serve
  
  # add this just below the SQL table definition we just created
  logging.basicConfig()
  log = logging.getLogger(__file__)
  
  
  @view_config(route_name='home', renderer='string')
  def home(request):
      return "Hello World"
  
  # add this function before the "main" function
  def connect_db(settings):
      """Return a connection to the configured database"""
      return psycopg2.connect(settings['db'])
  
  # add this function after the connect_db function
  def init_db():
      """Create database dables defined by DB_SCHEMA
  
      Warning: This function will not update existing table definitions
      """
      settings = {}
      settings['db'] = os.environ.get(
          'DATABASE_URL', 'dbname=learning_journal user=edward'
      )
      with closing(connect_db(settings)) as db:
          db.cursor().execute(DB_SCHEMA)
          db.commit()
  
  def main():
      """Create a configured wsgi app"""
      settings = {}
      settings['reload_all'] = os.environ.get('DEBUG', True)
      settings['debug_all'] = os.environ.get('DEBUG', True)
      settings['db'] = os.environ.get(
      'DATABASE_URL', 'dbname=learning_journal user=cewing'
      )
      # secret value for session signing:
      secret = os.environ.get('JOURNAL_SESSION_SECRET', 'itsaseekrit')
      session_factory = SignedCookieSessionFactory(secret)
      # configuration setup
      config = Configurator(
          settings=settings,
          session_factory=session_factory
      )
      config.add_route('home', '/')
      config.scan()
      app = config.make_wsgi_app()
      return app
  
  if __name__ == '__main__':
      app = main()
      port = os.environ.get('PORT', 5000)
      serve(app, host='0.0.0.0', port=port)
  
  DB_SCHEMA = """
  CREATE TABLE IF NOT EXISTS entries (
      id serial PRIMARY KEY,
      title VARCHAR (127) NOT NULL,
      text TEXT NOT NULL,
      created TIMESTAMP NOT NULL
  )
  """
  
subject: add journal.py