Opened 6 years ago

Closed 6 years ago

Last modified 22 months ago

#30240 closed New feature (fixed)

Add support for SHA database functions.

Reported by: Nick Pope Owned by: Nick Pope
Component: Database layer (models, ORM) Version: dev
Severity: Normal Keywords: sha1, sha224, sha256, sha384, sha512
Cc: Triage Stage: Ready for checkin
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

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.

Change History (5)

comment:1 by Nick Pope, 6 years ago

Has patch: set

comment:2 by Tim Graham, 6 years ago

Triage Stage: UnreviewedAccepted

comment:3 by Mariusz Felisiak, 6 years ago

Triage Stage: AcceptedReady for checkin

comment:4 by Mariusz Felisiak <felisiak.mariusz@…>, 6 years ago

Resolution: fixed
Status: assignedclosed

In 0b70985:

Fixed #30240 -- Added SHA1, SHA224, SHA256, SHA384, and SHA512 database functions.

Thanks Mariusz Felisiak and Tim Graham for reviews.

comment:5 by GitHub <noreply@…>, 22 months ago

In 04fdf71:

Refs #30240 -- Fixed argument name for MySQLSHA2Mixin.as_mysql() and PostgreSQLSHAMixin.as_postgresql() methods.

Note: See TracTickets for help on using tickets.
Back to Top