how to sort object in django

Question

def bubble_sort(nts):
nts_len = len(nts)
for i in range(nts_len):
    for p in range(nts_len - i - 1):
        if nts[p] < nts[p+1]:
            t = nts[p]
            nts[p]= nts[p+1]
            nts[p+1] = t
return nts
def menu(request):
products = Product.objects.all()
if request.method == "POST":
    s = request.POST['select']
    if s == 'Price: Low to High':
        element = []
        for var in products:
            element.append(var)
        list_items = list(element)
        bb = bubble_sort(list_items)
        el = list(bb)
        print(el)
        
        pro = Product.objects.filter(id__in=bb)
        print(pro)
        products = bb

        # print(products)

How to retrieve data from database in bubble sort for objects?TypeError: '<' not supported between instances of 'Product' and 'Product'

Why would you use bubble sort? TimSort is more efficient, and one normally orders in the database to do this in an efficient way. — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Aug 17, 2022 at 10:55
Either compare the attributes from the Product instances or define the rich comparison methods in your class. Even better: Don't write a sort method yourself (you could use sorted) or fetch the data from the database in the correct order. — Matthias
– Matthias, Commented Aug 17, 2022 at 10:57

Lorenzo Prodon · Accepted Answer · 2022-08-17 10:57:35Z

3

You can user order_by():

Product.objects.all().order_by('field_name')

answered Aug 17, 2022 at 10:57

Lorenzo Prodon

3731 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ashkan Goleh Pour · Accepted Answer · 2022-08-17 10:59:40Z

0

your bubble sort looks wrong try this one:

def bubbleSort(lis):
    length = len(lis)
    for i in range(length):
        for j in range(length - i):
            a = lis[j]
            if a != lis[-1]:
                b = lis[j + 1]
                if a > b:
                    lis[j] = b
                    lis[j + 1] = a
    return lis

and you can sort by django ORM or SQL command like order_by ASC or DESC

answered Aug 17, 2022 at 10:59

Ashkan Goleh Pour

5224 silver badges14 bronze badges

Comments

shah sawood · Accepted Answer · 2022-08-17 11:00:20Z

0

You use order_by()

# if you want products in ascending order by field_name
ordered_products = Product.objects.order_by('field_name')

# if your want products in descending order by field_name
ordered_products = Product.objects.order_by('-field_name')

answered Aug 17, 2022 at 11:00

shah sawood

4343 silver badges11 bronze badges

2 Comments

Anish Kumar Karki Over a year ago

yeh but i want to apply bubble sort on it

shah sawood Over a year ago

why do you want bubble sort

Collectives™ on Stack Overflow

how to sort object in django

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related