Ensure JDBC-compatibility of pre-defined values on IXMP4Backend

Open glatterf42 opened this issue 2 months ago • 1 comments

JDBC defines some things on all databases/platforms it creates, whereas ixmp4 consciously decides not to define anything on all databases/platforms. Currently, we add all required data in IXMP4Backend setup functions so that the tutorials and test suite pass, but these are not complete. This issue is to bring visibility to the missing items and to indicate where they can be found if we want to complete the setup.

Units

ixmp_source defines these units:

insert into ix_unit (id,name) values (-1 ,'???');
insert into ix_unit (id,name) values(0, 'y');
insert into ix_unit (id,name) values(1, '%');
insert into ix_unit (id,name) values(2, 'GWa');
insert into ix_unit (id,name) values(3, 'USD/GWa');
insert into ix_unit (id,name) values(4, 'kg/kWa');
insert into ix_unit (id,name) values(5, 'kg');
insert into ix_unit (id,name) values(6, 'USD/kg');
insert into ix_unit (id,name) values(7, 'USD');
insert into ix_unit (id,name) values(8, 'cases');
insert into ix_unit (id,name) values(9, 'km');
insert into ix_unit (id,name) values(10, 'USD/km');
insert into ix_unit (id,name) values(11, 'GW');
insert into ix_unit (id,name) values(12, 'G$');
insert into ix_unit (id,name) values(13, 'T$');
insert into ix_unit (id,name) values(14, '-');
insert into ix_unit (id,name) values(15, 'USD/kWa');
insert into ix_unit (id,name) values(16, 'MW');
insert into ix_unit (id,name) values(17, 'MWa');
insert into ix_unit (id,name) values(18, 'USD/tC');
insert into ix_unit (id,name) values(19, 'USD/tCO2');
insert into ix_unit (id,name) values(20, 't');
insert into ix_unit (id,name) values(21, 'tC');
insert into ix_unit (id,name) values(22, 'tCO2');

Regions

ixmp_source defines these regions:

