aishee / sqlalchemy-migrate

Automatically exported from code.google.com/p/sqlalchemy-migrate
MIT License
0 stars 0 forks source link

support for data sql scripts #53

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
The current version of sqlalchemy-migrate is perfectly fine for managing
DDL scripts.

However, it is sometimes also necessary to launch data-insertion scripts
(default user and roles, etc.). These scripts are special as they have to
be ignored in specific cases (e.g. when running unit tests, they need not
be run).

A data script is usually tied to a schema version:
for instance, if we have 2 DDL scripts (001, 002), and 2 data scripts:
001_001, and 002_001, then migrate should run the scripts in the following
order :
ddl_001
data_001_001
ddl_002
data_002_001

regards,
Sami Dalouche 

Original issue reported on code.google.com by sami.dal...@gmail.com on 10 Apr 2009 at 1:15

GoogleCodeExporter commented 8 years ago
Maybe we should add a way to run DDL script without affecting versions or 
anything. It 
should fall into this case also. Will that suit your needs?

Original comment by iElect...@gmail.com on 12 Jun 2009 at 11:05

GoogleCodeExporter commented 8 years ago
yeah, I guess it would allow running scripts that don't fit in the linear 
versionning
scheme. 

Original comment by sami.dal...@gmail.com on 14 Jun 2009 at 3:08

GoogleCodeExporter commented 8 years ago

Original comment by iElect...@gmail.com on 15 Jul 2010 at 9:09