Systems - Database: creating a test DB system and connection to CzechIdM via REST

This tutorial will show you, how to create simple database table that you can then connect to CzechIdM via REST endpoint.

Create new table in database of your CzechIdM.

CREATE TABLE system_users
(
  name CHARACTER VARYING(255) NOT NULL,
  lastname CHARACTER VARYING(255),
  firstname CHARACTER VARYING(255),
  password CHARACTER VARYING(255),
  email CHARACTER VARYING(255),
  descrip CHARACTER VARYING(255),
  STATUS CHARACTER VARYING,
  modified TIMESTAMP WITHOUT TIME zone DEFAULT now(),
  CONSTRAINT pk_system_users PRIMARY KEY (name)
);

Use rest below to create test system based on created table (use user with app_admin permissions)

POST:
http://localhost:8080/idm-backend/api/v1/systems/test/create-test-system