def test_calibrlogger_adjust_trend(self, mock_messagebar): db_utils.sql_alter_db("INSERT INTO obs_points (obsid) VALUES ('rb1')") db_utils.sql_alter_db("INSERT INTO w_levels_logger (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-01 00:00', 100)") db_utils.sql_alter_db("INSERT INTO w_levels_logger (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-10 00:00', 200)") db_utils.sql_alter_db("INSERT INTO w_levels (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-01 00:00', 200)") db_utils.sql_alter_db("INSERT INTO w_levels (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-10 00:00', 100)") calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms) gui_utils.set_combobox(calibrlogger.combobox_obsid, 'rb1 (uncalibrated)') calibrlogger.update_plot() calibrlogger.FromDateTime.setDateTime(date_utils.datestring_to_date('2000-01-01 00:00:00')) calibrlogger.L1_date.setDateTime(date_utils.datestring_to_date('2017-02-01 00:00')) calibrlogger.L2_date.setDateTime(date_utils.datestring_to_date('2017-02-10 00:00')) calibrlogger.M1_date.setDateTime(date_utils.datestring_to_date('2017-02-01 00:00')) calibrlogger.M2_date.setDateTime(date_utils.datestring_to_date('2017-02-10 00:00')) calibrlogger.L1_level.setText('100') calibrlogger.L2_level.setText('200') calibrlogger.M1_level.setText('200') calibrlogger.M2_level.setText('100') calibrlogger.adjust_trend_func() res = db_utils.sql_load_fr_db('SELECT obsid, date_time, head_cm, temp_degc, cond_mscm, level_masl, comment FROM w_levels_logger') l = list(res[1][1]) l[5] = '%.11e'%Decimal(l[5]) res[1][1] = tuple(l) test = utils_for_tests.create_test_string(res) print(mock_messagebar.mock_calls) ref = '(True, [(rb1, 2017-02-01 00:00, None, None, None, 100.0, None), (rb1, 2017-02-10 00:00, None, None, None, -2.84217094304e-14, None)])' print("Ref") print(ref) print("Test") print(test) assert test == ref
def test_calibrlogger_adjust_trend(self, mock_messagebar): db_utils.sql_alter_db("INSERT INTO obs_points (obsid) VALUES ('rb1')") db_utils.sql_alter_db("INSERT INTO w_levels_logger (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-01 00:00', 100)") db_utils.sql_alter_db("INSERT INTO w_levels_logger (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-10 00:00', 200)") db_utils.sql_alter_db("INSERT INTO w_levels (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-01 00:00', 200)") db_utils.sql_alter_db("INSERT INTO w_levels (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-10 00:00', 100)") calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms) gui_utils.set_combobox(calibrlogger.combobox_obsid, 'rb1 (uncalibrated)') calibrlogger.update_plot() calibrlogger.FromDateTime.setDateTime(date_utils.datestring_to_date('2000-01-01 00:00:00')) calibrlogger.L1_date.setDateTime(date_utils.datestring_to_date('2017-02-01 00:00')) calibrlogger.L2_date.setDateTime(date_utils.datestring_to_date('2017-02-10 00:00')) calibrlogger.M1_date.setDateTime(date_utils.datestring_to_date('2017-02-01 00:00')) calibrlogger.M2_date.setDateTime(date_utils.datestring_to_date('2017-02-10 00:00')) calibrlogger.adjust_trend_func() res = db_utils.sql_load_fr_db('SELECT * FROM w_levels_logger') l = list(res[1][1]) l[5] = '%.11e'%Decimal(l[5]) res[1][1] = tuple(l) test = utils_for_tests.create_test_string(res) print(mock_messagebar.mock_calls) print(test) ref = '(True, [(rb1, 2017-02-01 00:00, None, None, None, 100.0, None), (rb1, 2017-02-10 00:00, None, None, None, -2.84217094304e-14, None)])' assert test == ref
def test_calibrlogger_adjust_trend(self, mock_messagebar): db_utils.sql_alter_db(u"INSERT INTO obs_points (obsid) VALUES ('rb1')") db_utils.sql_alter_db(u"INSERT INTO w_levels_logger (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-01 00:00', 100)") db_utils.sql_alter_db(u"INSERT INTO w_levels_logger (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-10 00:00', 200)") db_utils.sql_alter_db(u"INSERT INTO w_levels (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-01 00:00', 200)") db_utils.sql_alter_db(u"INSERT INTO w_levels (obsid, date_time, level_masl) VALUES ('rb1', '2017-02-10 00:00', 100)") calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms) gui_utils.set_combobox(calibrlogger.combobox_obsid, u'rb1 (uncalibrated)') calibrlogger.update_plot() calibrlogger.FromDateTime.setDateTime(date_utils.datestring_to_date(u'2000-01-01 00:00:00')) calibrlogger.L1_date.setDateTime(date_utils.datestring_to_date(u'2017-02-01 00:00')) calibrlogger.L2_date.setDateTime(date_utils.datestring_to_date(u'2017-02-10 00:00')) calibrlogger.M1_date.setDateTime(date_utils.datestring_to_date(u'2017-02-01 00:00')) calibrlogger.M2_date.setDateTime(date_utils.datestring_to_date(u'2017-02-10 00:00')) calibrlogger.adjust_trend_func() test = utils_for_tests.create_test_string(db_utils.sql_load_fr_db(u'SELECT * FROM w_levels_logger')) print(mock_messagebar.mock_calls) print(test) ref = u'(True, [(rb1, 2017-02-01 00:00, None, None, None, 100.0, None), (rb1, 2017-02-10 00:00, None, None, None, -2.84217094304e-14, None)])' assert test == ref