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 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_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 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
