Re: How to delete a catalog or catagory ?

[Jacques Le Roux <ja...@les7arts.com>]

Stumbled upon this message by chance. The page in wiki have been deleted (still restorable, not sure of value I don't remember if I 
did or someone else...)
I wonder if it's not time to had a look at the ON DELETE CASCADE possibilities...
http://en.wikipedia.org/wiki/Foreign_key#Referential_Actions

Jacques


From: "Jacques Le Roux" <ja...@les7arts.com>
>I have done something very raw for now at
> http://docs.ofbiz.org/display/OFBENDUSER/How+to+delete+tuples+added+to+test+a+setup
>
> WIP...
>
> Jacques
>
> From: "Jacques Le Roux" <jl...@apache.org>
>> Note that my intention is to have a handy tool just to delete tests data after installation.
>>
>> Jacques
>>
>> From: "Zhibin Liang" <li...@gmail.com>
>>> Thanks again all for the comment. It would be great if we could add the
>>> delete functions. In terms of "auditing", if we could audit the "delete"
>>> actions as well, it should be non-issue then.
>>>
>>> Regards,
>>> Zhibin
>>>
>>> -----Original Message-----
>>> From: Ruth Hoffman [mailto:rhoffman@aesolves.com] Sent: Tuesday, November 10, 2009 9:20 AM
>>> To: user@ofbiz.apache.org
>>> Subject: Re: How to delete a catalog or catagory ?
>>>
>>> Hi Jacques:
>>> This is something I tried to get the group to look at doing a long time ago. As you said, its about testing and then cleaning up 
>>> test data. I got a lot of push back based on the "auditing" argument. The result: Now as I'm learning how to use various parts 
>>> of the data model - or building my own entities - I build data deletion tools along side my other code. It really helps me to 
>>> understand the relationships between all the entities in use and I get my data cleaned up in the process.
>>>
>>> A while back I started writing an Entity Engine cook book with examples of how to do just this along with lots of other 
>>> goodies...but then you guys went and deprecated all my favorite EE APIs, so now I'm back to square one on that idea :-(
>>>
>>> So, to answer you question: yes! I think its a great idea.
>>>
>>> Regards,
>>> Ruth
>>>
>>> Jacques Le Roux wrote:
>>>> Some SQL scripts could be attached to http://docs.ofbiz.org/display/OFBENDUSER/Apache+OFBiz+Business+Setup+Guide
>>>
>>>>
>>>> Or why not, even better, some specific services created, opinions ?
>>>>
>>>> Jacques
>>>>
>>>> From: "Jacques Le Roux" <ja...@les7arts.com>
>>>>> Zhibin,
>>>>>
>>>>> Actually it's a recurring problem and I begin to wonder if we should not try to provide some help at least to delete orders, 
>>>>> invoices, payments and all related entities created just after a setup to verify that all is working correctly. This of course 
>>>>> without having to reset all the DB (the records - tuples actually - created being there just for the purpose of testing the DB 
>>>>> setup)
>>>>> I guess we have all been in this situation  : clients like to see some results before going in production...
>>>>>
>>>>> Jacques
>>>>>
>>>>> From: "Zhibin Liang" <li...@gmail.com>
>>>>>> Hi Kumaraswamy,
>>>>>>
>>>>>> Thanks a lot for the feedback, the information you provide is very helpful.
>>>>>> I just tried to clean up some demo and test data before moving into
>>>>>> production. But that's not absolutely necessary I guess.
>>>>>>
>>>>>> Best regards,
>>>>>> Zhibin
>>>>>>
>>>>>> -----Original Message-----
>>>>>> From: Kumaraswamy nandipati [mailto:kumaraswamy@ecomzera.com]
>>>>>> Sent: Monday, November 09, 2009 6:49 PM
>>>>>> To: user@ofbiz.apache.org
>>>>>> Subject: Re: How to delete a catalog or catagory ?
>>>>>>
>>>>>> Hi Zhibin,
>>>>>>
>>>>>> Delete feature is lil. bit in secure(unfortunate delete will impact more on
>>>>>> business). May be because of this reason, delete action for catalog and
>>>>>> category was not provided from years.
>>>>>>
>>>>>> if you want to delete, write a stored procedure to delete catalog/category.
>>>>>> Otherwise, expire them to maintain it as historical data(sometimes, it is
>>>>>> important in ecommerce industry to maintain historical data.).
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Sat, Nov 7, 2009 at 5:34 PM, Zhibin Liang <li...@gmail.com> wrote:
>>>>>>
>>>>>>> Hi,
>>>>>>>
>>>>>>> I did some search on the old archives, it mentioned this can't be done.
>>>>>> but
>>>>>>> that was back in 2004, Just wondering if things have been changed since
>>>>>>> then
>>>>>>> ?
>>>>>>>
>>>>>>> Thanks much.
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> -- 
>>>>>> Thanks,
>>>>>> Kumaraswamy.N
>>>>>> 91-9866805250.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>