#23136 closed Cleanup/optimization (fixed)

sqlclear does not notify operator that there is nothing to clear

Reported by: jackiekazil Owned by: gmunumel
Component: Core (Management commands) Version: master
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: yes
Easy pickings: yes UI/UX: no


I tried passing sqlclear to dbshell and came up with this error, which was non-descript.

$ django-admin.py sqlclear foia_core | django-admin.py dbshell
ERROR:  syntax error at or near "/"
LINE 1: /Users/jacquelinekazil/Projects/code/foia/foia-core/foia_cor...

Then I tried running each command separately. When I ran sqlclear, nothing appeared to happened.

$ django-admin.py sqlclear foia_core

This is confusing to user if they are expecting something to happen. There should be output to tell the user what happened.
Example: Foo app has no tables in the database.

Change History (10)

comment:1 Changed 22 months ago by russellm

  • Needs documentation unset
  • Needs tests unset
  • Patch needs improvement unset
  • Triage Stage changed from Unreviewed to Accepted

Sounds reasonable, and shouldn't be too hard to implement either. Might be worth checking if other sql* commands are also affected as well.

comment:2 Changed 22 months ago by timo

I believe most of the sql* commands besides sqlmigrate are headed down the deprecation path, so this might not be worth it.

comment:3 Changed 22 months ago by gmunumel

I´d like to implement this if there is not objection.

comment:4 Changed 22 months ago by gmunumel

  • Owner changed from nobody to gmunumel
  • Status changed from new to assigned

comment:6 Changed 22 months ago by timo

Couple of issues:

  • New features are going to master only (not 1.6).
  • I only see a test in your commit, not the functional changes (and it isn't an actual pull request).

comment:8 Changed 22 months ago by timo

  • Has patch set
  • Patch needs improvement set
  • Version changed from 1.6 to master

comment:9 Changed 22 months ago by gmunumel

I made the changes Timo

comment:10 Changed 21 months ago by timgraham

  • Resolution set to fixed
  • Status changed from assigned to closed

In 3e241313a4cea5dbf53068181408a7c34f00c9ca:

Fixed #23136 -- Added a message when sqlclear does nothing

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