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_')