Reduce the number of tests that use computationally expensive cases unnecessarily

[johnjasa]

Reduce the number of tests that use computationally expensive cases unnecessarily

A few tests (across unit, regression, and integration) are using examples or cases that are unnecessarilyc omputationally expensive.
For example, test_sql_timeseries_to_csv.py uses a case that takes minutes to run, whereas we could use one that runs in seconds while still fully testing the capability the test handles.

Proposed solution

Generally change the cases/examples used in tests, especially for the unit test suite.
It may make sense to add new cases if you can make simpler ones that take less time to test the same capability.
Any test that runs HOPP (esp. with floris) or has an optimal controller unnecessarily would be the lowest-hanging fruits.

Alternatives considered

Additional context

[johnjasa]

Use a pytest tool to grab stats for longest running tests

[RHammond2]

Of the ~500 tests, the following take longer than 5 seconds to run. Example cases 1 & 2 seem to have an outsized impact

62.59s call     examples/test/test_all_examples.py::test_steel_example[01_onshore_steel_mn-None]
37.16s call     examples/test/test_all_examples.py::test_hybrid_energy_plant_example[11_hybrid_energy_plant-None]
32.34s setup    h2integrate/postprocess/test/test_sql_timeseries_to_csv.py::test_make_df_from_varname_list[02_texas_ammonia-None]
32.20s call     examples/test/test_all_examples.py::test_simple_ammonia_example[02_texas_ammonia-None]
32.01s setup    h2integrate/postprocess/test/test_sql_timeseries_to_csv.py::test_alternative_column_names[02_texas_ammonia-None]
31.72s setup    h2integrate/postprocess/test/test_sql_timeseries_to_csv.py::test_save_csv_all_results[02_texas_ammonia-None]
31.19s setup    h2integrate/postprocess/test/test_sql_timeseries_to_csv.py::test_make_df_from_varname_unit_dict[02_texas_ammonia-None]
22.72s call     examples/test/test_all_examples.py::test_pyomo_optimized_dispatch_example[30_pyomo_optimized_dispatch-None]
18.73s call     h2integrate/converters/hopp/test/test_hopp_caching.py::test_hopp_wrapper_cache_filenames
18.53s call     examples/test/test_all_examples.py::test_peak_load_management_example[33_peak_load_management-None]
16.66s call     examples/test/test_all_examples.py::test_wind_wave_oae_example[09_co2/ocean_alkalinity_enhancement-None]
15.65s call     examples/test/test_all_examples.py::test_plm_optimized_dispatch_example[34_plm_optimized_dispatch-None]
15.57s call     examples/test/test_all_examples.py::test_wind_wave_oae_example_with_finance[09_co2/ocean_alkalinity_enhancement_financials-None]
14.58s call     examples/test/test_all_examples.py::test_electrolyzer_demand[13_dispatch_for_electrolyzer-None]
13.41s call     h2integrate/preprocess/test/test_wind_turbine_file_tools.py::test_floris_turbine_export
12.68s call     examples/test/test_all_examples.py::test_floris_example[26_floris-None]
12.46s call     h2integrate/converters/co2/marine/test/test_oae.py::test_oae_standard_outputs
12.37s call     h2integrate/converters/co2/marine/test/test_oae.py::test_oae_outputs
12.25s call     h2integrate/converters/co2/marine/test/test_oae.py::test_performance_model
10.99s call     examples/test/test_all_examples.py::test_sweeping_different_resource_sites_doe[27_site_doe_diff-None]
10.75s call     examples/test/test_all_examples.py::test_wind_h2_opt_example[05_wind_h2_opt-None]
10.57s call     examples/test/test_all_examples.py::test_windard_pv_battery_dispatch_example[29_wind_ard-None]
10.13s call     h2integrate/converters/hydrogen/test/test_size_modes.py::test_resize_by_max_commodity
 9.87s call     h2integrate/converters/hydrogen/test/test_size_modes.py::test_resize_by_max_feedstock
 8.91s call     h2integrate/converters/hopp/test/test_hopp_caching.py::test_hopp_wrapper_outputs
 7.32s call     examples/test/test_all_examples.py::test_csvgen_parameter_sweep[20_solar_electrolyzer_doe-None]
 7.01s call     h2integrate/tools/test/test_tools.py::test_tech_config_modifier
 6.51s call     examples/test/test_all_examples.py::test_iron_mapping_example[21_iron_examples/iron_mapping-None]
 5.52s call     examples/test/test_all_examples.py::test_wind_wave_doc_example[09_co2/direct_ocean_capture-None]

A quick totaling of all the tests running for longer than second nets a very similar result when filtering for tests relying on example cases (typical culprits and easy to filter out), and whose total is at least 10 seconds.

example	time (s)
02_texas_ammonia	159.46
01_onshore_steel_mn	62.59
11_hybrid_energy_plant	37.16
05_wind_h2_opt	29.03
30_pyomo_optimized_dispatch	22.72
33_peak_load_management	18.53
09_co2/ocean_alkalinity_enhancement	16.66
34_plm_optimized_dispatch	15.65
09_co2/ocean_alkalinity_enhancement_financials	15.57
13_dispatch_for_electrolyzer	14.58
26_floris	12.68
27_site_doe_diff	10.99
29_wind_ard	10.57

A major caveat is that I'm running on the M1 Max architecture, so my results will be much faster than in CI or any typical Windows users.