Database

The data is stored on a SQLite3 database included in the Django project container. Here are some steps to check that the database is working properly.

  • Open a sqlite3 shell session

  • connect to the database with: .open oc-lettings-site.sqlite3

  • view tables in the database: .tables

  • show columns in the profiles table: pragma table_info(profiles_profile);

  • query the profile table: select user_id, favorite_city from profiles_profile where favorite_city like ‘B%’;

  • .quit to exit

Models

The project is broken down into 2 applications: lettings and profiles. Here is the description of the models and the links between the different classes.

class diagram