#django

objects.get_or_create() managed to create a duplicate? >_>

Hello! How i can check if object will be updated before save?

Oh I think the other programmer made an assumption about it

I need this because i need update one field with timestamp if it will be updated, for exmaple one of it field was changed.

loa: use an auto date-time thing

loa: Well django doesn't track dirty fields. So it uses much simpler algorithm.

you're overcomplicating it in that case

it is not i am, i just use another human db schema.

i need compare fields and if there got changed, i need update timestamp and model.

loa: if you .save() first django checks value of pk. If it's None django does insert. if it's set, django tries to update, if that fails django tries to insert.

so it will always update record right if even nothing got changed?

Yes.

loa: https://docs.djangoproject.com/en/1.11/ref/mode...

loa: Is jsut one or two fields that should update timestamp if changed? Or any fields on your model?

Few

Title, description, price

the form will know

how do I subtract current date with date from sql orm timestamp?

in django template

is it even possible?

Tadassssss: Should be possible.

Tadassssss: something like .annotate(ExpressionWrappere(datetime.now() - F('myfield'), output_field=DateTimeField())) should work.

jtiai^: that's some funny looking DTL ;P

doismellburning: where? :o

Tadassssss: avoid doing work in your template :)

or.. :D my reading skills sucks :D

maybe you want https://docs.djangoproject.com/en/1.11/ref/cont... ?

date - date is dateinterval, what are you gonna do with that in template

jtiai^, could you check, I have this https://paste.pound-python.org/show/4YISXGGIRWr...

I have no idea how to subtract that >.>

second day working in django

Tadassssss: Do that math in a view code.

yes, but how could I retrieve only date column, jtiai^?

Um... you can do something like: obj.date_difference = datetime.date.today() - obj.date

jtiai^, I think I tried something similiar but received obj has no attribute date, I will try again

also your view code is bit strange by doing manual template loading..

jtiai^, Yes I would like to know how to do that dinamically, because that is the goal of this app, just total newb and dont know anything

offical tutorial?

Tadassssss: https://docs.djangoproject.com/en/1.11/intro/tu... that's a bit better way.

jtiai^, aa like this, ok thanks!

Tadassssss: Also I suggest that you do official tutorial. Or, Django Girls do have very excellent tutorial as well.

jtiai^, I did these and they suggest only the very basics

jtiai^, with your suggested formula I'm getting AttributeError: 'QuerySet' object has no attribute 'date'

Tadassssss: So you do have queryset - you then need to loop over queryset and do the math over individual objects. (which now suggests that your obj is not really object but queryset - problem with naming)

jtiai^, so I need to loop in my views and not in my template right?

You need to do it in both. But it's for different reasons.

in a view you do data manipulation and such, in a template it's for representational purposes.

jtiai^, aah, okay, then I think I will give up on this for now and move on something easier

thanks

Actually what you're trying to do is very fudamental :D

and basic stuff that you do almost every time.

jtiai^, the thing is that i have over 100 users and increasing every time, I need to make it as a function so it would do this for me automatically

newb in python, 2months experience only

programming 6 months in total

so yeah

Tadassssss: If you do that math "often", you may want to write it as a property in your model.

okay, so as I said I will leave this for a bit later because I dont feel I have enough experience to write this yet

Tadassssss: https://dpaste.de/8mm0

And after that you can do in your tempalte: {{ obj.date_diff }}

jtiai^, okay thanks I will try to work on this!

so here I find myself again... craving a project to occupy my mind

nobody?

Write direct SDO_GEOMETRY using gis backend for oracle, instead of current WKT based...

jtiai^: I understand "gis" and "oracle" .... in that sentence.

Well latest cx_Oracle bough ability to access oracle user types directly - including SDO_GEOMETRY object.

Compared to WKT format, it's almost 200 times faster to read and 20 times faster to write.

But it needs quite a bunch of code to convert between Django geom types and SDO_GEOMETRY object.

Fun stuff.

"fun"... yes... quite

I might just make that fork of uwsgi, instead :)

Actually i've done it once...

but?

cx_oracle had some bugs so it crashed from time to time - and I didn't put my source anywhere safe place. And then I lost... :D

oracle? bugs? surely you jest!