Re: [Gusdev-gusdev] deleting objects/rows

[Deborah F. P. <pi...@pc...>]

Hi,

DeleteEntries.pl deletes rows using DBI and executing a delete statement.
That is equivalent to doing a delete using sqlplus, for example, and
doesn't put anything in corresponding version tables.  Plugins, that use
objects to delete and don't explicitly avoid versioning, put rows into ver
tables when rows are updated or deleted. 

Version tables allow you to track changes and recover data if necessary 
while deleteEntries is unrecoverable. I don't think we use the version 
tables often but they are an important safeguard.

                                                   Debbie


On Tue, 4 May 2004, Sucheta
Tripathy wrote:

> Hi Terry,
> 
> I think this means that the data which are deleted could be stored in the 
> ver tables. However, I am not sure if this has to be done by the user or 
> the deleteEntries.pl takes care of it. In our case I did not get any 
> version of my deleted records stored in the -ver tables.
> 
> I think Debbie can comment on this.
> 
> Sucheta
> 
> At 03:24 PM 5/4/2004 -0500, you wrote:
> >It sounds like rows that are not intended to be completely cleaned
> >from the database, but the model is to keep a "version" around, is that 
> >right?
> >Could you help to expand on this: What is in that version & what/who uses it?
> >Most of what I know about GUS versioning concepts I have gleaned from reading
> >Perl code in the object layer with occasional comments.
> >Can you (or someone) summarize the in's and out's of GUS
> >versioning, or maybe point to some writeup?
> >
> >many thanks
> >
> >Terry
> >
> >
> >On Tue, May 04, 2004 at 04:14:13PM -0400, Deborah F. Pinney wrote:
> > > We only use deleteEntries.pl in selected cases where there are no
> > > children. DeleteEntries.pl would fail if there were children of a row
> > > being deleted because of foriegn key contraints. In most of the cases that
> > > we want to delete rows with children, we write a plugin using objects.
> > > In that case, unless specified otherwise, deleted rows are versioned. I
> > > don't think there are any examples in the GUS set of plugins but I can
> > > send you an attached text if you need it.
> > >
> > >                                                    Deborah Pinney
> > >
> > >
> > >
> > > On Tue, 4 May
> > > 2004, Gregory Carl Kettler wrote:
> > >
> > > > I was wondering if there's a canonical way to delete rows or objects from
> > > > GUS.  A simple "delete from table where..." would do it, but that can
> > > > easily make orphans of any child objects and doesn't update
> > > > Core::AlgorithmInvocation.  Still, that seems to be what deleteEntries.pl
> > > > does.
> > > > GusRow.pm seems a little more sophisticated, since it can delete
> > > > children and makes use of an object's markedDeleted attribute, but 
> > I'm not
> > > > sure if that attribute is stored in the database or used anywhere else.
> > > > Can I get any insight into how this works?
> > > >
> > > >     Greg Kettler
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by: Oracle 10g
> > > > Get certified on the hottest thing ever to hit the market... Oracle 10g.
> > > > Take an Oracle 10g class now, and we'll give you the exam FREE.
> > > > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> > > > _______________________________________________
> > > > Gusdev-gusdev mailing list
> > > > Gus...@li...
> > > > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> > > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by: Oracle 10g
> > > Get certified on the hottest thing ever to hit the market... Oracle 10g.
> > > Take an Oracle 10g class now, and we'll give you the exam FREE.
> > > http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> > > _______________________________________________
> > > Gusdev-gusdev mailing list
> > > Gus...@li...
> > > https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> >
> >
> >-------------------------------------------------------
> >This SF.Net email is sponsored by: Oracle 10g
> >Get certified on the hottest thing ever to hit the market... Oracle 10g.
> >Take an Oracle 10g class now, and we'll give you the exam FREE.
> >http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> >_______________________________________________
> >Gusdev-gusdev mailing list
> >Gus...@li...
> >https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE.
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>