def test_query_account_equality(testbed):
Account(userid=42).put()
Account(userid=43).put()
query = snippets.query_account_equality()
accounts = query.fetch()
assert len(accounts) == 1
assert accounts[0].userid == 42
def test_query_account_inequality(testbed):
Account(userid=32).put()
Account(userid=42).put()
Account(userid=43).put()
query = snippets.query_account_inequality()
accounts = query.fetch()
assert len(accounts) == 2
assert all(a.userid > 40 for a in accounts)
def test_query_account_equality(testbed):
Account(userid=42).put()
Account(userid=43).put()
query = snippets.query_account_equality()
accounts = query.fetch()
if len(accounts) != 1:
raise AssertionError
if accounts[0].userid != 42:
raise AssertionError
def test_query_account_in_steps(testbed):
Account(userid=40).put()
Account(userid=49).put()
Account(userid=50).put()
Account(userid=6).put()
Account(userid=62).put()
_, _, query = snippets.query_account_in_steps()
accounts = query.fetch()
assert len(accounts) == 2
assert all(40 <= a.userid < 50 for a in accounts)
def test_query_account_inequality(testbed):
Account(userid=32).put()
Account(userid=42).put()
Account(userid=43).put()
query = snippets.query_account_inequality()
accounts = query.fetch()
if len(accounts) != 2:
raise AssertionError
if not all(a.userid > 40 for a in accounts):
raise AssertionError
def test_query_account_multiple_filters(testbed):
Account(userid=40).put()
Account(userid=49).put()
Account(userid=50).put()
Account(userid=6).put()
Account(userid=62).put()
query = snippets.query_account_multiple_filters()
accounts = query.fetch()
assert len(accounts) == 2
assert all(40 <= a.userid < 50 for a in accounts)
def test_query_account_in_steps(testbed):
Account(userid=40).put()
Account(userid=49).put()
Account(userid=50).put()
Account(userid=6).put()
Account(userid=62).put()
_, _, query = snippets.query_account_in_steps()
accounts = query.fetch()
if len(accounts) != 2:
raise AssertionError
if not all(40 <= a.userid < 50 for a in accounts):
raise AssertionError
def test_fetch_message_accounts_efficient(testbed):
for i in range(1, 6):
Account(username='******' % i, id=i).put()
Message(content='Message %s' % i, userid=i).put()
message_account_pairs = snippets.fetch_message_accounts_efficient(
Message.query().order(Message.userid))
assert len(message_account_pairs) == 5
for i in range(1, 6):
message, account = message_account_pairs[i - 1]
assert message.content == 'Message %s' % i
assert account.username == 'Account %s' % i
def test_fetch_message_accounts_efficient(testbed):
for i in range(1, 6):
Account(username='******' % i, id=i).put()
Message(content='Message %s' % i, userid=i).put()
message_account_pairs = snippets.fetch_message_accounts_efficient(
Message.query().order(Message.userid))
if len(message_account_pairs) != 5:
raise AssertionError
for i in range(1, 6):
message, account = message_account_pairs[i - 1]
if message.content != 'Message %s' % i:
raise AssertionError
if account.username != 'Account %s' % i:
raise AssertionError
def query_account_in_steps():
query1 = Account.query() # Retrieve all Account entitites
query2 = query1.filter(Account.userid >= 40) # Filter on userid >= 40
query3 = query2.filter(Account.userid < 50) # Filter on userid < 50 too
return query1, query2, query3
def query_account_multiple_filters():
query = Account.query(Account.userid >= 40, Account.userid < 50)
return query
def query_account_inequality():
query = Account.query(Account.userid >= 40)
return query
def query_account_equality():
query = Account.query(Account.userid == 42)
return query
def query_account_in_steps():
query1 = Account.query() # Retrieve all Account entitites
query2 = query1.filter(Account.userid >= 40) # Filter on userid >= 40
query3 = query2.filter(Account.userid < 50) # Filter on userid < 50 too
return query1, query2, query3
def query_account_multiple_filters():
query = Account.query(Account.userid >= 40, Account.userid < 50)
return query
def query_account_inequality():
query = Account.query(Account.userid >= 40)
return query
def query_account_equality():
query = Account.query(Account.userid == 42)
return query
