Forum OpenACS Development: What's the right way to delete rows from cr_items/cr_revisions?

Collapse
1: What's the right way to delete rows from cr_items/cr_revisions?
Posted by Janine Ohmer on 06/23/04 11:16 PM
I have a need to delete a bunch of rows from the CR tables.  I looked in acs-content-repository/tcl/item-procs.tcl but there doesn't seem to be a delete function there.  What is the "approved" way of doing this, so any loose ends get cleaned up properly?  TIA!
Collapse
2: Re: What's the right way to delete rows from cr_items/cr_revisions? (response to 1)
Posted by Randy O'Meara on 06/24/04 06:22 AM
Janine,

Check out the bcms-ui-base package. I believe this is the way oacs is leaning (bcms::item::delete_item -item_id item_id).

/R

Collapse
3: Re: What's the right way to delete rows from cr_items/cr_revisions? (response to 1)
Posted by Claudio Pasolini on 06/24/04 10:30 AM
... meanwhile you can always use the PG functions content_item__delete and content_revision__delete or the Oreacle equivalents.
Collapse
4: Re: What's the right way to delete rows from cr_items/cr_revisions? (response to 1)
Posted by Dave Bauer on 06/24/04 03:13 PM
Randy,

on HEAD there is a tcl API in content-item-procs.tcl

content::item::delete

For 5.1 you'll need to use the pl/sql api.