I’m trying to optimize a few different things.
I am looking to try to change this into a more database driven routine, instead
of having to iterate through each and every record. While not time consuming
(overall), I would like to try to make it a bit cleaner…
Effectively I am calculating which record the user is actually looking at in
the gallery. The UUID is based into the view, and the view then has to figure
out it’s image XX out of YYY.
for counter, data in enumerate(catalog_qs, start=1):
if str(data.uuid) == e_uuid:
context["page"] = counter
break
I generalized it to this:
def return_offset_uuid(sorder, fpath, tuuid):
"""
Fetch specific database values only from the database
"""
entries =
index_data.objects.exclude(ignore=True).exclude(delete_pending=True).filter(
fqpndirectory=fpath.lower().strip()).order_by(*SORT_MATRIX[sorder])
tpk = entries.filter(uuid=tuuid.strip())[0].pk
count = entries.filter(pk__lte=tpk).count() - 1
#answer = user.answer_set.filter(question=question).get()
# return user.answer_set.filter(pk__lte=answer.pk).count() - 1
return count
Which *seemed* to work, except it didn’t. Yes, I got results:
>>> return_offset_uuid(0, album, "c0543ce7-d156-430d-b08a-5f7379b6e246") # 1
1
>>> return_offset_uuid(0, album, "519f5b9c-e4f4-44e1-aa82-f36aed98e6a9") # 31
4905
>>> return_offset_uuid(0, album, "754fcb51-c3ad-417d-b317-b86305597ae9") # 61
5044
>>> return_offset_uuid(0, album, "b85f18e0-aa17-4192-9c0f-a363d82fa127") # 91
81
>>> return_offset_uuid(0, album, "fe750266-5fb6-467a-929e-c752fa2091ac") #
>>> 121
108
>>> return_offset_uuid(0, album, "51d5ea79-1859-402b-85ff-ae3b2adf7173") #
>>> 5535
4885
Looking at it, entry “AAAA.jpg” is added, it’ll have a larger PK than “ZZZ.jpg”
which was added two months ago.
Is there a better way to do this? I’ll keep the for loop if I have to…
- Benjamin
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/9D43C117-B6EF-4CAD-897C-725C02C67129%40schollnick.net.
