def update_stack_test_results(root_folder, rating_dict, default_weight):
LogConfig.init_logging()
logger = logging.getLogger(__name__)
daily_folders = testing.get_daily_directories(root_folder)
model = Model('stack_test_result')
column_list = ['daily_folder',]
parsed_folders = [record['daily_folder'] for record in model.select(column_list)]
for daily_folder in daily_folders:
if daily_folder in parsed_folders:
continue
try:
daily_results = testing.get_daily_results_from_daily_directory(daily_folder)
parsed_results = testing.parse_test_result(daily_results,
rating_dict, default_weight)
crio_date = parsed_results['crio_date']
results = parsed_results['results']
for os_name, pass_rates in results.items():
for target_model, pass_rate in pass_rates.items():
table_record = {
'daily_folder': daily_folder,
'validated_stack': crio_date,
'os_name': os_name,
'target_name': target_model,
'pass_rate': pass_rate
}
model.insert(table_record)
except Exception as e:
logger.warning('Exception happened: %s', e)
main_config.NEWER_THAN_DATE)
logger.info('UPDATE TABLE myrio_%s_bundle_installer_dashboard', year)
update_bundle_installer('myrio_'+year+'_bundle_installer_dashboard',
main_config.MYRIO_BUNDLE_INSTALLER_DAILY_FOLDER,
['myRIO-1900'],
['myRIO_DVD1', 'myRIO_DVD2'],
main_config.NEWER_THAN_DATE)
logger.info('UPDATE TABLE roborio_%s_bundle_installer_dashboard', year)
update_bundle_installer('roborio_'+year+'_bundle_installer_dashboard',
main_config.ROBORIO_BUNDLE_INSTALLER_DAILY_FOLDER,
['roboRIO'],
['roboRIO_DVD1', 'roboRIO_DVD2'],
main_config.NEWER_THAN_DATE)
logger.info('UPDATE TABLE stack_test_result')
update_stack_test_results(main_config.SANITY_TEST_ROOT_FOLDER,
main_config.SANITY_TEST_RATING_DICT,
main_config.SANITY_TEST_DEFAULT_WEIGHT)
if __name__ == '__main__':
LogConfig.init_logging()
# make sure the db file in the cwd.
cwd = os.path.dirname(__file__)
if cwd != '':
os.chdir(os.path.dirname(__file__))
update_db(main_config.CURRENT_YEAR)
