def full_delete(comm_id):
Session.execute("delete from crm_communication where comm_id = '%s'" % comm_id)
def clear(discount_id, product_id):
Session.execute("delete from crm_discount_product where discount_id = '%s' and product_id = '%s'" % (discount_id, product_id))
def clear_all(fk_type, fk_id):
#pylint: disable-msg=E1101
Session.execute("delete from core_attribute_value where fk_type = '%s' and fk_id = '%s'" % (fk_type, fk_id))
def full_delete(enterprise_id):
from pvscore.model.crm.customer import Customer
company_ids = db.get_list("select company_id from crm_company where enterprise_id = '%s'" % enterprise_id)
campaign_ids = db.get_list("""select campaign_id from crm_campaign where
company_id in (select company_id from crm_company where enterprise_id = '%s')""" % enterprise_id)
customer_ids = db.get_list("""select customer_id from crm_customer where
campaign_id in (select campaign_id from crm_campaign where
company_id in (select company_id from crm_company where enterprise_id = '%s'))""" % enterprise_id)
product_ids = db.get_list("""select product_id from crm_product where
company_id in (select company_id from crm_company where enterprise_id = '%s')""" % enterprise_id)
# KB: [2013-01-15]: pragma no cover on this because it is not possible to create customers or products on one campaign from another.
for cid in customer_ids: #pragma: no cover
Customer.full_delete(cid[0])
for pid in product_ids: #pragma: no cover
product_id = pid[0]
Session.execute("delete from crm_product_return where product_id = '%s'" % product_id)
Session.execute("delete from crm_product_category_join where product_id = '%s'" % product_id)
Session.execute("delete from crm_product_child where parent_id = '%s'" % product_id)
Session.execute("delete from crm_product_child where child_id = '%s'" % product_id)
Session.execute("delete from crm_product_pricing where product_id = '%s'" % product_id)
Session.execute("delete from crm_product_inventory_journal where product_id = '%s'" % product_id)
Session.execute("delete from crm_purchase_order_item where product_id = '%s'" % product_id)
Session.execute("delete from crm_order_item where product_id = '%s'" % product_id)
Session.execute("delete from crm_product where product_id = '%s'" % product_id)
for cid in campaign_ids:
campaign_id = cid[0]
Session.execute("delete from crm_product_pricing where campaign_id = '%s'" % campaign_id)
for cid in company_ids:
company_id = cid[0]
Session.execute("delete from crm_product_category where company_id = '%s'" % company_id)
Session.execute("delete from crm_report where company_id = '%s'" % company_id)
Session.execute("""delete from cms_content where site_id in (select site_id from cms_site where company_id = '%s')""" % company_id)
Session.execute("delete from cms_page where site_id in (select site_id from cms_site where company_id = '%s')" % company_id)
Session.execute("delete from cms_site where company_id = '%s'" % company_id)
Session.execute("update crm_company set default_campaign_id = null where company_id = '%s'" % company_id)
Session.execute("delete from crm_campaign where company_id = '%s'" % company_id)
Session.execute("delete from crm_purchase_order where company_id = '%s'" % company_id)
Session.execute("delete from core_asset where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from crm_communication where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from core_status where event_id in (select event_id from core_status_event where enterprise_id = '%s')" % enterprise_id)
Session.execute("delete from core_status_event_reason where event_id in (select event_id from core_status_event where enterprise_id = '%s')" % enterprise_id)
Session.execute("delete from core_status_event where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from cms_template where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from crm_company where enterprise_id = '%s'" % enterprise_id)
#Session.execute('update core_user set enterprise_id = null where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from core_status where username in (select user_id from core_user where enterprise_id = '%s')" % enterprise_id)
Session.execute("delete from crm_customer where user_created in (select user_id from core_user where enterprise_id = '%s')" % enterprise_id)
Session.execute("delete from crm_customer where user_assigned in (select user_id from core_user where enterprise_id = '%s')" % enterprise_id)
Session.execute("delete from core_user where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from crm_discount where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from crm_vendor where enterprise_id = '%s'" % enterprise_id)
Session.execute("delete from crm_enterprise where enterprise_id = '%s'" % enterprise_id)
def full_delete(username):
Session.execute("delete from core_user where username = '******'" % username)
def full_delete(event_id):
Session.execute("delete from core_status_event where event_id = '%s'" % event_id)
def full_delete(listing_id):
Session.execute("delete from pvs_listing where listing_id = '%s'" % listing_id)
def full_delete(appointment_id):
Session.execute("delete from crm_appointment where appointment_id = '%s'" % appointment_id)
def full_delete(phase_id):
Session.execute("update crm_customer set phase_id = null where phase_id = '%s'" % str(phase_id))
Session.execute("delete from crm_customer_phase where phase_id = '%s'" % str(phase_id))
def full_delete(customer_id):
""" KB: [2010-10-21]: this is mostly for testing purposes and typically from paster shell. Use with caution.
from pvscore.model.crm.customer import Customer
Customer.delete_newest_customer()
"""
Session.execute("delete from core_asset where status_id in (select status_id from core_status where customer_id = '%s')" % customer_id)
Session.execute("delete from crm_billing_history where customer_id = '%s'" % customer_id)
Session.execute("delete from crm_product_inventory_journal where return_id in (select return_id from crm_product_return where journal_id in (select journal_id from crm_journal where customer_id = '%s'))" % customer_id)
Session.execute("delete from crm_product_return where journal_id in (select journal_id from crm_journal where customer_id = '%s')" % customer_id)
Session.execute("delete from crm_journal where customer_id = '%s'" % customer_id)
Session.execute("delete from crm_product_inventory_journal where order_item_id in (select order_item_id from crm_order_item where order_id in (select order_id from crm_customer_order where customer_id = '%s'))" % customer_id)
Session.execute("delete from crm_oi_terms_acceptance where order_id in (select order_id from crm_customer_order where customer_id = '%s')" % customer_id)
Session.execute("delete from crm_order_item where order_id in (select order_id from crm_customer_order where customer_id = '%s')" % customer_id)
Session.execute("delete from crm_customer_order where customer_id = '%s'" % customer_id)
Session.execute("delete from pvs_listing where customer_id = '%s'" % customer_id)
Session.execute("update crm_customer set status_id = null where customer_id = '%s'" % customer_id)
Session.execute("delete from core_status where customer_id = '%s'" % customer_id)
Session.execute("delete from crm_billing_history where customer_id = '%s'" % customer_id)
Session.execute("delete from crm_appointment where customer_id = '%s'" % customer_id)
#Session.execute("delete from wm_portfolio where customer_id = '%s'" % customer_id)
#Session.execute("delete from wm_customer_holding where customer_id = '%s'" % customer_id)
#Session.execute("delete from wm_ireport_view_log where customer_id = '%s'" % customer_id)
billing_ids = db.get_column("select billing_id from crm_customer where customer_id = '%s'" % customer_id)
Session.execute("delete from crm_customer where customer_id = '%s'" % customer_id)
for bill_id in billing_ids:
Session.execute("delete from crm_billing where billing_id = '%s'" % bill_id)
