9999-00-00.import-test-data.sql 2.17 KB
Newer Older
1
2
3
4
--liquibase formatted sql

/* @formatter:off */

Ivar Meikas's avatar
Ivar Meikas committed
5
--changeset jyrgen:import_test_data runAlways:false runOnChange:true context:local,dev,integtest,test
6

7
8
delete from parameter_scope where parameter_code like 'X-TEST-%';
delete from parameter where code like 'X-TEST-%';
9
delete from feature_flag where id like 'X-TEST-%' or id in ('riskassessments', 'files-virus-scan-unchecked-download');
10

11
12
13
14
insert into parameter (code, name, value, mandatory, frequently_changed, data_type)
values ('X-TEST-TEHIK_URL', 'TEHIK homepage URL', 'https://www.tehik.ee/?id={regCode}&test', false, false, 'TEXT'),
       ('X-TEST-NETI_URL', 'Neti search engine URL', 'https://neti.ee', false, false, 'TEXT'),
       ('X-TEST-GOOGLE_URL', 'Google search engine URL', 'https://google.com', false, false, 'TEXT'),
15
16
       ('X-TEST-TRIPLEDEV_URL', 'Tripledev URL', 'https://tripledev.ee', true, true, 'TEXT'),
       ('X-TEST-TRIPLEDEV_REG_CODE', 'Tripledev registration number', '12055727', true, true, 'INT');
17

18
insert into parameter_scope (parameter_code, scope)
19
20
values ('X-TEST-TEHIK_URL', 'COMMON'),
       ('X-TEST-TEHIK_URL', 'OFFICE'),
21
22
       ('X-TEST-NETI_URL', 'COMMON'),
       ('X-TEST-TRIPLEDEV_URL', 'PUBLIC');
23

24
25
26
insert into feature_flag (id, description, enabled, created_at)
values ('X-TEST-1', 'Test Feature flag', false, now()),
       ('X-TEST-2', 'Test Feature flag 2', true, now()),
27
       ('X-TEST-riskassessments', 'Muutuja, mis näitab risk-assessments teenuse aktiivsuse olekut', true, now()),
28
       ('X-TEST-files-virus-scan-unchecked-download', 'Muutuja, mis lubab alla laadida faile, mida ei ole viirusetõrjete poolt skänneeritud', false, now()),
29
       ('X-TEST-new-violation-elimination', 'Puuduse parandamise uue funktsionaalsuse aktiivsuse olek', true, now()),
30
31
       ('riskassessments', 'Muutuja, mis näitab risk-assessments teenuse aktiivsuse olekut', true, now()),
       ('files-virus-scan-unchecked-download', 'Muutuja, mis lubab alla laadida faile, mida ei ole viirusetõrjete poolt skänneeritud', false, now());
32

33
update feature_flag set enabled = true where id in ('riskassessments-menu-item-visible', 'riskassessments-tool-visible', 'authorities-visible', 'riskassessments-files-visible', 'riskassessments');