Re: [Gusdev-gusdev] deleting objects/rows

[Sucheta T. <su...@vb...>]

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