Bootstrapping the Galaxy installation process: populating the database
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.com<mailto: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.
participants (2)
-
Duddy, John -
James Taylor