Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:  IntervalField| Triage Stage:  Accepted
  interval duration DurationField|
  feature 1.8-alpha  |
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  1
-+-

Comment (by Tim Graham ):

 In [changeset:"ee86e590516250a7db7bf7c9a979ced4faf4edd7"]:
 {{{
 #!CommitTicketReference repository=""
 revision="ee86e590516250a7db7bf7c9a979ced4faf4edd7"
 Refs #2443 -- Allowed creation of objects with NULL DurationFields
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.df083b593718dff957c05fed80514780%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:  IntervalField| Triage Stage:  Accepted
  interval duration DurationField|
  feature 1.8-alpha  |
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  1
-+-

Comment (by Tim Graham ):

 In [changeset:"227a4c48be18a439f0a08a49bf1f3062babeee82"]:
 {{{
 #!CommitTicketReference repository=""
 revision="227a4c48be18a439f0a08a49bf1f3062babeee82"
 Refs #2443 -- fixed format_dtdelta on SQLite

 A test failed on Python 2 32-bit.
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.b372887eb950ea4cd98cc3a709cb77f4%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:  IntervalField| Triage Stage:  Accepted
  interval duration DurationField|
  feature 1.8-alpha  |
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  1
-+-

Comment (by Marc Tamlyn ):

 In [changeset:"962bb9b6bd1deb042e139316108ec0da44cb22a9"]:
 {{{
 #!CommitTicketReference repository=""
 revision="962bb9b6bd1deb042e139316108ec0da44cb22a9"
 Refs #2443 -- Move the durationfield converter logic.

 This reduces how frequently this logic is run significantly.

 Thanks to Anssi for the suggestion.
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.e9b8c943fc3f45751c24031c8d15c791%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:  IntervalField| Triage Stage:  Accepted
  interval duration DurationField|
  feature 1.8-alpha  |
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  1
-+-

Comment (by Marc Tamlyn ):

 In [changeset:"07728a2c2c78b030b7de9c6b20ef028f82d6134a"]:
 {{{
 #!CommitTicketReference repository=""
 revision="07728a2c2c78b030b7de9c6b20ef028f82d6134a"
 Refs #2443 -- Fix Oracle tests for DurationField.

 It helps if there are the correct number of microseconds in a second.
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.b4f48c6337bdea76a7665691426efc5b%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Normal   |   Resolution:  fixed
 Keywords:  IntervalField| Triage Stage:  Accepted
  interval duration DurationField|
  feature 1.8-alpha  |
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  1
Easy pickings:  0|UI/UX:  1
-+-
Changes (by Marc Tamlyn ):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"57554442fe3e209c135e15dda4ea45123e579e58"]:
 {{{
 #!CommitTicketReference repository=""
 revision="57554442fe3e209c135e15dda4ea45123e579e58"
 Fixed #2443 -- Added DurationField.

 A field for storing periods of time - modeled in Python by timedelta. It
 is stored in the native interval data type on PostgreSQL and as a bigint
 of microseconds on other backends.

 Also includes significant changes to the internals of time related maths
 in expressions, including the removal of DateModifierNode.

 Thanks to Tim and Josh in particular for reviews.
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.3b381d8e6a65e126b99636da0379f656%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature 1.8-alpha  |UI/UX:  1
Has patch:  1|
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by timgraham):

 * keywords:  IntervalField interval duration DurationField feature =>
 IntervalField interval duration DurationField feature 1.8-alpha
 * needs_better_patch:  0 => 1
 * stage:  Ready for checkin => Accepted


Comment:

 There's a test failure that needs fixing.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.d679894b98f6d42559e88576334a531d%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Ready for
 Keywords:  IntervalField|  checkin
  interval duration DurationField|  Needs documentation:  0
  feature|  Patch needs improvement:  0
Has patch:  1|UI/UX:  1
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by mjtamlyn):

 * needs_better_patch:  1 => 0
 * stage:  Accepted => Ready for checkin


Comment:

 Changes have been made to:
 - remove SubFieldBase (completely!)
 - Support arithmetic with DurationField

 I believe this is now ready for checkin, I just need a final check from
 someone for the arithmetic changes.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.ede7c73e4b247e9c3d612ff98323ce4e%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by akaariai):

 * needs_better_patch:  0 => 1


Comment:

 I think we need support for `qs.filter(event_startdate__gte=datetime.now()
 - F('event_duration))`. I think this works on PostgreSQL, but at least on
 Oracle it produces wrong results. The event_duration is in microseconds,
 but in oracle the date arithmetic interprets integers as days. Actually, I
 am not sure if this query works at all.

 In any case usages of F('duration_field') need tests. Raising errors from
 F() usage is acceptable, but producing wrong results is clearly not OK.

 Another issue that keeps nagging me is the use of SubfieldBase to support
 value conversion (SubfieldBase basically calls to_python() anytime the
 field is set on the object). Other fields in Django core do not use this,
 instead they let the backend convert the values. I am not sure if usage of
 SubfieldBase leads to any problems, but I keep getting the feeling we
 should be consistent in not using SubfieldBase. One case where usage of
 backend specific converters differ from usage of to_python  + SubfieldBase
 is that SubfieldBase does value conversions on assignment. So:
 {{{
>>> obj.duration_field = '12:34:56'
>>> obj.duration_field
OUT: '12:34:56' if not using SubfieldBase
OUT: timedelta(12h, 34m, 56s)
 }}}
 Currently no local field in Django core do value conversions on
 assignment. In addition there is clear overhead in model `__init__` when
 using SubfieldBase, I'd guess the overhead is somewhere around 20% per
 field that uses SubfieldBase, though I haven't benchmarked this.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.2f0918c6523159f6957881b2907cd739%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  0
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by mjtamlyn):

 * needs_better_patch:  1 => 0
 * needs_docs:  1 => 0


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.713c0eeb35c34f7cb4e35ce17e2e96a1%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  1
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  0|
Easy pickings:  0|
-+-
Changes (by timo):

 * needs_docs:  0 => 1
 * needs_tests:  1 => 0


Comment:

 [https://github.com/django/django/pull/2995 WIP] from Marc.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.7a44da692599a09d60690c255399f918%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  mjtamlyn
 Type:  New feature  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by mjtamlyn):

 * status:  new => assigned
 * owner:  Adys => mjtamlyn


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.ff42e2e406e3c4095a99c229d6a47d6f%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  Adys
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-

Comment (by k_sze):

 I think this ticket is mostly moot now that there is django-
 timedeltafield, which works quite nicely. See links below:

 https://pypi.python.org/pypi/django-timedeltafield
 https://bitbucket.org/schinckel/django-timedelta-field/

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.a7105b47aa5de371c093a83757cf2303%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  Adys
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by styne666):

 * cc: styne666 (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/078.ecab9c49821de39a1b2ea29b016a1631%40djangoproject.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  Adys
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by aaugustin):

 * cc: aaugustin (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  Adys
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by net147):

 * cc: net147 (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  Adys
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  master
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-

Comment (by anonymous):

 [http://www.replicawatchesbuy.org.uk/cartier-watches-c-11.html cartier
 replica]  bomb~

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  Adys
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  SVN
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-

Comment (by smcoll):

 Replying to [comment:50 jpaulett]:
 > While Python does provide the timedelta class, there is no common SQL
 implementation for storing that object in the database.  PostgreSQL does
 provide the INTERVAL data type, MySQL and SQLite do not have any interval
 data type (I am not sure about Oracle, MSSQL, etc.).

 What about MySQL's TIME type?

 "MySQL retrieves and displays TIME values in 'HH:MM:SS' format (or
 'HHH:MM:SS' format for large hours values). TIME values may range from
 '-838:59:59' to '838:59:59'. The hours part may be so large because the
 TIME type can be used not only to represent a time of day (which must be
 less than 24 hours), but also elapsed time or a time interval between two
 events (which may be much greater than 24 hours, or even negative)."

 http://dev.mysql.com/doc/refman/5.0/en/time.html

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
 Reporter:  ben.tucker@… |Owner:  Adys
 Type:  New feature  |   Status:  new
Component:  Database layer   |  Version:  SVN
  (models, ORM)  |   Resolution:
 Severity:  Normal   | Triage Stage:  Accepted
 Keywords:  IntervalField|  Needs documentation:  0
  interval duration DurationField|  Patch needs improvement:  1
  feature|UI/UX:  1
Has patch:  1|
  Needs tests:  1|
Easy pickings:  0|
-+-
Changes (by carbonXT):

 * cc: mike@… (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
   Reporter: |  Owner:  Adys
  ben.tucker@…   | Status:  new
   Type:  New|  Component:  Database layer
  feature|  (models, ORM)
  Milestone: |   Severity:  Normal
Version:  SVN|   Keywords:  IntervalField
 Resolution: |  interval duration DurationField
   Triage Stage:  Accepted   |  feature
Needs documentation:  0  |  Has patch:  1
Patch needs improvement:  1  |Needs tests:  1
  UI/UX:  1  |  Easy pickings:  0
-+-

Comment (by jpaulett):

 Karen,

 While Python does provide the timedelta class, there is no common SQL
 implementation for storing that object in the database.  PostgreSQL does
 provide the INTERVAL data type, MySQL and SQLite do not have any interval
 data type (I am not sure about Oracle, MSSQL, etc.).

 Luckily Django makes it relatively simple to create
 [https://docs.djangoproject.com/en/dev/howto/custom-model-fields/ custom
 model fields].  If you are willing to be PostgreSQL-specific, you could
 store timedeltas as INTERVALs (I believe the psycopg driver handles the
 conversion for you).

 You could also convievably pickle the timedelta instance and store that
 blob in the database.  This approach breaks the sorting semantics,
 potentially corrupts the data across Python versions, and is completely
 opaque from a pure database perspective.

 Another approach is to store the data in the database as a BIGINT.  This
 approach has the advantage of working across databases and retains the the
 expected sorting semantics.  The downside to this approach from a pure
 database perspective, is that you now must know the function to convert
 from a BIGINT into an interval.  Based upon the patches included in this
 ticket, myself and several other developers created [http://django-
 durationfield.readthedocs.org/ django-durationfield]. One advantage of
 being a standalone app as opposed to being in core is that we can release
 new features & bug fixes without having to wait for a major Django point
 release.

 I do not mean to speak for the core developers, but since there is no
 ideal solution and since using a standalone app is extremely easy, I doubt
 we will see this feature included in core anytime soon.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
   Reporter: |  Owner:  Adys
  ben.tucker@…   | Status:  new
   Type:  New|  Component:  Database layer
  feature|  (models, ORM)
  Milestone: |   Severity:  Normal
Version:  SVN|   Keywords:  IntervalField
 Resolution: |  interval duration DurationField
   Triage Stage:  Accepted   |  feature
Needs documentation:  0  |  Has patch:  1
Patch needs improvement:  1  |Needs tests:  1
  UI/UX:  1  |  Easy pickings:  0
-+-
Changes (by anonymous):

 * ui_ux:  0 => 1


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
   Reporter: |  Owner:  Adys
  ben.tucker@…   | Status:  new
   Type:  New|  Component:  Database layer
  feature|  (models, ORM)
  Milestone: |   Severity:  Normal
Version:  SVN|   Keywords:  IntervalField
 Resolution: |  interval duration DurationField
   Triage Stage:  Accepted   |  feature
Needs documentation:  0  |  Has patch:  1
Patch needs improvement:  1  |Needs tests:  1
  UI/UX:  0  |  Easy pickings:  0
-+-
Changes (by Karen Rustad):

 * ui_ux:   => 0


Comment:

 This is a vote to get a DurationField (or whatever you want to call it)
 into Django 1.4. I'm currently running into this problem in that I need to
 represent an iteration length in some task management software I'm
 writing, where the length is set by the user and could be anything from a
 week to a month to a couple months (even more hilarity since months aren't
 consistent lengths). Of course, timedeltas are super-conveniently built
 into Python and can handle all of this in a snap...but in Django I have no
 way to store them. It's driving me nuts.

 Like, come on. If Django is Python, timedelta needs a model field.
 Without, it's incomplete.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
   Reporter: |  Owner:  Adys
  ben.tucker@…   | Status:  new
   Type:  New|  Component:  Database layer
  feature|  (models, ORM)
  Milestone: |   Severity:  Normal
Version:  SVN|   Keywords:  IntervalField
 Resolution: |  interval duration DurationField
   Triage Stage:  Accepted   |  feature
Needs documentation:  0  |  Has patch:  1
Patch needs improvement:  1  |Needs tests:  1
 |  Easy pickings:  0
-+-
Changes (by sorin):

 * cc: sorin (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
   Reporter: |  Owner:  Adys
  ben.tucker@…   | Status:  new
   Type:  New|  Component:  Database layer
  feature|  (models, ORM)
  Milestone: |   Severity:  Normal
Version:  SVN|   Keywords:  IntervalField
 Resolution: |  interval duration DurationField
   Triage Stage:  Accepted   |  feature
Needs documentation:  0  |  Has patch:  1
Patch needs improvement:  1  |Needs tests:  1
 |  Easy pickings:  0
-+-
Changes (by evgenpioneer@…):

 * cc: evgenpioneer@… (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
   Reporter: |  Owner:  Adys
  ben.tucker@…   | Status:  new
   Type:  New|  Component:  Database layer
  feature|  (models, ORM)
  Milestone: |   Severity:  Normal
Version:  SVN|   Keywords:  IntervalField
 Resolution: |  interval duration DurationField
   Triage Stage:  Accepted   |  feature
Needs documentation:  0  |  Has patch:  1
Patch needs improvement:  1  |Needs tests:  1
 |  Easy pickings:  0
-+-
Changes (by fckin.spam@…):

 * cc: fckin.spam@… (added)
 * easy:   => 0


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
-+-
   Reporter: |Owner:  Adys
  ben.tucker@…   |Milestone:
 Status:  new|  Version:  SVN
  Component:  Database   | Keywords:  IntervalField
  layer (models, ORM)|  interval duration DurationField
 Resolution: |  feature
   Triage Stage:  Accepted   |Has patch:  1
Needs documentation:  0  |  Needs tests:  1
Patch needs improvement:  1  |
-+-
Changes (by slafs):

 * cc: slafs (added)


-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField feature
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by ubernostrum):

  * milestone:  1.3 =>

Comment:

 1.3 is feature-frozen now.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.3
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField feature
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by rasca):

  * keywords:  IntervalField interval duration DurationField =>
   IntervalField interval duration DurationField
   feature

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.3
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by gogna):

 * cc: flavio.cure...@gmail.com (added)

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.3
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by jpaulett):

 * cc: j...@paulett.org (added)

Comment:

 I am not sure if this is appropriate, but I took the latest patch by Adys
 and turned it into a reusable application, [http://github.com/johnpaulett
 /django-durationfield/ django-durationfield]. If anyone has an issue with
 turning the patch into an external app, please let me know.

 I am viewing the django-durationfield app as a temporary solution since
 this patched missed the 1.2 feature deadline. I will try to keep the app
 in sync with latest patch for this issue (and contribute any fixes,
 documentation, and tests to this issue).

 Assuming that a DurationField is eventually committed to Django core, the
 switch from the django-durationfield app to the core version should just
 be a matter of switching a few import statements.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.3
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by Alex):

  * milestone:  1.2 => 1.3

Comment:

 We are now passed the 1.2 feature freeze.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.2
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by sebzur):

 Adys, I liked the DurationField idea and I hope You were not seorious
 saying that You're going to leave it? I've tried it in my my project -
 there are some issues with it which I'm going to address soon - but all in
 all it works OK and I will be happy to help maintain it.

 It would be great to see it in django itself in the future. Up to this
 time, I must agree with russellm that it would be easier to use/test it
 'externally'. Right now, I had to create another django version (along
 side with my default system one from Gentoo) and patch it to use
 DurationField... I want to stay in-sync with Your code - that's why I
 didn't extract it.

 Please, consider such an extraction, I belive it would made the
 DurationField more attractive (while it's not in django).

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.2
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by russellm):

 Replying to [comment:34 Adys]:
 > Unless there are bugs, I will not work on this anymore. The core devs
 seem to hate the idea of having a DurationField...

 Yes, the core devs clearly hate the idea of DurationField. That's why this
 ticket was marked accepted by Jacob, and
 [wiki:Version1.2Features#LowPriority is on the low prioirty feature list
 for v1.2].

 There is a difference between "don't like an idea" and "haven't had time
 to apply a patch because we've been busy with one or two other things". If
 we didn't like the idea, we'd close the ticket.

 > meanwhile I'm perfectly happy keeping my core patched.

 I'll also point out that you don't need to patch core to write your own
 field definition. You can define fields in your own code base, and
 import/use them as you wish.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.2
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by Adys):

 There, new updated patch.
 See: http://groups.google.com/group/django-
 developers/browse_thread/thread/d32316ce7964dbaf?hl=en

 Unless there are bugs, I will not work on this anymore. The core devs seem
 to hate the idea of having a DurationField... meanwhile I'm perfectly
 happy keeping my core patched.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-upda...@googlegroups.com.
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en.

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone:  1.2
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by Adys):

  * milestone:  => 1.2

Comment:

 Ok, 1.1 is out, it's time for an update.[[BR]]
 This ticket has been open long enough. I'm decided to get everything
 closed for 1.2. I'm going to upload a rebased patch today or tomorrow.
 Right now, there are three outstanding issues with it:[[br]]
 * In the admin, a durationfield appears as a Decimal's __unicode__ in
 filters, and when it's equal to zero on the admin detail page.[[br]]
 * Validation isn't getting handled correctly in the admin - a 500 is
 raised rather than a ValidationError.[[br]]
 * Lack of docs/tests[[br]]

 First issue is something I've tried to fix but came up blank. Second one
 should be easy enough to fix (I'll have a look before rebasing hopefully),
 third one I'll leave until the former two are fixed.[[br]]
 I'm still *very* itchy about using a DecimalField as backend. But hey...

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Adys   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by Adys):

  * owner:  Gulopine => Adys

Comment:

 Yuri did some updates to the patch posted above; I'll post a rebase by
 tomorrow. This rebase also comments out support for months and years as
 per list discussion; since it's just two values, might as well leave them
 commented.[[BR]][[BR]]

 1.1's almost out if I am to trust the targeted bugs. I suppose we could
 start looking at DurationField implementation for 1.2? This ticket has
 been open long enough.[[BR]][[BR]]

 Reassigning to myself.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by Adys):

 Any feedback on the DurationField patch? I still need to figure out the
 admin output.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by Adys):

 * cc: mic...@salaban.info (added)

Comment:

 cc mic...@salaban.info, sorry for the spam, Firefox is horrible.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by Adys):

 * cc: mic...@salaban.info (removed)

Comment:

 Emes, I agree with you. I just wanted to get the implementation in. It's
 easier to remove than to add-on.[[BR]]
 [[BR]]
 I sent the Dev list a mail a couple of days ago:
 http://groups.google.com/group/django-
 developers/browse_thread/thread/612e6c641d109f40?hl=en

 Another question I bumped into this morning: Should we allow negative
 values?

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by emes):

 * cc: mic...@salaban.info (added)

