From: Steve F. <sfi...@pc...> - 2012-04-09 10:57:44
|
yes, nicolas, that will work. steve On 4/9/2012 3:20 AM, Nicolas Joannin wrote: > Hi again, > > Disclaimer: I am not a Perl programmer, so please forgive me if I > suggest something totally ridiculous etc. > > Going through the ExternalDatabaseRls plugin, I see at line 226 (and > in subsequent GusRow and DbiRow modules) that it checks to see if the > attribute "id_is_alias" exists in the table ExternalDatabaseRelease, > which, in the GUS I retrieved from the svn, is absent. > Would a quick and dirty fix be to comment out that line (as shown below)? > > Best regards, > Nicolas > > > The resulting sub in the ExternalDatabaseRls plugin would be as follows: > > sub makeNewReleaseId{ > my ($self, $id) = @_; > my $dbVer = $self->getArg('databaseVersion'); > > my $newRelease = GUS::Model::SRes::ExternalDatabaseRelease->new({ > external_database_id => $id, > version => $dbVer, > download_url => $self->getArg('downloadUrl'), > id_type => $self->getArg('idType'), > id_url => $self->getArg('idUrl'), > #id_is_alias => $self->getArg('idIsAlias'), > secondary_id_type => $self->getArg('secondaryIdType'), > secondary_id_url => $self->getArg('secondaryIdUrl'), > description => $self->getArg('description'), > file_name => $self->getArg('fileName'), > file_md5 => $self->getArg('fileMd5'), > }); > > $newRelease->submit(); > my $newReleasePk = $newRelease->getId(); > > return $newReleasePk; > > } > > > On Mon, Apr 9, 2012 at 15:25, Nicolas Joannin > <nic...@gm... <mailto:nic...@gm...>> wrote: > > Hi Steve, > > Thanks for the quick response. > Please let me know the conclusions to your discussions. > In the mean time, I will go through the different modules to try > and better understand what's going on. > > Best regards, > Nicolas > > On Fri, Apr 6, 2012 at 22:55, > <gus...@li... > <mailto:gus...@li...>> wrote: > > Send Gusdev-gusdev mailing list submissions to > gus...@li... > <mailto:gus...@li...> > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > or, via email, send a message with subject or body 'help' to > gus...@li... > <mailto:gus...@li...> > > You can reach the person managing the list at > gus...@li... > <mailto:gus...@li...> > > When replying, please edit your Subject line so it is more > specific > than "Re: Contents of Gusdev-gusdev digest..." > > > Today's Topics: > > 1. Re: Problem with InsertExternalDatabaseRls plugin (Steve > Fischer) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 06 Apr 2012 09:55:29 -0400 > From: Steve Fischer <sfi...@pc... > <mailto:sfi...@pc...>> > Subject: Re: [GUSDEV] Problem with InsertExternalDatabaseRls > plugin > To: gus...@li... > <mailto:gus...@li...> > Message-ID: <4F7...@pc... > <mailto:4F7...@pc...>> > Content-Type: text/plain; charset="iso-8859-1" > > Nicolas- > > The problem is a mismatch between the plugin and the schema. The > plugin has been upgraded to conform with an in-house schema > enhancement. Your schema does not have the enhancement. > > We'll need to discuss this here, to figure out how to best > resolve it. > > Sorry for the inconvenience. > > Steve > > On 4/6/2012 3:10 AM, Nicolas Joannin wrote: > > Hello everyone, > > > > I have successfully installed GUS and am now struggling a > bit to get > > data into it. > > I am facing several problems, but will decline them in > different email > > threads as I get blocked on my way... > > > > The current blocking point I'm at is with > InsertExternalDatabaseRls. > > In order to use InsertSequenceFeature, I need to have a > > database+version in my DB. The data I'm trying to insert was > > downloaded strait from Genbank, just to test the whole process. > > I managed to insert a row with InsertExternalDatabase, but I am > > failing with this one. You'll find below the output I get > from the > > terminal. > > > > I really can't figure out what I'm doing wrong. I hope you > can help me! > > Best regards, > > > > Nicolas > > > > > > Terminal output: > > > > ga GUS::Supported::Plugin::InsertExternalDatabaseRls > --databaseName > > Genbank --releaseDate '15 Feb 2012' --databaseVersion 188.0 > > --downloadUrl ftp://ftp.ncbi.nih.gov/genbank/ > > Fri Apr 6 15:54:24 2012INFOPlugin > > GUS::Supported::Plugin::InsertExternalDatabaseRls registered > with cvs > > revision '10163' > > Fri Apr 6 15:54:24 2012DSNdbi:Pg:dbname=varDB_2012 > > Fri Apr 6 15:54:24 > > 2012PLUGINGUS::Supported::Plugin::InsertExternalDatabaseRls > > Fri Apr 6 15:54:24 2012ARGalgoinvo1 > > Fri Apr 6 15:54:24 2012ARGcomment > > Fri Apr 6 15:54:24 2012ARGcommit0 > > Fri Apr 6 15:54:24 2012ARGdatabaseNameGenbank > > Fri Apr 6 15:54:24 2012ARGdatabaseVersion188.0 > > Fri Apr 6 15:54:24 2012ARGdebug0 > > Fri Apr 6 15:54:24 2012ARGdescription > > Fri Apr 6 15:54:24 > 2012ARGdownloadUrlftp://ftp.ncbi.nih.gov/genbank/ > <http://ftp.ncbi.nih.gov/genbank/> > > Fri Apr 6 15:54:24 2012ARGfileMd5 > > Fri Apr 6 15:54:24 2012ARGfileName > > Fri Apr 6 15:54:24 2012ARGgroup > > Fri Apr 6 15:54:24 > > > 2012ARGgusconfigfile/Users/Nicolas/GUS/gus_home/config/gus.config > > Fri Apr 6 15:54:24 2012ARGhelp0 > > Fri Apr 6 15:54:24 2012ARGhelpHTML0 > > Fri Apr 6 15:54:24 2012ARGidIsAlias0 > > Fri Apr 6 15:54:24 2012ARGidType > > Fri Apr 6 15:54:24 2012ARGidUrl > > Fri Apr 6 15:54:24 2012ARGproject > > Fri Apr 6 15:54:24 2012ARGreleaseDate15 Feb 2012 > > Fri Apr 6 15:54:24 2012ARGsecondaryIdType > > Fri Apr 6 15:54:24 2012ARGsecondaryIdUrl > > Fri Apr 6 15:54:24 2012ARGsqlVerbose0 > > Fri Apr 6 15:54:24 2012ARGuser > > Fri Apr 6 15:54:24 2012ARGverbose0 > > Fri Apr 6 15:54:24 2012ARGveryVerbose0 > > Fri Apr 6 15:54:24 2012ARGworkflowstepid0 > > Fri Apr 6 15:54:24 2012AlgInvocationId12 > > Fri Apr 6 15:54:24 2012COMMITcommit off > > > > ERROR: > > ERROR: attempting to access attribute 'id_is_alias' of table > > ExternalDatabaseRelease, but that table does not have such > an attribute > > > > at > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 746 > > > GUS::ObjRelP::DbiRow::checkAttribute('GUS::ObjRelP::DbiRow=HASH(0x100c30e50)', > > 'id_is_alias') called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 753 > > > GUS::ObjRelP::DbiRow::checkAttributeHash('GUS::ObjRelP::DbiRow=HASH(0x100c30e50)', > > 'HASH(0x100c89568)') called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 179 > > > GUS::ObjRelP::DbiRow::setAttributes('GUS::ObjRelP::DbiRow=HASH(0x100c30e50)', > > 'HASH(0x100c30df0)') called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 42 > > GUS::ObjRelP::DbiRow::new('GUS::ObjRelP::DbiRow', > > 'GUS::Model::SRes::ExternalDatabaseRelease', > 'HASH(0x100c30df0)', > > undef, undef) called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/Model/GusRow.pm line 25 > > > GUS::Model::GusRow::new('GUS::Model::SRes::ExternalDatabaseRelease', > > 'HASH(0x100c30df0)') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertExternalDatabaseRls.pm > > line 220 > > > GUS::Supported::Plugin::InsertExternalDatabaseRls::makeNewReleaseId('GUS::Supported::Plugin::InsertExternalDatabaseRls=HASH(0x100a...', > > 1) called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertExternalDatabaseRls.pm > > line 180 > > > GUS::Supported::Plugin::InsertExternalDatabaseRls::run('GUS::Supported::Plugin::InsertExternalDatabaseRls=HASH(0x100a...', > > 'HASH(0x100c29838)') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 602 > > eval {...} called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 591 > > > GUS::PluginMgr::GusApplication::doMajorMode_RunOrReport('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'GUS::Supported::Plugin::InsertExternalDatabaseRls', 1) > called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 508 > > > GUS::PluginMgr::GusApplication::doMajorMode_Run('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'GUS::Supported::Plugin::InsertExternalDatabaseRls') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 394 > > > GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'GUS::Supported::Plugin::InsertExternalDatabaseRls') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 303 > > > GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'ARRAY(0x100829b60)') called at > /Users/Nicolas/GUS/gus_home/bin/ga line 11 > > > > STACK TRACE: > > at > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 746 > > > GUS::ObjRelP::DbiRow::checkAttribute('GUS::ObjRelP::DbiRow=HASH(0x100c30e50)', > > 'id_is_alias') called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 753 > > > GUS::ObjRelP::DbiRow::checkAttributeHash('GUS::ObjRelP::DbiRow=HASH(0x100c30e50)', > > 'HASH(0x100c89568)') called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 179 > > > GUS::ObjRelP::DbiRow::setAttributes('GUS::ObjRelP::DbiRow=HASH(0x100c30e50)', > > 'HASH(0x100c30df0)') called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/ObjRelP/DbiRow.pm > line 42 > > GUS::ObjRelP::DbiRow::new('GUS::ObjRelP::DbiRow', > > 'GUS::Model::SRes::ExternalDatabaseRelease', > 'HASH(0x100c30df0)', > > undef, undef) called at > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/Model/GusRow.pm line 25 > > > GUS::Model::GusRow::new('GUS::Model::SRes::ExternalDatabaseRelease', > > 'HASH(0x100c30df0)') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertExternalDatabaseRls.pm > > line 220 > > > GUS::Supported::Plugin::InsertExternalDatabaseRls::makeNewReleaseId('GUS::Supported::Plugin::InsertExternalDatabaseRls=HASH(0x100a...', > > 1) called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/Supported/Plugin/InsertExternalDatabaseRls.pm > > line 180 > > > GUS::Supported::Plugin::InsertExternalDatabaseRls::run('GUS::Supported::Plugin::InsertExternalDatabaseRls=HASH(0x100a...', > > 'HASH(0x100c29838)') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 602 > > eval {...} called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 591 > > > GUS::PluginMgr::GusApplication::doMajorMode_RunOrReport('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'GUS::Supported::Plugin::InsertExternalDatabaseRls', 1) > called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 508 > > > GUS::PluginMgr::GusApplication::doMajorMode_Run('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'GUS::Supported::Plugin::InsertExternalDatabaseRls') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 394 > > > GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'GUS::Supported::Plugin::InsertExternalDatabaseRls') called at > > > /Users/Nicolas/GUS/gus_home/lib/perl/GUS/PluginMgr/GusApplication.pm > > line 303 > > > GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr::GusApplication=HASH(0x100803ae8)', > > 'ARRAY(0x100829b60)') called at > /Users/Nicolas/GUS/gus_home/bin/ga line 11 > > > > > > > > > ------------------------------------------------------------------------------ > > For Developers, A Lot Can Happen In A Second. > > Boundary is the first to Know...and Tell You. > > Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! > > http://p.sf.net/sfu/Boundary-d2dvs2 > > > > > > _______________________________________________ > > Gusdev-gusdev mailing list > > Gus...@li... > <mailto:Gus...@li...> > > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > -------------- next part -------------- > An HTML attachment was scrubbed... > > ------------------------------ > > ------------------------------------------------------------------------------ > For Developers, A Lot Can Happen In A Second. > Boundary is the first to Know...and Tell You. > Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! > http://p.sf.net/sfu/Boundary-d2dvs2 > > ------------------------------ > > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > <mailto:Gus...@li...> > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > > > End of Gusdev-gusdev Digest, Vol 23, Issue 2 > ******************************************** > > > > > > ------------------------------------------------------------------------------ > For Developers, A Lot Can Happen In A Second. > Boundary is the first to Know...and Tell You. > Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! > http://p.sf.net/sfu/Boundary-d2dvs2 > > > _______________________________________________ > Gusdev-gusdev mailing list > Gus...@li... > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev |