def get()

in courses/understanding_spanner/cloud-run/main.py [0:0]

• 14 lines of code
• 2 McCabe index (conditional complexity)

    def get(self):
        query = """SELECT Owners.OwnerID, OwnerName,
                   PetID, PetName, PetType, Breed
                   FROM Owners
                   JOIN Pets ON Owners.OwnerID = Pets.OwnerID;"""

        pets = []
        with database.snapshot() as snapshot:
            results = snapshot.execute_sql(query)
            for row in results:
                pet = {'OwnerID': row[0],
                       'OwnerName': row[1],
                       'PetID': row[2],
                       'PetName': row[3],
                       'PetType': row[4],
                       'Breed': row[5], }
                pets.append(pet)
            return pets, 200