All Downloads are FREE. Search and download functionalities are using the official Maven repository.

config.adminQueries.properties Maven / Gradle / Ivy

The newest version!
#create RegCenter with ID as teId1, regCenter should be under authUser(cookie) zone, in this these things may 
#change: cntrTyp_code, location_code, holiday_loc_code, zone_code, lang_code. update them accordingly.
createRegCenter=INSERT INTO master.registration_center( \
            id, name, cntrtyp_code, addr_line1, addr_line2, addr_line3, latitude, \
            longitude, location_code, contact_phone, contact_person, number_of_kiosks, \
            working_hours, per_kiosk_process_time, center_start_time, center_end_time, \
            lunch_start_time, lunch_end_time, time_zone, holiday_loc_code, \
            zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, \
            is_deleted, del_dtimes) \
    VALUES ('Tcntr', 'Test Center', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '14022', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'STT', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null);
            
#create regcent by replacing the id and zone in upper query wit this regCentID(using this center to map device, machine, user)
regCentId1=Tcnt1
regCentId2=Tcnt2
zoneCode=BRK
         
#delete created RegCenter with above IDs, here role will be replaced by username of AuthUser.
deleteRegCenter=delete from master.registration_center where id = 'Tcntr' and is_active = false and is_deleted = true and upd_by = 'role'
deleteRegCenter1=delete from master.registration_center where id = 'Tcnt1' or id = 'Tcnt2'
deleteCntrCrtdByApi= delete from master.registration_center where name = 'Test Center'
deleteWorkNonWorkDays=delete from master.reg_working_nonworking where regcntr_id IN (select id from master.registration_center where name = 'Test Center')
deleteExcptnlHolidy=delete from master.reg_exceptional_holiday where regcntr_id IN (select id from master.registration_center where name = 'Test Center') 
deleteWorkNonWorkDaysUpdate=delete from master.reg_working_nonworking where regcntr_id IN ('Tcnt1','Tcntr')
deleteExcptnlHolidyUpdate=delete from master.reg_exceptional_holiday where regcntr_id IN ('Tcnt1','Tcntr') 

