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_last_calibration(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, head_cm, level_masl) VALUES ('rb1', '2017-02-01 00:00', 50, 100)")
db_utils.sql_alter_db(u"INSERT INTO w_levels_logger (obsid, date_time, head_cm, level_masl) VALUES ('rb1', '2017-03-01 00:00', 100, NULL)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
test = utils_for_tests.create_test_string(calibrlogger.getlastcalibration(calibrlogger.selected_obsid))
ref = u'[(2017-02-01 00:00, 99.5)]'
assert test == ref
def test_calibrlogger_last_calibration(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, head_cm, level_masl) VALUES ('rb1', '2017-02-01 00:00', 50, 100)")
db_utils.sql_alter_db("INSERT INTO w_levels_logger (obsid, date_time, head_cm, level_masl) VALUES ('rb1', '2017-03-01 00:00', 100, NULL)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
test = utils_for_tests.create_test_string(calibrlogger.getlastcalibration(calibrlogger.selected_obsid))
ref = '[(2017-02-01 00:00, 99.5)]'
assert test == ref
def test_calibrlogger_set_last_calibration_zero(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, head_cm, level_masl) VALUES ('rb1', '2017-02-01 00:00', 100, 1)")
db_utils.sql_alter_db(u"INSERT INTO w_levels_logger (obsid, date_time, head_cm, level_masl) VALUES ('rb1', '2017-03-01 00:00', 100, NULL)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
"""(level_masl - (head_cm/100))"""
calibrlogger.update_plot()
res = calibrlogger.getlastcalibration(calibrlogger.selected_obsid)
test = utils_for_tests.create_test_string(calibrlogger.INFO.text())
ref = u'Last pos. for logger in rb1 was 0.0 masl at 2017-02-01 00:00'
assert test == ref
def test_calibrlogger_set_last_calibration_zero(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, head_cm, level_masl) VALUES ('rb1', '2017-02-01 00:00', 100, 1)")
db_utils.sql_alter_db("INSERT INTO w_levels_logger (obsid, date_time, head_cm, level_masl) VALUES ('rb1', '2017-03-01 00:00', 100, NULL)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
"""(level_masl - (head_cm/100))"""
calibrlogger.update_plot()
res = calibrlogger.getlastcalibration(calibrlogger.selected_obsid)
test = utils_for_tests.create_test_string(calibrlogger.INFO.text())
ref = 'Last pos. for logger in rb1 was 0.0 masl at 2017-02-01 00:00'
assert test == ref
def test_calibrlogger_add_to_level_masl(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)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
calibrlogger.FromDateTime.setDateTime(date_utils.datestring_to_date('2000-01-01 00:00:00'))
calibrlogger.Add2Levelmasl.setText('50')
gui_utils.set_combobox(calibrlogger.combobox_obsid, 'rb1 (uncalibrated)')
calibrlogger.add_to_level_masl()
test = utils_for_tests.create_test_string(db_utils.sql_load_fr_db('SELECT * FROM w_levels_logger'))
ref = '(True, [(rb1, 2017-02-01 00:00, None, None, None, 150.0, None)])'
print(test)
assert test == ref
def test_calibrlogger_calc_best_fit_add_no_matches_same_to_date(
self, mock_messagebar, skip_popup):
db_utils.sql_alter_db("INSERT INTO obs_points (obsid) VALUES ('rb1')")
db_utils.sql_alter_db(
"INSERT INTO w_levels (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-01 01:00', 50)"
)
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
calibrlogger.loggerpos_masl_or_offset_state = 2
calibrlogger.FromDateTime.setDateTime(
date_utils.datestring_to_date('2010-02-01 01:00'))
calibrlogger.ToDateTime.setDateTime(
date_utils.datestring_to_date('2017-02-01 01:00'))
gui_utils.set_combobox(calibrlogger.combobox_obsid,
'rb1 (uncalibrated)')
calibrlogger.bestFitSearchRadius.setText('2 hours')
calibrlogger.calc_best_fit()
test = utils_for_tests.create_test_string(
db_utils.sql_load_fr_db('SELECT * FROM w_levels_logger'))
ref = '(True, [(rb1, 2017-02-01 01:00, None, None, None, 50.0, None)])'
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.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_set_log_pos(self, mock_messagebar):
db_utils.sql_alter_db("INSERT INTO obs_points (obsid) VALUES ('rb1')")
db_utils.sql_alter_db(
"INSERT INTO w_levels (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, head_cm) VALUES ('rb1', '2017-02-01 00:00', 100)"
)
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
calibrlogger.FromDateTime.setDateTime(
date_utils.datestring_to_date('2000-01-01 00:00:00'))
calibrlogger.LoggerPos.setText('2')
gui_utils.set_combobox(calibrlogger.combobox_obsid,
'rb1 (uncalibrated)')
calibrlogger.set_logger_pos()
print(str(mock_messagebar.mock_calls))
test = utils_for_tests.create_test_string(
db_utils.sql_load_fr_db('SELECT * FROM w_levels_logger'))
ref = '(True, [(rb1, 2017-02-01 00:00, 100.0, None, None, 3.0, None)])'
print(test)
assert test == ref
def test_calibrlogger_calc_best_fit_log_pos_out_of_radius(self, mock_messagebar, skip_popup):
db_utils.sql_alter_db(u"INSERT INTO obs_points (obsid) VALUES ('rb1')")
db_utils.sql_alter_db(u"INSERT INTO w_levels (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, head_cm) VALUES ('rb1', '2017-03-01 00:00', 50)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
calibrlogger.loggerpos_masl_or_offset_state = 1
calibrlogger.FromDateTime.setDateTime(date_utils.datestring_to_date(u'2000-01-01 00:00:00'))
gui_utils.set_combobox(calibrlogger.combobox_obsid, u'rb1 (uncalibrated)')
calibrlogger.calc_best_fit()
test = utils_for_tests.create_test_string(db_utils.sql_load_fr_db(u'SELECT * FROM w_levels_logger'))
ref = u'(True, [(rb1, 2017-03-01 00:00, 50.0, None, None, None, None)])'
print(test)
assert test == ref
def test_calibrlogger_add_to_level_masl(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)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
calibrlogger.FromDateTime.setDateTime(date_utils.datestring_to_date(u'2000-01-01 00:00:00'))
calibrlogger.Add2Levelmasl.setText(u'50')
gui_utils.set_combobox(calibrlogger.combobox_obsid, u'rb1 (uncalibrated)')
calibrlogger.add_to_level_masl()
test = utils_for_tests.create_test_string(db_utils.sql_load_fr_db(u'SELECT * FROM w_levels_logger'))
ref = u'(True, [(rb1, 2017-02-01 00:00, None, None, None, 150.0, None)])'
print(test)
assert test == ref
def test_calibrlogger_calc_best_fit_log_pos_out_of_radius(self, mock_messagebar, skip_popup):
db_utils.sql_alter_db("INSERT INTO obs_points (obsid) VALUES ('rb1')")
db_utils.sql_alter_db("INSERT INTO w_levels (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, head_cm) VALUES ('rb1', '2017-03-01 00:00', 50)")
calibrlogger = Calibrlogger(self.iface.mainWindow(), self.ms)
calibrlogger.update_plot()
calibrlogger.loggerpos_masl_or_offset_state = 1
calibrlogger.FromDateTime.setDateTime(date_utils.datestring_to_date('2000-01-01 00:00:00'))
gui_utils.set_combobox(calibrlogger.combobox_obsid, 'rb1 (uncalibrated)')
calibrlogger.calc_best_fit()
test = utils_for_tests.create_test_string(db_utils.sql_load_fr_db('SELECT * FROM w_levels_logger'))
ref = '(True, [(rb1, 2017-03-01 00:00, 50.0, None, None, None, None)])'
print(test)
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