def test_2(request):
"""
Test type 2: Single database query
"""
num = randint(1, 10000)
result = DBSession.query(World).filter(World.id == num).one()
return result.__json__()
def test_2(request):
"""
Test type 2: Single database query
"""
num = randint(1, 10001)
result = DBSession.query(World).filter(World.id == num).one()
return result
def test_4(request):
"""
Test type 4: Fortunes
"""
fortunes = [obj.__json__() for obj in DBSession.query(Fortune).all()]
fortunes.append(
{"id": 0, "message": "Additional fortune added at request time."}
)
return {'fortunes': sorted(fortunes, key=lambda x: x['message'])}
def test_4(request):
"""
Test type 4: Fortunes
"""
fortunes = [obj.__json__() for obj in DBSession.query(Fortune).all()]
fortunes.append({
"id": 0,
"message": "Additional fortune added at request time."
})
return {"fortunes": sorted(fortunes, key=lambda x: x["message"])}
def test_3(request):
"""
Test type 3: Multiple database queries
"""
queries = request.params["queries"]
try:
queries = int(queries)
except ValueError:
queries = 1
else:
if queries < 1:
queries = 1
elif queries > 500:
queries = 500
result = [
DBSession.query(World).filter(World.id == num).one()
for num in [randint(1, 10000) for _ in range(1, queries + 1)]
]
return [obj.__json__() for obj in result]
def test_3(request):
"""
Test type 3: Multiple database queries
"""
queries = request.params['queries']
try:
queries = int(queries)
except ValueError:
queries = 1
else:
if queries < 1:
queries = 1
elif queries > 500:
queries = 500
result = [
DBSession.query(World).filter(World.id == num).one()
for num in [randint(1, 10001) for _ in range(1, queries + 1)]
]
return result
def test_5(request):
"""
Test type 5: Database updates
"""
queries = request.params["queries"]
try:
queries = int(queries)
except ValueError:
queries = 1
else:
if queries < 1:
queries = 1
elif queries > 500:
queries = 500
objset = [
DBSession.query(World).filter(World.id == num).one()
for num in [randint(1, 10000) for _ in range(1, queries + 1)]
]
for obj in objset:
obj.randomNumber = randint(1, 10000)
resultset = [obj.__json__() for obj in objset]
DBSession.commit()
return resultset
def test_5(request):
"""
Test type 5: Database updates
"""
queries = request.params['queries']
try:
queries = int(queries)
except ValueError:
queries = 1
else:
if queries < 1:
queries = 1
elif queries > 500:
queries = 500
objset = [
DBSession.query(World).filter(World.id == num).one()
for num in [randint(1, 10001) for _ in range(1, queries + 1)]
]
for obj in objset:
obj.randomNumber = randint(1, 10001)
resultset = [obj.__json__() for obj in objset]
DBSession.commit()
return resultset