insert into iamc_nodes(id, hierarchy, name, parent) values ('0','common','World','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('1','region (R11)','North America (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('2','region (R11)','Latin America (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('3','region (R11)','Western Europe (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('4','region (R11)','Eastern Europe (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('5','region (R11)','Former Soviet Union (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('6','region (R11)','Middle East and Africa (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('7','region (R11)','Subsaharan Africa (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('8','region (R11)','Centrally planned Asia (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('9','region (R11)','Pacific OECD (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('10','region (R11)','Pacific Asia (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('11','region (R11)','South Asia (R11)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('12','country','Canada','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('13','country','Sao Tome and Principe','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('14','country','Turkmenistan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('15','country','Saint Helena','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('16','country','Lithuania','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('17','country','Cambodia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('18','country','Ethiopia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('19','country','Aruba','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('20','country','Swaziland','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('21','country','Palestine','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('22','country','Argentina','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('23','country','Bolivia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('24','country','Bahamas, The','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('25','country','Burkina Faso','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('26','country','Ghana','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('27','country','Saudi Arabia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('28','country','Cape Verde','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('29','country','Slovenia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('30','country','Guatemala','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('31','country','Bosnia and Herzegovina','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('32','country','Guinea','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('33','country','Jordan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('34','country','Congo, Rep.','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('35','country','Spain','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('36','country','Liberia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('37','country','Netherlands','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('38','country','Jamaica','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('39','country','Oman','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('40','country','Tanzania','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('41','country','Albania','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('42','country','Gabon','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('43','country','Niue','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('44','country','New Zealand','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('45','country','Yemen','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('46','country','Pakistan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('47','country','Greenland','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('48','country','Samoa','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('49','country','Slovak Republic','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('50','country','United Arab Emirates','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('51','country','Guam','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('52','country','Kosovo','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('53','country','India','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('54','country','Azerbaijan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('55','country','Madagascar','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('56','country','Lesotho','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('57','country','Saint Vincent and the Grenadines','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('58','country','Kenya','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('59','country','South Korea','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('60','country','Belarus','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('61','country','Tajikistan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('62','country','Turkey','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('63','country','Afghanistan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('64','country','Bangladesh','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('65','country','Mauritania','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('66','country','Solomon Islands','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('67','country','Turks and Caicos Islands','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('68','country','Saint Lucia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('69','country','Cyprus','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('70','country','French Polynesia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('71','country','France','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('72','country','Bermuda','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('73','country','Namibia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('74','country','Somalia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('75','country','Peru','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('76','country','Laos','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('77','country','Nauru','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('78','country','Seychelles','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('79','country','Norway','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('80','country','Cote d''Ivoire','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('82','country','Cook Islands','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('83','country','Benin','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('84','country','Western Sahara','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('85','country','Cuba','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('86','country','Cameroon','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('87','country','Montenegro','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('88','country','Saint Kitts and Nevis','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('89','country','Togo','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('90','country','China','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('91','country','Armenia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('92','country','Antigua and Barbuda','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('93','country','Dominican Republic','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('94','country','Ukraine','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('95','country','Bahrain','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('96','country','Tonga','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('97','country','Finland','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('98','country','Libya','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('99','country','Indonesia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('100','country','Central African Republic','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('101','country','United States','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('102','country','Sweden','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('103','country','Vietnam','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('104','country','British Virgin Islands','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('105','country','Mali','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('106','country','Russia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('107','country','Bulgaria','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('108','country','Mauritius','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('109','country','Romania','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('110','country','Angola','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('111','country','Portugal','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('112','country','South Africa','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('113','country','Fiji','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('114','country','Brunei Darussalam','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('115','country','Malaysia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('116','country','Austria','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('117','country','Mozambique','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('118','country','Uganda','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('119','country','Kyrgyz Republic','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('120','country','Hungary','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('121','country','Niger','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('122','country','Brazil','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('123','country','Falkland Islands','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('124','country','Kuwait','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('125','country','Panama','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('126','country','Guyana','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('127','country','Costa Rica','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('128','country','Luxembourg','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('129','country','American Samoa','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('130','country','Gibraltar','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('131','country','Ireland','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('132','country','Nigeria','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('133','country','Ecuador','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('134','country','Czech Republic','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('135','country','Australia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('136','country','Iran','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('137','country','Algeria','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('138','country','El Salvador','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('139','country','Saint Pierre and Miquelon','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('140','country','Chile','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('141','country','Puerto Rico','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('142','country','Belgium','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('143','country','Thailand','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('144','country','Haiti','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('145','country','Iraq','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('146','country','Sierra Leone','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('147','country','Georgia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('148','country','Hong Kong (China)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('149','country','Denmark','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('150','country','Poland','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('151','country','Moldova','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('152','country','Morocco','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('153','country','Croatia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('154','country','Mongolia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('155','country','Guinea-Bissau','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('156','country','Kiribati','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('157','country','Switzerland','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('158','country','Grenada','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('159','country','Belize','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('160','country','Chad','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('161','country','Estonia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('162','country','Uruguay','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('163','country','Equatorial Guinea','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('164','country','Lebanon','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('165','country','Uzbekistan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('166','country','Tunisia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('167','country','Djibouti','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('168','country','Rwanda','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('169','country','Timor-Leste','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('170','country','Dominica','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('171','country','Colombia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('172','country','Reunion','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('173','country','Burundi','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('174','country','Taiwan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('175','country','Nicaragua','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('176','country','Barbados','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('177','country','Qatar','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('178','country','Congo, Dem. Rep.','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('179','country','Italy','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('180','country','Bhutan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('181','country','Sudan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('182','country','Nepal','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('183','country','Malta','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('184','country','Maldives','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('185','country','Suriname','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('186','country','Cayman Islands','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('187','country','Venezuela','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('188','country','Israel','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('189','country','Iceland','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('190','country','Zambia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('191','country','Senegal','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('192','country','Papua New Guinea','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('193','country','Malawi','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('194','country','Macau (China)','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('195','country','Trinidad and Tobago','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('196','country','Zimbabwe','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('197','country','Germany','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('198','country','Vanuatu','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('199','country','Martinique','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('200','country','Kazakhstan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('201','country','Philippines','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('202','country','Eritrea','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('203','country','Montserrat','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('204','country','New Caledonia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('205','country','Macedonia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('206','country','North Korea','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('207','country','Paraguay','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('208','country','Latvia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('209','country','Japan','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('210','country','Syria','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('211','country','Honduras','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('212','country','Myanmar','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('213','country','Mexico','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('214','country','Egypt','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('215','country','Singapore','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('216','country','Serbia','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('217','country','Botswana','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('218','country','United Kingdom','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('219','country','Antarctica','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('220','country','Gambia, The','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('221','country','Greece','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('222','country','Sri Lanka','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('223','country','French Guiana','World');
insert into iamc_nodes(id, hierarchy, name, parent) values ('224','country','Comoros','World');

Timeslice

ixmp_source also defines a single timeslice for all timeseries data that don't have a the "time" column set to -1:

INSERT INTO iamc_timeslices(id, name, category, duration) VALUES (-1, 'Year', 'Common', 1);

Nov 07 '25 09:11 glatterf42