What to prescribe so that selenium + chromedriver does not constantly open the settings?

Question

MySQL

run like this in win7

java -jar -Dwebdriver.chrome.driver=chromedriver.exe selenium-server-standalone.jar

Answer 1

Query the latest data at dateTime:

SELECT `p`.`pressure`, `t`.`temperature`, `h`.`humidity`
  FROM (
    SELECT `DATA_SENSOR` AS `pressure`
      FROM `bmp_pressure`
      WHERE `DATESTAMP` <= :dateTime
      ORDER BY `DATESTAMP` DESC
      LIMIT 1
  ) AS `p`
  JOIN (
    SELECT `DATA_SENSOR` AS `temperature`
      FROM `bmp_temperature`
      WHERE `DATESTAMP` <= :dateTime
      ORDER BY `DATESTAMP` DESC
      LIMIT 1
  ) AS `t`
  JOIN (
    SELECT `DATA_SENSOR` AS `humidity`
      FROM `humidity`
      WHERE `DATESTAMP` <= :dateTime
      ORDER BY `DATESTAMP` DESC
      LIMIT 1
  ) AS `h`

Query averaged hourly data for the specified date date:

SELECT `p`.`hour`, `p`.`pressure`, `t`.`temperature`, `h`.`humidity`
  FROM (
    SELECT HOUR(`DATESTAMP`) AS `hour`, `DATA_SENSOR` AS `pressure`
      FROM `bmp_pressure`
      WHERE `DATESTAMP` BETWEEN :date AND :date + INTERVAL 1 DAY
      GROUP BY HOUR(`DATESTAMP`)
  ) AS `p`
  JOIN (
    SELECT `DATA_SENSOR` AS `temperature`
      FROM `bmp_temperature`
      WHERE `DATESTAMP` BETWEEN :date AND :date + INTERVAL 1 DAY
      GROUP BY HOUR(`DATESTAMP`)
  ) AS `t` ON `t`.`hour` = `p`.`hour`
  JOIN (
    SELECT `DATA_SENSOR` AS `humidity`
      FROM `humidity`
      WHERE `DATESTAMP` BETWEEN :date AND :date + INTERVAL 1 DAY
      GROUP BY HOUR(`DATESTAMP`)
  ) AS `h` ON `h`.`hour` = `p`.`hour`