def write_measurement_to_database(self, measurement, table_name):
# This function writes to the db
# TODO: check if the table exists before trying to insert data into it
meas = Measurement.convert_to_dict(measurement)
list_of_keys = meas.keys()
list_of_values = [meas[key] for key in list_of_keys]
sql_str = 'INSERT INTO ' + table_name + ' ' + _assemble_insert_args(meas)
self.modify_db(sql_str, list_of_values)
def test_convert_to_dict(self):
m = Measurement(timeStamp=1, value=2, units='degC')
outputs = m.convert_to_dict()
self.assertDictEqual(outputs, {'timeStamp': 1, 'value': 2, 'units': 'degC'})
