iogen.set_exchange_rate(exchange_rate)
envgen = cfgen.get_envgen()
envgen.set_universal_conditions([
"year = %d" % year,
"industry not in %s" % sqlhelper.set_repr(config.env_blacklist),
])
io_harmonizer = matrixutils.generate_selector_matrix(
"%s.sector_map" % config.SCHEMA, iogen.get_sectors(), "io_code",
"harmonized", ["io_code is not null"])
env_harmonizer = matrixutils.generate_selector_matrix(
"%s.sector_map" % config.SCHEMA, envgen.get_sectors(), "env_code",
"harmonized", ["env_code is not null"])
series = ["1"]
cfgen.prepare(year, series, io_harmonizer, env_harmonizer)
sector_titles = {}
stmt = db.prepare("select distinct code, description" +
" from %s.ind_codes order by code" % config.SCHEMA)
for row in stmt():
sector_titles[row[0]] = row[1]
cfgen.set_sector_titles(sector_titles)
cfgen.describe()
cfgen.describe(True)
cfgen.counterfact(1997, "ca")
envgen.set_universal_conditions([
"year = %d" % year,
"industry not in %s" % sqlhelper.set_repr(config.env_blacklist),
])
io_harmonizer = matrixutils.generate_selector_matrix(
"%s.sector_map" % config.SCHEMA,
iogen.get_sectors(), "io_code", "harmonized",
["io_code is not null"])
env_harmonizer = matrixutils.generate_selector_matrix(
"%s.sector_map" % config.SCHEMA,
envgen.get_sectors(), "env_code", "harmonized",
["env_code is not null"])
series = ["1"]
cfgen.prepare(year, series, io_harmonizer, env_harmonizer)
sector_titles = {}
stmt = db.prepare("select distinct code, description" +
" from %s.ind_codes order by code" % config.SCHEMA)
for row in stmt():
sector_titles[row[0]] = row[1]
cfgen.set_sector_titles(sector_titles)
cfgen.describe()
cfgen.describe(True)
cfgen.counterfact(1997, "ca")
