Пагинация сырых запросов Django

Основной текст заметки

Django RAW query pagination
найдено тута: https://gist.github.com/tkrajina/11298980

# Dummy model:
class DbCounter(models.Model):
count = models.IntegerField()

def get_count(table, where):
# Check strings for sql injections here before doing this!
return DbCounter.objects.raw('select 1 as id, count(*) as count from %s where %s' % (table, where))[0].count

# View:
def index(request):
count = get_count('table', 'suggestion=0')
objects = mod_models.WMS.objects.raw('select * from table where suggestion=0 order by created desc')
objects.count = lambda : count
paginator = Paginator(objects, 5)
# ...

Заметка написана: 22.12.2018

Теги заметки: Django