Re: [GUSDEV] new Undo plugin

[Steve F. <sfi...@pc...>]

there is one algorithm_invocation_id per plugin run.

in theory, one could find every row in the database that a particular 
row introduced by checking every row for that algorithm_invocation_id.   
the problem is that it would take too much time to do that.   so, the 
compromise i implemented in the Undo-er is that the author of the plugin 
manually specifies the tables to search.  

the tracking of the plugin version is very stringent. we store in the 
database the md5 checksum of the plugin file.  if the plugin has 
changed, then it is re-registered in the database.

steve

Chris Stoeckert wrote:

>> Is there a way of enforcing plugin version tracking?  I guess what 
>> I'm asking is, is there a way to detect if a plugin has been modified 
>> since its last use?
>
> Yes, through AlgorithmImplementation (AlgorithmInvocation points to 
> this table)
> see 
> http://www.gusdb.org/SchemaBrowser/table.htm?schema=Core&table=AlgorithmImplementation 
> <http://www.gusdb.org/SchemaBrowser/table.htm?schema=Core&table=AlgorithmImplementation>
>
> Chris
>
> On Oct 30, 2005, at 12:55 PM, Chris Topinka wrote:
>
>> what about storing which row/tables were updated by an 
>> algorithm_invocation_ids?  I'm new to GUS.  Is this done already?  Am 
>> I correct in assuming that algorithm_invocation_ids are created every 
>> time a particular plugin (algorithm) is run or are there multiple 
>> algorithm_invocation_ids per plugin run? 
>>
>> Is there a way of enforcing plugin version tracking?  I guess what 
>> I'm asking is, is there a way to detect if a plugin has been modified 
>> since its last use?
>>
>>  
>>
>> On 10/30/05, *Steve Fischer* <sfi...@pc... 
>> <mailto:sfi...@pc...>> wrote:
>>
>>     i like the idea of checking the name of the plugin.  I'll do that.
>>
>>     as far as the plugin evolving, i guess that is a mirky area.  
>>     I'll add
>>     that to the risks.  My main answer is that I envision Undo to be
>>     applied
>>     shortly after the data is loaded, so the presumption is that the
>>     evolution is small and known.
>>
>>     steve
>>
>>     Jonathan Schug wrote:
>>
>>     > Steve:
>>     >
>>     > Does the Undo plugin check to see that the
>>     algorithm_invocation_ids
>>     > belong to the target plugin?  That would add a measure of
>>     safety.  Of
>>     > course we'd probably need an override if a plugin has since changed
>>     > names.  What if the plugin changes the tables it touches.  I guess
>>     > the undoTables() has to return a comprehensive list?
>>     >
>>     > Jonathan
>>     >
>>     >
>>     >
>>     >
>>     > Jonathan Schug - js...@pc...
>>     <mailto:js...@pc...>
>>     >
>>     >
>>     >
>>     > -------------------------------------------------------
>>     > This SF.Net email is sponsored by the JBoss Inc.
>>     > Get Certified Today * Register for a JBoss Training Course
>>     > Free Certification Exam for All Training Attendees Through End
>>     of 2005
>>     > Visit http://www.jboss.com/services/certification for more
>>     information
>>     > _______________________________________________
>>     > Gusdev-gusdev mailing list
>>     > Gus...@li...
>>     <mailto:Gus...@li...>
>>     > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>     <https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev>
>>
>>
>>
>>     -------------------------------------------------------
>>     This SF.Net email is sponsored by the JBoss Inc.
>>     Get Certified Today * Register for a JBoss Training Course
>>     Free Certification Exam for All Training Attendees Through End of
>>     2005
>>     Visit http://www.jboss.com/services/certification for more
>>     information
>>     _______________________________________________
>>     Gusdev-gusdev mailing list
>>     Gus...@li...
>>     <mailto:Gus...@li...>
>>     https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>
>>
>>
>>
>> -- 
>> Christopher M. Topinka
>> NLM-BHIRT Predoctoral Fellow in Computer Science
>> 113 Life Sciences Center
>> University of Missouri
>> Columbia, MO 65211
>> (573)-823-0616
>> cmt...@mi... <mailto:cmt...@mi...>
>
>