groovy in javascript

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
22 messages Options
12
Reply | Threaded
Open this post in threaded view
|

Re: How to delete a catalog or catagory ?

Jacques Le Roux
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.
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>

Reply | Threaded
Open this post in threaded view
|

Re: How to delete a catalog or catagory ?

Jacques Le Roux
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.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>
12