with warnings.catch_warnings():
# ignore _mysql_exceptions.Warning: Duplicate entry '0316a2193bff-2018-08-29 14:30:00' for key 'sensorid_timestamp'
warnings.simplefilter("ignore", category=MySQLdb.cursors.Warning)
+ if args.verbose:
+ logging.info("Writing to database: sensor_id={}, sensor_name={}, value_type={}, value_raw={}, value={}, timestamp={}".format(sensor_id, sensor_name, value_type, value_raw, value, timestamp))
conn.execute("insert ignore into sensors (sensor_id, sensor_name, value_type, value_raw, value, timestamp) values (%s,%s,%s,%s,%s,%s)", sensor_id, sensor_name, value_type, value_raw, value, timestamp)
conn.close()
parser = argparse.ArgumentParser(description='Read sensor data')
parser.add_argument('--config', default=default_config_file, help='configuration file')
parser.add_argument('--fromcsvfile', help='write values from csv file to database')
+ parser.add_argument("--verbose", help='write some output', action='store_true')
args = parser.parse_args()
main(args.config, args.fromcsvfile)