Delete all demo things

[ladroge]

Hi
I want to delete all demo product.
I think that the script on sourceforge.net named delete-everything delete only some tables content.
I wanto perform this script but someone can explain me the command line :

delete from shipment_receipt where 1=1;

I want to understand the clause where 1=1;

Thanks

[Roberto Cosenza-5]

I don't know why it is there. it is probably an implementation issue.
But since 1 is always equals to 1 it will delete all the entries from  
the table shipment_receipt
/roberto

On Mar 13, 2008, at 4:04 PM, ladroge wrote:

>
> Hi
> I want to delete all demo product.
> I think that the script on sourceforge.net named delete-everything  
> delete
> only some tables content.
> I wanto perform this script but someone can explain me the command  
> line :
>
> delete from shipment_receipt where 1=1;
>
> I want to understand the clause where 1=1;
>
> Thanks
> --
> View this message in context: http://www.nabble.com/Delete-all-demo-things-tp16025512p16025512.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[rajsaini]

/ /I think the script you are talking about is Opentaps.

In Ofbiz, you just do not load demo data instead of deleting it. Run the
"run-install-seed" ant task instead of "run-install". It will only load
your seed (minimal data required for Ofbiz to work) and no demo data.

Raj

ladroge wrote:

> Hi
> I want to delete all demo product.
> I think that the script on sourceforge.net named delete-everything delete
> only some tables content.
> I wanto perform this script but someone can explain me the command line :
>
> delete from shipment_receipt where 1=1;
>
> I want to understand the clause where 1=1;
>
> Thanks
>  

[BJ Freeman]

if you are using the derby db then do a ant clean-data which basically
deletes the DB and  "run-install-seed" ant task rebuilds it from seed data
if you using an external DB you will have to purge the DB for the DB
admin then  "run-install-seed" ant task

The "run-install-seed" ant task will not remove demo data.


ladroge sent the following on 3/13/2008 7:04 AM:

> Hi
> I want to delete all demo product.
> I think that the script on sourceforge.net named delete-everything delete
> only some tables content.
> I wanto perform this script but someone can explain me the command line :
>
> delete from shipment_receipt where 1=1;
>
> I want to understand the clause where 1=1;
>
> Thanks