We want to automate certain aspects of setup. We already create the target database and put it in universe_wsgi.ini, but we want to plug some values into the tables during installation.
Currently, the schema is created the first time Galaxy is run. I did not see a way to cause that to happen via the manage_db.sh script. Have I missed something? If not, any pointers on how I might go about adding that (i.e. what stuff to call to just initialize the schema)?
John Duddy Sr. Staff Software Engineer Illumina, Inc. E-mail: jduddy@illumina.commailto:jduddy@illumina.com
On Nov 15, 2011, at 7:40 PM, Duddy, John wrote:
Currently, the schema is created the first time Galaxy is run. I did not see a way to cause that to happen via the manage_db.sh script. Have I missed something? If not, any pointers on how I might go about adding that (i.e. what stuff to call to just initialize the schema)?
There currently is not a way to create a db from scratch in manage_db.sh, but it shouldn't be hard to implement something like that. You want to look at:
galaxy.model.migrate.check.create_or_verify_database
Which is called in app.py during startup to create the database or print the message about needing an update.
It would be great to have a hook that when creating a new database would load initial data from files.
galaxy-dev@lists.galaxyproject.org