learn-co-curriculum / dsc-1-05-08-filtering-and-ordering-lab Goto Github PK

FF [100%]

============================================== FAILURES ==============================================
_____________________________ test_select_all_female_dogs_name_and_breed _____________________________

def test_select_all_female_dogs_name_and_breed():
    result = [('Little Ann', 'coonhound'), ('Pickles', 'black lab'), ('Lassie', 'collie'), ('Snowy', 'fox terrier')]

  assert table.execute(select_all_female_dogs_name_and_breed()).fetchall() == result

E AssertionError: assert [] == [('Little Ann', 'coonhound')...), ('Snowy', 'fox terrier')]
E Right contains more items, first extra item: ('Little Ann', 'coonhound')
E Use -v to get the full diff

pytests/test_index.py:20: AssertionError
__________________________ test_select_all_dogs_names_in_alphabetical_order __________________________

def test_select_all_dogs_names_in_alphabetical_order():
    result = [(None,), ('Clifford',), ('Lassie',), ('Little Ann',), ('McGruff',), ('Pickles',), ('Scooby',), ('Snoopy',), ('Snowy',)]

  assert table.execute(select_all_dogs_names_in_alphabetical_order()).fetchall() == result

E AssertionError: assert [] == [(None,), ('Clifford',), ('L...Gruff',), ('Pickles',), ...]
E Right contains more items, first extra item: (None,)
E Use -v to get the full diff

pytests/test_index.py:24: AssertionError
______________________________________ test_select_nameless_dog ______________________________________

def test_select_nameless_dog():
    result = [(9, None, 4, 'M', 'golden retriever', 'playful', 1)]

  assert table.execute(select_nameless_dog()).fetchall() == result

E AssertionError: assert [] == [(9, None, 4, 'M', 'golden retriever', 'playful', ...)]
E Right contains more items, first extra item: (9, None, 4, 'M', 'golden retriever', 'playful', ...)
E Use -v to get the full diff

pytests/test_index.py:28: AssertionError
________________ test_select_hungry_dogs_name_and_breed_ordered_by_youngest_to_oldest ________________

def test_select_hungry_dogs_name_and_breed_ordered_by_youngest_to_oldest():
    result = [('Snoopy', 'beagle'), ('Clifford', 'big red'), (None, 'golden retriever'), ('Scooby', 'great dane'), ('Lassie', 'collie'), ('Pickles', 'black lab')]

  assert table.execute(select_hungry_dogs_name_and_breed_ordered_by_youngest_to_oldest()).fetchall() == result

E AssertionError: assert [] == [('Snoopy', 'beagle'), ('Cli...), ('Pickles', 'black lab')]
E Right contains more items, first extra item: ('Snoopy', 'beagle')
E Use -v to get the full diff

pytests/test_index.py:32: AssertionError
_________________________ test_select_name_age_and_temperament_of_oldest_dog _________________________

def test_select_name_age_and_temperament_of_oldest_dog():
    result = [('Pickles', 13, 'mischievous')]

  assert table.execute(select_name_age_and_temperament_of_oldest_dog()).fetchall() == result

E AssertionError: assert [] == [('Pickles', 13, 'mischievous')]
E Right contains more items, first extra item: ('Pickles', 13, 'mischievous')
E Use -v to get the full diff

pytests/test_index.py:36: AssertionError
__________________________ test_select_name_and_age_of_three_youngest_dogs ___________________________

def test_select_name_and_age_of_three_youngest_dogs():
    result = [('Snoopy', 3), ('Clifford', 4), (None, 4)]

  assert table.execute(select_name_and_age_of_three_youngest_dogs()).fetchall() == result

E AssertionError: assert [] == [('Snoopy', 3), ('Clifford', 4), (None, 4)]
E Right contains more items, first extra item: ('Snoopy', 3)
E Use -v to get the full diff

pytests/test_index.py:40: AssertionError
_____ test_select_name_and_breed_of_dogs_between_age_five_and_ten_ordered_by_oldest_to_youngest ______

def test_select_name_and_breed_of_dogs_between_age_five_and_ten_ordered_by_oldest_to_youngest():
    result = [('McGruff', 'bloodhound'), ('Snowy', 'fox terrier'), ('Lassie', 'collie'), ('Scooby', 'great dane'), ('Little Ann', 'coonhound')]

  assert table.execute(select_name_and_breed_of_dogs_between_age_five_and_ten_ordered_by_oldest_to_youngest()).fetchall() == result

E AssertionError: assert [] == [('McGruff', 'bloodhound'), ...('Little Ann', 'coonhound')]
E Right contains more items, first extra item: ('McGruff', 'bloodhound')
E Use -v to get the full diff

pytests/test_index.py:44: AssertionError
test_select_select_name_age_and_hungry_of_hungry_dogs_between_age_two_and_seven_in_alphabetical_order

def test_select_select_name_age_and_hungry_of_hungry_dogs_between_age_two_and_seven_in_alphabetical_order():
    result = [(None, 4, 1), ('Clifford', 4, 1), ('Lassie', 7, 1), ('Scooby', 6, 1), ('Snoopy', 3, 1)]

  assert table.execute(select_name_age_and_hungry_of_hungry_dogs_between_age_two_and_seven_in_alphabetical_order()).fetchall() == result

E AssertionError: assert [] == [(None, 4, 1), ('Clifford', ...y', 6, 1), ('Snoopy', 3, 1)]
E Right contains more items, first extra item: (None, 4, 1)
E Use -v to get the full diff

pytests/test_index.py:48: AssertionError
================================= 8 failed, 1 passed in 0.15 seconds =========