Removing a tenant or vertical

Owned by Onesait Platform
09/09/22
1 min read

Removing a tenant or vertical is possible but it is a manual process that requires the following steps.

You will have to access the platform configuration database (config db), and execute the following instructions:

 

use onesaitplatform_config_master; #DELETE TENANT delete from master_user where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT"); delete from master_user_token where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT"); delete from vertical_tenant where tenant_id in (select tenant.id from tenant where tenant.name="NOMBRE_TENANT"); delete from master_device_token where tenant="NOMBRE_TENANT"; delete from tenant where tenant.name="NOMBRE_TENANT"; #DELETE VERTICAL delete from master_user where tenant_id in (select tenant_id from vertical_tenant inner join vertical on vertical.id=vertical_id where vertical.name="NOMBRE_VERTICAL"); delete from master_user_token where tenant_id in (select tenant_id from vertical_tenant inner join vertical on vertical.id=vertical_id where vertical.name="NOMBRE_VERTICAL"); delete from vertical_tenant where vertical_id in (select vertical.id from vertical where vertical.name="NOMBRE_VERTICAL"); delete from master_device_token where vertical="NOMBRE_VERTICAL"; drop schema onesaitplatform_config_NOMBRE_VERTICAL;

 

Finally we must do the following:

  1. Stop cacheservice.

  2. Stop controlpanelservice,

  3. Start cacheservice and controlpanelservice.

 

Â