#django

blackcross ▸ hahah sorry that was a stupid crud app i did for a 'job interview'

blackcross ▸ my 'studychess' app is django channels though

nkuttler: looks like the problem is with django-bootstrap3. Doesn't mark message as safe. so i wrote my own display and added it. thx

jonez: https://docs.djangoproject.com/en/1.10/topics/i...

for templates

I am using |date in my template, but that only gives me the seconds offset when I use Z instead of the timezone name

nincha,

show your code? for what you're trying to do

ok hold on. ty for your help

nincha, https://dpaste.de/BYs8

my goal is to display "EDT" instead of "-14400". I can prolly modify the event somehow and make the format I want with a proper tzname using strftime() or such...

yeah are you trying to show the time in the user's timezone?

because you said you want it to show "EDT or PDT"

nincha, eventually, yes. at the moment it's ok if I see "EDT" which is the server's timezone

pl

ok

I would like the ability to add an event in whatever timezone I want.. might be pacific time, or central, or whatever.

yeah you have to explicitly ask the user what zone they want it displayed in

no way for it to detect their timezone that I know of

but yeah I don't know if there's a way to do that through the filter

I'll prolly make a field in the user profile for that

I'd do it in a strftime

can I call strftime from the tmpl?

set the TIME_FORMAT variable I think

or DATETIME_FORMAT would be more applicable

sorry I can't help much more than that other than doing some trial and error

anyone have a go to tempalte tag / filter for dict access

been done many times

but really, stop passing dicts to your context :)

ok here's what I concluded, the "date" and "time" filters in a template use the PHP style format strings, so if you wanted to do it all in the template you would do:

{{event.startdate|date:"D d M Y" }} {{ event.startdate|time:"H:i T" }}

FunkyBob: double checking on my djangocon talk: I use GIN indexes on JSONB fields, GIST on spacial fields and with a unique constraint to e.g. prevent time-range overlaps (room booking and such), right?

FunkyBob: OH BOY, i don't want to but essentially i need to do some looks up as a result of the ORM not letting me do an annotate query effiecently which leads to me having to do a few queries and then map items in to each other to get some extra info

MarkusH: erk.. ask mattmcc or schinckel :)

mattmcc: schinckel: consider yourself asked --^ :)

what does that mean

fission6: pull the work out of the template... either do it in the view, make a smarter data type, or move it into a filter/tag

i did move the look up into a template tag

but i need to pass the dict in

why don't you know the _key_ ahead of time?

i mean i could, if i did some data restructing inside the view

fission6: but I also applaud you explaining the path that lead you to this point

FunkyBob: "stop passing dicts to your contexts" should be "stop messing around with dynamic keys"

FunkyBob: its been a damn painful 24 hours

i have everything working i want to deploy but the annotate query was just not performant, i then made it raw SQL which is nasty and got it working and it performed a bit better, now I just threw in the towel and did seperate queries for what I need which are VERY fast but i need to associate it to "Brands" which is what I am listing in my template

jonez: {{event.startdate|date:"D d M Y" }} {{ event.startdate|time:"H:i T" }} worked for me

fission6: well, for some background please provide the query and how it's poorly executed

nincha, does that display the timezone?

yes the "T" on the "time" filter

ah cool

FunkyBob: http://dpaste.com/2901ZQ0 been in here discussing and #postgres for the last 24 hours ;(

I am going to make a custom filter to make things easier

fission6: I mean ,a dict lookup filter is _trivial_ .. so go with that for the short time

but know that you are accruing technical debt

right

how woud you approach this

FunkyBob:

you know the problem is hard when your dpaste times out

lol

fission6: sorry, I really need to focus on my paid work right now...

sounds like Koterpillar is on the case, though

nighty-night

(client dumped a list of fixes/changes on me 3 days before end of contract)

totally understood

MarkusH: see you soon :)

fission6: I know little about queries though

so I'll just attack the map problem

imagine you have your filter as {{ dict|key:mykey }}, what will you write then?

what do you mean

that's your filter for dict access

that results in dict[mykey]

what do you want to do with it?

win 4

use it

{% with |get_item as value %} …

how do I make sure my 'templatetags' module is imported? I made a 'datestamp' filter, and I consistently get an error about how 'datestamp' is not a defined tag library

http://www.pfinn.net/custom-django-filter-tutor... is the example I'm looking at.

fission6: which key did you want for this? Can you paste the structure of the data?

jonez: use {% load mylib %}

jonez: why aren't you reading the actual django docs?

oh.. the 'load' is for the 'templatetags' name, not the individual filter?

jonez: it's for whatever you called the file

that link says I'm supposed to put my filters in this custom folder.. I'll change it

you put them in a folder in your app called templatetags/

Koterpillar: what do you mean which key did i want for this?

FunkyBob, ah. ok.

fixed it. prob was I needed to restart the server

yes, that does happen... because the reload watcher didn't know about the file

ok