1 mysql> select * from ProximitySensor where zone=2;
2 +-------------------+------+-------+
4 +-------------------+------+-------+
5 | 00:10:00:00:00:03 | 2 | 100 |
6 | 00:10:00:00:00:07 | 2 | 100 |
7 +-------------------+------+-------+
8 2 rows in set (0.00 sec)
10 mysql> select * from Vent where zone=1;
11 +-------------------+------+
13 +-------------------+------+
14 | 00:14:00:00:00:01 | 1 |
15 | 00:14:00:00:00:02 | 1 |
16 +-------------------+------+
17 2 rows in set (0.00 sec)
19 mysql> select * from IoTComm;
20 +-------------------+-----------------------+-------------------+----------------------+--------+
21 | ID_SOURCE | TYPE_SOURCE | ID_DESTINATION | TYPE_DESTINATION | ACCESS |
22 +-------------------+-----------------------+-------------------+----------------------+--------+
23 | 00:10:00:00:00:01 | ProximitySensorImpl | 00:14:00:00:00:01 | VentImpl | WRITE |
24 | 00:10:00:00:00:02 | ProximitySensorImpl | 00:14:00:00:00:02 | VentImpl | WRITE |
25 | 00:10:00:00:00:03 | ProximitySensorImpl | 00:14:00:00:00:03 | VentImpl | WRITE |
26 | 00:10:00:00:00:03 | ProximitySensorImpl | 00:14:00:00:00:04 | VentImpl | WRITE |
27 +-------------------+-----------------------+-------------------+----------------------+--------+
28 11 rows in set (0.00 sec)
30 +-------------------+-----------------------+-------------------+----------------------+--------+
31 | ID_SOURCE | TYPE_SOURCE | ID_DESTINATION | TYPE_DESTINATION | ACCESS |
32 +-------------------+-----------------------+-------------------+----------------------+--------+
33 | 00:10:00:00:00:01 | ProximitySensorImpl | 00:14:00:00:00:01 | VentImpl | WRITE |
34 | 00:10:00:00:00:02 | ProximitySensorImpl | 00:14:00:00:00:02 | VentImpl | WRITE |
35 | 00:10:00:00:00:03 | ProximitySensorImpl | 00:14:00:00:00:03 | VentImpl | WRITE |
36 | | 00:14:00:00:00:04 | VentImpl | WRITE |
37 +-------------------+-----------------------+-------------------+----------------------+--------+
39 Objects need to be created:
41 AcmeVentControl (dc-8)
42 VentImpl 00:14:00:00:00:01 (dc-11)
43 VentImpl 00:14:00:00:00:02 (dc-11)
44 VentImpl 00:14:00:00:00:03 (dc-11)
45 VentImpl 00:14:00:00:00:04 (dc-11)
46 ProximitySensorImpl 00:10:00:00:00:01 (dc-9)
47 ProximitySensorImpl 00:10:00:00:00:02 (dc-9)
48 ProximitySensorImpl 00:10:00:00:00:03 (dc-9)
49 ProximitySensorBrandD 00:10:00:00:00:07 (dc-11)