Thread: [Gusdev-gusdev] How are the dotsver etc. schemas are used in the version control?

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

>Hi:

Can anyone tell me how the vers schemas are used in the version control of 
the GUS?

Thanks!

Derek

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

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

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

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

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
>>
>

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
>