-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy path_2_add_samples.sql.old
More file actions
34 lines (29 loc) · 2.93 KB
/
_2_add_samples.sql.old
File metadata and controls
34 lines (29 loc) · 2.93 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
--- FAKE DATA SAMPLE
--- Insert LOCATIONS
INSERT INTO aidb.location (country,description,town,street,zipcode) VALUES ((SELECT aidb.location.id FROM aidb.location WHERE aidb.location.town = 'Bratislava'),'BA1','Bratislava','some_street 343','84463');
INSERT INTO aidb.location (country,description,town,street,zipcode) VALUES ((SELECT aidb.location.id FROM aidb.location WHERE aidb.location.town = 'Zagreb'),'ZA1','Zagreb','some_street 343','84463');
INSERT INTO aidb.location (country,description,town,street,zipcode) VALUES ((SELECT aidb.location.id FROM aidb.location WHERE aidb.location.town = 'Athens'),'ATH1','Athens','some_street 343','84463');
--- Insert ROOMs into locations
INSERT INTO aidb.room (loc, floor, room_number, room_name) VALUES ((SELECT aidb.location.id FROM aidb.location WHERE aidb.location.town = 'Bratislava'), 2, 244, 'R1');
INSERT INTO aidb.room (loc, floor, room_number, room_name) VALUES ((SELECT aidb.location.id FROM aidb.location WHERE aidb.location.town = 'Bratislava'), 4, 412, 'R2');
INSERT INTO aidb.room (loc, floor, room_number, room_name) VALUES ((SELECT aidb.location.id FROM aidb.location WHERE aidb.location.town = 'Zagreb'), 1, 155, 'R1');
INSERT INTO aidb.room (loc, floor, room_number, room_name) VALUES ((SELECT aidb.location.id FROM aidb.location WHERE aidb.location.town = 'Athens'), 5, 532, 'R1');
--- Insert RACK into room
INSERT INTO aidb.rack (rack_name, rack_size, purchase_order,room)
VALUES ('rck1L', 64, 'M4c0vx4t3jt24234', (SELECT aidb.room.id FROM aidb.room WHERE aidb.room.room_name = 'R1' AND aidb.room.loc = 'Bratislava'));
INSERT INTO aidb.rack (rack_name, rack_size, purchase_order,room)
VALUES ('rck1L', 64, 'M550vx4t3jt24234', (SELECT aidb.room.id FROM aidb.room WHERE aidb.room.room_name = 'R2' AND aidb.room.loc = 'Bratislava'));
INSERT INTO aidb.rack (rack_name, rack_size, purchase_order,room)
VALUES ('rck1M', 36, 'M345345355t24234', (SELECT aidb.room.id FROM aidb.room WHERE aidb.room.room_name = 'R1' AND aidb.room.loc = 'Zagreb'));
INSERT INTO aidb.rack (rack_name, rack_size, purchase_order,room)
VALUES ('rck1L', 64, 'dfggfgft3jt24234', (SELECT aidb.room.id FROM aidb.room WHERE aidb.room.room_name = 'R1' AND aidb.room.loc = 'Athens'));
---
INSERT INTO aidb.hw (manufacturer, model, serial_number, cpus, warranty_to, purchase_order)
VALUES ('Lenovo','X5','342345tagag344q5',4,NOW(),'84463'),
('Lenovo','X54','rtegs543534534fg',4,NOW(),'86663'),
('Lenovo','X54','dfgfgsdfgsdgfsdg',4,NOW(),'84863');
--- Insert HW to RACK
INSERT INTO aidb.hw_pos_in_rack (rack, hw)
VALUES ((SELECT aidb.rack.id FROM aidb.rack WHERE aidb.rack.rack_name = 'rck1L' AND aidb.rack.room = 'R1'), (SELECT aidb.hw.id FROM aidb.hw WHERE aidb.hw.serial_number = '342345tagag344q5'));
INSERT INTO aidb.hw_pos_in_rack (rack, hw)
VALUES ((SELECT aidb.rack.id FROM aidb.rack WHERE aidb.rack.rack_name = 'rck1L' AND aidb.rack.room = 'R2'), (SELECT aidb.hw.id FROM aidb.hw WHERE aidb.hw.serial_number = 'rtegs543534534fg'));