[Gusdev-gusdev] updating a working gus installation....

[Michael L. <lu...@ug...>]

Hello-
If you would like to help us write some documentation on updating a
working GUS installation, please read the following and offer advice and
or answer the questions at the end.

We wanted to enter new data into GUS.  Mass Spec data.  This required
the use of a plug-in that was provided by Martin Fraunholz.  
The plugin needed two perl modules that we did not have.  
DoTS::MassSpecSummary and DoTS::MassSpecFeature.
These are plug-ins of the type that are automatically generated by a gus
install with regards to the tables that in the GUS schema
(how this is done we will explain later).

We did not have these modules in our $GUS_HOME/lib/perl/GUS/Model/DoTS/
directory.
This is because we did not have these tables in our schema.
So the problems are:
How to create the tables (easily done)
and how to get the modules to be generated.
And what order to do it in.

First thing to do is to create the tables.  You can get the sql commands
to do this from the latest version of CVS.  in
checkoutdir/GUS/Model/schema/oracle/dots-tables.sql

The description of the new tables then need to be entered into
Core.TableInfo, since (supposedly) this is the place that the GUS
installation will look for tables to create modules for.

Then, rebuild the GUS installation by executing the command:

build GUS install -append

This did not create the modules as we expected.  Additionally, all
sequences contained in GUS were reset to 1.  We have written a script to
set the sequences back to where they should be.    

Did we miss some step in between that would have created the modules? 
Is there a command that would have regenerated the GUS objects without
reseting the sequences back to 1?

Thanks in advance,
-- 
Michael Luchtan
http://www.cs.uga.edu/~luchtan