Comment:

 I think the year and month units are misleading, as in real life they have
 no fixed length. This is probably why the timedelta type does accept day
 as the longest unit possible.

 We can assume that year is an astronomical unit, but it's almost never
 useful in real life. A year has to round to days and it's length is known
 only when applied to a certain start date. The same (or even worse)
 happens with a month. In Gregorian calendar there are 4 different lengths
 possible: 28, 29, 30, 31 days. We could assume that month is astronomical
 unit again (moon cycle) but it will roughly match only the Muslim
 calendar.

 I'd prefer to leave a week as the longest unit possible.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by Adys):

 It feels wrong to "store" as seconds. Then again, just my opinion.[[BR]]
 [[BR]]
 I was thinking the same thing about a js helper, and a friend came up with
 the idea of just parsing the field for units. I'll see if I can get a few
 mins to work on it tonight, I really like the idea. Three big
 advantages:[[BR]]
 - No need for javascript (6 weeks would be "6w", 30 seconds would be
 "30s", 2 hours would be "2h", etc)[[BR]]
 - Easy to understand, very user friendly (parsing "3h 10d" is okay, I
 suppose we'd give validationerror on "1h 10m 2h" or similar tho)[[BR]]
 - No need for multiple input boxes, avoids confusion[[BR]]
 [[BR]]
 On a slightly-related note, I don't know what to do about microseconds.
 Standard display is µs, but that could cause problems for users with
 special keyboard layouts etc.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by Adys):

 For the interface part, there's two decent choices.[[BR]]
 Either go for a parse of the values in a single field, for example (input)
 "3d 12h 4m 7s", "7d 10m", "15 ms"; output would be highest value
 possible first - 6ms would be "1m", 75000ms would be "1m 15s"
 (abbreviations are up for change, would go for the standard ones).[[BR]]
 [[BR]]
 Or, go for a single field with a  box, with some js shortcuts.
 [___] [ Unit ... ] (X)[[BR]][[BR]]

 In both cases, the possible units would be years, months, weeks, days,
 hours, minutes, seconds, milliseconds, microseconds (assuming microsecond
 precision). Thoughts?

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by Adys):

 I had a look through the patch today. Using a DecimalField and playing
 with commas seems unreasonably hacky. Is using a 64-bit int an option? It
 shouldn't be a problem under postgres, but I don't know about the other db
 backends.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by Gulopine):

 Well, you'll notice that yours is the first patch to hit this ticket since
 Jacob said it "needs some UI help." That criticism still stands, since a
 half-dozen input fields don't make for a very good user experience.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by Adys):

 What's holding DurationField from going upstream (at least in contrib)? I
 can help fix whatever is necessary.

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  ben.tuc...@gmail.com  | Owner:  Gulopine   
  
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Comment (by benhasek219):

 [http://six-pack-abs.0mbt.com/articles/8/The-3-Best-Abdominal-Exercises-
 that-Are-Not-Traditional-Ab-Exercises.html The 3 Best Abdominal Exercises
 that Are Not Traditional Ab Exercises]

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to 
django-updates+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
---+
  Reporter:  [EMAIL PROTECTED]  | Owner:  Gulopine  
   
