Re: [GUSDEV] new Undo plugin

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

oops, i had a typo.

i meant to say "one could find every row in the database that a 
particular plugin introduced..."

steve

Steve Fischer wrote:

> 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...>
>>
>>
>>
>
>
> -------------------------------------------------------
> 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...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev