def start_of_year(year, ps=_ps):
dc.dump_pg_tbls(lambda: pr.connect_to_aa(ps), ps.scendir, ps.aa_schema,
'^' + str(year))
syntar_f = '{}\\PopSynTargets.csv'.format(year)
if not (os.path.exists(syntar_f)):
cmd = 'copy /Y AllYears\\Working\\PopulationSynthesis\\PopSynTargets.csv {}\\PopSynTargets.csv'.format(
year)
print(cmd)
os.system(cmd)
skimyear = pr.get_skim_year(year, ps.skimyears)
if skimyear < year:
skimfilename = ps.skim_fname.format(yr=skimyear)
if skimyear < ps.earliest_squeeze_year:
dc.dump_pg_tbls(lambda: pr.connect_to_aa(ps), ps.scendir,
ps.aa_schema,
str(skimyear) + '_' + skimfilename[0:-4])
if year == ps.baseyear:
prev_year = year - 1
dc.dump_pg_tbls(lambda: pr.connect_to_aa(ps), ps.scendir, ps.aa_schema,
'^' + str(prev_year))
if year == 2013:
y13_smain_input = '..\\..\\Supply\\data\\supply_input_{}.csv'.format(
year)
dc.dump_a_table(lambda: pr.connect_to_aa(ps), 'srf', '_supply_input',
y13_smain_input)
def start_of_year(year,ps=_ps):
dc.dump_pg_tbls(lambda: pr.connect_to_aa(ps), ps.scendir, ps.aa_schema, str(year))
skimyear = pr.get_skim_year(year, ps.skimyears)
skimfilename = ps.skim_fname.format(yr=skimyear)
dc.dump_pg_tbls(lambda: pr.connect_to_aa(ps), ps.scendir, ps.aa_schema, str(skimyear)+'_'+skimfilename[0:-4])
if year==ps.baseyear:
prev_year=year-1
dc.dump_pg_tbls(lambda: pr.connect_to_aa(ps), ps.scendir, ps.aa_schema, str(prev_year))
def before_run(ps=_ps):
dc.dump_techopt(lambda: pr.connect_to_aa(ps), ps.scendir)
dc.dump_pg_tbls(lambda: pr.connect_to_aa(ps), ps.scendir, ps.aa_schema, '^Inputs_')