def test_query_contact_multiple_values_in_single_sub_entity(testbed): address = Address(type='home', street='Spear St', city='Amsterdam') address.put() Contact(name='Bertus Aafjes', addresses=[address]).put() address1 = Address(type='home', street='Damrak St', city='Amsterdam') address1.put() address2 = Address(type='work', street='Spear St', city='San Francisco') address2.put() Contact(name='Willem Jan Aalders', addresses=[address1, address2]).put() address = Address(type='home', street='29th St', city='San Francisco') address.put() Contact(name='Hans Aarsman', addresses=[address]).put() query = snippets.query_contact_multiple_values_in_single_sub_entity() contacts = query.fetch() assert len(contacts) == 1 assert any(a.city == 'San Francisco' and a.street == 'Spear St' for a in contacts[0].addresses)
def test_query_contact_with_city(testbed): address = Address(type='home', street='Spear St', city='Amsterdam') address.put() Contact(name='Bertus Aafjes', addresses=[address]).put() address1 = Address(type='home', street='Damrak St', city='Amsterdam') address1.put() address2 = Address(type='work', street='Spear St', city='San Francisco') address2.put() Contact(name='Willem Jan Aalders', addresses=[address1, address2]).put() address = Address(type='home', street='29th St', city='San Francisco') address.put() Contact(name='Hans Aarsman', addresses=[address]).put() query = snippets.query_contact_with_city() contacts = query.fetch() assert len(contacts) == 2
def test_query_contact_sub_entities_beware(testbed): address = Address(type='home', street='Spear St', city='Amsterdam') address.put() Contact(name='Bertus Aafjes', addresses=[address]).put() address1 = Address(type='home', street='Damrak St', city='Amsterdam') address1.put() address2 = Address(type='work', street='Spear St', city='San Francisco') address2.put() Contact(name='Willem Jan Aalders', addresses=[address1, address2]).put() address = Address(type='home', street='29th St', city='San Francisco') address.put() Contact(name='Hans Aarsman', addresses=[address]).put() query = snippets.query_contact_sub_entities_beware() contacts = query.fetch() assert len(contacts) == 2 for contact in contacts: assert ('Spear St' in [a.street for a in contact.addresses] or 'Amsterdam' in [a.city for a in contact.addresses])
def query_contact_multiple_values_in_single_sub_entity(): query = Contact.query( Contact.addresses == Address(city='San Francisco', street='Spear St')) return query
def test_query_contact_multiple_values_in_single_sub_entity(testbed): address = Address(type="home", street="Spear St", city="Amsterdam") address.put() Contact(name="Bertus Aafjes", addresses=[address]).put() address1 = Address(type="home", street="Damrak St", city="Amsterdam") address1.put() address2 = Address(type="work", street="Spear St", city="San Francisco") address2.put() Contact(name="Willem Jan Aalders", addresses=[address1, address2]).put() address = Address(type="home", street="29th St", city="San Francisco") address.put() Contact(name="Hans Aarsman", addresses=[address]).put() query = snippets.query_contact_multiple_values_in_single_sub_entity() contacts = query.fetch() assert len(contacts) == 1 assert any(a.city == "San Francisco" and a.street == "Spear St" for a in contacts[0].addresses)
def test_query_contact_sub_entities_beware(testbed): address = Address(type="home", street="Spear St", city="Amsterdam") address.put() Contact(name="Bertus Aafjes", addresses=[address]).put() address1 = Address(type="home", street="Damrak St", city="Amsterdam") address1.put() address2 = Address(type="work", street="Spear St", city="San Francisco") address2.put() Contact(name="Willem Jan Aalders", addresses=[address1, address2]).put() address = Address(type="home", street="29th St", city="San Francisco") address.put() Contact(name="Hans Aarsman", addresses=[address]).put() query = snippets.query_contact_sub_entities_beware() contacts = query.fetch() assert len(contacts) == 2 for contact in contacts: assert "Spear St" in [a.street for a in contact.addresses] or "Amsterdam" in [a.city for a in contact.addresses]
def test_query_contact_with_city(testbed): address = Address(type="home", street="Spear St", city="Amsterdam") address.put() Contact(name="Bertus Aafjes", addresses=[address]).put() address1 = Address(type="home", street="Damrak St", city="Amsterdam") address1.put() address2 = Address(type="work", street="Spear St", city="San Francisco") address2.put() Contact(name="Willem Jan Aalders", addresses=[address1, address2]).put() address = Address(type="home", street="29th St", city="San Francisco") address.put() Contact(name="Hans Aarsman", addresses=[address]).put() query = snippets.query_contact_with_city() contacts = query.fetch() assert len(contacts) == 2