optittm / bugprediction

A CLI tool to assess the risk of releasing your next version. Can generate a comprehensive dataset for testing your bug prediction models.
MIT License
0 stars 1 forks source link

[BugPrediction] Fix import radon metrics #31

Closed MelisandeDes closed 1 year ago

MelisandeDes commented 1 year ago

when python main.py report run with a trained model we get this error

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: metric.radon_cc_total [SQL: SELECT version.version_id AS version_version_id, version.project_id AS version_project_id, version.name AS version_name, version.tag AS version_tag, version.start_date AS version_start_date, version.end_date AS version_end_date, version.bugs AS version_bugs, version.changes AS version_changes, version.avg_team_xp AS version_avg_team_xp, version.bug_velocity AS version_bug_velocity, version.code_churn_count AS version_code_churn_count, version.code_churn_max AS version_code_churn_max, version.code_churn_avg AS version_code_churn_avg, metric.metrics_id AS metric_metrics_id, metric.version_id AS metric_version_id, metric.lizard_total_nloc AS metric_lizard_total_nloc, metric.lizard_avg_nloc AS metric_lizard_avg_nloc, metric.lizard_avg_token AS metric_lizard_avg_token, metric.lizard_fun_count AS metric_lizard_fun_count, metric.lizard_fun_rt AS metric_lizard_fun_rt, metric.lizard_nloc_rt AS metric_lizard_nloc_rt, metric.lizard_total_complexity AS metric_lizard_total_complexity, metric.lizard_avg_complexity AS metric_lizard_avg_complexity, metric.lizard_total_operands_count AS metric_lizard_total_operands_count, metric.lizard_unique_operands_count AS metric_lizard_unique_operands_count, metric.lizard_total_operators_count AS metric_lizard_total_operators_count, metric.lizard_unique_operators_count AS metric_lizard_unique_operators_count, metric.total_lines AS metric_total_lines, metric.total_blank_lines AS metric_total_blank_lines, metric.total_comments AS metric_total_comments, metric.comments_rt AS metric_comments_rt, metric.ck_cbo AS metric_ck_cbo, metric.ck_cbo_modified AS metric_ck_cbo_modified, metric.ck_fan_in AS metric_ck_fan_in, metric.ck_fan_out AS metric_ck_fan_out, metric.ck_dit AS metric_ck_dit, metric.ck_noc AS metric_ck_noc, metric.ck_nom AS metric_ck_nom, metric.ck_nopm AS metric_ck_nopm, metric.ck_noprm AS metric_ck_noprm, metric.ck_num_fields AS metric_ck_num_fields, metric.ck_num_methods AS metric_ck_num_methods, metric.ck_num_visible_methods AS metric_ck_num_visible_methods, metric.ck_nosi AS metric_ck_nosi, metric.ck_rfc AS metric_ck_rfc, metric.ck_wmc AS metric_ck_wmc, metric.ck_loc AS metric_ck_loc, metric.ck_lcom AS metric_ck_lcom, metric.ck_lcom_modified AS metric_ck_lcom_modified, metric.ck_tcc AS metric_ck_tcc, metric.ck_lcc AS metric_ck_lcc, metric.ck_qty_returns AS metric_ck_qty_returns, metric.ck_qty_loops AS metric_ck_qty_loops, metric.ck_qty_comparisons AS metric_ck_qty_comparisons, metric.ck_qty_try_catch AS metric_ck_qty_try_catch, metric.ck_qty_parenth_exps AS metric_ck_qty_parenth_exps, metric.ck_qty_str_literals AS metric_ck_qty_str_literals, metric.ck_qty_numbers AS metric_ck_qty_numbers, metric.ck_qty_math_operations AS metric_ck_qty_math_operations, metric.ck_qty_math_variables AS metric_ck_qty_math_variables, metric.ck_qty_nested_blocks AS metric_ck_qty_nested_blocks, metric.ck_qty_ano_inner_cls_and_lambda AS metric_ck_qty_ano_inner_cls_and_lambda, metric.ck_qty_unique_words AS metric_ck_qty_unique_words, metric.ck_numb_log_stmts AS metric_ck_numb_log_stmts, metric.ck_has_javadoc AS metric_ck_has_javadoc, metric.ck_modifiers AS metric_ck_modifiers, metric.ck_usage_vars AS metric_ck_usage_vars, metric.ck_usage_fields AS metric_ck_usage_fields, metric.ck_method_invok AS metric_ck_method_invok, metric.jp_camc AS metric_jp_camc, metric.jp_lcom AS metric_jp_lcom, metric.jp_mmac AS metric_jp_mmac, metric.jp_nhd AS metric_jp_nhd, metric.jp_scom AS metric_jp_scom, metric.halstead_length AS metric_halstead_length, metric.halstead_vocabulary AS metric_halstead_vocabulary, metric.halstead_volume AS metric_halstead_volume, metric.halstead_difficulty AS metric_halstead_difficulty, metric.halstead_effort AS metric_halstead_effort, metric.halstead_time AS metric_halstead_time, metric.halstead_bugs AS metric_halstead_bugs, metric.nb_legacy_files AS metric_nb_legacy_files, metric.radon_cc_total AS metric_radon_cc_total, metric.radon_cc_avg AS metric_radon_cc_avg, metric.radon_loc_total AS metric_radon_loc_total, metric.radon_loc_avg AS metric_radon_loc_avg, metric.radon_lloc_total AS metric_radon_lloc_total, metric.radon_lloc_avg AS metric_radon_lloc_avg, metric.radon_sloc_total AS metric_radon_sloc_total, metric.radon_sloc_avg AS metric_radon_sloc_avg, metric.radon_comments_total AS metric_radon_comments_total, metric.radon_comments_avg AS metric_radon_comments_avg, metric.radon_docstring_total AS metric_radon_docstring_total, metric.radon_docstring_avg AS metric_radon_docstring_avg, metric.radon_blank_total AS metric_radon_blank_total, metric.radon_blank_avg AS metric_radon_blank_avg, metric.radon_single_comments_total AS metric_radon_single_comments_total, metric.radon_single_comments_avg AS metric_radon_single_comments_avg, metric.radon_noc_total AS metric_radon_noc_total, metric.radon_noc_avg AS metric_radon_noc_avg, metric.radon_nom_total AS metric_radon_nom_total, metric.radon_nom_avg AS metric_radon_nom_avg, metric.radon_nof_total AS metric_radon_nof_total, metric.radon_nof_avg AS metric_radon_nof_avg, metric.radon_class_loc_total AS metric_radon_class_loc_total, metric.radon_class_loc_avg AS metric_radon_class_loc_avg, metric.radon_method_loc_total AS metric_radon_method_loc_total, metric.radon_method_loc_avg AS metric_radon_method_loc_avg, metric.radon_func_loc_total AS metric_radon_func_loc_total, metric.radon_func_loc_avg AS metric_radon_func_loc_avg FROM version JOIN metric ON version.version_id = metric.version_id WHERE version.project_id = ? AND version.name != ? AND (version.tag NOT IN (SELECT 1 FROM (SELECT 1) WHERE 1!=1)) ORDER BY version.end_date DESC] [parameters: (1, 'Next Release')] (Background on this error at: https://sqlalche.me/e/14/e3q8)