#django

Is there a way to have cursor.execute/fetchall() return a generator instead of loading everything into an array immediately?

is there an easy way to get the db part of the test factilities only for external testing?

chrisgeorge: are you really afraid of models ? because the sql response has to be in memory somewhere

i basically just want to hit a django instance from the outside and have the db reset when i ask it to

Lauxley: Mostly, it's a large set of joins that get messy in models

chrisgeorge: then what about a nested loop and fetching by batch ?

jdv79: the test runner does something like that

sorry Lauxley got kicked off

(06:59:48 PM) Lauxley: chrisgeorge: then what about a nested loop and fetching by batch ?

Lauxley: would the memory difference change if I'm using this to build a dict that gets dumped into a json?

chrisgeorge_: well model instances wouldn't stay in memory longer than what is needed for the batch to be processed

chrisgeorge_: but hard to tell from this far if you really would have something to gain out of it

benchmark it :)

Thanks Lauxley figured I might have to

chrisgeorge_: maybe you could try .values() to skip the instanciation if you don't need model methods and such

Ah - forgot about that

I'm out have fun :)

is it possible to get the actual SQL generated by a QuerySet? .query doesn't give me the right dialect (Postgres vs. MySQL)

i'm trying to debug a queryset that works on MySQL but not on MariaDB

sorry working on 10.1.20-MariaDB but seems not to be 10.1.23-MariaDB

pembo13: django-debug-toolbar?

matsaman, one is production, so not really an option there... plus in the production side, i'm using the shell

pembo13: enable DEBUG logging for 'django.db.backends'

i'll try that

pachewise: do you have a sample logging setting?

i tried https://coderwall.com/p/uzhyca/quickly-setup-sq...

but that doesn't seem to work

pembo13: one caveat to that is that I'm not sure if it'll work for DEBUG=False in your settings file

pachewise: no sample setups for db logging in the docs unfortunately

pachewise: i'm testing on my dev env. first

ok, then your link should work. Make sure DEBUG=True in your dev env's settings file

pachewise: definitely have DEBUG=True

i'm getting the requests logged

but not DBs

do i need to add some args to runserver or something?

no, you shouldn't have to

try this then: https://docs.djangoproject.com/en/dev/faq/model...

and double check your django version (though I'm pretty sure you should have that functionality), and the logging changes worked for me in my Django app)

crap, sorry... totally editing the wrong settings.py

thanks

`CONVERT_TZ` in MariaDB is returning NULL it seems

Hey! Is there any way to specify which table to use for a many to many relationship filter? i.e. Article.objects.filter(publications__title="Science News") in the example in https://docs.djangoproject.com/en/1.11/topics/d... . I want to change it from the default (in this case) myapp_article_publications.

Hello. I'm trying to return HTML with an HttpResponse in django, but my HTML file refers to a script that I have on my server. However, when my HTML is displayed, it seems that the javascript file wasn't found. I think my problem is how I'm refering to my js file in the HTML. Anyone know how to do this?

Right now, my html file refers to the absolute path of my js file on the server, but when I keep it like that evidently 127.0.0.1:8000/<filepath> is being queried, which isn't good

harwiltz: use the staticfiles app.

adfa

Hi #django, I was wondering how django.test.TestCase and the ORM interact. If I create a databased backed object in a TestCase, the ORM can "see" the object when I query for it (like so https://dpaste.de/agio#L1). But if I were to connect to the test database directly using let's say "mysql -u myuser -p test_database_that_django_made", the tables are empty. How does the ORM know about this uncommited object? And, how can I see thi

Wooble: I've never heard of that, but is there really no way to do this without using another tool?

harwiltz: it's built in to django. You can probably get your server to serve them without it, but it's definitely the easiest way. https://docs.djangoproject.com/en/1.11/howto/st...

Wooble: Alright, I'll check it out. Thanks

I have this query:

Ticket.objects.prefetch_related('quote_set').all().annotate(revenue=Coalesce(Sum('quote__price'), 0.00))

as you can see, I am annotating this 'revenue' field to contain the sum of all the quote elements' price fields.

And Quote has a foreign key to Ticket

How can I modify this to include only 'some' of the quotes?

let's say model Quote has a field is_trashed, and I want to exclude the quotes whose is_trashed is True.

anyone?