def test_set_result_with_invalid_result_returns_result(self):
crate = Crate('foo', 'bar', 'baz', 'goo')
self.assertEqual(
crate.set_result(('wat?', 'some crazy message'))[0],
'unknown result')
self.assertEqual(crate.result[0], 'unknown result')
def test_set_result_with_valid_result_returns_result(self):
crate = Crate('foo', 'bar', 'baz', 'goo')
self.assertEqual(
crate.set_result((Crate.UPDATED, 'Yay!'))[0], Crate.UPDATED)
self.assertEqual(crate.result[0], Crate.UPDATED)
def test_set_result_with_invalid_result_returns_result(self):
crate = Crate('foo', 'bar', 'baz', 'goo')
self.assertEqual(crate.set_result(('wat?', 'some crazy message'))[0], 'unknown result')
self.assertEqual(crate.result[0], 'unknown result')
try:
sgid_name = 'DAQAirMonitorData'
sgid_db = settings.sgid['ENVIRONMENT']
stage_db = r'C:\forklift\data\hashed\deqquerylayers.gdb'
source_db = path.join(settings.dbConnects, r'AVData.sde')
source_name = 'AVData.dbo.interactive_map_monitoring_data'
bad_results = [Crate.INVALID_DATA, Crate.UNHANDLED_EXCEPTION, Crate.UNINITIALIZED, Crate.ERROR]
log = _setup_logging()
log.info('creating crate')
crate = Crate(sgid_name, sgid_db, stage_db, sgid_name)
log.info('processing crate')
core.init(log)
crate.set_result(core.update(crate, validate_crate))
if crate.was_updated():
log.info('updating data in SDE')
sgid_destination = path.join(sgid_db, 'SGID10.ENVIRONMENT.{}'.format(sgid_name))
arcpy.management.TruncateTable(sgid_destination)
arcpy.management.Append(crate.destination, sgid_destination, 'NO_TEST')
log.info('updating prod fgdbs')
for dest_fgdb in [settings.mapData1, settings.mapData2]:
dest = path.join(dest_fgdb, 'deqquerylayers.gdb', sgid_name)
arcpy.management.TruncateTable(dest)
arcpy.management.Append(crate.destination, dest, 'NO_TEST')
if crate.result[0] in bad_results:
send_email(reportEmail,
'DEQ Hourly Crate Error',
def test_set_result_with_valid_result_returns_result(self):
crate = Crate('foo', 'bar', 'baz', 'goo')
self.assertEqual(crate.set_result((Crate.UPDATED, 'Yay!'))[0], Crate.UPDATED)
self.assertEqual(crate.result[0], Crate.UPDATED)
