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