CommencerCommencer gratuitement

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.

Cet exercice fait partie du cours

Building Chatbots in Python

Afficher le cours

Instructions

  • 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.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

# Define find_hotels()
def find_hotels(params):
    # Create the base query
    query = 'SELECT * FROM hotels'
    # Add filter clauses for each of the parameters
    if len(params) > 0:
        filters = ["{}=?".format(k) for k in params]
        query += " ____ " + " ____ ".join(____)
    # Create the tuple of values
    t = tuple(____)
    
    # Open connection to DB
    conn = sqlite3.connect("____")
    # Create a cursor
    c = ____
    # Execute the query
    ____
    # Return the results
    ____
Modifier et exécuter le code