Re: [Gusdev-gusdev] How are the dotsver etc. schemas are used

[Paul M. <pj...@sa...>]

Hi,

while on the subject, how many people have used the version tables to 
access old data?
We can store the old data but we don't (yet?) pulll it out.
If I wanted to reconstruct what a gene looked like (sequence, GO 
assignments, Pfam, etc) 2 weeks ago I think it would take quite a bit 
of coding. Not sure if the object layer can help...?

Paul.

On 9 Dec 2004, at 19:52, Deborah Pinney wrote:

> Hi Derek,
> No you don't want to version the version tables so you don't want to 
> set their is_versioned attribute to 1, just the non-version tables. As 
> I said, when using the objects to insert, update or delete, there is 
> automatic versioning in your case (is_versioned =1 for all the 
> tables). With a script that uses DBI, the script must explicity insert 
> into the version tables before deleting. If you are deleting using 
> something like sqlplus, there will not be any versioning unless you do 
> it, again explicity, prior to deleting from teh non-version table. I 
> don't know how you deleted but if you did it with dbvis or sqlplus, 
> there would be no entries into the version tables. So, you can't 
> conclude that versioning is not working.
>
>                                                                        
>                                                             -Debbie
>
>
> Dequan (Derek) Kong wrote:
>
>> Hi Deborah:
>>
>> Thanks!
>>
>> I checked my database.  I found that the  is_version of 
>> core.tableinfo is all set to 1 in the standard schema tables, but 
>> they are set to 0 in all the tables of the version  schema.  Do I 
>> have to change all of them to 1.  Would you please explain a little 
>> bit more about how the version system in GUS works?  I have deleted 
>> many rows from my GUS database, but I did not find any row inserted 
>> into the table of version schema.  Is this means that my version 
>> system does not work or I need to configure other stuff to make it 
>> work!
>>
>> By the way, how and when did those 1 or 0 in the core.tableinfo are 
>> set?
>>
>> Thanks again for your help!
>>
>> Derek
>>
>>
>>
>>
>> At 01:16 PM 12/9/2004 -0500, Deborah Pinney wrote:
>>
>>> Hi Derek,
>>> I'm sorry to disappoint you but I have not written such a script and 
>>> don't know of one. The table objects can automatically version and 
>>> will if core.TableInfo.is_versioned is set to 1 (not nullable).  
>>> When versioning is on, rows are put into the corresponding 
>>> spacever.tablever when rows are being deleted or updated. The 
>>> primary key of the version tables is a combination of PK and 
>>> modification date (from the original row). Apart from the objects, 
>>> there are scripts for specific purposes that put rows in the 
>>> corresponding version table prior to  deleting them. These scripts  
>>> generally  do this using DBI do statements.
>>>
>>> Does anyone else know about a plugin or script dealing with 
>>> versioning?
>>>
>>>                                                                     
>>> -Debbie
>>>
>>>
>>>
>>> Dequan (Derek) Kong wrote:
>>>
>>>> To Debbie Pinney
>>>>
>>>> Hi Debbie:
>>>>
>>>> Sucheta told me that you have written a plugin or program in CBIL 
>>>> to control the data Version using  the ver schemas in GUS.  Can I 
>>>> get the plugin or program if you have one?
>>>>
>>>> Thanks!
>>>>
>>>> Derek
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> At 10:19 AM 12/9/2004 -0500, Sucheta Tripathy wrote:
>>>>
>>>>> Hi Derek,
>>>>>
>>>>> The ver schema is used for storing any deleted objects from the 
>>>>> main database.
>>>>>
>>>>>  The deleteentry.pl script does not take care of it. Either the 
>>>>> user
>>>>> has to do it himself or get it from CBIL (they have a script, 
>>>>> which does that.)
>>>>>
>>>>> cheers
>>>>>
>>>>> Sucheta
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> At 08:14 AM 12/9/2004 -0500, Dequan (Derek) Kong wrote:
>>>>>
>>>>>>> Hi:
>>>>>>
>>>>>>
>>>>>>
>>>>>> Can anyone tell me how the vers schemas are used in the version 
>>>>>> control of the GUS?
>>>>>>
>>>>>> Thanks!
>>>>>>
>>>>>> Derek
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> -------------------------------------------------------
>>>>>> SF email is sponsored by - The IT Product Guide
>>>>>> Read honest & candid reviews on hundreds of IT Products from real 
>>>>>> users.
>>>>>> Discover which products truly live up to the hype. Start reading 
>>>>>> now. http://productguide.itmanagersjournal.com/
>>>>>> _______________________________________________
>>>>>> Gusdev-gusdev mailing list
>>>>>> Gus...@li...
>>>>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>> -------------------------------------------------------
>>>> SF email is sponsored by - The IT Product Guide
>>>> Read honest & candid reviews on hundreds of IT Products from real 
>>>> users.
>>>> Discover which products truly live up to the hype. Start reading 
>>>> now. http://productguide.itmanagersjournal.com/
>>>> _______________________________________________
>>>> Gusdev-gusdev mailing list
>>>> Gus...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>
>>
>
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real 
> users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>