Skip to main content
Ctrl+K

ACCERT documentation

  • User’s Guide
  • Reference
  • Example
  • Developer’s Guide
  • GitHub
  • User’s Guide
  • Reference
  • Example
  • Developer’s Guide
  • GitHub

Section Navigation

  • Accert Code Reference
    • Main.Accert.__init__
    • Main.Accert.setup_table_names
    • Main.Accert.load_obj
    • Main.Accert.get_current_COAs
    • Main.Accert.update_account_before_insert
    • Main.Accert.insert_new_COA
    • Main.Accert.insert_COA
    • Main.Accert.extract_variable_info_on_name
    • Main.Accert.extract_super_val
    • Main.Accert.update_input_variable
    • Main.Accert.update_variable_info_on_name
    • Main.Accert.update_super_variable
    • Main.Accert.extract_total_cost_on_name
    • Main.Accert.cal_LCOE
    • Main.Accert.check_unit_conversion
    • Main.Accert.convert_unit
    • Main.Accert.convert_unit_scale
    • Main.Accert.update_total_cost
    • Main.Accert.update_total_cost_on_name
    • Main.Accert.get_var_value_by_name
    • Main.Accert.run_pre_alg
    • Main.Accert.update_account_value
    • Main.Accert.update_cost_element_on_name
    • Main.Accert.update_new_cost_elements
    • Main.Accert.update_new_accounts
    • Main.Accert.update_account_table_by_cost_elements
    • Main.Accert.roll_up_cost_elements
    • Main.Accert.roll_up_cost_elements_by_level
    • Main.Accert.roll_up_account_table
    • Main.Accert.roll_up_account_table_by_level
    • Main.Accert.roll_up_account_table_GNCOA
    • Main.Accert.sum_cost_elements_2C
    • Main.Accert.roll_up_lmt_account_2C
    • Main.Accert.roll_up_lmt_direct_cost
    • Main.Accert.cal_direct_cost_elements
    • Main.Accert.roll_up_lmt_account_table
    • Main.Accert.print_logo
    • Main.Accert.execute_accert
    • Main.Accert.process_reference_model
    • Main.Accert.process_power_inputs
    • Main.Accert.process_variables
    • Main.Accert.process_super_values
    • Main.Accert.process_COA
    • Main.Accert.process_level_accounts
    • Main.Accert.process_ce
    • Main.Accert.process_var
    • Main.Accert.process_alg
    • Main.Accert.check_and_process_total_cost
    • Main.Accert.check_total_cost_changed
    • Main.Accert.check_total_cost_accounts
    • Main.Accert.process_total_cost
    • Main.Accert.process_total_cost_accounts
    • Main.Accert.exit_with_error
    • Main.Accert.finalize_process
    • Main.Accert.generate_results
    • Main.Accert._generate_common_results
    • Main.Accert._common_cost_processing
    • Main.Accert._print_results
    • Main.Accert._pwr12be_processing
    • Main.Accert._no_cost_element_processing
    • Main.Accert.generate_results_table_with_cost_elements
    • Main.Accert._generate_excel
    • Main.Accert.generate_results_table
    • utility_accert.Utility_methods.__init__
    • utility_accert.Utility_methods.setup_table_names
    • utility_accert.Utility_methods.print_table
    • utility_accert.Utility_methods.print_account
    • utility_accert.Utility_methods.print_leveled_accounts
    • utility_accert.Utility_methods.print_leveled_accounts_gncoa
    • utility_accert.Utility_methods.print_algorithm
    • utility_accert.Utility_methods.print_cost_element
    • utility_accert.Utility_methods.print_facility
    • utility_accert.Utility_methods.print_escalation
    • utility_accert.Utility_methods.print_variable
    • utility_accert.Utility_methods.print_user_request_parameter
    • utility_accert.Utility_methods.print_updated_cost_elements
    • utility_accert.Utility_methods.extract_affected_cost_elements
    • utility_accert.Utility_methods.extract_affected_accounts
    • utility_accert.Utility_methods.extract_user_changed_variables
    • utility_accert.Utility_methods.extract_changed_cost_elements
  • Table References
    • ABR 1000 Tables
    • Fusion Tables
    • Heatpipe Tables
    • PWR12-BE Tables
  • Database Stored Procedures
    • cal_direct_cost_elements
    • extract_affected_accounts
    • extract_affected_cost_elements
    • extract_affected_cost_elements_w_dis
    • extract_changed_cost_elements
    • extract_super_val
    • extract_total_cost_on_name
    • extract_user_changed_variables
    • extract_variable_info_on_name
    • get_current_COAs
    • get_var_value_by_name
    • insert_new_COA
    • insert_new_COA_gncoa
    • print_account_all
    • print_account_simple
    • print_leveled_accounts_all
    • print_leveled_accounts_gn
    • print_leveled_accounts_gn_all
    • print_leveled_accounts_simple
    • print_table
    • print_updated_cost_elements
    • print_user_request_parameter
    • remove_specific_row
    • roll_up_account_table_by_gn_level
    • roll_up_account_table_by_level
    • roll_up_cost_elements_by_level
    • roll_up_lmt_account_2C
    • roll_up_lmt_direct_cost
    • sum_cost_elements_2C_fac
    • sum_cost_elements_2C_lab
    • sum_cost_elements_2C_mat
    • sum_up_lmt_account_2C
    • sum_up_lmt_direct_cost
    • sup_coa_level
    • update_account_before_insert
    • update_account_table_by_cost_elements
    • update_cost_element_on_name
    • update_new_accounts
    • update_new_cost_elements
    • update_super_variable
    • update_total_cost_on_name
    • update_variable_info_on_name
  • Reference
  • Database Stored Procedures
  • print_table

print_table#

Parameters#

Name

Type

table_name

VARCHAR(255)

SQL Definition#

CREATE PROCEDURE `print_table`(IN table_name VARCHAR(255))
BEGIN
    SET @stmt = CONCAT('SELECT * FROM ',table_name);
        PREPARE stmt FROM @stmt;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
END;;

previous

print_leveled_accounts_simple

next

print_updated_cost_elements

On this page
  • Parameters
  • SQL Definition
Show Source

© Copyright © 2023 UChicago Argonne, LLC.

Created using Sphinx 9.1.0.

Built with the PyData Sphinx Theme 0.17.1.