Actions
Task #2636
closedInvestigate Squash test system
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
Related issues
Updated by Alena Peterová almost 4 years ago
- File hrdata_sql.sql hrdata_sql.sql added
- File hridentities.zip hridentities.zip added
- File hr-contracts.zip hr-contracts.zip added
- File script-definition-backup-bulk-action.zip script-definition-backup-bulk-action.zip added
- File organizations.png organizations.png added
- File generators.png generators.png added
- File ad-virtual-mock.zip ad-virtual-mock.zip added
- File roles_objects.csv roles_objects.csv added
- File roles_objects_import_task.png roles_objects_import_task.png added
Updated by Alena Peterová almost 4 years ago
- File autoroles_structure.csv autoroles_structure.csv added
- File autoroles_structure_import_task.png autoroles_structure_import_task.png added
- File autoroles_attributes.csv autoroles_attributes.csv added
- File autoroles_attributes_import_task.png autoroles_attributes_import_task.png added
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';
Updated by Ondrej Husník almost 4 years ago
- Related to Task #2665: Verification of product test scenarios. added
Updated by Ondrej Husník over 3 years ago
- Related to Task #2675: Automation of product integration tests - prerequisities added
Updated by Ondrej Husník over 3 years ago
- Status changed from In Progress to Closed
- % Done changed from 0 to 100
Actions