def test_paginate_query_no_pagination(self):
sqlalchemy.asc("user").AndReturn("asc")
self.query.order_by("asc").AndReturn(self.query)
sqlalchemy.desc("project").AndReturn("desc")
self.query.order_by("desc").AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5, ["user_id", "project_id"], sort_dirs=["asc", "desc"])
def test_paginate_query_no_pagination(self):
sqlalchemy.asc('user').AndReturn('asc')
self.query.order_by('asc').AndReturn(self.query)
sqlalchemy.desc('project').AndReturn('desc')
self.query.order_by('desc').AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5,
['user_id', 'project_id'],
sort_dirs=['asc', 'desc'])
def test_paginate_query_no_pagination(self):
sqlalchemy.asc('user').AndReturn('asc')
self.query.order_by('asc').AndReturn(self.query)
sqlalchemy.desc('project').AndReturn('desc')
self.query.order_by('desc').AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5,
['user_id', 'project_id'],
sort_dirs=['asc', 'desc'])
def test_paginate_query_no_pagination_no_sort_dirs(self):
sqlalchemy.asc("user").AndReturn("asc_3")
self.query.order_by("asc_3").AndReturn(self.query)
sqlalchemy.asc("project").AndReturn("asc_2")
self.query.order_by("asc_2").AndReturn(self.query)
sqlalchemy.asc("snapshot").AndReturn("asc_1")
self.query.order_by("asc_1").AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5, ["user_id", "project_id", "snapshot_id"])
def test_paginate_query_no_pagination_no_sort_dirs(self):
sqlalchemy.asc('user').AndReturn('asc_3')
self.query.order_by('asc_3').AndReturn(self.query)
sqlalchemy.asc('project').AndReturn('asc_2')
self.query.order_by('asc_2').AndReturn(self.query)
sqlalchemy.asc('snapshot').AndReturn('asc_1')
self.query.order_by('asc_1').AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5,
['user_id', 'project_id', 'snapshot_id'])
def test_paginate_query_no_pagination_no_sort_dirs(self):
sqlalchemy.asc('user').AndReturn('asc_3')
self.query.order_by('asc_3').AndReturn(self.query)
sqlalchemy.asc('project').AndReturn('asc_2')
self.query.order_by('asc_2').AndReturn(self.query)
sqlalchemy.asc('snapshot').AndReturn('asc_1')
self.query.order_by('asc_1').AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5,
['user_id', 'project_id', 'snapshot_id'])
def test_paginate_query(self):
sqlalchemy.asc("user").AndReturn("asc_1")
self.query.order_by("asc_1").AndReturn(self.query)
sqlalchemy.desc("project").AndReturn("desc_1")
self.query.order_by("desc_1").AndReturn(self.query)
self.mox.StubOutWithMock(sqlalchemy.sql, "and_")
sqlalchemy.sql.and_(False).AndReturn("some_crit")
sqlalchemy.sql.and_(True, False).AndReturn("another_crit")
self.mox.StubOutWithMock(sqlalchemy.sql, "or_")
sqlalchemy.sql.or_("some_crit", "another_crit").AndReturn("some_f")
self.query.filter("some_f").AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(
self.query, self.model, 5, ["user_id", "project_id"], marker=self.marker, sort_dirs=["asc", "desc"]
)
def test_paginate_query(self):
sqlalchemy.asc('user').AndReturn('asc_1')
self.query.order_by('asc_1').AndReturn(self.query)
sqlalchemy.desc('project').AndReturn('desc_1')
self.query.order_by('desc_1').AndReturn(self.query)
self.mox.StubOutWithMock(sqlalchemy.sql, 'and_')
sqlalchemy.sql.and_(False).AndReturn('some_crit')
sqlalchemy.sql.and_(True, False).AndReturn('another_crit')
self.mox.StubOutWithMock(sqlalchemy.sql, 'or_')
sqlalchemy.sql.or_('some_crit', 'another_crit').AndReturn('some_f')
self.query.filter('some_f').AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5,
['user_id', 'project_id'],
marker=self.marker,
sort_dirs=['asc', 'desc'])
def test_paginate_query(self):
sqlalchemy.asc('user').AndReturn('asc_1')
self.query.order_by('asc_1').AndReturn(self.query)
sqlalchemy.desc('project').AndReturn('desc_1')
self.query.order_by('desc_1').AndReturn(self.query)
self.mox.StubOutWithMock(sqlalchemy.sql, 'and_')
sqlalchemy.sql.and_(False).AndReturn('some_crit')
sqlalchemy.sql.and_(True, False).AndReturn('another_crit')
self.mox.StubOutWithMock(sqlalchemy.sql, 'or_')
sqlalchemy.sql.or_('some_crit', 'another_crit').AndReturn('some_f')
self.query.filter('some_f').AndReturn(self.query)
self.query.limit(5).AndReturn(self.query)
self.mox.ReplayAll()
utils.paginate_query(self.query, self.model, 5,
['user_id', 'project_id'],
marker=self.marker,
sort_dirs=['asc', 'desc'])
