IdStory Identity Manager

I added tests for HR processes in our Squash test system. The preparation of data is written in Information -> Prerequisite of the 1st HR test.

The system doesn't accept attachments, so I uploaded it here. All the attached files can be used for preparation of the tests if we don't want to click it manually :-) Steps:

• Import hrdata_sql.sql to your PostgreSQL database (we assume that user "czechidm" already exists)
  psql
  create database hrdata owner czechidm
  psql -d hrdata < /tmp/hrdata_sql.sql
• Import script-definition-backup-bulk-action.zip - necessary Groovy transformation scripts.
• Import HR systems - hridentities.zip and hr-contracts.zip through Export/import agenda. Change to Readonly. Change Host - localhost, User password - password for DB user czechidm. Synchronization of contracts somehow didn't get imported, so create it manually and check "After end, start the HR processes" in the specific settings of the sync.
• Create organizations (organizations.png)
• Create standard generators for login and e-mail (generators.png)
• Create a virtual system "AD" (or import AD from ad-virtual-mock.zip. You must manually set the form attribute "rights" as multivalued in the form definition of VsAccount!)
• Create role AD-users, system AD, set Forward account management
• Import roles from roles_objects.csv (extras ImportRolesFromCSVExecutor with settings from roles_objects_import_task.png). AD-group-pki - set Skip value when contract is excluded for the "rights" attribute
• Import autoroles for structure autoroles_structure.csv (extras ImportAutomaticRoleForTreeNodeFromCSVExecutor with settings from autoroles_structure_import_task.png)
• Import definitions of automatic roles by attribute from CSV autoroles_attributes.csv (extras ImportAutomaticRoleByAttributesCSVExecutor with settings from autoroles_attributes_import_task.png)
• Start HrEnableContractProcess and other 2 HR processes at least once manually. Otherwise, they wouldn't be started by the synchronization of contracts

---

Or here are some SQL queries for the source HR system for the tests.

-- new contract
insert into identities values (1,'Jan','Dvořák','Ing.',null,'1000',now());
insert into contracts values (1, '1000', '2021-01-01','2021-12-31',null,'Department 1','consultant', now());
-- new future contract
insert into identities values (2,'Petr','Novák','Ing.','PhD.','1001',now());
insert into contracts values (2, '1001', '2021-02-01','2021-12-31',null,'Department 1','consultant', now());
-- second contract
insert into contracts values (3, '1000', '2021-01-01','2023-12-31',null,'Department 2','director', now());
-- setting contract to excluded
update contracts set state='EXCLUDED', lastupdatetime=now() where id='1';