From: Nicolas J. <nic...@gm...> - 2012-04-09 11:02:26
|
Hi Steve, Thanks: I'll do that then. Best regards, Nicolas On Mon, Apr 9, 2012 at 19:57, Steve Fischer <sfi...@pc...> wrote: > 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...>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...> wrote: >> >>> Send Gusdev-gusdev mailing list submissions to >>> 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... >>> >>> You can reach the person managing the list at >>> 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...> >>> Subject: Re: [GUSDEV] Problem with InsertExternalDatabaseRls plugin >>> To: gus...@li... >>> Message-ID: <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/ >>> > 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... >>> > 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... >>> 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 lis...@li...https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev > > |