[Django] #30821: Add "iso_week_day" lookup type to DateField/DateTimeField
Django
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
spookyvision |
Type: | Status: new
Uncategorized |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords: ORM Extract
Triage Stage: | Has patch: 1
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
as [https://groups.google.com/forum/#!topic/django-developers/pLS-eKhJBwE
discussed on the mailing list] and
[https://docs.djangoproject.com/en/2.2/ref/models/database-
functions/#extract mentioned by the documentation]: Django's `week_day` is
unusual in that Monday=2.
Rectify this by adding `iso_week_day` with Monday=1 through Sunday=7.
I have checked "has patch" because I have implemented this feature already
and will create a PR
--
Ticket URL: <https://code.djangoproject.com/ticket/30821>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
-------------------------------------+-------------------------------------
| spookyvision
Type: Uncategorized | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: ORM Extract | Triage Stage:
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* status: new => assigned
* owner: nobody => spookyvision
--
Ticket URL: <https://code.djangoproject.com/ticket/30821#comment:1>
Django
-------------------------------------+-------------------------------------
| spookyvision
Type: Uncategorized | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by spookyvision):
`tests/timezones/tests.py` tests pass under PostgreSQL, Oracle, SQLite,
and MySQL.
--
Ticket URL: <https://code.djangoproject.com/ticket/30821#comment:2>
Django
-------------------------------------+-------------------------------------
| spookyvision
Type: Uncategorized | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Old description:
> as [https://groups.google.com/forum/#!topic/django-developers/pLS-eKhJBwE
> discussed on the mailing list] and
> [https://docs.djangoproject.com/en/2.2/ref/models/database-
> functions/#extract mentioned by the documentation]: Django's `week_day`
> is unusual in that Monday=2.
> Rectify this by adding `iso_week_day` with Monday=1 through Sunday=7.
>
> I have checked "has patch" because I have implemented this feature
> already and will create a PR
New description:
as [https://groups.google.com/forum/#!topic/django-developers/pLS-eKhJBwE
discussed on the mailing list] and
[https://docs.djangoproject.com/en/2.2/ref/models/database-
functions/#extract mentioned by the documentation]: Django's `week_day` is
unusual in that Monday=2.
Rectify this by adding `iso_week_day` with Monday=1 through Sunday=7.
--
--
Ticket URL: <https://code.djangoproject.com/ticket/30821#comment:3>
Django
-------------------------------------+-------------------------------------
Reporter: spookyvision | Owner:
| spookyvision
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* type: Uncategorized => New feature
* stage: Unreviewed => Accepted
--
Ticket URL: <https://code.djangoproject.com/ticket/30821#comment:4>
Django
-------------------------------------+-------------------------------------
Reporter: Anatol Ulrich | Owner: Anatol
| Ulrich
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: ORM Extract | Triage Stage: Accepted
Needs tests: 1 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* needs_docs: 0 => 1
* needs_tests: 0 => 1
--
Ticket URL: <https://code.djangoproject.com/ticket/30821#comment:5>
Django
-------------------------------------+-------------------------------------
Reporter: Anatol Ulrich | Owner: Anatol
| Ulrich
Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* needs_docs: 1 => 0
* needs_tests: 1 => 0
* stage: Accepted => Ready for checkin
Comment:
[https://github.com/django/django/pull/11856 PR]
--
Ticket URL: <https://code.djangoproject.com/ticket/30821#comment:6>
Django
-------------------------------------+-------------------------------------
Reporter: Anatol Ulrich | Owner: Anatol
| Ulrich
Component: Database layer | Version: master
(models, ORM) |
Keywords: ORM Extract | Triage Stage: Ready for
| checkin
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* status: assigned => closed
* resolution: => fixed
Comment:
In [changeset:"8ed6788aa479034a44a8aa87da47de56dd728c95" 8ed6788a]:
{{{
#!CommitTicketReference repository=""
revision="8ed6788aa479034a44a8aa87da47de56dd728c95"
Fixed #30821 -- Added ExtractIsoWeekYear database function and
iso_week_day lookup.
}}}
--
Ticket URL: <https://code.djangoproject.com/ticket/30821#comment:7>