#map regCenter to device, device and regCenter should be under authUser(cookie) zone. here device_id and lang_code can change,
# update them accordingly
mapRegCentDevice=INSERT INTO master.reg_center_device( \
	regcntr_id, device_id, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('Tcnt1', '3000025', 'eng', true, 'superadmin', '2019-09-04 12:28:11.553519', null, null, null, null);
	
deleteMappedRegCentDevice=delete from master.reg_center_device where regcntr_id = 'Tcnt1'
	
#map regCenter to machine, machine and regCenter should be under authUser(cookie) zone. here machine_id and lang_code can change,
# update them accordingly
mapRegCentMach=INSERT INTO master.reg_center_machine( \
	regcntr_id, machine_id, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('Tcnt1', '10005', 'eng', true, 'superadmin', '2019-09-04 12:28:11.553519', null, null, null, null);
	
deleteMappedRegCentMach=delete from master.reg_center_machine where regcntr_id = 'Tcnt1'
	
#map regCenter to user, user and regCenter should be under authUser(cookie) zone. here user_id and lang_code can change,
# update them accordingly
mapRegCentUser=INSERT INTO master.reg_center_user( \
	regcntr_id, usr_id, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('Tcnt1', '110033', 'eng', true, 'superadmin', '2019-09-04 12:28:11.553519', null, null, null, null);
	
deleteMappedRegCentUser=delete from master.reg_center_user where regcntr_id = 'Tcnt1'

#create Device with ID as Tdevice, Device should be under authUser(cookie) zone, in this these things may 
#change: dspecId, zone_code, lang_code. update them accordingly.
createDevice=INSERT INTO master.device_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, dspec_id, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('Tdevice', 'TestDevice', '85-BB-97-4B-14-05', 'SZ5912878988', null, null, '165', 'CST', 'eng', true, 'superadmin', '2019-07-26 12:18:40.718295', null, null, null, null);
	
#create device by replacing the id and zone in upper query with this deviceID(using this device to map regCenter)
deviceId1=Tdevice1
deviceId2=Tdevice2

#delete created Device with above IDs, here role will be replaced by username of AuthUser.
deleteDevice=delete from master.device_master where id = 'Tdevice' and is_active = false and is_deleted = true and upd_by = 'role'
deleteDevice1=delete from master.device_master where id = 'Tdevice1' or id = 'Tdevice2'

#create Machine with ID as Tmach, Machine should be under authUser(cookie) zone, in this these things may 
#change: mspecId, zone_code, lang_code. update them accordingly.
createMachine=INSERT INTO master.machine_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, mspec_id, public_key, key_index, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('Tmach', 'TestMachine', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'Pkey', 'KeyI', 'CST', 'eng', true, '110005', '2019-07-26 12:18:40.718295', null, null, null, null), \
	('Tmac1', 'TestMachine', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'Pkey', 'KeyI', 'CST', 'eng', true, '110005', '2019-07-26 12:18:40.718295', null, null, null, null), \
	('Tmac2', 'TestMachine', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'Pkey', 'KeyI', 'BRK', 'eng', true, '110005', '2019-07-26 12:18:40.718295', null, null, null, null);

machineId1=Tmac1

#delete created Machine with above IDs, here role will be replaced by username of AuthUser.
deleteMachine=delete from master.machine_master where id = 'Tmach' and is_active = false and is_deleted = true and upd_by = 'role'
deleteMachine1=delete from master.machine_master where id = 'Tmac1' or id = 'Tmac2'

#create location data
createLocation=INSERT INTO master.location( \
	code, name, hierarchy_level, hierarchy_level_name, parent_loc_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('TestLoc_code_1','Test_Loc_B_1' , 3, 'City', 'KNT', 'eng', false, '110005', '2019-07-26 12:18:38.523228', null, null, null, null), \
		   ('TestLoc_code_2','Test_Loc_B_2' , 2, 'Province', 'TestLoc_code_1', 'eng', true, '110005', '2019-07-26 12:18:38.523228', null, null, null, null), \
		   ('TestLoc_code_2','Test_Loc_B_2' , 2, '\u0627\u0644\u0645\u062D\u0627\u0641\u0638\u0629', 'TestLoc_code_1', 'ara', true, '110005', '2019-07-26 12:18:38.523228', null, null, null, null), \
		   ('TestLoc_code_3','Test_Loc_B_3' , 2, 'Province', 'TestLoc_code_1', 'eng', false, '110005', '2019-07-26 12:18:38.523228', null, null, null, null);
		   #delete created locations
deleteCreatedLocations=delete from master.location where cr_by = '110005'

InsertRegDevice=insert into master.registered_device_master (code,dtype_code,dstype_code,status_code,device_id,device_sub_id,digital_id,serial_number,provider_name,provider_id,purpose,firmware,make,model,expiry_date,certification_level,is_active,cr_by,cr_dtimes) \
values ('inActive-D1','Face' , 'Full face', 'Registered', 'TestDev1', '[0,1]', '{ \
    "serialNo" "Serial number1", \
    "make" "Microsoft", \
    "model\u201D : "ca3e7ab9-b4c3-4ae6-8251-579ef933890f", \
    "type" "Face" \
    "dp" "SYNCBYTE", \
    "dpId" "SYNCBYTE.TCI322", \
    "dateTime" "2025-01-01T00:00:00.000+05:30" \
}', 'Serial number1', 'SYNCBYTE', 'SYNCBYTE.TCI322', 'Registration', 'TCI322L1.0', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', '2025-01-01T00:00:00.000+05:30 \
', 'L0',False,'superadmin','now()'),('Revoked-D1','Face' , 'Full face', 'Revoked', 'TestDev1', '[0,1]', '{ \
    "serialNo" "Serial number2", \
    "make" "Microsoft", \
    "model\u201D : "ca3e7ab9-b4c3-4ae6-8251-579ef933890f", \
    "type" "Face" \
    "dp" "SYNCBYTE", \
    "dpId" "SYNCBYTE.TCI322", \
    "dateTime" "2025-01-01T00:00:00.000+05:30" \
}', 'Serial number2', 'SYNCBYTE', 'SYNCBYTE.TCI322', 'Registration', 'TCI322L1.0', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', '2025-01-01T00:00:00.000+05:30 \
', 'L0','TRUE','superadmin','now()'),('Retired-D1','Face' , 'Full face', 'Retired', 'TestDev1', '[0,1]', '{ \
    "serialNo" "Serial number3", \
    "make" "Microsoft", \
    "model\u201D : "ca3e7ab9-b4c3-4ae6-8251-579ef933890f", \
    "type" "Face" \
    "dp" "SYNCBYTE", \
    "dpId" "SYNCBYTE.TCI322", \
    "dateTime" "2025-01-01T00:00:00.000+05:30" \
}', 'Serial number3', 'SYNCBYTE', 'SYNCBYTE.TCI322', 'Registration', 'TCI322L1.0', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', '2025-01-01T00:00:00.000+05:30 \
', 'L0','TRUE','superadmin','now()');

InsertMDS=INSERT INTO master.mosip_device_service( \
	id, sw_binary_hash, sw_version, dprovider_id, dtype_code, dstype_code, make, model, sw_cr_dtimes, sw_expiry_dtimes, is_active, cr_by, cr_dtimes) \
	VALUES ('inActiveMDS', 'dummy data', 'inActiveMDSsVersion', 'SYNCBYTE.TCI322', 'Face' , 'Full face', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', False, '110005', 'now()'), \
	('diffDtypMDS', 'dummy data', 'MDSsVersionDty', 'SYNCBYTE.TCI322', 'Finger' , 'Full face', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()'), \
	('diffDstypMDS', 'dummy data', 'MDSsVersionDsTyp', 'SYNCBYTE.TCI322', 'Face' , 'Single', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()'), \
	('difMakeMDS', 'dummy data', 'MDSsVersionMake', 'SYNCBYTE.TCI322', 'Face' , 'Full face', 'difMakeThanDev', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()'), \
	('difModelMDS', 'dummy data', 'MDSsVersionModel', 'SYNCBYTE.TCI322', 'Face' , 'Full face', 'Microsoft', 'difModelThanDev', 'now()', 'now()', True, '110005', 'now()'), \
	('diffDpId', 'dummy data', 'MDSsVersionDpid', 'SYNCBYTE.MC01A', 'Face' , 'Full face', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()');
	
DeleteRegDevice=delete from master.registered_device_master where code IN ('inActive-D1','Revoked-D1','Retired-D1','ActiveRegDev1');
DeleteMDS=delete from master.mosip_device_service where id IN ('inActiveMDS','diffDtypMDS','diffDstypMDS','difMakeMDS','difModelMDS','diffDpId');
DeleteRegDeviceCreatedByApi=delete from master.registered_device_master where device_id IN ('RegDeviceIdT1','RegDeviceIdT2','RegDeviceIdT3','3000025','3000045');
validateHistory=select count(*) from master.registered_device_master_h where device_id IN ('RegDeviceIdT1','RegDeviceIdT2','RegDeviceIdT3','3000025','3000045');
validateDeRegDevHistory=select count(*) from master.registered_device_master_h where device_id IN ('ActiveRegDev1');

InsertRegDeviceHistory=insert into master.registered_device_master_h (code,dtype_code,dstype_code,status_code,device_id,device_sub_id,digital_id,serial_number,provider_name,provider_id,purpose,firmware,make,model,expiry_date,certification_level,is_active,cr_by,cr_dtimes,eff_dtimes) values ('inActive-D1','Face' , 'Full face', 'Registered', 'TestDev1', '[0,1]', '{ "serialNo" "Serial number1", "make" "Microsoft", "model\u201D : "ca3e7ab9-b4c3-4ae6-8251-579ef933890f", "type" "Face" "dp" "SYNCBYTE", "dpId" "SYNCBYTE.TCI322", "dateTime" "2025-01-01T00:00:00.000+05:30" }', 'Serial number1', 'SYNCBYTE', 'SYNCBYTE.TCI322', 'Registration', 'TCI322L1.0', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', '2025-01-01T00:00:00.000+05:30 ', 'L0',False,'superadmin','now()','2019-11-22 10:11:30.854'),('Revoked-D1','Face' , 'Full face', 'Revoked', 'TestDev1', '[0,1]', '{ "serialNo" "Serial number2", "make" "Microsoft", "model\u201D : "ca3e7ab9-b4c3-4ae6-8251-579ef933890f", "type" "Face" "dp" "SYNCBYTE", "dpId" "SYNCBYTE.TCI322", "dateTime" "2025-01-01T00:00:00.000+05:30" }', 'Serial number2', 'SYNCBYTE', 'SYNCBYTE.TCI322', 'Registration', 'TCI322L1.0', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', '2025-01-01T00:00:00.000+05:30 ', 'L0','TRUE','superadmin','now()','2019-11-22 10:11:30.854'),('Retired-D1','Face' , 'Full face', 'Retired', 'TestDev1', '[0,1]', '{ "serialNo" "Serial number3", "make" "Microsoft", "model\u201D : "ca3e7ab9-b4c3-4ae6-8251-579ef933890f", "type" "Face" "dp" "SYNCBYTE", "dpId" "SYNCBYTE.TCI322", "dateTime" "2025-01-01T00:00:00.000+05:30" }', 'Serial number3', 'SYNCBYTE', 'SYNCBYTE.TCI322', 'Registration', 'TCI322L1.0', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', '2025-01-01T00:00:00.000+05:30 ', 'L0','TRUE','superadmin','now()','2019-11-22 10:11:30.854');
InsertMDSHistory=INSERT INTO master.mosip_device_service_h( \
	id, sw_binary_hash, sw_version, dprovider_id, dtype_code, dstype_code, make, model, sw_cr_dtimes, sw_expiry_dtimes, is_active, cr_by, cr_dtimes,eff_dtimes) \
	VALUES ('inActiveMDS', 'dummy data', 'inActiveMDSsVersion', 'SYNCBYTE.TCI322', 'Face' , 'Full face', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', False, '110005', 'now()','2019-11-22 10:11:30.854'), \
	('diffDtypMDS', 'dummy data', 'MDSsVersionDty', 'SYNCBYTE.TCI322', 'Finger' , 'Full face', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()','2019-11-22 10:11:30.854'), \
	('diffDstypMDS', 'dummy data', 'MDSsVersionDsTyp', 'SYNCBYTE.TCI322', 'Face' , 'Single', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()','2019-11-22 10:11:30.854'), \
	('difMakeMDS', 'dummy data', 'MDSsVersionMake', 'SYNCBYTE.TCI322', 'Face' , 'Full face', 'difMakeThanDev', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()','2019-11-22 10:11:30.854'), \
	('difModelMDS', 'dummy data', 'MDSsVersionModel', 'SYNCBYTE.TCI322', 'Face' , 'Full face', 'Microsoft', 'difModelThanDev', 'now()', 'now()', True, '110005', 'now()','2019-11-22 10:11:30.854'), \
	('diffDpId', 'dummy data', 'MDSsVersionDpid', 'SYNCBYTE.MC01A', 'Face' , 'Full face', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', True, '110005', 'now()','2019-11-22 10:11:30.854');

InsertSingleRegDeviceValues=('ActiveRegDev1','Face' , 'Full face', 'Registered', 'TestDev1', '[0,1]', '{ \
    "serialNo" "Serial number1", \
    "make" "Microsoft", \
    "model\u201D : "ca3e7ab9-b4c3-4ae6-8251-579ef933890f", \
    "type" "Face" \
    "dp" "SYNCBYTE", \
    "dpId" "SYNCBYTE.TCI322", \
    "dateTime" "2025-01-01T00:00:00.000+05:30" \
}', 'Serial number4', 'SYNCBYTE', 'SYNCBYTE.TCI322', 'Registration', 'TCI322L1.0', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', '2025-01-01T00:00:00.000+05:30 \
', 'L0',True,'superadmin','now()');

createDevProviderUpdate=INSERT INTO master.device_provider( \
	id, vendor_name, address, email, contact_number, certificate_alias, is_active, cr_by, cr_dtimes) \
	VALUES ('TestDPro1', 'TestVend1', 'testDevPro1', 'testDevProMail', '1234567890','testCerti', true, 110005, '2025-01-01T00:00:00.000+05:30'), ('TestDPro2', 'TestVend2', 'testDevPro2', 'testDevProMail2', '1234567890','testCerti', false, 110005, '2025-01-01T00:00:00.000+05:30');
deleteDevProCreatedByAPI=delete from master.device_provider where cr_by IN ('110005');
validateDevProHistory=select count(*) from master.device_provider_h where cr_by IN ('110005');

deleteFTPCreatedByAPI=delete from master.foundational_trust_provider where name IN ('TestFTP')
createFTPtoUpdate=INSERT INTO master.foundational_trust_provider( \
	id, name, address, email, contact_number, certificate_alias, is_active, cr_by, cr_dtimes) \
	VALUES ('TestFTP2', 'TestFTP1', 'Test Address', '[email protected]', '1234567890', 'testAlias', true, '110005', '2019-11-25 11:22:19.799'),('TestFTP1', 'TestFTP2', 'Test Address', '[email protected]', '1234567890', 'testAlias', true, '110005', '2019-11-25 11:22:19.799'); 
deleteFTP=delete from master.foundational_trust_provider where id IN ('TestFTP1','TestFTP2');
validateFTPHistory=select count(*) from master.foundational_trust_provider_h where name IN ('TestFTP');

#create RegCenter with ID as TestUnmap, regCenter should be under authUser(cookie) zone, in this these things may 
#change: cntrTyp_code, location_code, holiday_loc_code, zone_code, lang_code. update them accordingly.
createRegCenterForUnmap1=INSERT INTO master.registration_center( \
            id, name, cntrtyp_code, addr_line1, addr_line2, addr_line3, latitude, \
            longitude, location_code, contact_phone, contact_person, number_of_kiosks, \
            working_hours, per_kiosk_process_time, center_start_time, center_end_time, \
            lunch_start_time, lunch_end_time, time_zone, holiday_loc_code, \
            zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, \
            is_deleted, del_dtimes) \
    VALUES ('TestUnmap', 'Test Center', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CSB', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null), \
            ('TestUnmap1', 'Test Center', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CSB', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null), \
            ('TestUnmap2', 'Test Center', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'NDR', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null);
            
deleteRegCntrForUnmap= delete from master.registration_center where id in ('TestUnmap', 'TestUnmap1', 'TestUnmap2')          
            
            
#create Device with ID as TestDeviceToMapNew, Device should be under authUser(cookie) zone, in this these things may 
#change: dspecId, zone_code, lang_code. update them accordingly.
createDeviceForUnmap1=INSERT INTO master.device_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, dspec_id, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('TestDeviceToMapNew', 'TestDevice', '85-BB-97-4B-14-05', 'SZ5912878988', null, null, '165', 'CST', 'eng', true, 'superadmin', '2019-07-26 12:18:40.718295', null, null, null, null), \
	('TestDeviceToMapNew1', 'TestDevice', '85-BB-97-4B-14-05', 'SZ5912878988', null, null, '165', 'CST', 'eng', true, 'superadmin', '2019-07-26 12:18:40.718295', null, null, null, null), \
	('TestDeviceToMapNew2', 'TestDevice', '85-BB-97-4B-14-05', 'SZ5912878988', null, null, '165', 'NDR', 'eng', true, 'superadmin', '2019-07-26 12:18:40.718295', null, null, null, null); 

deleteUnmapDeviceByApi=delete from master.device_master where id in ('TestDeviceToMapNew','TestDeviceToMapNew1','TestDeviceToMapNew2') 

 	
#map regCenter to device, device and regCenter should be under authUser(cookie) zone. here device_id and lang_code can change,
# update them accordingly
mapRegCentDevice1=INSERT INTO master.reg_center_device( \
	regcntr_id, device_id, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('TestUnmap', 'TestDeviceToMapNew', 'eng', true, 'superadmin', '2019-09-04 12:28:11.553519', null, null, null, null), \
	('TestUnmap1', 'TestDeviceToMapNew2', 'eng', true, 'superadmin', '2019-09-04 12:28:11.553519', null, null, null, null), \
	('TestUnmap2', 'TestDeviceToMapNew1', 'eng', true, 'superadmin', '2019-09-04 12:28:11.553519', null, null, null, null);
	
deleteMappedRegCentDevice1=delete from master.reg_center_device where regcntr_id in ('TestUnmap','TestUnmap1','TestUnmap2')	
	
		
#create RegCenter with ID as MapZone1, regCenter should be under authUser(cookie) zone, in this these things may 
#change: cntrTyp_code, location_code, holiday_loc_code, zone_code, lang_code. update them accordingly.
createRegCenterForMapMCReg=INSERT INTO master.registration_center( \
            id, name, cntrtyp_code, addr_line1, addr_line2, addr_line3, latitude, \
            longitude, location_code, contact_phone, contact_person, number_of_kiosks, \
            working_hours, per_kiosk_process_time, center_start_time, center_end_time, \
            lunch_start_time, lunch_end_time, time_zone, holiday_loc_code, \
            zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, \
            is_deleted, del_dtimes) \
    VALUES ('MapZone1', 'Test Center', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '0', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CSB', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null), \
            ('MapDevReg', 'Test Center', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '0', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'MRS', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null); 
            
deleteRegCntrByApiMac= delete from master.registration_center where id in ('MapZone1', 'MapDevReg');        
            
            
#create Machine with ID as RegCntrMa, Device should be under authUser(cookie) zone, in this these things may 
#change: dspecId, zone_code, lang_code. update them accordingly.
createMachineForMapMCReg=INSERT INTO master.machine_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, mspec_id, public_key, key_index, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('RegCntrMa', 'TestDevice', '85-BB-97-4B-14-05', 'SZ5912878988', null, null, '1001','pkeyI', 'pkeyI', 'CST', 'eng', true, 'superadmin', '2019-07-26 12:18:40.718295', null, null, null, null), \
	('OutZone', 'TestDevice', '85-BB-97-4B-14-05', 'SZ5912878988', null, null, '1001','pkeyI', 'pkeyI', 'MRS', 'eng', true, 'superadmin', '2019-07-26 12:18:40.718295', null, null, null, null);

deleteMapMachineByApi=delete from master.machine_master where id in ('RegCntrMa','OutZone'); 

 	
#map regCenter to machine, machine and regCenter should be under authUser(cookie) zone. here device_id and lang_code can change,
# update them accordingly
mapRegCentMachine1=INSERT INTO master.reg_center_machine( \
	regcntr_id, machine_id, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('MapZone1', 'RegCntrMa', 'eng', true, 'superadmin', '2019-09-04 12:28:11.553519', null, null, null, null);
	
deleteMappedRegCentMachine1=delete from master.reg_center_machine where regcntr_id in ('MapZone1');	

#return the number of kiosks from registration center table
validateNoOfKiosks=	SELECT number_of_kiosks \
	FROM master.registration_center \
	WHERE id in ('MapZone1');
		
createRegCenterWithDifferentData=INSERT INTO master.registration_center( \
            id, name, cntrtyp_code, addr_line1, addr_line2, addr_line3, latitude, \
            longitude, location_code, contact_phone, contact_person, number_of_kiosks, \
            working_hours, per_kiosk_process_time, center_start_time, center_end_time, \
            lunch_start_time, lunch_end_time, time_zone, holiday_loc_code, \
            zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, \
            is_deleted, del_dtimes) \
    VALUES ('TRegCntr1', 'TestRegCenter', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CST', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null),\
           ('TRegCntr2', 'TestRegCenter2', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'RBT', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null),\
           ('TRegCntr3', 'TestRegCenter3', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CST', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null),\
            ('TRegCntr4', 'TestRegCenter3', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'RBT', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            'true', null),\
            ('TRegCntr5', 'TestRegCenter3', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'BSN', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null),\
            ('TRegCntr6', 'TestRegCenter6', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'RBT', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            'true', null),\
            ('TRegCntr7', 'TestRegCenter6', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CST', 'eng', 'false', '110005', '2019-08-27 12:28:11.553519', null, null, \
            'true', null);
 
            
deleteRegCntrByApi= delete from master.registration_center where id in ('TRegCntr1', 'TRegCntr2', 'TRegCntr3','TRegCntr4','TRegCntr5','TRegCntr6','TRegCntr7')


createDeviceWithDifferentData=INSERT INTO master.device_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, dspec_id, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('TestDevice1', 'che iris 1', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CST', 'eng', 'false', '110006', '2019-11-25 11:22:19.799', null, null, null, null),\
	('TestDevice2', 'che iris 2', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CST', 'eng', 'false', '110006', '2019-11-25 11:22:19.799', null, null, null, null),\
	('TestDevice3', 'che iris 3', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'NDR', 'eng', 'false', '110006', '2019-11-25 11:22:19.799', null, null, null, null),\
	('TestDevice4', 'che iris 3', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'BSN', 'eng', 'false', '110006', '2019-11-25 11:22:19.799', null, null, null, null),\
	('TestDevice5', 'che iris 3', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CSB', 'eng', 'false', '110006', '2019-11-25 11:22:19.799', null, null, null, null),\
	('TestDevice6', 'che iris 3', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CST', 'eng', 'false', '110006', '2019-11-25 11:22:19.799', null, null, null, null),\
	('TestDevice7', 'che iris 3', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CST', 'eng', 'false', '110006', '2019-11-25 11:22:19.799', null, null, 'true', null);

deleteDeviceByApi= delete from master.device_master where id in ('TestDevice1', 'TestDevice2', 'TestDevice3','TestDevice4','TestDevice5','TestDevice6','TestDevice7')          

deleteDeviceRegCenterMapping = delete from master.reg_center_device where regcntr_id in ('TRegCntr1','TRegCntr3')

createUser=INSERT INTO master.user_detail(\
	id, uin, name, email, mobile, status_code, lang_code, last_login_dtimes, last_login_method, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('testuser', '7234451333', 'Dummy User', '[email protected]', '818876500', 'ACT', 'eng', null, 'PWD', 'true', 'superadmin', '2019-10-21 06:50:27.696842', null, null, null, null),\
	('testuserdiffzone', '7234451333', 'Dummy User', '[email protected]', '818876500', 'ACT', 'eng', null, 'PWD', 'true', 'superadmin', '2019-10-21 06:50:27.696842', null, null, null, null),\
	('testusernewzone', '7234451333', 'Dummy User', '[email protected]', '818876500', 'ACT', 'eng', null, 'PWD', 'true', 'superadmin', '2019-10-21 06:50:27.696842', null, null, null, null),\
	('testuservalid', '7234451333', 'Dummy User', '[email protected]', '818876500', 'ACT', 'eng', null, 'PWD', 'true', 'superadmin', '2019-10-21 06:50:27.696842', null, null, null, null),\
	('testusernorole', '7234451333', 'Dummy User', '[email protected]', '818876500', 'ACT', 'eng', null, 'PWD', 'true', 'superadmin', '2019-10-21 06:50:27.696842', null, null, null, null);

deleteUserdetail= delete from master.user_detail where id in ('testuser', 'testuserdiffzone', 'testusernewzone','testuservalid','testusernorole')

createZoneUserWithDifferentData=INSERT INTO master.zone_user(\
	zone_code, usr_id, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('CST', 'testuser', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('NDR', 'testuserdiffzone', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('CSB', 'testusernewzone', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('CST', 'testuservalid', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('CST', 'testusernorole', 'eng', 'true', 'Registration Admin', '2019-10-21 06:50:27.950738', null, null, null, null);

deleteUser= delete from master.zone_user where usr_id in ('testuser', 'testuserdiffzone', 'testusernewzone','testuservalid','testusernorole')

deleteUserRegCenterMapping=delete from master.reg_center_user where regcntr_id in ('TRegCntr1')

mapUserRegCenter=INSERT INTO master.reg_center_user(\
	regcntr_id, usr_id, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('TRegCntr1', 'testuser', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('TRegCntr2', 'testuservalid', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('TRegCntr4', 'testuserdiffzone', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('TRegCntr3', 'testuserdiffzone', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('TRegCntr5', 'testusernewzone', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null),\
	('TRegCntr6', 'testusernorole', 'eng', 'true', 'superadmin', '2019-10-21 06:50:27.950738', null, null, null, null);

deleteMapUserRegCenter=delete from master.reg_center_user where regcntr_id in ('TRegCntr1','TRegCntr2','TRegCntr3','TRegCntr4','TRegCntr5','TRegCntr6');

deleteMDSCreatedByAPI=delete from master.mosip_device_service where cr_by in ('110005');

validateMDSHistory=select count(*) from master.mosip_device_service_h where sw_version IN ('TestMDS1','TestMDS2');

InsertMDSToUpdate=INSERT INTO master.mosip_device_service( \
	id, sw_binary_hash, sw_version, dprovider_id, dtype_code, dstype_code, make, model, sw_cr_dtimes, sw_expiry_dtimes, is_active, cr_by, cr_dtimes) \
	VALUES ('UpdateTestMDS', 'dummy data', 'TestMDS1', 'SYNCBYTE.TCI322', 'Face' , 'Full face', 'Microsoft', 'ca3e7ab9-b4c3-4ae6-8251-579ef933890f', 'now()', 'now()', true, '110005', 'now()')
	
	
createMachine2Eng=INSERT INTO master.machine_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, mspec_id, public_key, key_index, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('Test', 'Dummy MachineTest', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'pkeyI', 'pkeyI', 'CST', 'eng', true, '110005', '2019-07-26 12:18:40.718295', null, null, null, null),\
	('TestF', 'Dummy MachineTest', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'pkeyI', 'pkeyI', 'CST', 'eng', false, '110005', '2019-07-26 12:18:40.718295', null, null, null, null);

deleteMachine2Eng=delete from master.machine_master where cr_by in ('110005'); 	

createMachine2EngUpdate=INSERT INTO master.machine_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, mspec_id, public_key, key_index, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('TestSpecNe', 'Test123', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'pkeyI', 'pkeyI', 'CST', 'eng', true, '110005', '2019-07-26 12:18:40.718295', null, null, null, null),\
	 ('Test', 'Dummy Machine', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'pkeyI', 'pkeyI', 'CST', 'eng', true, '110005', '2019-07-26 12:18:40.718295', null, null, null, null),\
	 ('Test', 'Dummy Machine', '8C-16-45-5A-5D-0D', 'NM5328114630', '192.168.0.150', null, '1001', 'pkeyI', 'pkeyI', 'CST', 'ara', true, '110005', '2019-07-26 12:18:40.718295', null, null, null, null); 

deleteMachine2EngUpdate=delete from master.machine_master where cr_by in ('110005');	

createDocumentType=INSERT INTO master.doc_type( \
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('Act','Activate flag test','Test flag activation','eng','false','superadmin','2019-07-26 12:18:40.718295',null,null,null,null),\
	('Test','Contrat de location','Contrat de location dadresse','eng','true','superadmin','2019-07-26 12:18:40.718295',null,null,null,null),\
	  ('DeAct','Deactivate flag test','Test flag deactivation','eng','true','superadmin','2019-07-26 12:18:40.718295',null,null,null,null);
updateDocumentType=,('Test','Contrat de location','Contrat de location dadresse','ara','false','superadmin','2019-07-26 12:18:40.718295',null,null,null,null);	

deleteDocumentType=delete from master.doc_type where code in ('TestDoc01','TestDoc2','Act','DeAct','Test') or cr_by ='110005';

createDeviceForUpdate=INSERT INTO master.device_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, dspec_id, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('TestDevicePro12', 'test dev2', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CST', 'eng', 'true', '110006', '2019-11-25 11:22:19.799', null, null, null, null), \
	('TestDevicePro12', 'test dev2', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CST', 'ara', 'true', '110006', '2019-11-25 11:22:19.799', null, null, null, null), \
	('TestDevicePro13', 'test dev2', 'D4-3D-7E-C0-8C-4A','ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', \
	'2020-08-07 09:13:22.221', '327', 'CST', 'eng', 'true', '110006', '2019-11-25 11:22:19.799', null, null, null, null);

deleteDeviceForUpdate=delete from master.device_master where id in ('TestDevicePro12','TestDevicePro13'); 	

createDevice2Eng=INSERT INTO master.device_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, dspec_id, zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('id1', 'testdeviceswat1', 'D4-3D-7E-C0-8C-4A', 'ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', '2018-12-10T06:12:52.994Z', '327', \
	'CST', 'eng', 'false', '110005', '2019-11-25 11:22:19.799', null, null, null, null),\
	('id2', 'testdeviceswat2', 'D4-3D-7E-C0-8C-4A', 'ceec5f62-77b7-46f3-816b-3e734305a9c8', '172.23.174.113', '2018-12-10T06:12:52.994Z', '327', \
	'CST', 'eng', 'true', '110005', '2019-11-25 11:22:19.799', null, null, null, null);
	

deleteDevice2Eng=delete from master.device_master where name in ('testdeviceswat1','testdeviceswat2','testDevicedummy','testDevicedummy1', 'testDeviceDummy2'); 

validateDeviceHistory=select count(*) from master.device_master_h where name IN ('testdeviceswat1','testdeviceswat2','testDevicedummy','testDevicedummy1');
deleteDeviceHistory=delete from master.device_master_h where name in ('testdeviceswat1','testdeviceswat2','testDevicedummy','testDevicedummy1');

validateMachineHistory=select count(*) from master.machine_master_h where name IN ('Dummy MachineTest');	
	
createRegCenterWorkingNonWorkingDays = INSERT INTO master.registration_center( \
            id, name, cntrtyp_code, addr_line1, addr_line2, addr_line3, latitude, \
            longitude, location_code, contact_phone, contact_person, number_of_kiosks, \
            working_hours, per_kiosk_process_time, center_start_time, center_end_time, \
            lunch_start_time, lunch_end_time, time_zone, holiday_loc_code, \
            zone_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, \
            is_deleted, del_dtimes) \
    VALUES ('59395', 'TestRegCenter', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CST', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null),\
            ('59396', 'TestRegCenter', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CST', 'ara', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            null, null),\
            ('59397', 'TestRegCenter', 'REG', 'addr_line1', 'addr_line2', 'addr_line3', '34.52117', \
            '-6.453275', '10106', '944945765', 'John Doe', '3', \
            '8:00:00', '00:15:00', '09:00:00', '17:00:00', \
            '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'KTA', \
            'CST', 'eng', true, '110005', '2019-08-27 12:28:11.553519', null, null, \
            'false', null);

deleteRegCenterWorkNonWork = delete from master.registration_center where id in ('59395', '59396','59397')
           
mapworkingDaysToRegCenter = INSERT INTO master.reg_working_nonworking(\
	regcntr_id, day_code, lang_code, is_working, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, \
	is_deleted, del_dtimes)\
	VALUES ('59395', '101', 'eng', 'false', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59395', '102', 'eng', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59395', '103', 'eng', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59395', '104', 'eng', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59395', '105', 'eng', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59395', '106', 'eng', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59395', '107', 'eng', 'false', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59396', '101', 'ara', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59396', '102', 'ara', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59396', '103', 'ara', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59396', '104', 'ara', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59396', '105', 'ara', 'true', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59396', '106', 'ara', 'false', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null),\
	('59396', '107', 'ara', 'false', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null,null,null,null);

deleteRegCenterWorkingdaysMapping = delete from master.reg_working_nonworking where regcntr_id in ('59395', '59396')

regCntrExceptionalHolidaysMapping = INSERT INTO master.reg_exceptional_holiday(\
	regcntr_id, hol_date, hol_name, hol_reason, lang_code, is_active, cr_by, \
	cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('59395', '2020-01-04', 'Emergency Holiday', 'Emergency Holiday', 'eng', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null, null, null, null),\
	('59395', '2019-11-26', 'Emergency Holiday', 'Emergency Holiday', 'eng', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null, null, null, null),\
	('59395', '2019-03-10', 'Emergency Holiday', 'Emergency Holiday', 'eng', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null, null, null, null),\
	('59395', '2019-09-24', 'Emergency Holiday', 'Emergency Holiday', 'eng', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null, null, null, null),\
	('59396', '2019-02-28', 'Emergency Holiday', 'Emergency Holiday', 'ara', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null, null, null, null),\
	('59396', '2019-07-11', 'Emergency Holiday', 'Emergency Holiday', 'ara', 'true', 'superadmin', '2020-01-02 11:59:14.79031', null, null, null, null);
	
deleteRegCntrExceptionalHolidaysMapping=delete from master.reg_exceptional_holiday where regcntr_id in ('59395','59396')

createHoliday= INSERT INTO master.loc_holiday(\
       id, location_code, holiday_date, holiday_name, holiday_desc, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
       VALUES (20010191,'KTA','2020-07-15','Labour Day','Automation labour Holiday','eng','true','110005','2020-05-07T05:30:46.227Z',null,null,null,null);

deleteUpdateHoliday= delete from master.loc_holiday where cr_by='110005' ; 


updateHoliday= INSERT INTO master.loc_holiday(\
       id, location_code, holiday_date, holiday_name, holiday_desc, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
       VALUES (20000191,'KTA','2020-07-15','Labour Day','Automation labour Holiday','eng','true','110005','2020-05-07T05:30:46.227Z',null,null,null,null);
       
       
createTitle= INSERT INTO master.title(\
       code, name,descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
       VALUES ('TEST4','TEST4','TEST4','eng','false','110005','2020-05-18T05:19:53.996Z',null,null,null,null);
		
createTitleDelete= delete from master.title where cr_by='110005';

checkPrimDataAgainstSecData= select count(*) from master.title where lang_code='ara' and code='TEST5';

updateCreatedTitle= INSERT INTO master.title(\
       code, name,descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
       VALUES ('TEST-auto','Master-auto','MASTER-auto','eng','false','110005','2020-05-26T05:19:53.996Z',null,null,null,null);
       
deleteUpdatedTitle= delete from master.title where cr_by='110005';

createMachineType= INSERT INTO master.machine_type(\
               code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
              VALUES ('Laptop-0002','Laptop-0002 test','Laptop-0002 info','eng','false','110005','2020-05-27T05:19:53.996Z',null,null,null,null);
              
deleteMachineType= delete from master.machine_type where cr_by='110005';
checkPrimDataAgainstSecData_MachineType= select count(*) from master.machine_type where lang_code='ara' and code='Laptop-1';              
  
createDeviceSpecification= INSERT INTO master.device_spec(\
                    id, name, brand, model, dtyp_code, min_driver_ver, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
                 VALUES('744','Cam','Technoforte','2020','CMR','1.0','Test DeviceSpec','eng','false','110005','2020-05-27T05:19:53.996Z',null,null,null,null);   
deleteCreatedDeviceSpecification= delete from master.device_spec where cr_by='110005';

updateDeviceSpecification= INSERT INTO master.device_spec(\
                    id, name, brand, model, dtyp_code, min_driver_ver, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
                 VALUES('746','Laptop','Dell','2020','CMR','1.1','Dell DeviceSpec','eng','true','110005','2020-05-28T05:19:53.996Z',null,null,null,null),\
                 ('746','Laptop','Dell','2020','CMR','1.1','Dell DeviceSpec','ara','true','110005','2020-05-28T05:19:53.996Z',null,null,null,null);   
deleteUpdatedDeviceSpecification= delete from master.device_spec where cr_by='110005';



validatePrimDataAgnstSecData= select count(*) from master.device_spec where lang_code='ara' and dtyp_code='FP1' and brand='Techno';

updateMachineType= INSERT INTO master.machine_type(\
               code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
              VALUES ('Laptop','Laptop test','Laptop','eng','true','110005','2020-05-28T05:19:53.996Z',null,null,null,null),\
              ('Laptop','Laptop test','Laptop','ara','true','110005','2020-05-28T05:19:53.996Z',null,null,null,null);
	
deleteUpdatedMachineType= delete from master.machine_type where cr_by='110005';

createMachineSpecification=	INSERT INTO master.machine_spec(\
              id, name, brand, model, mtyp_code, min_driver_ver, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
              VALUES('HP001','HP','HP','1234','DKS','3.2','HP brand','eng','true','110005','2020-05-29T05:19:53.996Z',null,null,null,null);
              
 deleteMachineSpecification= delete from master.machine_spec where cr_by='110005';   
 
 validatePrimDataForMachineSpec= select count(*) from master.machine_spec where lang_code='ara' and mtyp_code='DKS' and id='HP-06';
 
 updateMachineSpecification= INSERT INTO master.machine_spec(\
              id, name, brand, model, mtyp_code, min_driver_ver, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
              VALUES('HP07','HP','HP','1234','DKS','3.2','HP brand','eng','true','110005','2020-05-30T05:19:53.996Z',null,null,null,null);
              
 deleteUpdatedMachineSpec= delete from master.machine_spec where cr_by='110005';
 
 createRegCenterType=INSERT INTO master.reg_center_type(\
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('ALT-2', 'alternate','alternate center' ,'eng', 'true', '110005', '2020-05-30T05:19:53.996Z', null, null, null, null);
	
deleteCretedRegCenterType=	delete from master.reg_center_type where cr_by='110005'; 

validatePrimDataForRegCenter= select count(*) from master.reg_center_type where lang_code='ara' and code='ALT-13';

updateRegCenterType= INSERT INTO master.reg_center_type(\
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('ALT-3', 'alternate','alternate center' ,'eng', 'true', '110005', '2020-05-30T05:19:53.996Z', null, null, null, null);
	
deleteUpdatedRegCenterType=	delete from master.reg_center_type where cr_by='110005';

createTemplateFileFormat=INSERT INTO master.template_file_format(\
	code, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('Xaml', 'Xaml Test', 'eng', 'true', '110005','2020-06-02T10:04:43.336Z' ,null, null, null, null);  
	
deleteCreatedTemplateFileFormat= delete from master.template_file_format where cr_by='110005';

updateTemplateFileFormat=INSERT INTO master.template_file_format(\
	code, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('PDF', 'PDF Test', 'eng', 'true', '110005','2020-06-02T10:04:43.336Z' ,null, null, null, null),\
	('PDF-1', 'PDF-1 Test', 'eng', 'true', '110005','2020-06-02T10:04:43.336Z' ,null, null, null, null);
	
deleteUpdatedTemplateFileFormat= delete from master.template_file_format where cr_by='110005';

createTemplate= INSERT INTO master.template(\
	id, name, descr, file_format_code, model, file_txt, module_id, module_name, template_typ_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('test-002','Test-template','test template','html','model-1','abc','10001','Pre-Registration','Acknowledgement-email-subject','eng','true','110005','2020-06-03T10:15:27.703Z', null,null,null,null);


deleleCreatedTemplate=	delete from master.template where cr_by='110005';  


createHoliday= INSERT INTO master.loc_holiday(\
       id, location_code, holiday_date, holiday_name, holiday_desc, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
       VALUES (20010191,'KTA','2020-07-15','Labour Day','Automation labour Holiday','eng','true','110005','2020-05-07T05:30:46.227Z',null,null,null,null);

deleteCreatedHoliday= delete from master.loc_holiday where cr_by='110005' ; 

createGender= INSERT INTO master.gender(\
       code, name, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
       VALUES ('MLE-Auto','Test-Auto','eng','false','110005','2020-05-18T05:19:53.996Z',null,null,null,null);
       
deleteGender= delete from master.gender where cr_by='110005' ;  

updateGender= INSERT INTO master.gender(\
       code, name, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
       VALUES ('MLE-Auto-1','Test-Auto-1','eng','false','110005','2020-05-18T05:19:53.996Z',null,null,null,null);  

deleteUpdatedGender= delete from master.gender where cr_by='110005' ;

createDocumentCategory= INSERT INTO master.doc_category(\
                  code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('DocCat00','DocCat','Testing positive Doc','eng','false','110005','2020-05-19T12:46:15.373Z',null,null,null,null);
	
	
deleteDocumentCategory= delete from master.doc_category where cr_by='110005';	

validatePrimDocCatUpdatedBySec = select count(*) from master.doc_category where is_active='true' and code='DocCat00';
isActiveStatusFalse = select count(*) from master.doc_category where is_active='false' and code='DocTestCode11';

createDocumentCategoryForUpdate=INSERT INTO master.doc_category(\
                  code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes) \
	VALUES ('DocCat002','DocCat002','Testing positive002','eng','true','110005','2020-05-19T12:46:15.373Z',null,null,null,null),\
	        ('DocCat003','DocCat003','Testing positive003','eng','true','110005','2020-05-19T12:46:15.373Z',null,null,null,null),\
	        ('DocCat004','DocCat004','Testing positive004','eng','false','110005','2020-05-19T12:46:15.373Z',null,null,null,null),\
	        ('DocCat005','DocCat005','Testing positive005','eng','false','110005','2020-05-19T12:46:15.373Z',null,null,null,null),\
	        ('DocCat005','DocCat004','Testing positive005','ara','false','110005','2020-05-19T12:46:15.373Z',null,null,null,null),\
	        ('DocCat006','DocCat006','Testing positive006','eng','true','110005','2020-05-19T12:46:15.373Z',null,null,null,null),\
	        ('DocCat006','DocCat006','Testing positive006','ara','true','110005','2020-05-19T12:46:15.373Z',null,null,null,null);
	        
checkPrimDocCatUpdatedBySec = select count(*) from master.doc_category where is_active='true' and code='DocCat004';	        
	        
	

deleteDocumentCategoryForUpdate=delete from master.doc_category where cr_by='110005';

updateTemplate= INSERT INTO master.template(\
	id, name, descr, file_format_code, model, file_txt, module_id, module_name, template_typ_code, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('test-01','Test-template','test template','html','model-1','abc','10001','Pre-Registration','Acknowledgement-email-subject','eng','true','110005','2020-06-03T10:15:27.703Z', null,null,null,null);


deleteUpdateTemplate=	delete from master.template where cr_by='110005';

createTemplateType= INSERT INTO master.template_type(\
	code, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('Test-SMS','Test-SMS-info','eng','true','110005', '2020-06-05T10:15:27.703Z', null, null, null, null);

deleteCreatedTemplateType=	delete from master.template_type where cr_by='110005';  	

createDeviceType= INSERT INTO master.device_type(\
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('GST0', 'GST', 'Test GST', 'eng', 'false', '110005', '2020-06-06T10:15:27.703Z',null, null, null, null);
deleteCreatedDeviceType=  delete from master.device_type where cr_by='110005';

checkPrimDataAgnstSecData= select count(*) from master.device_type where lang_code='ara' and code='GST00' and name='GST00';


updateDeviceType= INSERT INTO master.device_type(\
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('FPT', 'finger print scanner', 'test 1.0.8', 'eng', 'true', '110005', '2020-06-06T10:15:27.703Z',null, null, null, null),\
	       ('GST3', 'GST', 'test 1.0.8', 'eng', 'true', '110005', '2020-06-06T10:15:27.703Z',null, null, null, null),\
	       ('GST3', 'GST', 'test 1.0.8', 'ara', 'true', '110005', '2020-06-06T10:15:27.703Z',null, null, null, null);
	       
deleteUpdatedDeviceType=  delete from master.device_type where cr_by='110005';
deleteIndividualType=  delete from master.individual_type where cr_by='110005';
validatePrimDataForIndividualType= select count(*) from master.individual_type where lang_code='ara' and code='TST2' and name='TestInd';


updateIndividualType=INSERT INTO master.individual_type(\
	code, name, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('TST0', 'TestInd', 'eng','true', '110005', '2020-06-08T06:12:52.994Z', null, null, null, null),\
	('TST0', 'TestInd', 'ara','true', '110005', '2020-06-08T06:12:52.994Z', null, null, null, null),\
	('TST1', 'TST1', 'eng','false', '110005', '2020-06-08T06:12:52.994Z', null, null, null, null),\
	('TST1', 'TST1', 'ara','true', '110005', '2020-06-08T06:12:52.994Z', null, null, null, null),\
	('TST2', 'TST2', 'eng','true', '110005', '2020-06-08T06:12:52.994Z', null, null, null, null);
	
deleteUpdatedIndividualType=  delete from master.individual_type where cr_by='110005';	


# These data is for Auth devices, used by IDA.
crtDeviceDetails = INSERT INTO authdevice.device_detail(\
id, dprovider_id, dtype_code, dstype_code, make, model, partner_org_name, approval_status, is_active, cr_by, cr_dtimes)VALUES \
('devIrisD', '1873299273', 'Iris', 'Double', 'EYECOOL', 'TCI322', 'EYECOOL.com', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973'),\
('devFinger', '1873299273', 'Finger', 'Slap', 'Logitech', '4d36e96c-e325-11ce-bfc1-08002be10316', 'Logitech.com', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973'),\
('devIrisS', '1873299273', 'Iris', 'Single', 'Logitech', '4d36e96c-e325-11ce-bfc1-08002be10317', 'Logitech.com', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973'),\
('devFace', '1873299273', 'Face', 'Full face', 'Logitech', '6bdd1fc6-810f-11d0-bec7-08002be2092f', 'Logitech.com', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973');
dltDeviceDetails = delete from authdevice.device_detail where id IN('devIrisD', 'devFinger', 'devIrisS', 'devFace');

crtSBI = INSERT INTO authdevice.secure_biometric_interface(id, sw_binary_hash, sw_version, device_detail_id, sw_cr_dtimes, sw_expiry_dtimes, approval_status, is_active, cr_by, cr_dtimes)VALUES \
('devIrisD', 'binary data', 'SB.WIN.001', 'devIrisD', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973'),\
('devFinger', 'binary data', 'SB.WIN.001', 'devFinger', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973'),\
('devIrisS', 'binary data', 'SB.WIN.001', 'devIrisS', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973'),\
('devFace', 'binary data', 'SB.WIN.001', 'devFace', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973');
dltSBI = delete from authdevice.secure_biometric_interface where id IN('devIrisD', 'devFinger', 'devIrisS', 'devFace');

crtSBIHist = INSERT INTO authdevice.secure_biometric_interface_h(id, sw_binary_hash, sw_version, device_detail_id, sw_cr_dtimes, sw_expiry_dtimes, approval_status, is_active, cr_by, cr_dtimes, eff_dtimes)VALUES \
('devIrisD', 'binary data', 'SB.WIN.001', 'devIrisD', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973', '2020-10-09 07:10:46.072973'),\
('devFinger', 'binary data', 'SB.WIN.001', 'devFinger', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973', '2020-10-09 07:10:46.072973'),\
('devIrisS', 'binary data', 'SB.WIN.001', 'devIrisS', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973', '2020-10-09 07:10:46.072973'),\
('devFace', 'binary data', 'SB.WIN.001', 'devFace', '2020-01-01 07:10:46.072973', '2030-12-31 07:10:46.072973', 'Activated', true, 'automation', '2020-10-09 07:10:46.072973', '2020-10-09 07:10:46.072973');
dltSBIHist = delete from authdevice.secure_biometric_interface_h where id IN('devIrisD', 'devFinger', 'devIrisS', 'devFace');

crtAuthDevices = INSERT INTO authdevice.registered_device_master(code, status_code, device_id, device_sub_id, digital_id, serial_number, device_detail_id, purpose, firmware, expiry_date, certification_level, is_active, cr_by, cr_dtimes)VALUES \
('2a4af583-da31-4800-8cb9-9340643fd1bf', 'REGISTERED', 'FingerDevice', '1', '', '78467169', 'devFinger', 'AUTH','firmware', '2030-12-31 07:10:46.072973', 'L0', true, 'automation', '2020-10-09 07:10:46.072973'),\
('9ac2ea4c-6ce5-4558-873d-575d130dfc29', 'REGISTERED', 'IrisDevice', '1', '', '78467170', 'devIrisS', 'AUTH','firmware', '2030-12-31 07:10:46.072973', 'L0', true, 'automation', '2020-10-09 07:10:46.072973'),\
('097b9460-d3d3-4e14-8ac9-c95a734d5d81', 'REGISTERED', 'FaceDevice', '1', '', '097b9460-d3d3-4e14-8ac9-c95a734d5d81', 'devFace', 'AUTH','firmware', '2030-12-31 07:10:46.072973', 'L0', true, 'automation', '2020-10-09 07:10:46.072973');
dltAuthDevices = delete from authdevice.registered_device_master where code IN('2a4af583-da31-4800-8cb9-9340643fd1bf', '9ac2ea4c-6ce5-4558-873d-575d130dfc29', '097b9460-d3d3-4e14-8ac9-c95a734d5d81');

crtAuthDevicesHist = INSERT INTO authdevice.registered_device_master_h(code, status_code, device_id, device_sub_id, digital_id, serial_number, device_detail_id, purpose, firmware, expiry_date, certification_level, is_active, cr_by, cr_dtimes, eff_dtimes)VALUES \
('2a4af583-da31-4800-8cb9-9340643fd1bf', 'REGISTERED', 'FingerDevice', '1', '', '78467169', 'devFinger', 'AUTH','firmware', '2030-12-31 07:10:46.072973', 'L0', true, 'automation', '2020-10-09 07:10:46.072973', '2020-10-09 07:10:46.072973'),\
('9ac2ea4c-6ce5-4558-873d-575d130dfc29', 'REGISTERED', 'IrisDevice', '1', '', '78467170', 'devIrisS', 'AUTH','firmware', '2030-12-31 07:10:46.072973', 'L0', true, 'automation', '2020-10-09 07:10:46.072973', '2020-10-09 07:10:46.072973'),\
('097b9460-d3d3-4e14-8ac9-c95a734d5d81', 'REGISTERED', 'FaceDevice', '1', '', '097b9460-d3d3-4e14-8ac9-c95a734d5d81', 'devFace', 'AUTH','firmware', '2030-12-31 07:10:46.072973', 'L0', true, 'automation', '2020-10-09 07:10:46.072973', '2020-10-09 07:10:46.072973');
dltAuthDevicesHist = delete from authdevice.registered_device_master_h where code IN('2a4af583-da31-4800-8cb9-9340643fd1bf', '9ac2ea4c-6ce5-4558-873d-575d130dfc29', '097b9460-d3d3-4e14-8ac9-c95a734d5d81');

# list of the query-keywords for the bulk query for device management data
crtAuthDevicesData = crtDeviceDetails,crtSBI,crtSBIHist,crtAuthDevices,crtAuthDevicesHist
dltAuthDevicesData = dltAuthDevicesHist,dltAuthDevices,dltSBIHist,dltSBI,dltDeviceDetails

# Below data is for search and filter APIs automation, so no dependency on DB data. these data will be inserted just 
# before the execution starts and will be deleted at the end of the admin execution.
# below are the only zones we should use for automation
crtAutoZone = INSERT INTO master.zone(\
	code, name, hierarchy_level, hierarchy_level_name, hierarchy_path, parent_zone_code, lang_code, is_active, cr_by, cr_dtimes)VALUES\
	('TPRNTZ', 'Parent',0,'Parent', 'TPRNTZ', null, 'eng', true, 'mosipautouser', '2019-10-21 06:50:26.445996'),\
	('TPRNTZ', '\u0627\u0644\u0623\u0628\u0648\u064A\u0646',0,'\u0627\u0644\u0623\u0628\u0648\u064A\u0646', 'TPRNTZ', null, 'ara', true, 'mosipautouser', '2019-10-21 06:50:26.445996'),\
	('LFZL', 'Child1',1,'Child1', 'TPRNTZ/LFZL', 'TPRNTZ', 'eng', true, 'mosipautouser', '2019-10-21 06:50:26.445996'),\
	('LFZL', '\u0637\u0641\u06441',1,'\u0637\u0641\u06441', 'TPRNTZ/LFZL', 'TPRNTZ', 'ara', true, 'mosipautouser', '2019-10-21 06:50:26.445996'),\
	('LFZR', 'Child2',1,'Child2', 'TPRNTZ/LFZR', 'TPRNTZ', 'eng', true, 'mosipautouser', '2019-10-21 06:50:26.445996'),\
	('LFZR', '\u0637\u0641\u06442',1,'\u0637\u0641\u06442', 'TPRNTZ/LFZR', 'TPRNTZ', 'ara', true, 'mosipautouser', '2019-10-21 06:50:26.445996');
dltAutoZone = delete from master.zone where cr_by = 'mosipautouser';

#status type is used in status list and status list is used in user
crtStatusTyp = INSERT INTO master.status_type(\
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes)\
	VALUES ('TSD', 'Tested', 'Tested', 'eng',true,'mosipautouser', '2019-10-21 06:50:26.054295');
dltStatusTyp = 	delete from master.status_type where cr_by = 'mosipautouser';

crtStatusList = INSERT INTO master.status_list(\
	code, descr, status_seq, sttyp_code, lang_code, is_active, cr_by, cr_dtimes)\
	VALUES('TST', 'TestON', null, 'TSD', 'eng',true,'mosipautouser', '2019-10-21 06:50:27.193756' );
dltStatusList = delete from master.status_list where cr_by = 'mosipautouser';

# auth method is used in user	
crtAuthMethod = INSERT INTO master.authentication_method(\
	code, method_seq, lang_code, is_active, cr_by, cr_dtimes)\
	VALUES('TPWD',1,'eng', true, 'mosipautouser', '2019-10-21 06:50:24.650103');	
dltAuthMethod = delete from master.authentication_method where cr_by = 'mosipautouser';	

# user to use in whole automation, with zonal admin role and mapped to TprntZ zone
crtAutoUser = INSERT INTO master.user_detail(\
	id, uin, name, email, mobile, status_code, lang_code, last_login_dtimes, last_login_method, is_active, cr_by, cr_dtimes)\
	VALUES ('mosipautouser', '5400020000', 'mosipautouser', '[email protected]', '975366148', 'TST', 'eng', null, 'TPWD', true, 'mosipautouser', '2019-10-21 06:50:27.696842');
dltAutoUser = delete from master.user_detail where cr_by = 'mosipautouser';	
	
crtZoneUserMap = INSERT INTO master.zone_user(\
	zone_code, usr_id, lang_code, is_active, cr_by, cr_dtimes)\
	VALUES ('TPRNTZ', 'mosipautouser', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.950738');	
dltZoneUserMap = delete from master.zone_user where cr_by = 'mosipautouser';

# below device type only we will be using for automation
crtDeviceTyp = INSERT INTO master.device_type(\
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes)\
	VALUES ('TDtyp', 'Finger test Scanner', 'For test finger', 'eng', true, 'mosipautouser', '2019-10-21 06:50:24.840922'),\
	('TDtyp', '\u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u0645\u0627\u0633\u062D \u0627\u0644\u0636\u0648\u0626\u064A', 'For test finger', 'ara', true, 'mosipautouser', '2019-10-21 06:50:24.840922');	
dltDeviceTyp = delete from master.device_type where cr_by = 'mosipautouser';	

# below device spec only we will be using for automation
crtDeviceSpec = INSERT INTO master.device_spec(\
	id, name, brand, model, dtyp_code, min_driver_ver, descr, lang_code, is_active, cr_by, cr_dtimes)\
	VALUES ('TDSpec', 'Finger Test', 'brand', 'model', 'TDtyp', '1.12', 'To scan fingerprint', 'eng', true, 'mosipautouser', '2019-10-21 06:50:26.685205'),\
	('TDSpec', '\u0627\u062E\u062A\u0628\u0627', '\u0627\u0644\u0639\u0644\u0627\u0645\u0629 \u0627\u0644\u062A\u062C\u0627\u0631\u064A\u0629', '\u0646\u0645\u0648\u0630\u062C', 'TDtyp', '1.12', 'To scan fingerprint', 'ara', true, 'mosipautouser', '2019-10-21 06:50:26.685205');
dltDeviceSpec = delete from master.device_spec where cr_by = 'mosipautouser';

crtDevice = INSERT INTO master.device_master(\
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, dspec_id, zone_code, lang_code, is_active, cr_by, cr_dtimes)\
	VALUES ('TdeviceSF', 'TestDevice', 'test mac', 'test serial', null, null, 'TDSpec', 'TPRNTZ', 'eng', true, 'mosipautouser', '2019-07-26 12:18:40.718295'),\
	('TdeviceSF', '\u062C\u0647\u0627\u0632 \u0627\u062E\u062A\u0628\u0627\u0631', 'test mac', 'test serial', null, null, 'TDSpec', 'TPRNTZ', 'ara', true, 'mosipautouser', '2019-07-26 12:18:40.718295'),\
	('TdeviceSF1', 'TestDevice1', 'test mac1', 'test serial1', null, null, 'TDSpec', 'LFZL', 'eng', true, 'mosipautouser', '2019-07-26 12:18:40.718295'),\
	('TdeviceSF1', '\u062C\u0647\u0627\u0632 \u0627\u062E\u062A\u0628\u0627\u0631 1', 'test mac1', 'test serial1', null, null, 'TDSpec', 'LFZL', 'ara', true, 'mosipautouser', '2019-07-26 12:18:40.718295');
dltDevice = delete from master.device_master where cr_by = 'mosipautouser';

crtLocHier = INSERT INTO master.loc_hierarchy_list(hierarchy_level, hierarchy_level_name, lang_code, is_active, cr_by, cr_dtimes) VALUES \
    (0, 'test parent', 'eng', true, 'mosipautouser','2019-10-21 06:50:25.785225'), \
	(0, '\u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u0648\u0627\u0644\u062F\u064A\u0646', 'ara', true, 'mosipautouser','2019-10-21 06:50:25.785225'),\
	(1, 'Child', 'eng', true, 'mosipautouser','2019-10-21 06:50:25.785225'),\
	(1, '\u0637\u0641\u0644', 'ara', true, 'mosipautouser','2019-10-21 06:50:25.785225');
dltLocHier = delete from master.loc_hierarchy_list where cr_by = 'mosipautouser';

crtLoacation = INSERT INTO master.location( \
	code, name, hierarchy_level, hierarchy_level_name, parent_loc_code, lang_code, is_active, cr_by, cr_dtimes) VALUES \
	('TLOC', 'Location test M',	0, 'test parent',  null, 'eng',	true,	'mosipautouser', '2019-10-21 06:50:25.31645'), \
	('TLOC', '\u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u0645\u0648\u0642\u0639', 0, '\u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u0648\u0627\u0644\u062F\u064A\u0646',  null, 'ara',	true,	'mosipautouser', '2019-10-21 06:50:25.31645'),\
	('TCLOC', 'childloctest',	1, 'Child', 'TLOC', 'eng',	true,	'mosipautouser', '2019-10-21 06:50:25.31645'),\
	('TCLOC', '\u0634\u0627\u0630', 1, '\u0637\u0641\u0644', 'TLOC', 'ara',	true,'mosipautouser', '2019-10-21 06:50:25.31645');
dltLoacation = delete from master.location where cr_by = 'mosipautouser';

crtRegCentTyp = INSERT INTO master.reg_center_type( \
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TREG', 'Test R cent', 'Center For test', 'eng',	true,	'mosipautouser', '2019-10-21 06:50:25.785225'), \
	('TREG', '\u0627\u062E\u062A\u0628\u0627\u0631 R \u0627\u0644\u0645\u0627\u0626\u0629', '\u0645\u0631\u0643\u0632 \u0627\u0644\u0627\u062E\u062A\u0628\u0627\u0631', 'ara',	true,	'mosipautouser', '2019-10-21 06:50:25.785225');
dltRegCentTyp = delete from master.reg_center_type where cr_by = 'mosipautouser';

crtRegCenter = INSERT INTO master.registration_center( \
	id, name, cntrtyp_code, addr_line1, addr_line2, addr_line3, latitude, longitude, location_code, contact_phone, contact_person, number_of_kiosks, working_hours, per_kiosk_process_time, center_start_time, center_end_time, lunch_start_time, lunch_end_time, time_zone, holiday_loc_code, zone_code, lang_code, is_active, cr_by, cr_dtimes) \
	VALUES ('TRCnt', 'map test center', 'TREG', 'address1', 'address2', 'address3', '34.522414', '-6.320471', 'TCLOC', '0000000000', 'owner',	2,	'8:00:00', '00:15:00', '09:00:00', '17:00:00', '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'HLOC', 'LFZL', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.012387'), \
	('TRCnt', '\u0645\u0631\u0643\u0632 \u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u062E\u0631\u0627\u0626\u0637', 'TREG', '\u0627\u0644\u0639\u0646\u0648\u0627\u0646 1', 'address2', 'address3', '34.522414', '-6.320471', 'TCLOC', '0000000000', '\u0635\u0627\u062D\u0628',	2,	'8:00:00', '00:15:00', '09:00:00', '17:00:00', '13:00:00', '14:00:00', '(GTM+01:00) CENTRAL EUROPEAN TIME', 'HLOC', 'LFZL', 'ara', true, 'mosipautouser', '2019-10-21 06:50:27.012387');
dltRegCenter = delete from master.registration_center where cr_by = 'mosipautouser';

crtRegCntrDev = INSERT INTO master.reg_center_device( \
	regcntr_id, device_id, lang_code, is_active, cr_by, cr_dtimes) \
	VALUES ('TRCnt', 'TdeviceSF', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.732946');
dltRegCntrDev = delete from master.reg_center_device where cr_by = 'mosipautouser';

crtMachineTyp = INSERT INTO master.machine_type(code, name, descr, lang_code, is_active, cr_by, cr_dtimes)VALUES \
		('TMTYP', 'Test M Type', 'Test Mach type', 'eng', true, 'mosipautouser', '2019-10-21 06:50:25.446465'), \
	    ('TMTYP', '\u0627\u062E\u062A\u0628\u0627\u0631 \u0646\u0648\u0639 M','\u0627\u062E\u062A\u0628\u0627\u0631 \u0646\u0648\u0639 \u0645\u0627\u062E', 'ara', true, 'mosipautouser', '2019-10-21 06:50:25.446465');
delMachineTyp = delete from master.machine_type where cr_by = 'mosipautouser';

crtMachSpec = INSERT INTO master.machine_spec( \
	id, name, brand, model, mtyp_code, min_driver_ver, descr, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TMSPC', 'Testro', 'brand', 'model', 'TMTYP', '1.454', 'To test enrol', 'eng', true,'mosipautouser', '2019-10-21 06:50:26.846071'), \
	('TMSPC', '\u062A\u0633\u062A\u0631\u0648', '\u0627\u0644\u0639\u0644\u0627\u0645\u0629 \u0627\u0644\u062A\u062C\u0627\u0631\u064A\u0629', '\u0646\u0645\u0648\u0630\u062C', 'TMTYP', '1.454', '\u0644\u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u062A\u0633\u062C\u064A\u0644', 'ara', true,'mosipautouser', '2019-10-21 06:50:26.846071');
delMachSpec = delete from master.machine_spec where cr_by = 'mosipautouser';

crtMachine = INSERT INTO master.machine_master( \
	id, name, mac_address, serial_num, ip_address, validity_end_dtimes, mspec_id, public_key, key_index, zone_code, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TMachid', 'test mach', 'test mac', 'test serial', 'test ip','2029-10-21 06:50:27.523105', 'TMSPC','testpublickey', 'testKeyIndex', 'TPRNTZ', 'eng', 'true', 'mosipautouser', '2019-10-21 06:50:27.523105'), \
	('TMachid', '\u0627\u062E\u062A\u0628\u0627\u0631', 'test mac', 'test serial', 'test ip','2029-10-21 06:50:27.523105', 'TMSPC','testpublickey', 'testKeyIndex', 'TPRNTZ', 'ara', 'true', 'mosipautouser', '2019-10-21 06:50:27.523105'), \
	('TMachid1', 'test mach1', 'test mac1', 'test serial1', 'test ip1','2029-10-21 06:50:27.523105', 'TMSPC','testpublickey1', 'testKeyIndex1', 'LFZL', 'eng', 'true', 'mosipautouser', '2019-10-21 06:50:27.523105'), \
	('TMachid1', '\u0627\u062E\u062A\u0628\u0627\u0631 1', 'test mac1', 'test serial1', 'test ip1','2029-10-21 06:50:27.523105', 'TMSPC','testpublickey1', 'testKeyIndex1', 'LFZL', 'ara', 'true', 'mosipautouser', '2019-10-21 06:50:27.523105');
dltMachine = delete from master.machine_master where cr_by = 'mosipautouser';

crtRegCntrMach = INSERT INTO master.reg_center_machine( \
	regcntr_id, machine_id, lang_code, is_active, cr_by, cr_dtimes) \
	VALUES ('TRCnt', 'TMachid1', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.732946');	
dltRegCntrMach = delete from master.reg_center_machine where cr_by = 'mosipautouser';

crtDocTyp = INSERT INTO master.doc_type( \
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TDTYP', 'Tdoctyp', 'test document', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.732946'),\
	('TDTYP', '\u062A\u062F\u0648\u0637\u064A', '\u0648\u062B\u064A\u0642\u0629 \u0627\u062E\u062A\u0628\u0627\u0631', 'ara', true, 'mosipautouser', '2019-10-21 06:50:27.732946');
dltDocTyp = delete from master.doc_type where cr_by = 'mosipautouser';

crtDocCat = INSERT INTO master.doc_category(\
	code, name, descr, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TDCAT', 'Tdoccat', 'test document', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.732946'),\
	('TDCAT', '\u062A\u062F\u0648\u0643\u0627\u062A', '\u0648\u062B\u064A\u0642\u0629 \u0627\u062E\u062A\u0628\u0627\u0631', 'ara', true, 'mosipautouser', '2019-10-21 06:50:27.732946');
dltDocCat = delete from master.doc_category where cr_by = 'mosipautouser';

crtDocCatTyp = INSERT INTO master.valid_document( \
	doctyp_code, doccat_code, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TDTYP', 'TDCAT', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.732946');	
dltDocCatTyp = delete from master.valid_document where cr_by = 'mosipautouser';

crtTitle = INSERT INTO master.title(code, name, descr, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TTTL', 'test title','title testing', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.732946'),\
	('TTTL', '\u0639\u0646\u0648\u0627\u0646 \u0627\u0644\u0627\u062E\u062A\u0628\u0627\u0631','\u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u0639\u0646\u0648\u0627\u0646', 'ara', true, 'mosipautouser', '2019-10-21 06:50:27.732946');
dltTitle = delete from master.title where cr_by = 'mosipautouser';

crtGender = INSERT INTO master.gender(code, name, lang_code, is_active, cr_by, cr_dtimes)VALUES \
	('TGDR', 'test gender', 'eng', true, 'mosipautouser', '2019-10-21 06:50:27.732946'),\
	('TGDR', '\u0627\u062E\u062A\u0628\u0627\u0631 \u0627\u0644\u062C\u0646\u0633', 'ara', true, 'mosipautouser', '2019-10-21 06:50:27.732946');
dltGender = delete from master.gender where cr_by = 'mosipautouser';

# list of the query-keywords for the bulk query
allAutoCrt = crtAutoZone,crtStatusTyp,crtStatusList,crtAuthMethod,crtAutoUser,crtZoneUserMap,crtDeviceTyp,\
			 crtDeviceSpec,crtDevice,crtLocHier,crtLoacation,crtRegCentTyp,crtRegCenter,crtRegCntrDev,crtMachineTyp,\
			 crtMachSpec,crtMachine,crtRegCntrMach,crtDocTyp,crtDocCat,crtDocCatTyp
allAutoDlt = dltRegCntrDev,dltRegCntrMach,dltRegCenter,dltRegCentTyp,dltDevice,dltDeviceSpec,dltDeviceTyp,dltMachine,\
			 delMachSpec,delMachineTyp,dltZoneUserMap,dltAutoZone,dltAutoUser,dltStatusList,\
			 dltStatusTyp,dltAuthMethod,dltLoacation,dltLocHier,dltDocCatTyp,dltDocCat,dltDocTyp
			 
# temp for test, need to add fields in permanent			 
#allAutoCrt = crtTitle,crtGender
#allAutoDlt = dltTitle,dltGender

# verifying the status in DB when create API runs with only one  language[i.e when record created in primary language]
createDeviceSpecIsActive= select count(*) from master.device_spec where is_active='false' and id='743' and lang_code='eng';
createMachineTypeIsActive= select count(*) from master.machine_type where is_active='false' and code='Laptop-2' and lang_code='eng';
createGenderIsActive= select count(*) from master.gender where is_active='false' and code='Genderdummy-0' and lang_code='eng';
createTemplateFileFormateIsActive= select count(*) from master.template_file_format where is_active='false' and code='Docx' and lang_code='eng';
createDeviceTypeIsActive= select count(*) from master.device_type where is_active='false' and code='GST31607' and lang_code='eng';
createHolidayIsActive= select count(*) from master.loc_holiday where is_active='false' and holiday_name='AutoTest user 16july' and lang_code='eng';
createMachineSpecIsActive= select count(*) from master.machine_spec where is_active='false' and id='HP04' and lang_code='eng';
createRegCentrTypeIsActive= select count(*) from master.reg_center_type where is_active='false' and code='RegALT-03' and lang_code='eng';
createTitleIsActive= select count(*) from master.title where is_active='false' and code='crTEST0011' and lang_code='eng';
createTemplateIsActive= select count(*) from master.template where is_active='false' and id='crTempTest-03' and lang_code='eng';
createTemplateTypeIsActive= select count(*) from master.template_type where is_active='false' and code='crTest-info-Template' and lang_code='eng';
createBlackLstWordIsActive= select count(*) from master.blacklisted_words where is_active='false' and word='asshole' and lang_code='eng';


deleteBlackListedWord=delete from master.blacklisted_words where cr_by='110005'

deleteDynamicField=	delete from master.dynamic_field where cr_by='110005';
createDynamicFiledData=INSERT INTO master.dynamic_field(\
	id, name, description, data_type, value_json, lang_code, is_active, cr_by, cr_dtimes, upd_by, upd_dtimes, is_deleted, del_dtimes)\
	VALUES ('DF-001', 'Technology', 'Technology Known', 'String', '[{"code":"Angular","value":"Angular","langCode":"eng","active":true}]', 'eng', 'true', '110005', '2020-08-07 09:08:51.607', null, null, null, null);		




© 2015 - 2025 Weber Informatics LLC | Privacy Policy