dbFiles.PMS_delete_script.txt Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of apitest-masterdata Show documentation
Parent project of MOSIP Admin Services apitests
The newest version!
delete from pms.partner_contact where partner_id='Tech-123';
delete from partner_policy where part_id='Tech-123';
delete from partner_policy where policy_id in (select id from auth_policy where name in ('mosip policy','mosip data share policy'));
delete from partner_policy_request where part_id='Tech-123';
delete from pms.partner_policy where label='string';
delete from partner_policy_request where policy_id in (select id from auth_policy where name in ('mosip policy','mosip data share policy'));
delete from partner_policy_bioextract where policy_id in (select id from auth_policy where name in ('mosip policy','mosip data share policy'));
delete from partner_policy_credential_type where part_id='MOVP';
delete from pms.partner where id in ('Tech-123','MOVP','DPP','MISP','MISP2','FTP','111997','updatepolicy'); 
delete from pms.auth_policy where name in('mosip policy','mosip policy2','mosip policy3','mosip data share policy','mosip data share policy2');
delete from pms.policy_group where name in ('mosip policy group','mosip policy group2','update_policy_group');
delete from pms.misp_license where cr_by='pm_testuser';
delete from pms.misp_license where misp_id in ('MISP','MISP2');
delete from pms.ftp_chip_detail where foundational_trust_provider_id='FTP';
delete from pms.misp where name='mosip_misp';
delete from pms.secure_biometric_interface where provider_id='Tech-123';
delete from pms.device_detail where id='device-id-123';
delete from pms.device_detail where make in ('abcde','abcdef');
delete from mosip_keymgr.keymgr.ca_cert_store where cert_subject ='CN=mosiptest.org,O=MOSIPTEST,L=Bangalore,ST=Karantaka,C=IN';
delete from mosip_keymgr.keymgr.partner_cert_store where cert_subject ='CN=Techno.com,O=Techno,L=Bangalore,ST=Karnataka,C=IN';
delete from mosip_keymgr.keymgr.partner_cert_store where cert_subject ='CN=Techno,O=Techno,L=Bangalore,ST=Karnataka,C=IN';
delete from mosip_keymgr.keymgr.ca_cert_store where cert_subject ='CN=apitest,OU=apitest,O=apitest,L=BLR,ST=KAR,C=IN';
delete from mosip_keymgr.keymgr.ca_cert_store where cert_subject ='CN=apitest2,OU=apitest2,O=apitest2,L=BLR,ST=KAR,C=IN';
delete from mosip_keymgr.keymgr.partner_cert_store where cert_subject ='CN=deviceprovider,OU=deviceprovider,O=deviceprovider,L=BLR,ST=KAR,C=IN';
delete from mosip_keymgr.keymgr.partner_cert_store where cert_subject ='CN=movp,OU=movp,O=movp,L=BLR,ST=KAR,C=IN';
delete from mosip_keymgr.keymgr.partner_cert_store where cert_subject ='CN=ftp,OU=ftp,O=ftp,L=BLR,ST=KAR,C=IN';
delete from mosip_keymgr.keymgr.partner_cert_store where cert_subject ='CN=misp,OU=misp,O=misp,L=BLR,ST=KAR,C=IN';
delete from mosip_keymgr.keymgr.partner_cert_store where cert_subject ='CN=misp2,OU=misp2,O=misp2,L=BLR,ST=KAR,C=IN';