summaryrefslogtreecommitdiff
path: root/opendc-web/opendc-web-server/src/main/resources/db/testing/V3.0.1__entities.sql
blob: 1b702f4e0a9ed9418afe85c61d69c0fa9842b858 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
-- Test entities

alter sequence hibernate_sequence restart with 500;

insert into projects (id, created_at, name, portfolios_created, scenarios_created, topologies_created, updated_at)
values (1, current_timestamp(), 'Test Project', 1, 2, 1, current_timestamp());
insert into project_authorizations (project_id, user_id, role)
values (1, 'owner', 'OWNER'),
       (1, 'editor', 'EDITOR'),
       (1, 'viewer', 'VIEWER');

insert into portfolios (id, name, number, targets, project_id)
values (1, 'Test Portfolio', 1, '{ "metrics": [] }' format json, 1);

insert into topologies (id, created_at, name, number, rooms, updated_at, project_id)
values (1, current_timestamp(), 'Test Topology', 1, '[]' format json, current_timestamp(), 1);

insert into scenarios (id, name, number, phenomena, scheduler_name, sampling_fraction, portfolio_id, project_id, topology_id, trace_id)
values (1, 'Test Scenario', 1, '{ "failures": false, "interference": false }' format json, 'mem', 1.0, 1, 1, 1, 'bitbrains-small'),
       (2, 'Test Scenario', 2, '{ "failures": false, "interference": false }' format json, 'mem', 1.0, 1, 1, 1, 'bitbrains-small');

insert into jobs (id, created_by, created_at, repeats, updated_at, scenario_id)
values (1, 'owner', current_timestamp(), 1, current_timestamp(), 1),
       (2, 'owner', current_timestamp(), 1, current_timestamp(), 2);