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