Administrator
|
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" <[hidden email]> > Note that my intention is to have a handy tool just to delete tests data after installation. > > Jacques > > From: "Zhibin Liang" <[hidden email]> >> 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:[hidden email]] >> Sent: Tuesday, November 10, 2009 9:20 AM >> To: [hidden email] >> 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" <[hidden email]> >>>> 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" <[hidden email]> >>>>> 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:[hidden email]] >>>>> Sent: Monday, November 09, 2009 6:49 PM >>>>> To: [hidden email] >>>>> 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 >>>>> <[hidden email]> 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. >>>>> >>>>> >>>> >>>> >>> >>> >> >> > |
Administrator
|
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" <[hidden email]> >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" <[hidden email]> >> Note that my intention is to have a handy tool just to delete tests data after installation. >> >> Jacques >> >> From: "Zhibin Liang" <[hidden email]> >>> 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:[hidden email]] Sent: Tuesday, November 10, 2009 9:20 AM >>> To: [hidden email] >>> 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" <[hidden email]> >>>>> 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" <[hidden email]> >>>>>> 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:[hidden email]] >>>>>> Sent: Monday, November 09, 2009 6:49 PM >>>>>> To: [hidden email] >>>>>> 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 <[hidden email]> 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. >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >> > |
Free forum by Nabble | Edit this page |