#django

repaste your view

Ugggh mysqlclient hell

jessamynsmith: self inflicted, no sympathy :P

Basically, no matter what I tried, I could not get mysqlclient to see the libssl

FunkyBob: *I* wouldn't use it, but clients do what they do

sydbarret: https://dpaste.de/uK7v#L7,8,9

sydbarret: you are passing a fields list... STOP IT

anyway, the solution, apparently, was to mysql-connector-python

in case that helps anyone else

it seems that anaconda just... destroys mysqlclient in some way

well, let's face it, anaconda takes over your machine with a rusty rake

ah... conda

right?

yeah

how often do you have some weird and mysterious problem... and it turns out to be anaconda

FunkyBob: so, how terrible is this... it's a set of courses, and one requires anaconda, and the instructions for the other fail if you have anaconda installed, and they are in the same semester

urk

FunkyBob: oh, and it gets better... installing mysqlclient in a python2 env worked just fine. Of course, the course is py3/django2.

anyway, I felt bad for this poor student... they are just supposed to be doing a first django course, not trying to figure out library conflicts

jessamynsmith: of course... why would anyone use py2? :)

well, yeah, obviously!

it would be nice if mysqlclient worked properly in py3 with anaconda, but...

nearly every interaction I have with anaconda solidifies my hatred

or, you know, the course didn't encourage people to use shit tools like mysql :)

yeah, I have to use anaconda for my new job... but... I resist

also sad, BUT based on what I saw online, postgres has the same issue with py3/anaconda

pip install psycopg2-binary

:P

reminds me... I should spend some time on egress again some time

there were a ton of google hits about postgres client not finding libssl

though I didn't try it myself, so I don't know

last time I tried to run django tests with egress, it was hitting a problem where the array type test table was created without the array field

is egress a driver, FunkyBob?

yes

one I wrote for experience

mm, cool

binds to libpq, uses the binary protocol...

django.db.utils.ProgrammingError: ('ERROR: column postgres_tests_integerarraymodel.field does not exist\nLINE 1: SELECT "postgres_tests_integerarraymodel"."id", "postgres_te...\n ^\n', '42703')

Is there a common library or method to handle filtering views in Django?

PaulWay[w]: say more?

E.g. I have a list of books owned by the user and they want to just list sci-fi (i.e. by values of a 'genre' related field), or books with 'stone' in their name.

Something that would look for e.g. a 'filter' or 'search' parameter in the request, then add filters to the queryset based on those filters.

having a search field is simple... interpreting it, and working out which fields to search? not so much

Yeah.

I realise that can end up being complex.

But I'd like something to at least take care of the simple stuff.

OK, I'll just write it myself then :-)

PaulWay[w]: I've certainly used this https://github.com/carltongibson/django-filter

Sounds like what I want, thanks jessamynsmith!

isn't there a django-filter2 ?

django-filter has a version 2, I wasn't aware of another package

FunkyBob: so help me, this poor client's prof INSISTS she use mysqlclient so I guess I'll see if I can figure the magic incantation to make it play nicely with anaconda

:/

I feel like having a little snippy conversation about which database is recommended

go track down the video of the talk "Just use postgres"

this one? https://www.youtube.com/watch?v=UgcC_bY4rPg

yep

thanks!

jessamynsmith: I was in the audience :)

nice!

how can i filter a datetime field for an item created in the last hour

?

Foo.objects.filter(created__gte=datetime.datetime.utcnow() - datetime.timedelta(hours=1))

schinckel: thanks, is that datetime or django's datetime timezone helper

oh, it works for both

In that case I just used python's datetime, but that assumes it's stored as UTC.

hey i want to have a delete button on some records...but some things i want to allow staff to delete ..and other things i only want main admin person to delete

how do i go about that

i know there is something called is_staff

ah sorry maybe is_superuser

is that what i should use

If it's in the admin, that will already use delete_* permissions.

im not using the admin panel...im am building a dashboard for all the stuff i need to do

ill look into delete_* permissions

if it works for admin panel ..then i should be able to incorporate it into my dashboard

You probably should use permissions rather than explicitly checking is_superuser anyway.

thanks schinckel, ill look into setting that up

yeah, permissions, you can your own too

great