localconfig/mysql/AcmeVentControl_query_results

   1 mysql> select * from ProximitySensor where zone=2;
   2 +-------------------+------+-------+
   3 | ID                | ZONE | POWER |
   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)
   9
  10 mysql> select * from Vent where zone=1;
  11 +-------------------+------+
  12 | ID                | ZONE |
  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)
  18
  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)
  29
  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 +-------------------+-----------------------+-------------------+----------------------+--------+
  38
  39 Objects need to be created:
  40
  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)
  50