#django

pendekar_langit: what do you do ? is there {% csrf_token %} in the template like it's said here https://docs.djangoproject.com/en/1.10/ref/csrf/ ?

yes i add yet.

token is already on template, but on post cant get csrf_token

i use a class on views, what because of this?

if you could show us the piece of code that display your form and save the data + the code of the template ; we try can see what is going worng

Is there some sort of caching in django DB? Was looking at what SQL queries my page generates up. First load 8 queries. I hit refresh and only 7. I have identified SQL that went missing and certainly result is still visible on the HTML page. Not problem obviously(good if it has!) but just wondering why SQL queries goes down sometimes despite otherwise identical requests have lesser amount of

SQL queries.

tneva82: Django only caches results of querysets within queryset itself. There is no additional caching normally.

tneva82: There though exists session database backend with write-through caching. Which could explain what you see.

tneva82: Maybe you're setting some class attributes yourself without realizing...

db-backed sessions, so first load causes a Session INSERT?

(guessing here)

would help to know the code, template, and queries

hi all. given the following model:

class CyrusUserModel(Model):

id = BigAutoField(db_column='AUT_ID', primary_key=True) # real_size=10

don't paste in here ,StucKman

FunkyBob: 3 lines

read the topic

ok, ok

don't paste in here, StucKman

now.. what's your question?

morning, kezabelle

ahoy

YAARRR

I was saying: given the model at the line 1 this: http://linkode.org/HOxwAD2s5oWf83NcaQhwT4 , how can I implement the sql query at line 10? I tried something at line 15, but I either get something that looks like None (line 19), or an exception (line 23). 'cyrus_crm-dev' is connected to the same mySQL db as the query

FunkyBob: ok, ok, it was *more* than three lines :)

CyrusUserModel.objects.filter(is_active=True)

oops... is_actif

you likely want to mark supervisor as null=True too

context: the table is a hierarchy of users, but it doesn't have a field marking supervisors. I can only findem as supervisors of somebody else

.filter(is_actif=True).distinct().values_list('supervisor', flat=True) would get you the distinct supervisor columns, I think

aha, and from there to the objects?

oh, missed the first line of the query

a query using id__in (sup_ids) ?

MyModel.objects.filter(pk__in=my_values_list) ... so it'd be a subquery, essentially

aren't subqueries one of the (many) things mysql sucks at? :)

(unless you forcibly evaluate the values_list into a list/tuple/set, then it'd use the values themselves)

FunkyBob: for a given value of suck at :)

FunkyBob: I can give a full list of things of which MySQL sucks at

it'll get gnarly at you sometimes for complex ones, or multi-nested ones, IIRC

but pk in some other simple query isn't usually the pathological case, IMHE.

annnnd I think recent versions are somewhat better.

ah, yes, then that, this one is not really recent

but that's 'an implementation problem' :-P

subqueries can be a less bad option when dealing with mysql

truth

StucKman: so.. you want all supervisors of all active users?

the most strange thing is the exception I get

FunkyBob: yes

objects.filter(cyrususermodel_set__is_actif=True).distinct()

is there a way to log the queries that django builds and/or executes?

using a pk subquery over a values list can be a good way to get expensive late rows, at least historically

late rows?

StucKman: you can print the queryset's query attr, or you can flip DEBUG on and use django.db.connection.queries

historically==this is what happened in the past

?

django logs all the queries, so if you configure that logger to be noisy enough

hylje: connection.queries just has the queries still running, not all executed. I already tried that

kezabelle: yeah i remember making a small query that joins into itself to get the rest of the values

StucKman: no, it has all executed this request

StucKman: ddt can show queries and there’s a middleware listed on awsome-django that also does this.

hylje: yeah. also handy if you have concrete inheritance and want to page into a late offset without eating a bunch of joins ;)

(just pop the pks from the base table, and then let the joins happen in the outer query)

FunkyBob: Why do you need the .distinct() in your ..._set__is_actif=True query?

vlt: because that's what I need...

(the distinct)

it's standard python logging, StucKman

vlt: because multiple people may have the same supervisor ...

kezabelle: https://github.com/cherrypy/cherrypy/blob/2c000... :/

FunkyBob: yes, i see, thanks

FunkyBob: lol. have fun ;)

kezabelle: pass

rather work out what I'm doing wrong with FieldStorage