<commit_before>/*
Copy timeseries from SQ to 'NEP 2035' scenario
__copyright__ 	= "Flensburg University of Applied Sciences, Centre for Sustainable Energy Systems"
__license__ 	= "GNU Affero General Public License Version 3 (AGPL-3.0)"
__url__ 	= "https://github.com/openego/data_processing/blob/master/LICENSE"
__author__ 	= "IlkaCu" 
*/

---------------
-- Add load time series to future scenarios equivalent to Status Quo scenario
---------------


-- Include data from .load_pq_set for scenario 'NEP 2035' equivalent to Status Quo 

DELETE FROM model_draft.ego_grid_pf_hv_load_pq_set WHERE scn_name = 'NEP 2035'; 

INSERT INTO model_draft.ego_grid_pf_hv_load_pq_set
SELECT 'NEP 2035', a.load_id, a.temp_id, a.p_set, a.q_set
FROM model_draft.ego_grid_pf_hv_load_pq_set a
WHERE scn_name= 'Status Quo'; <commit_msg>Add scenario log<commit_after>/*
Copy timeseries from SQ to 'NEP 2035' scenario
__copyright__ 	= "Flensburg University of Applied Sciences, Centre for Sustainable Energy Systems"
__license__ 	= "GNU Affero General Public License Version 3 (AGPL-3.0)"
__url__ 	= "https://github.com/openego/data_processing/blob/master/LICENSE"
__author__ 	= "IlkaCu" 
*/

---------------
-- Add load time series to future scenarios equivalent to Status Quo scenario
---------------


-- Include data from .load_pq_set for scenario 'NEP 2035' equivalent to Status Quo 

DELETE FROM model_draft.ego_grid_pf_hv_load_pq_set WHERE scn_name = 'NEP 2035'; 

INSERT INTO model_draft.ego_grid_pf_hv_load_pq_set
SELECT 'NEP 2035', a.load_id, a.temp_id, a.p_set, a.q_set
FROM model_draft.ego_grid_pf_hv_load_pq_set a
WHERE scn_name= 'Status Quo'; 

-- ego scenario log (version,io,schema_name,table_name,script_name,comment)
SELECT ego_scenario_log('v0.2.6','output','model_draft','ego_grid_pf_hv_load_pq_set','ego_dp_powerflow_load_timeseries_NEP2035.sql',' ');
{'fraction_non_alphanumeric': 0.11783783783783784, 'fraction_numerical': 0.024324324324324326, 'mean_word_length': 4.59214501510574, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 2, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '420118', 'n_tokens_mistral': 700, 'n_tokens_neox': 641, 'n_words': 170}