localconfig/mysql/AcmeProximity_query_results

   1 mysql> select * from LightBulb where zone=1;
   2 +-------------------+------+-------+
   3 | ID                | ZONE | POWER |
   4 +-------------------+------+-------+
   5 | 00:11:00:00:00:02 |    1 |    30 |
   6 +-------------------+------+-------+
   7 1 row in set (0.00 sec)
   8
   9 mysql> select * from ProximitySensor where zone=2;
  10 +-------------------+------+-------+
  11 | ID                | ZONE | POWER |
  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)
  17
  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)
  28
  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 +-------------------+-----------------------+-------------------+----------------------+--------+
  37
  38
  39 Objects need to be created:
  40
  41 AcmeProximity (dc-8)
  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)
  48