[patch] Execute prefixed and sorted files for initial SQL data
|Reported by:||Owned by:||nobody|
|Component:||Core (Management commands)||Version:|
|Cc:||Triage Stage:||Design decision needed|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
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.