#30595: sqlsequencereset silently exits if there's nothing to do, without
informing
the user
-------------------------------------+-------------------------------------
Reporter: Keryn | Owner: nobody
Knight |
Type: New | Status: new
feature |
Component: Core | Version: 2.2
(Management commands) |
Severity: Normal | Keywords:
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
This just came up on IRC, because someone was expecting `sqlsequencereset`
to provide resets for the auto-increment values for an SQLite table.
Running `python manage.py sqlsequencereset <myapp>` provides no output if
there are no results returned by `connection.ops.sequence_reset_sql` (see
[https://github.com/django/django/blob/26d16c07fdc4a297daca554afa6375c70d6d82a9/django/core/management/commands/sqlsequencereset.py#L23
here])
So the user has no idea if it failed, succeeded, or they got the
invocation wrong (assuming they're not familiar enough with Django to know
that invoking it wrong will raise a `CommandError`).
I'd suggest it should avoid ambiguity, so if `len(statements) == 0` it
should raise `CommandError` and say there's nothing to do. Bonus points if
it also sniffs the connection backend to know if there is anything it
**could** do, and if there's not, report that `sqlsequencereset` isn't
necessary/available for that backend.
--
Ticket URL: <https://code.djangoproject.com/ticket/30595>
Django <https://code.djangoproject.com/>
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 [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/052.c148f7dfc980a608c418d31430ce4e7a%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
