Resettare db Odoo

Pubblicato il di

Un semplice elenco di Delete per eliminare tutto quello riguarda documenti e prodotti mantenendo solo le anagrafiche partners, può essere utile quando si fanno molti test in fase di sviluppo:

DELETE FROM public.stock_picking;
DELETE FROM public.stock_move;
DELETE FROM public.stock_move_line;
DELETE FROM public.stock_inventory;
DELETE FROM public.purchase_order;
DELETE FROM public.sale_order;
DELETE FROM public.sale_order_template_option;
DELETE FROM public.sale_order_template_line;
DELETE FROM public.account_invoice;
DELETE FROM public.mrp_production;
DELETE FROM public.pos_order;
DELETE FROM public.pos_order_line;
DELETE FROM public.stock_quant;
DELETE FROM public.stock_production_lot;
DELETE FROM public.stock_scrap;
DELETE FROM public.mrp_bom;
DELETE FROM public.mrp_bom_line;
DELETE FROM public.product_template;
DELETE FROM public.product_product;