[Django] #29517: Add support for SQLite column check constraints

14 views
Skip to first unread message

Django

unread,
Jun 22, 2018, 2:42:35 PM6/22/18
to django-...@googlegroups.com
#29517: Add support for SQLite column check constraints
-------------------------------------+-------------------------------------
Reporter: Tim | Owner: Tim Graham
Graham |
Type: | Status: assigned
Cleanup/optimization |
Component: Database | Version: master
layer (models, ORM) |
Severity: Normal | Keywords:
Triage Stage: Accepted | Has patch: 0
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
SQLite supports check constraints on positive integer fields but it's
never been implemented in Django like it has for other databases.

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

Django

unread,
Jun 22, 2018, 3:22:40 PM6/22/18
to django-...@googlegroups.com
#29517: Add SQLite support for column check constraints on positive integer fields
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Tim
Type: | Graham
Cleanup/optimization | Status: assigned
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Tim Graham):

* has_patch: 0 => 1


Comment:

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

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

Django

unread,
Jun 25, 2018, 3:31:47 AM6/25/18
to django-...@googlegroups.com
#29517: Add SQLite support for column check constraints on positive integer fields
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Tim
Type: | Graham
Cleanup/optimization | Status: closed

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Claude Paroz <claude@…>):

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


Comment:

In [changeset:"4c36414323d9035a93a2b7a54ff5281116950fe1" 4c36414]:
{{{
#!CommitTicketReference repository=""
revision="4c36414323d9035a93a2b7a54ff5281116950fe1"
Fixed #29517 -- Rephrased error message when passing incorrect kwarg to
model constructor
}}}

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

Django

unread,
Jun 25, 2018, 3:33:15 AM6/25/18
to django-...@googlegroups.com
#29517: Add SQLite support for column check constraints on positive integer fields
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Tim
Type: | Graham
Cleanup/optimization | Status: new

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Claude Paroz):

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


Comment:

Sorry, bad ticket number in another commit.

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

Django

unread,
Jun 25, 2018, 2:30:58 PM6/25/18
to django-...@googlegroups.com
#29517: Add SQLite support for column check constraints on positive integer fields
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Tim
Type: | Graham
Cleanup/optimization | Status: closed

Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Tim Graham <timograham@…>):

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


Comment:

In [changeset:"b9cf764be62e77b4777b3a75ec256f6209a57671" b9cf764]:
{{{
#!CommitTicketReference repository=""
revision="b9cf764be62e77b4777b3a75ec256f6209a57671"
Fixed #29517 -- Added support for SQLite column check constraints on
positive integer fields.
}}}

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

Django

unread,
Dec 27, 2021, 12:17:53 AM12/27/21
to django-...@googlegroups.com
#29517: Add SQLite support for column check constraints on positive integer fields
-------------------------------------+-------------------------------------
Reporter: Tim Graham | Owner: Tim
Type: | Graham
Cleanup/optimization | Status: closed
Component: Database layer | Version: dev

(models, ORM) |
Severity: Normal | Resolution: fixed
Keywords: | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

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

Comment (by GitHub <noreply@…>):

In [changeset:"ff225fac1d129d4bcfef0aeb03df6f3b20fbb23d" ff225fac]:
{{{
#!CommitTicketReference repository=""
revision="ff225fac1d129d4bcfef0aeb03df6f3b20fbb23d"
Refs #29517 -- Removed obsolete PositiveIntegerField test skip.
}}}

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

Reply all
Reply to author
Forward
0 new messages