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)