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" <jacques.le.r...@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" <jler...@apache.org>
Note that my intention is to have a handy tool just to delete tests data after
installation.
Jacques
From: "Zhibin Liang" <liang.zhi...@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:rhoff...@aesolves.com] Sent: Tuesday, November 10,
2009 9:20 AM
To: u...@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" <jacques.le.r...@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" <liang.zhi...@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:kumarasw...@ecomzera.com]
Sent: Monday, November 09, 2009 6:49 PM
To: u...@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 <liang.zhi...@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.
