def test_with_row_count_limit(self):
sql, bind_vars = sql_builder.build_limit_clause(5)
self.assertEqual(sql, 'LIMIT %(limit_row_count)s')
self.assertEqual(bind_vars, dict(limit_row_count=5))
sql, bind_vars = sql_builder.build_limit_clause([5])
self.assertEqual(sql, 'LIMIT %(limit_row_count)s')
self.assertEqual(bind_vars, dict(limit_row_count=5))
def test_with_row_count_limit(self): sql, bind_vars = sql_builder.build_limit_clause(5) self.assertEqual(sql, 'LIMIT %(limit_row_count)s') self.assertEqual(bind_vars, dict(limit_row_count=5)) sql, bind_vars = sql_builder.build_limit_clause([5]) self.assertEqual(sql, 'LIMIT %(limit_row_count)s') self.assertEqual(bind_vars, dict(limit_row_count=5))
def test_with_no_limit(self):
sql, bind_vars = sql_builder.build_limit_clause(None)
self.assertEqual(sql, '')
self.assertEqual(bind_vars, {})
def test_with_offset_and_row_count_limit(self):
sql, bind_vars = sql_builder.build_limit_clause([100, 5])
self.assertEqual(sql, 'LIMIT %(limit_offset)s, %(limit_row_count)s')
self.assertEqual(bind_vars, dict(limit_offset=100, limit_row_count=5))
def test_with_no_limit(self):
sql, bind_vars = sql_builder.build_limit_clause(None)
self.assertEqual(sql, '')
self.assertEqual(bind_vars, {})
def test_with_offset_and_row_count_limit(self): sql, bind_vars = sql_builder.build_limit_clause([100, 5]) self.assertEqual(sql, 'LIMIT %(limit_offset)s, %(limit_row_count)s') self.assertEqual(bind_vars, dict(limit_offset=100, limit_row_count=5))
