Code

Opened 8 years ago

Closed 7 years ago

#3070 closed enhancement (wontfix)

[patch] Execute prefixed and sorted files for initial SQL data

Reported by: Bastian Kleineidam <calvin@…> Owned by: nobody
Component: Core (Management commands) Version:
Severity: normal Keywords:
Cc: Triage Stage: Design decision needed
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:

Description

I had the need to execute initial SQL statements in a certain order. This patch looks not only for $model.sql and $model.$dbwrapper.sql, but also for any filename that ends with one of those two patterns. Furthermore, the files are alphabetically sorted before execution.

With these two enhancements, it is for example possible to have a sorted SQL file list which is processed in alphabetical order:

sql/01_blog.sql
sql/02_blogentry.sql
...

Another feature is that all SQL commands are printed when the verbosity level is greater than two.

A downside (or for me, this is an upside ;) is that with the patch, all initial SQL commands are executed in one single transaction. Either all or none initial SQL commands for newly detected models get applied.

Attachments (1)

django_management_sql.diff (7.4 KB) - added by Bastian Kleineidam <calvin@…> 8 years ago.

Download all attachments as: .zip

Change History (4)

Changed 8 years ago by Bastian Kleineidam <calvin@…>

comment:1 Changed 7 years ago by Simon G. <dev@…>

  • Triage Stage changed from Unreviewed to Design decision needed

comment:2 Changed 7 years ago by calvin@…

It is nice to have sorted files, but I guess fixtures are the preferred way to get data into the database now.
If nobody really needs this, you can close my ticket.

comment:3 Changed 7 years ago by russellm

  • Resolution set to wontfix
  • Status changed from new to closed

Closed at the request of the original requester, coupled with the fact that the use case it covers is now covered by fixtures.

Add Comment

Modify Ticket

Change Properties
<Author field>
Action
as closed
as The resolution will be set. Next status will be 'closed'
The resolution will be deleted. Next status will be 'new'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.