[Django] #30240: Add support for SHA database functions.

[Django]

#30240: Add support for SHA database functions.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope
Type: New | Status: assigned
feature |
Component: Database | Version: master
layer (models, ORM) | Keywords: sha1, sha224,
Severity: Normal | sha256, sha384, sha512
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
Following on from `MD5()` defined in #28643, we can add support for
`SHA1()`, `SHA224()`, `SHA256()`, `SHA384()` and `SHA512()`.

There are two caveats:

- `SHA224()` is not supported by `STANDARD_HASH` in Oracle.
- PostgreSQL requires the use of the `pgcrypto` extension.

--
Ticket URL: <https://code.djangoproject.com/ticket/30240>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

[Django]

#30240: Add support for SHA database functions.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope

Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: sha1, sha224, | Triage Stage:
sha256, sha384, sha512 | Unreviewed
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Nick Pope):

* has_patch: 0 => 1

Comment:

[https://github.com/django/django/pull/11059 PR]

--
Ticket URL: <https://code.djangoproject.com/ticket/30240#comment:1>

[Django]

#30240: Add support for SHA database functions.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope

Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:

Keywords: sha1, sha224, | Triage Stage: Accepted
sha256, sha384, sha512 |
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Tim Graham):

* stage: Unreviewed => Accepted

--
Ticket URL: <https://code.djangoproject.com/ticket/30240#comment:2>

[Django]

#30240: Add support for SHA database functions.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope

Type: New feature | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:

Keywords: sha1, sha224, | Triage Stage: Ready for
sha256, sha384, sha512 | checkin
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by felixxm):

* stage: Accepted => Ready for checkin

--
Ticket URL: <https://code.djangoproject.com/ticket/30240#comment:3>

[Django]

#30240: Add support for SHA database functions.
-------------------------------------+-------------------------------------
Reporter: Nick Pope | Owner: Nick Pope

Type: New feature | Status: closed

Component: Database layer | Version: master
(models, ORM) |

Severity: Normal | Resolution: fixed

Keywords: sha1, sha224, | Triage Stage: Ready for
sha256, sha384, sha512 | checkin

Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

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

Comment:

In [changeset:"0b70985f42da7a8eb2e206e6780681b7849564ef" 0b70985]:
{{{
#!CommitTicketReference repository=""
revision="0b70985f42da7a8eb2e206e6780681b7849564ef"
Fixed #30240 -- Added SHA1, SHA224, SHA256, SHA384, and SHA512 database
functions.

Thanks Mariusz Felisiak and Tim Graham for reviews.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/30240#comment:4>