Project

General

Profile

Actions

Task #2636

closed

Investigate Squash test system

Added by Ondrej Husník about 3 years ago. Updated about 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Ondrej Husník
Category:
-
Target version:
-
Start date:
01/08/2021
Due date:
% Done:

100%

Estimated time:
Owner:

Description

Add new tests into Squash test system and summarize own user experience possibility for using it as general test tool.


Files

hrdata_sql.sql (1.96 KB) hrdata_sql.sql Alena Peterová, 01/25/2021 07:11 PM
hridentities.zip (62 KB) hridentities.zip Alena Peterová, 01/25/2021 07:11 PM
hr-contracts.zip (63.2 KB) hr-contracts.zip Alena Peterová, 01/25/2021 07:11 PM
script-definition-backup-bulk-action.zip (1.34 KB) script-definition-backup-bulk-action.zip Alena Peterová, 01/25/2021 07:12 PM
organizations.png (13.5 KB) organizations.png Alena Peterová, 01/25/2021 07:12 PM
generators.png (26.5 KB) generators.png Alena Peterová, 01/25/2021 07:12 PM
ad-virtual-mock.zip (52.1 KB) ad-virtual-mock.zip Alena Peterová, 01/25/2021 07:12 PM
roles_objects.csv (829 Bytes) roles_objects.csv Alena Peterová, 01/25/2021 07:12 PM
roles_objects_import_task.png (46.8 KB) roles_objects_import_task.png Alena Peterová, 01/25/2021 07:12 PM
autoroles_structure.csv (139 Bytes) autoroles_structure.csv Alena Peterová, 01/25/2021 07:13 PM
autoroles_structure_import_task.png (28.9 KB) autoroles_structure_import_task.png Alena Peterová, 01/25/2021 07:13 PM
autoroles_attributes.csv (160 Bytes) autoroles_attributes.csv Alena Peterová, 01/25/2021 07:13 PM
autoroles_attributes_import_task.png (29.2 KB) autoroles_attributes_import_task.png Alena Peterová, 01/25/2021 07:13 PM

Related issues

Related to IdStory Identity Manager - Task #2665: Verification of product test scenarios.ClosedOndrej Husník01/26/2021

Actions
Related to IdStory Identity Manager - Task #2675: Automation of product integration tests - prerequisitiesClosedOndrej Husník02/08/2021

Actions
Actions #2

Updated by Alena Peterová about 3 years ago

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';
Actions #3

Updated by Ondrej Husník about 3 years ago

  • Related to Task #2665: Verification of product test scenarios. added
Actions #4

Updated by Ondrej Husník about 3 years ago

  • Related to Task #2675: Automation of product integration tests - prerequisities added
Actions #5

Updated by Ondrej Husník about 3 years ago

  • Status changed from In Progress to Closed
  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF