Exercise

Creating queries from parameters

Now you're going to implement a more powerful function for querying the hotels database. The goal is for that function to take arguments that can later be specified by other parts of your code.

More specifically, your job is to define a find_hotels() function which takes a single argument - a dictionary of column names and values - and returns a list of matching hotels from the database.

Instructions

100 XP
  • A filters list has been created for you. Join this list together with the strings " WHERE " and " and ".
  • Create a tuple of the values of the params dictionary.
  • Create a connection and cursor to "hotels.db" and then execute the query, just as in the previous exercise.
  • Return the results of the query.