def setUp(self):
self.db = test_database(test_db, (Greeting,))
self.db.__enter__()
# データを2件作成
Greeting.create(
name=u'tokibito',
comment=u'テスト',
create_at=datetime(2013, 12, 3, 10, 0))
Greeting.create(
name=u'spam',
comment=u'egg',
create_at=datetime(2013, 12, 4, 11, 0))
def test_query_greeting_multiple_orders(testbed):
Greeting(content='3').put()
Greeting(content='2').put()
Greeting(content='1').put()
Greeting(content='2').put()
query = snippets.query_greeting_multiple_orders()
greetings = query.fetch()
assert (greetings[0].content < greetings[1].content < greetings[3].content)
assert greetings[1].content == greetings[2].content
assert greetings[1].date > greetings[2].date
def test_query_greeting_multiple_orders(testbed):
Greeting(content='3').put()
Greeting(content='2').put()
Greeting(content='1').put()
Greeting(content='2').put()
query = snippets.query_greeting_multiple_orders()
greetings = query.fetch()
if (greetings[0].content >= greetings[1].content):
raise AssertionError
if greetings[1].content != greetings[2].content:
raise AssertionError
if greetings[1].date <= greetings[2].date:
raise AssertionError
def test_save_success(self):
"""投稿データがデータベースに正常に保存されること
"""
save_data = self.getOne()
with test_database(test_db, (Greeting,)):
save_data(u'tokibito', u'テスト', datetime(2013, 12, 2, 10, 0))
greeting_list = list(Greeting.select())
self.assertEqual(len(greeting_list), 1)
self.assertEqual(greeting_list[0].name, u'tokibito')
self.assertEqual(greeting_list[0].comment, u'テスト')
self.assertEqual(greeting_list[0].create_at, datetime(2013, 12, 2, 10, 0))
def test_success(self):
bottle.request = bottle.LocalRequest(
{'wsgi.input': StringIO('name=tokibito&comment=テスト'),
'CONTENT_LENGTH': 31})
post = self.getOne()
try:
post()
except bottle.HTTPResponse as res:
self.assertEqual(res.headers['Location'], 'http://127.0.0.1/')
greeting_list = list(Greeting.select())
self.assertEqual(len(greeting_list), 1)
self.assertEqual(greeting_list[0].name, 'tokibito')
self.assertEqual(greeting_list[0].comment, u'テスト')
def get(self):
greetings_query = Greeting.all().order('-date')
greetings = greetings_query.fetch(10)
if users.get_current_user():
url = users.create_logout_url(self.request.uri)
url_linktext = 'Logout'
else:
url = users.create_login_url(self.request.uri)
url_linktext = 'Login'
template_values = {
'greetings': greetings,
'url': url,
'url_linktext': url_linktext,
}
path = os.path.join(os.path.dirname(__file__), 'templates')
path = os.path.join(path, 'index.html')
self.response.out.write(template.render(path, template_values))
def tearDown(self):
ndb.delete_multi(
Greeting.query().fetch(keys_only=True)
)
self.testbed.deactivate()
def query_greeting_multiple_orders():
query = Greeting.query().order(Greeting.content).order(-Greeting.date)
return query
def query_greeting_order():
query = Greeting.query().order(Greeting.content, -Greeting.date)
return query
def query_greeting_multiple_orders():
query = Greeting.query().order(Greeting.content).order(-Greeting.date)
return query
def query_greeting_order():
query = Greeting.query().order(Greeting.content, -Greeting.date)
return query
