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