UpdateGusFromCla.pm
 

Location

Name

Description

Synopsis

Options and Arguments

Important

More

Bugs

Author

 


Location    

    /GUS/perl/lib/GUS30/Utils

Name    

    UpdateGusFromCla.pm

Description   

    This is a plug-in that update one GUS table from command line.

Synopsis   

    ga Utils::UpdateGusFromCla --help

    ga Utils::UpdateGusFromCla --tablename <string> --attrlist <string> --valuelist <string> --debug > logfile

    ga Utils::UpdateGusFromCla --tablename <string> --attrlist <string> --valuelist <string> --refresh --debug > logfile

    ga Utils::UpdateGusFromCla --tablename <string> --attrlist <string> --valuelist <string> --commit > logfile

 Options and Arguments   

 
--debug            optional boolean, default 0 debugging output,
--help  optional boolean, default 0 get usage; same as usage
--verbose optional boolean, default 0 lots of output
--commit optional boolean, default 0 if set, the plug-in will commit the data to database
--tablename mandatory string The format should be "databasename::tablename".
--attrlist mandatory string It will be a comma-separated list of attributes
--valuelist mandatory string It will be a comma-separated list of values for the attributes
--refresh optional boolean, default 0 If set, the plug-in will update one row in the table.
--user             optional string, must be one of user in Core::UserInfo table set value for row_user_id. default: (from your .gus30.cfg file)
--group             optional string, must be one of group in Core::GroupInfo table set value for row_group_id. default: (from your .gus30.cfg file)
--project optional string, must be one of project in Core::ProjectInfo table set value for row_project_id. default: (from your .gus30.cfg file)

Important   

    Before you can run this plug-in you need to create the Perl objects for the views you will be loading, should these objects not exist yet.

    The plug-in outputs a print statement to STDOUT (for possible redirection to a log file) which lists the number of data file lines read (counting empty lines, but not counting the header and the lines preceding it in the data file) and any warning statement(s) regarding data lines which have not been loaded into RAD3.

    Make sure your .gus30.cfg file contains the correct login name, which should be RAD3.

More   

attrlist   

    The attribute should be the same as defined in the schema. And it will be small-case.

refresh

    If this is set to 1, then the primary key must be specified in the "attrlist" argument. The plug-in will update the row with new modification data and algorithmInvocation regardless if has changed from the database

valuelist

    The order of values in the list will correspond to the order of attributes in the "attrlist" argument.

Bugs   

    To be reported

Author   

Junmin Liu, junmin@pcbi.upenn.edu