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

[Bastian Kleineidam <calvin@…>]

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.

[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.

[Russell Keith-Magee]

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