Status:  new   | Milestone: 
  
 Component:  Database layer (models, ORM)  |   Version:  SVN
  
Resolution:|  Keywords:  
IntervalField interval duration DurationField
 Stage:  Accepted  | Has_patch:  1  
  
Needs_docs:  0 |   Needs_tests:  1  
  
Needs_better_patch:  1 |  
---+
Changes (by guettli):

 * cc: [EMAIL PROTECTED] (added)

Comment:

 Related: http://www.djangosnippets.org/snippets/1060/

-- 
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates?hl=en
-~--~~~~--~~--~--~---

Re: [Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
+---
 Reporter:  [EMAIL PROTECTED]|Owner:  adrian
 Type:  enhancement |   Status:  new   
 Priority:  lowest  |Milestone:
Component:  Database wrapper|  Version:  SVN   
 Severity:  minor   |   Resolution:
 Keywords:  IntervalField interval  |  
+---
Changes (by adrian):

  * priority:  normal => lowest
  * severity:  normal => minor

-- 
Ticket URL: 
Django 
The web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates
-~--~~~~--~~--~--~---

[Django] #2443: Add IntervalField to database models

[Django]

#2443: Add IntervalField to database models
--+-
 Reporter:  [EMAIL PROTECTED]  |   Owner:  adrian
 Type:  enhancement   |  Status:  new   
 Priority:  normal|   Milestone:
Component:  Database wrapper  | Version:  SVN   
 Severity:  normal|Keywords:  IntervalField interval
--+-
 Although not all backends support the interval data type, it can be
 implemented using some other data type. This field is quite useful and it
 would be nice if it were available.

-- 
Ticket URL: 
Django 
The web framework for perfectionists with deadlines.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To post to this group, send email to django-updates@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-updates
-~--~~~~--~~--~--~---