search

quintel / etmodel

Professional interface of the Energy Transition model.
https://energytransitionmodel.com/
MIT License
25 stars 12 forks source link

Clean up database entries that refer to non-existent queries #1362

Closed ChaelKruip closed 10 years ago

ChaelKruip commented 11 years ago

The etmodel database (etmodel_staging) contains deprecated output_element_series that still refer to the non-existing gqueries.

They are the following: Please update/delete them. 

id  output_element_id   label   color   order_by    group   created_at  updated_at  show_at_first   is_target_line  target_line_position    gquery
961 115 gas_ccgt    #228B22 NULL        2012-03-09 10:36:11 2012-03-12 16:37:26 0   0       gas_ccgt_in_overview_backup_capacity_options
962 115 coal    #666666 NULL        2012-03-09 12:05:41 2012-03-12 16:35:03 0   0       coal_pwd_in_overview_backup_capacity_options
1024    115 coal_conventional   #A9A9A9 NULL        2012-03-12 16:34:02 2012-03-12 16:42:08 0   0       coal_conv_in_overview_backup_capacity_options
1025    115 gas_conventional    #5D7929 NULL        2012-03-12 16:34:37 2012-03-12 16:42:24 0   0       gas_conv_in_overview_backup_capacity_options
1026    115 coal_ccs    #4169E1 NULL        2012-03-12 16:35:28 2012-03-13 07:10:17 0   0       coal_pwd_ccs_in_overview_backup_capacity_options
1027    115 coal_igcc   #333333 NULL        2012-03-12 16:35:57 2012-03-12 16:35:57 0   0       coal_igcc_in_overview_backup_capacity_options
1028    115 coal_igcc_ccs   #00008B NULL        2012-03-12 16:36:44 2012-03-13 07:09:52 0   0       coal_igcc_ccs_in_overview_backup_capacity_options
1029    115 oil #854321 NULL        2012-03-12 16:37:04 2012-03-12 16:43:15 0   0       oil_plant_in_overview_backup_capacity_options
1030    115 gas_ccgt_ccs    #ADDE4C NULL        2012-03-12 16:37:54 2012-03-12 16:45:38 0   0       gas_ccgt_ccs_in_overview_backup_capacity_options
1031    115 gas_turbine #B3CF7B NULL        2012-03-12 16:38:10 2012-03-12 16:38:10 0   0       gas_turbine_in_overview_backup_capacity_options
ChaelKruip commented 10 years ago

These are not deprecated! The scatterplot works differently from the other charts. The names of the above 'queries' are appended with the words 'cost' and 'capacity' to refer to existing gqueries.

Closing.