#django

How can I say this in a better way: https://bpaste.net/show/7d352f6fbcc9 ... output: {'may': None, 'nov': None, 'apr': None, 'aug': 3, 'oct': None, 'jul': None, 'feb': None, 'sep': None, 'jan': None, 'jun': None, 'mar': None, 'dec': None}

adamsilver: So you're okay with hardcoding the dict?

cnk, airstrike: Event.objects.filter(id__in=Like.objects.filter(content_type=17, person=u).values_list('object_id', flat=True))

pingveno: I don't mind if I get the months as numbers

it really was *that* simple

i have just 'converted' cnk raw sql query to django orm

except you are not guaranteed that Event is content type 17

yeah i'll change that

to this: ContentType.objects.get(model='event')

also i'm trying to figure out how to filter only object_id in queryset, because maybe it would be a performance hit since it unnecesarily queries other fields too

and i need only that field

and it performs the query twice

but i don't see the other way of doing it

therefore, cnk, it would be slower than using .raw()?

you will have to try each and benchmark

raw(): 0.00012254714965820312 seconds

ORM: 0.01342463493347168 seconds

it's *much* faster

about 100 times

wow

Can you post both of the queries?

My best bet is that most of that time is converting between Django ORM methods into SQL primitives, and not actually run time

this is the first function

and here's the second one: https://dpaste.de/Hnkw

MikiSoft - do `ContentType.objects.get(model='event').query`

See what django is actually generating

actually, there's no executed query to ContentType there

because when starting the app CONTENT_TYPES constant is populated with needed data

You're compairing a reified string do a raw SQL statement, if you're doing it from the python shell this is the wrong way to do it

You need to DB to profile it for you

Also, you're arguing about 1/10th of one second, which is funny

i don't understand what you're saying?

what if 100 users decide to execute such query at the same time?

How are you timing the transactions?

or even more

i'm timing it like this

How are you timing the DB transactions?

start_time = time.time()

ok, thats wrong

model.objects.filter(pk__in=target.objects.filter(content_type=CONTENT_TYPES[model.__name__.lower()], person=person).values_list('object_id', flat=True))

print("--- %s seconds ---" % (time() - start_time))

Yes, so you don't know what you're doing

why?

in the case of ORM it's executing the query *twice* so that's the reason why it's much slower

in the case of .raw() it's executing it only once

but i don't know the other way of doing it in one query in ORM

maybe it can be made through .extra() command to be faster but i'm not enough experienced to make it

You're timing 2 things, you're timing the time it takes to convert chained method calls into SQL, and then the time to actually run the SQL

type this instead: model.objects.filter(pk__in=target.objects.filter(content_type=CONTENT_TYPES[model.__name__.lower()], person=person).values_list('object_id', flat=True)).query

The .query flag will give the SQL you can use to time

yeah but then it would give me the query which does the other half of the job

because it executes two queries

hello

did you see my las error https://dpaste.de/6TsA

i am new in django and im trrying to do the tutorial

but in the tutorial say https://docs.djangoproject.com/en/1.10/intro/tu...

this and if you se in line 7 of my code is not the same answer

you need the `__str__()` method in your question/poll models

jbitcm-: ^

make sure its the same as the tutorial `return self.question_text`

cnk: https://dpaste.de/Ao1m

finally made it with extra(), now it returns QuerySet instead of RawQuerySet

hi all, i'm currently using python-memcached w/ my django app. i recently had a degradation problem which caused all memcached server requests to freeze, which resulted in 503 errors to my users (since the request took longer than 30s to process). what would be the best way to degrade gracefully in the future? i'd like for each memcached call to fail silently (or return None) if it takes longer than 0.1s.

OtherAllan: https://dpaste.de/cyvS

correction of the code from the last link i've posted above: https://dpaste.de/DSHp

OtherAllan: do you know who is my problem naw?

hey guys

anyone use django-openid package yet?

i've been trying to find some good django assessment tests - does anyone have links to some free content?

what i mean is assessing someones knowledge of django, not writing test code

How would you go about calling an API in your views? Seems easy but I am drawing a blank...https://dpaste.de/FaNn#L7,8

deltaskelta: um, usually you're either making an ajax request, using javascript, from the rendered view

or you're calling python code directly

what are you trying to do?

deltaskelta: you can use requests to make an HTTP request to whatever service you need

if the service is large enough they may even had a python SDK you can use

limbera: ah, you are calling someone else's api?

I want to call my DRF API from another view within my own project, and display the data along with custom forms and context...

why not just call the function directly?

or abstract the logic into a function - and then have the API endpoint call that abastracted function

right, so if you want to get data from your own, you should... what limbera said

and your other function do the same thing

you can call the serializer directly and get the data from it, if that's what you need

hmm ok I'll try to make sense of some of that and try it out in my code. Thanks

Hey, I've been through the docs and can't see it. If I mock something out, and I access to a Call object, how do I access the arguments that were passed to it? Like this: https://dpaste.de/TSOm

jessamynsmith: limbera: I am having some trouble calling the function directly like you were talking about. I know its right in front of me but I can't see how to do it.https://dpaste.de/Gn6H